OP Consulting Group LLC
Database Administrator / Senior DBA
OP Consulting Group LLC, Lansing, Michigan, United States, 48900
Position
Database Administrator / Senior DBA at OP Consulting Group LLC. Location
Lansing, MI – Hybrid: 2 days on‑site, remote support. Applicants must be within 90 minutes of Lansing, MI. Employment Type
Contract – 20 months. Responsibilities
Participate in 24x7 software and hardware support, including Disaster Recovery and incident response, following DTMB standards. Help develop and submit plans for installation, patch management, maintenance, upgrades and support for database systems. Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as liaison to external consultants. Follow and enforce database standards, policies & procedures; research and draft guidelines within policy boundaries. Monitor space allocation across databases; 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 and monitor their results. Monitor and support clustered database environments, replication and backup environments. Implement strategy to release unused space or recover fragmentation in test and development environments. Execute scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects (tables, views, constraints, indexes, etc.). Monitor database backups to ensure recoverability; troubleshoot backup errors. Monitor database jobs and scheduled processes in development, test and production environments; participate in troubleshooting. Monitor database environments for issues using alert logs, trace files and other tools; ensure connectivity and uptime. Qualifications
7+ years of Database administration experience with SQL Server 2016 and newer. In‑depth knowledge of Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs – features, limitations and best practices. Proven experience implementing and managing HA/DR solutions such as Always On Availability Groups, geo‑replication and point‑in‑time restore. Expertise in Transparent Data Encryption within SQL Server. Over 3 years of experience creating, updating and maintaining system documentation. Strong understanding of database security principles, user management, role‑based access control, data encryption and compliance regulations. Proficient in designing, implementing and testing backup and recovery strategies for Azure SQL databases. Experience with Azure Monitor, Azure Log Analytics and other monitoring tools for proactive monitoring, alerting and troubleshooting. 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 such as Azure Data Factory or SSIS for data integration. Advanced skills in identifying and resolving performance bottlenecks, including query optimization, index tuning and database configuration. Must be willing to be on site for interviews in Lansing, MI; a screenshot photo is required and a vendor must be present for the initial MS Teams interview to validate the candidate. We welcome diverse applicants in accordance with equal employment opportunity laws.
#J-18808-Ljbffr
Database Administrator / Senior DBA at OP Consulting Group LLC. Location
Lansing, MI – Hybrid: 2 days on‑site, remote support. Applicants must be within 90 minutes of Lansing, MI. Employment Type
Contract – 20 months. Responsibilities
Participate in 24x7 software and hardware support, including Disaster Recovery and incident response, following DTMB standards. Help develop and submit plans for installation, patch management, maintenance, upgrades and support for database systems. Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as liaison to external consultants. Follow and enforce database standards, policies & procedures; research and draft guidelines within policy boundaries. Monitor space allocation across databases; 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 and monitor their results. Monitor and support clustered database environments, replication and backup environments. Implement strategy to release unused space or recover fragmentation in test and development environments. Execute scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects (tables, views, constraints, indexes, etc.). Monitor database backups to ensure recoverability; troubleshoot backup errors. Monitor database jobs and scheduled processes in development, test and production environments; participate in troubleshooting. Monitor database environments for issues using alert logs, trace files and other tools; ensure connectivity and uptime. Qualifications
7+ years of Database administration experience with SQL Server 2016 and newer. In‑depth knowledge of Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs – features, limitations and best practices. Proven experience implementing and managing HA/DR solutions such as Always On Availability Groups, geo‑replication and point‑in‑time restore. Expertise in Transparent Data Encryption within SQL Server. Over 3 years of experience creating, updating and maintaining system documentation. Strong understanding of database security principles, user management, role‑based access control, data encryption and compliance regulations. Proficient in designing, implementing and testing backup and recovery strategies for Azure SQL databases. Experience with Azure Monitor, Azure Log Analytics and other monitoring tools for proactive monitoring, alerting and troubleshooting. 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 such as Azure Data Factory or SSIS for data integration. Advanced skills in identifying and resolving performance bottlenecks, including query optimization, index tuning and database configuration. Must be willing to be on site for interviews in Lansing, MI; a screenshot photo is required and a vendor must be present for the initial MS Teams interview to validate the candidate. We welcome diverse applicants in accordance with equal employment opportunity laws.
#J-18808-Ljbffr