We are seeking a highly experienced and detail-oriented SQL Server Database Administrator (DBA) to manage, maintain, and optimize critical SQL Server environments. The ideal candidate will play a key role in ensuring the reliability, performance, and security of our database systems, both on-premises and in the cloud.
Key Responsibilities
Database Administration
- Install, configure, and maintain SQL Server instances (on-premises and/or cloud-based)
- Perform database backups, restores, and recovery operations
- Manage and enforce SQL Server security including authentication, roles, and permissions
- Implement and manage high availability (HA) and disaster recovery (DR) solutions
Performance Tuning & Monitoring
- Monitor database performance and troubleshoot bottlenecks and outages
- Optimize T-SQL queries and indexes for better performance
- Use tools such as SQL Profiler, Extended Events, and third-party solutions like Redgate or SolarWinds
Automation & Maintenance
- Automate routine DBA tasks using T-SQL, PowerShell, or other scripting tools
- Perform capacity planning, storage management, and patching
- Collaborate with development and support teams for performance improvements and project deployments
Documentation & Collaboration
- Maintain comprehensive technical documentation and standard operating procedures
- Support database deployments and CI/CD pipelines where applicable
- Coordinate with cloud platform teams for database hosting (Azure, AWS, or GCP)
Required Skills and Qualifications
- Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022)
- Proficiency in T-SQL and SQL Server Management Studio (SSMS)
- Experience with performance tuning, query optimization, and indexing
- Strong knowledge of backup and recovery strategies
- Experience with HA/DR solutions like AlwaysOn, Log Shipping, and Clustering
- Familiarity with monitoring tools (SQL Profiler, Extended Events, Redgate, SolarWinds)
- Strong analytical, troubleshooting, and problem-solving abilities
- Excellent communication and documentation skills
Preferred Qualifications
- Microsoft Certified: Azure Database Administrator Associate or equivalent
- Experience with cloud database platforms such as Azure SQL Database, AWS RDS, or SQL Managed Instance
- Exposure to SSIS, SSRS, and SSAS
- Knowledge of DevOps, CI/CD for database deployment
- Familiarity with cloud-native tools and database-as-a-service models
