Jobs via Dice
Job Overview
Role: Database Administrator 5 (Contract) for State of Michigan – Department of Technology, Management and Budget (DTMB), supporting the Agency for the Michigan Accounts Receivable and Collections (MiARC) Project.
Location: Lansing, MI – Hybrid (2 days in office; no remote‑only option). Accepting local candidates within 90 minutes of Lansing, MI.
Duration: 22 months.
Interview: Phone or MS Teams, followed by Face‑to‑Face onsite in Lansing.
Responsibilities
Participate in 24x7 software and hardware support including Disaster Recovery and incident response support, following industry and DTMB development standards.
Help develop and submit for approval plans for installation, patch management, maintenance, upgrades and support for the database systems.
Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as a liaison to external consultants.
Follow and enforce database standards, policies & procedures; research and draft guidelines.
Monitor space allocation across databases; perform adjustments in test and development environments as needed.
Calculate disk space requirements for existing and new installations.
Modify DBMS parameters based on capacity changes.
Configure and execute database integrity checks; monitor their results.
Install database base management software, patches, and service packs for development/test environments.
Monitor and support clustered database environments, database replication and backup environments.
Implement strategy to release unused space or repair fragmentation in test and development environments.
Execute scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects.
Monitor database back‑ups and troubleshoot backup errors.
Monitor database jobs and scheduled processes in development, test and production environments; participate in troubleshooting.
Monitor database environments for issues and problems with functionality, connectivity, and downtime.
Follow standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
Qualifications & Skills
7+ years of database administration experience on SQL Server 16 and newer.
In-depth knowledge of Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.
Proven experience implementing and managing HA/DR solutions such as Always On Availability Groups, geo-replication, point-in-time restore.
Expertise in Transparent Data Encryption within SQL Server.
Over 3+ years of experience creating, updating, and maintaining systems documentation.
Strong understanding of database security principles, user management, role-based access control, encryption, and compliance regulations.
Proficient in designing, implementing, and testing robust backup and recovery strategies for Azure SQL databases.
Experience with Azure Monitor, Azure Log Analytics, and other proactive monitoring, alerting, and troubleshooting tools.
Proficiency in scripting languages such as PowerShell or Python for automating routine tasks, deployments, and management.
Experience migrating on-premises SQL Server databases to Azure SQL platforms.
Familiarity with ETL processes and tools like Azure Data Factory or SSIS for data integration.
Advanced skills in identifying and resolving performance bottlenecks, including query optimization, index tuning, and database configuration.
Requirements Submit a resume, take a required on-site photo for interviews, and bring a vendor to the beginning of any MS Teams interview to validate the candidate.
Additional Information Position falls under mid-senior level; full-time employment. Eligible for legal compliance EEO statement (not shown due to privacy).
#J-18808-Ljbffr
Location: Lansing, MI – Hybrid (2 days in office; no remote‑only option). Accepting local candidates within 90 minutes of Lansing, MI.
Duration: 22 months.
Interview: Phone or MS Teams, followed by Face‑to‑Face onsite in Lansing.
Responsibilities
Participate in 24x7 software and hardware support including Disaster Recovery and incident response support, following industry and DTMB development standards.
Help develop and submit for approval plans for installation, patch management, maintenance, upgrades and support for the database systems.
Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as a liaison to external consultants.
Follow and enforce database standards, policies & procedures; research and draft guidelines.
Monitor space allocation across databases; perform adjustments in test and development environments as needed.
Calculate disk space requirements for existing and new installations.
Modify DBMS parameters based on capacity changes.
Configure and execute database integrity checks; monitor their results.
Install database base management software, patches, and service packs for development/test environments.
Monitor and support clustered database environments, database replication and backup environments.
Implement strategy to release unused space or repair fragmentation in test and development environments.
Execute scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects.
Monitor database back‑ups and troubleshoot backup errors.
Monitor database jobs and scheduled processes in development, test and production environments; participate in troubleshooting.
Monitor database environments for issues and problems with functionality, connectivity, and downtime.
Follow standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
Qualifications & Skills
7+ years of database administration experience on SQL Server 16 and newer.
In-depth knowledge of Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.
Proven experience implementing and managing HA/DR solutions such as Always On Availability Groups, geo-replication, point-in-time restore.
Expertise in Transparent Data Encryption within SQL Server.
Over 3+ years of experience creating, updating, and maintaining systems documentation.
Strong understanding of database security principles, user management, role-based access control, encryption, and compliance regulations.
Proficient in designing, implementing, and testing robust backup and recovery strategies for Azure SQL databases.
Experience with Azure Monitor, Azure Log Analytics, and other proactive monitoring, alerting, and troubleshooting tools.
Proficiency in scripting languages such as PowerShell or Python for automating routine tasks, deployments, and management.
Experience migrating on-premises SQL Server databases to Azure SQL platforms.
Familiarity with ETL processes and tools like Azure Data Factory or SSIS for data integration.
Advanced skills in identifying and resolving performance bottlenecks, including query optimization, index tuning, and database configuration.
Requirements Submit a resume, take a required on-site photo for interviews, and bring a vendor to the beginning of any MS Teams interview to validate the candidate.
Additional Information Position falls under mid-senior level; full-time employment. Eligible for legal compliance EEO statement (not shown due to privacy).
#J-18808-Ljbffr