Database Administrator 4

Shree Narayani Networking Solutions • Lansing, MI

2d • Hybrid

About The Position

This role supports the Center for Educational Performance and Information (CEPI) database environment, primarily for the Statewide Longitudinal Data System (SLDS) modernization with the Common Education Data Standards (CEDS). The environment includes multiple SQL Server instances and 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, using independent judgment to direct and coordinate data administration and management practices, procedures, and tools. The role requires Microsoft SQL Server support expertise and professional knowledge of CEDS. It contributes to strategic and tactical information design, business-area analysis, security, and data modeling for data collection needs, including transitioning ETL processes from on-premises systems to cloud servers. The position also helps ensure architectural frameworks are implemented and enforced and monitors and upgrades the supporting server infrastructure.

This is a one-year contract assignment, with an extension likely. It is a hybrid role requiring two days in the office in Lansing, Michigan, and is limited to candidates located within 90–100 miles of Lansing at the time of submission. Candidates must be available for an in-person interview; the initial interview is virtual, and a second in-person round may occur.

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.
• Must be located within 90–100 miles of Lansing, Michigan at the time of submission.
• Must be available for an in-person interview.
• Clear and concise written and verbal communication skills.

Nice To Haves

• USC or Green Card candidates are preferred.

Responsibilities

• Design, implement, expand, and maintain data pipelines by performing extraction, transformation, and loading activities.
• Manage data preparation jobs, data analysis, and data reporting.
• Troubleshoot technical issues, perform root cause analysis, and provide technical expertise for ETL jobs.
• Collaborate with developers, business stakeholders, and other team members to deliver accurate, high-quality data and provide advice and support.
• Manage databases and perform data analysis, maintenance, enhancements, performance tuning, and development of data dictionaries and logical and physical database models.
• Use database storage-management utilities and production tools to support the Application Team.
• Coordinate physical changes to computer databases; code, test, and implement physical databases using knowledge of database management systems.
• Establish physical database parameters and use SQL, 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 and third-party utilities to monitor performance, including record distribution and available memory.
• Direct programmers and analysts in database management system changes and review and correct programs.
• Answer user questions and consult coworkers about the effects 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 and develop ETLs.
• Perform logical and physical data modeling, design relational database models, and create physical data models from logical models.
• Perform security recovery procedures and save, retrieve, and recover databases from hardware or software failures.
• Assist in determining, implementing, and enhancing database security standards and monitoring agency disaster recovery procedures and systems.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior