Database Administrator

Zenfreed • Lansing, MI

3d • Hybrid

About The Position

The Database Administrator 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 for development, quality assurance/testing, pre-release, and production, as well as numerous SQL Reporting Services servers, more than 35 collection databases, and more than 100 analysis databases.

As the subject matter expert for the CEPI SLDS data warehouse, this role uses considerable independent judgment to direct and coordinate data administration and management methods, practices, procedures, and tools. The position requires expertise in Microsoft SQL Server database support and professional knowledge of CEDS. It contributes to strategic and tactical information design, business-area analysis, security, data modeling, data collection needs, and the transition of ETL processes from on-premises to cloud servers. The role also helps ensure architectural frameworks are implemented and enforced and monitors and upgrades the server infrastructure supporting the database environment.

This is a W2 position for 40 hours per week on a hybrid schedule. The employee must be located within 90–100 miles of Lansing, Michigan at the time of submission, and must work onsite Wednesdays and Thursdays from the first day; remote-only work is not available. Typical hours are Monday through Friday, approximately 8:00 a.m. to 5:00 p.m. Candidates must be authorized to work in the United States; sponsorship is unavailable. Employment is subject to a background check and drug screening.

Requirements

• Bachelor's degree.
• At least 12 years of 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 Scrum experience.
• Experience with Azure database services.
• SQL data modeling and database structure skills.
• Extensive ETL development experience.
• Professional knowledge of Common Education Data Standards (CEDS).
• Must be located within 90–100 miles of Lansing, Michigan at the time of submission.
• Must be authorized to work in the United States; sponsorship is not available.
• Must undergo a background check and drug screening.

Responsibilities

• Design, implement, expand, and maintain data pipelines, including extraction, transformation, and loading activities.
• Perform data preparation, data analysis, and data reporting.
• Troubleshoot ETL jobs, conduct root cause analysis, and provide technical expertise.
• Collaborate with developers, business stakeholders, and other team members to deliver high-quality data and provide advice and support.
• Manage databases and maintain, enhance, and design data dictionaries and logical and physical database models.
• Perform database performance tuning and use database storage-management utilities and production tools to support the Application Team.
• Coordinate physical database changes; code, test, and implement 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 making database-management-system changes; review and correct programs.
• Answer user questions and 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 and relational database models; create physical data models from logical models.
• Perform database security and recovery procedures, including saving, retrieving, and recovering databases from hardware and software failures.
• Assist in determining, implementing, and enhancing database security standards and monitoring agency disaster recovery procedures and systems.
• Monitor and upgrade server infrastructure and help ensure architectural frameworks are properly implemented and enforced.

Benefits

• Medical coverage options.
• Dental coverage options.
• Vision coverage options.

What This Job Offers

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