Previous Job
Previous
Database Developer
Ref No.: 18-20464
Location: Roseville, Minnesota

Job Title: Database Developer
Location: Roseville, MN 55113
Duration: One Year + Contract

Job Description:

  • Serve as technical lead with the Lottery's programmers to architect a database structure In Microsoft SQL Server Enterprise 2017 that will be used for the Data Warehouse as well as data structures to support the Lottery's analysis, reporting, and business intelligence, and other needs.
  • Serve as technical lead with the Lottery's programmers, network administrators, and outsourcing vendors to create secure automated Export, Transform, Load (ETL) processes to send critical data to the vendor's system and receive a copy of all Lottery data held by the vendor into the Lottery's data warehouse.
  • Modify databases according to requests and perform tests
  • Solve database usage issues and malfunctions
  • Serve as the technical lead with the Lottery's programmers as they work with analysts and other consumers of reports and data to configure Microsoft SQL Server Reporting Services, Analysis Services, and PowerBI in SQL Server Enterprise 2017 and establish initial reporting and analysis capabilities.
  • Work with Lottery staff as needed to replace functionality currently contained in MS Access databases via ODBC connections to the legacy platform.
  • At each phase, work with IT and Security staff to create and enforce controls based on Active Directory to control access to data as well as other security measures deemed appropriate.
  • Asist Lottery staff as needed to migrate databases from IBM DB2 to SQL Server.
  • Advise IT support staff on software and configurations for developer, administrator, and end user workstations.
  • Mentor Lottery IT staff as needed to ensure all systems are supportable internally after the end of the engagement. This includes providing recommendations on formal training requirements to Lottery management.
  • Develop technical documentation
  • Provide data management support to users
  • Ensure all database programs meet company and performance and security requirements
  • Research and suggest new database products, services and protocols

Minimum Qualifications:

  • Vendor must have the capacity to provide multiple resources that satisfy each of the qualification skill set requirements listed below. The skill sets identified below will be used as Pass/Fail requirements when reviewing resumes for proposed resources prior to starting on the project.
  • Ten (10) years' experience in Database Development role using Microsoft SQL Server with at least two years in version 2012 or higher.
    • A relevant Master's or Bachelor's degree substitutes for two (2) years, or an Associate's degree substitutes for one year.
    • Experience as a Microsoft SQL Server Database Administrator substitutes one for Client Program to six (6) years.
    • No substitutions allowed for the requirement for at least two years in version 2012 or higher
  • Five (5) years' experience with the following:
    • SQL Server Reporting Services and Analysis Services
    • Architecting new SQL Server environments in cooperation with Windows System Administrators and programmers.
    • Creating automated Export, Transform, Load (ETL) processes to exchange data between dissimilar systems
    • Microsoft Transact SQL
    • Training and mentoring technical staff on SQL Server and related development tools
    • Designing new databases
    • Migrating data from old to new systems or between dissimilar systems.

Desired Skills:

  • Ability to understand front-end users' requirements and a problem-solving attitude
  • Excellent analytical and organization skills
  • Proven work experience as a Database developer
  • In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
  • Knowledge of software development and user interface web applications
  • MySQL, MSSQL, DB2, Oracle, MS SQL or MS Access
  • Familiarity working with .Net Framework, JavaScript, HTML and Oracle
  • Experience working in an Agile/Scrum development process
  • Experience as a Business Analyst (BA)
  • Experience in implementing SQL Server environments within a VMWare virtualization environment