SQL Database Administrator

Dice is the leading career destination for tech experts at every stage of their careers. Our client, OP Consulting Group LLC, is seeking the following. Apply via Dice today!

Join our dynamic team in Lansing as an SQL Database Administrator, where you''ll play a crucial role in managing and optimizing our database systems. This is an exciting opportunity to work in a fast-paced environment and contribute to the success of our organization.

Key Responsibilities

• Review and comply with policies and procedures.
• Perform data analysis and manage databases, including maintenance, enhancement, and design of data dictionaries, physical and logical database models, and performance tuning.
• Design logical and physical databases and review changes to understand their impact on the physical database.
• Establish physical database parameters and use SQL to define and control access to database objects.
• Enter SQL to create production databases and use utility programs to monitor performance.
• Review and correct programs, answer user questions, and collaborate with coworkers on database changes.
• Aid in planning, development, maintenance, and monitoring of integrated database systems.
• Evaluate user requests for new data elements and systems, ensuring data integrity and control redundancy.
• Execute procedures to save, retrieve, and recover databases from failures and assist in database security and disaster recovery.
• Assist in the installation of database software and the selection of database management software.
• Apply knowledge of computer programming, systems design, and current database technologies.
  
  

Requirements

<>Database Administration Backup & Recovery

• 3–5 years of experience implementing native, cloud-native, and hybrid cross-site backup and recovery strategies.
• 3–5 years of experience configuring SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.
  
  

<>Security & Compliance

• 3–5 years of experience enforcing data masking, encryption (TDE), and Row-Level Security for internal customers.
  
  

<>Database Maintenance

• 3–5 years of experience managing automated indexing, statistics, and integrity checks.
• 2–3 years of experience in PowerShell / CLI Automation for hybrid environment configuration.
  
  

<>Performance Tuning & Monitoring

• 2–3 years of experience analyzing metrics across physical servers, IaaS VMs, and PaaS endpoints.
• 3–5 years of experience in query and index optimization, identifying bottlenecks, and resolving locking/blocking issues.
  
  

<>Hybrid Infrastructure Management

• 2–3 years of experience managing connectivity between on-premises SQL Servers and cloud environments.
  
  

<>Azure SQL / AWS RDSS

• 2–3 years of experience configuring Azure SQL Database, Managed Instances, or AWS RDS SQL Server.
• Preferred 1–2 years of experience in cloud migration using Azure Database Migration Service or AWS SMS.
  
  

<>CI/CD & Database Versioning

• Preferred 1–2 years of experience in schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.
  
  

Take the next step in your career with us in Lansing and make a significant impact on our database management systems.