Job Purpose:The SQL Server DBA is responsible for the installation, configuration, maintenance, performance tuning, and reliable operation of SQL Server databases in production environments. The role ensures high availability, data integrity, security, and optimal performance of database systems supporting business operations.
Role Description1. Database Administration & Support Install, configure, and maintain SQL Server databases in production and non-production environments Monitor database health, performance, and availability daily Manage user access, roles, permissions, and security configurations Ensure data integrity and compliance with internal policies and standards
2. Performance Tuning & Optimization Identify and resolve performance bottlenecks in queries and database structures Optimize SQL queries, indexes, and execution plans for improved efficiency Monitor and analyze system performance using SQL Server tools and logs Provide recommendations for database and application performance improvements
3. Backup & Recovery Management Design, implement, and maintain backup and restore strategies Perform regular backup validation and recovery testing Ensure disaster recovery readiness and minimal data loss (RPO/RTO compliance) Maintain documentation of backup and recovery procedures
4. High Availability & Disaster Recovery Support implementation and maintenance of High Availability solutions (e.g., Always On Availability Groups, Failover Clustering) Ensure database replication and synchronization across environments Participate in disaster recovery planning and execution
5. Maintenance & Upgrades Perform routine database maintenance tasks (index rebuilds, statistics updates, etc.) Support SQL Server upgrades, patches, and version migrations Automate repetitive database administration tasks where possible
6. Troubleshooting & Incident Management Diagnose and resolve database-related issues in production environments Respond to alerts, incidents, and performance degradation issues on time Collaborate with developers and infrastructure teams to resolve complex issues
7. Documentation & Reporting Maintain accurate documentation of database architecture, configurations, and procedures Generate periodic performance and availability reports Document incidents, root cause analysis, and resolutions
Qualifications Bachelor’s degree in Computer Science, Information Systems, or related field Up to 3 years of experience as a SQL Server DBA in production environments Strong hands-on experience with Microsoft SQL Server Strong knowledge of SQL Server architecture and administration Expertise in performance tuning and query optimization Solid understanding of backup and recovery strategies Experience with indexing strategies and execution plans Familiarity with monitoring tools and SQL Server logs Basic knowledge of scripting (T-SQL, Power Shell is a plus) Experience with High Availability solutions (Always On, clustering, replication) Exposure to database automation and scripting Experience with database upgrades and patch management Knowledge of cloud databases (Azure SQL is a plus)