Microsoft Database Administrator (DBA)

Summary

We are seeking an experienced Microsoft Database administrator (DBA) to join our team. The ideal candidate will have over 7 years of experience managing, optimizing, and securing Microsoft SQL Server databases. This role requires a deep understanding of database architecture, performance-tuning, disaster recovery, and automation. This DBA will collaborate with developers, system administrators, and business analysts to ensure enterprise database systems' availability, reliability, and security.

Responsibilities

• Install, configure, and maintain Microsoft SQL Server (2016, 2019, and later versions) in on-premise and Cloud environments.
• Monitor and optimize database performance; tuning queries, indexes, and execution plans.
• Implement backup, recovery, and disaster recovery strategies to ensure business continuity.
• Manage and optimize database security, user access, and role-based permissions.
• Design and implement high-availability solutions including clustering, mirroring, and replication.
• Develop and maintain T-SQL scripts, stored procedures, functions, and triggers to support application requirements.
• Automate administrative tasks using PowerShell, SQL Server Agent, or other scripting tools.
• Conduct database patching, updates, and migrations to ensure compliance with security and industry standards.
• Troubleshoot and resolve database performance issues, locks, deadlocks, and connectivity problems.
• Work closely with developers and system engineers to optimize database-driven applications.
• Implement and maintain data integrity, indexing strategies, and normalization techniques.
• Stay up-to-date with industry best practices and emerging technologies in SQL Server administration and Cloud database solutions.
  
  

Requirements

• 7 years of hands-on experience with Microsoft SQL Server (2016, 2019, and newer).
• Strong expertise in database performance-tuning, indexing, and query optimization.
• Experience with backup and disaster recovery strategies including Always-On Availability Groups.
• Knowledge of Cloud-based SQL solutions (Azure SQL Database, AWS RDS for SQL Server, etc.).
• Proficiency in T-SQL development including writing and debugging stored procedures, views, and triggers.
• Hands-on experience with SQL Server integration services (SSIS), SQL Server reporting services (SSRS) and SQL Server analysis services (SSAS).
• Experience with PowerShell scripting and SQL Server automation.
• Familiarity with Data Security Best Practices and encryption and compliance standards (GDPR, HIPAA, SOX, etc.).
• Strong problem-solving and analytical skills with the ability to troubleshoot complex database issues.
• Excellent communication and collaboration skills.
• Experience working with DevOps methodologies and using CI/CD pipelines for database deployments.
• Experience with AI-driven database optimization and monitoring tools.
  
  

Preferred

• Understanding of NoSQL, Big Data, or other emerging database technologies.
• Microsoft certifications: MCSA-SQL Server, MCSE-Data Management & Analytics, or Azure Database Administrator-Associate.
• Knowledge of other database systems including Oracle, MySQL, or PostgreSQL.
  
  

This is a Direct Hire opportunity with our Kansas City, MO client. Employee benefits include Medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k). H1-B Visa sponsorship is not available for this position. No third-parties, please

#Onsite