16326 - Database Administrator 4

Smith Johnson Tech•Lansing, MI

3d•Hybrid

About The Position

This position supports the Center for Educational Performance and Information (CEPI) database environment, primarily for modernization of the Statewide Longitudinal Data System (SLDS) using the Common Education Data Standards (CEDS). The environment includes multiple SQL Server instances; Development, Quality Assurance/Testing, Pre-Release, and Production collection environments; numerous SQL Reporting Services servers; more than 35 collection databases; and more than 100 analysis databases. The Database Administrator serves as the subject matter expert for the CEPI SLDS data warehouse. The role requires considerable independent judgment in directing and coordinating data administration and management methods, practices, procedures, and tools. It requires expertise in Microsoft SQL Server database support and professional knowledge of CEDS. The position is heavily involved in strategic and tactical information design, business-area analysis, security, and data modeling to meet data collection needs, as well as transitioning ETL processes from on-premises to cloud servers. The role identifies, analyzes, categorizes, synthesizes, designs, and supports productive use of business information. It also ensures architectural frameworks are properly implemented and enforced, and monitors and upgrades the server infrastructure supporting the database environment. This is a hybrid contract opportunity with two days per week onsite. Relocation is allowed. Candidates must be available to interview in person. Employment and/or client submission is contingent on applicable background, drug, identity/location, employment eligibility, and qualification checks, along with any additional client requirements.

Requirements

12 or more years of experience.
Experience with Azure Database services.
Experience with SQL data modeling and structure.
Extensive ETL development experience.
8–10 years of T-SQL experience.
6–8 years of ETL development experience.
5 years of PowerShell experience.
5 years of Azure DevOps experience.
5 years of Scrum experience.
Bachelor’s degree.
Clear and concise written and verbal communication skills.
Must be available to interview in person.
Must successfully complete required pre-employment screening and verification, including applicable background and drug screening, identity/location verification, employment eligibility documentation, and qualification verification.

Responsibilities

Design, implement, expand, and maintain data pipelines through extraction, transformation, and loading activities.
Perform data preparation jobs, data analysis, and data reporting.
Troubleshoot technical issues with ETL jobs, conduct root-cause analysis, and provide technical expertise.
Collaborate with developers, business stakeholders, and other team members to design and deliver accurate, high-quality data and provide advice and support.
Manage databases and perform data analysis, maintenance, enhancements, data-dictionary design, logical and physical database modeling, and performance tuning.
Use data-storage management utilities and production tools to support the Application Team.
Coordinate physical changes to computer databases; code, test, and implement physical databases using database management system knowledge.
Establish physical database parameters and use SQL, including DDL and DCL, to define database objects and control access.
Test and correct errors, refine database changes, and create production databases using SQL.
Use database utilities and third-party tools to monitor database performance, including record distribution and available memory.
Direct programmers and analysts in making database management system changes; review and correct programs; and answer user questions.
Consult coworkers about 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 maintain integrity and control redundancy; load and reorganize databases as needed.
Perform data modeling and prototyping, develop ETLs, design relational database models, and create physical models from logical models.
Perform database security and recovery procedures, including saving, retrieving, and recovering databases from hardware or software failures in accordance with established procedures.
Assist with determining, implementing, and enhancing database security standards, and with monitoring agency disaster-recovery procedures and systems.
Ensure architectural frameworks are implemented and enforced, and monitor and upgrade supporting server infrastructure.
Support the transition of ETL processes from on-premises to cloud servers.