NEWPosted 6 hours ago
Job ID: JOB_ID_3791
Job Overview:
The State of Michigan is seeking an experienced Database Administrator to provide essential Infrastructure DBA support for all SQL Server applications. This role is crucial for maintaining critical Tier 1 applications within the Bureau of Labs, Cancer Registry, and other vital areas. The position involves 24×7 software and hardware support for complex SQL Server applications, ensuring high availability and disaster recovery.
Key Responsibilities:
- Provide Infrastructure DBA support for all SQL Server applications.
- Ensure 24×7 software and hardware support for complex SQL Server applications.
- Implement and maintain high availability and Disaster Recovery solutions.
- Develop and submit plans for installation, patch management, maintenance, and upgrades for Database systems.
- Evaluate the impact of changes and new technologies, recommending solutions for persistent problems.
- Serve as an Agency Services liaison to external consultants.
- Follow and enforce database standards, policies, and procedures.
- Monitor space allocation across databases and perform adjustments in test and development environments.
- Calculate disk space requirements for existing and new installations.
- Modify DBMS parameters based on capacity changes.
- Configure and execute database integrity checks.
- Monitor for database integrity checks.
- Install database base management software for development and test environments.
- Install database patches and service packs for development and test environments.
- Monitor and support clustered database environments.
- Monitor and support database replication and backup environments.
- Implement strategies to release unused space or repair fragmentation in test and development environments.
- Execute scripts for creating and modifying database objects (tables, views, constraints, indexes, etc.).
- Monitor database back-ups to ensure recoverability and troubleshoot backup errors.
- Monitor database jobs and scheduled processes in development, test, and production environments.
- Participate in troubleshooting database environments for issues with functionality, connectivity, or downtime.
- Follow standards and guidelines for database space allocation based on best practices and business requirements.
Required Skills and Experience:
- 4+ years of Database administration specifically on SQL Server 16 and upwards.
- Expertise in HA and DR solutions.
- Transparent Data Encryption within SQL Server.
- Over 2+ years of experience creating, updating, and maintaining systems documentation.
Special Requirements
Hybrid – 2 days a week
Compensation & Location
Salary: $70,000 – $110,000 per year (Estimated)
Location: Lansing, MI
Recruiter / Company – Contact Information
Email: ni@datamanusa.com
Recruiter Notice:
To remove this job posting, please send an email from
ni@datamanusa.com with the subject:
DELETE_JOB_ID_3791