Senior Azure Database Engineer

MasterApp Labs•Lansing, MI

4d•$50 - $52•Hybrid

About The Position

The Senior Azure Database Engineer serves as the subject matter expert for the CEPI SLDS data warehouse, exercising considerable independent judgment in directing and coordinating data administration and management methods, practices, procedures, and tools. The role requires expertise in Microsoft SQL Server database support and professional knowledge of the CEDS standard. The database environment includes multiple SQL Server instances and collection environments for Development, Quality Assurance/Testing, Pre-Release, and Production; numerous SQL Reporting Services servers; more than 35 collection databases; and more than 100 analysis databases. The position is heavily involved in strategic and tactical information design, business-area analysis, security, and data modeling to meet data collection needs and transition ETL processes from on-premises to cloud servers. It identifies, analyzes, categorizes, synthesizes, designs, and supports the productive use of business information. It also ensures architectural frameworks are implemented and enforced and monitors and upgrades the server infrastructure supporting the database environment. This is a contract role based in Lansing, Michigan, with a hybrid arrangement requiring onsite work two days per week, Wednesdays and Thursdays, from day one. Interviews are conducted initially via MS Teams, with a possible second round in person. Applicants must submit a separate attachment with two to three professional references, including each reference’s name, email, phone number, and position title/company name.

Requirements

At least 12 years of experience.
8–10 years of TSQL experience.
6–8 years of ETL development experience.
5 years of PowerShell experience.
5 years of Azure DevOps experience.
5 years of Scrum experience.
Expertise in Microsoft SQL Server database support.
Professional knowledge of the CEDS standard.
Expertise in Azure database services.
SQL data modeling and structure skills.
Extensive ETL development experience.
Provide a separate attachment with two to three professional references; each reference must include name, email, phone number, and position title/company name.

Responsibilities

Design, implement, expand, and maintain data pipelines through extraction, transformation, and loading activities.
Perform data preparation, analysis, and reporting; troubleshoot ETL jobs, conduct root cause analysis, and provide technical expertise.
Collaborate with developers, business stakeholders, and other team members to deliver accurate, high-quality data and provide advice and support.
Manage databases and perform maintenance, enhancements, data dictionary design, logical and physical data modeling, and performance tuning.
Support the Application Team using data-storage management utilities and production tools.
Coordinate physical changes to computer databases; code, test, and implement physical databases using database management system knowledge.
Establish physical database parameters and use SQL, DDL, and DCL to define database objects and control access.
Test database changes, correct errors, and refine implementations.
Create production databases using SQL and use database and third-party utilities to monitor performance, record distribution, and available memory.
Direct programmers and analysts in making database management system changes; review and correct programs; answer user questions; and assess the impact of database changes on other systems.
Evaluate requests for new data elements and systems, incorporate them into the shared data environment, and provide technical assistance.
Coordinate data use to ensure integrity and control redundancy; load and reorganize databases as needed.
Perform data modeling and prototyping; develop ETLs; design relational database models; and create physical data models from logical models.
Perform security recovery procedures and save, retrieve, and recover databases from hardware and software failures according to established procedures.
Assist in determining, implementing, and enhancing database security standards and monitoring agency disaster recovery procedures and systems.
Ensure architectural frameworks are properly implemented and enforced, and monitor and upgrade supporting server infrastructure.
Support the transition of ETL processes from on-premises systems to cloud servers.