Microsoft SQL Server Production DBA
Responsibilities
- Manage and maintain Microsoft SQL Server databases across Production, UAT, and Training environments.
- Perform SQL Server installation, configuration, patching, and upgrades to ensure stable database environments.
- Monitor database health and performance, troubleshooting blocking, deadlocks, and long-running queries.
- Configure and manage High Availability solutions such as AlwaysOn Availability Groups, clustering, and transactional replication.
- Implement and manage backup, restore, and disaster recovery strategies to meet RPO and RTO requirements.
- Support data migration, database refreshes, and import/export operations across different environments.
- Manage SQL Server security, including logins, roles, permissions, and database auditing policies.
- Maintain SQL Server Agent jobs, database maintenance plans, and automation scripts for routine operational tasks.
Requirements
- 4–7 years of experience in Microsoft SQL Server Database Administration.
- Strong hands-on experience with Microsoft SQL Server (2016 / 2017 / 2019 / 2022).
- Experience managing Production database environments with high availability and performance requirements.
- Hands-on experience with AlwaysOn Availability Groups, SQL Server Clustering, or Replication.
- Strong knowledge of backup, restore, disaster recovery, and database maintenance strategies.
- Good experience with T-SQL scripting, stored procedures, and query optimization.
- Experience with SSIS, SQL Server Agent Jobs, and data migration utilities (BCP / Import Wizard).
- Familiarity with database monitoring tools, automation scripting, or cloud platforms (Azure SQL / AWS RDS).