The posting
Job Responsibilities
- Install, configure, maintain, and upgrade Microsoft SQL Server databases.
- Monitor database performance, availability, capacity, and overall health.
- Perform regular database backup, restore, and recovery activities.
- Troubleshoot database performance issues, blocking, deadlocks, failed jobs, and connectivity problems.
- Perform SQL query optimization and performance tuning.
- Manage indexes, statistics, stored procedures, views, functions, and database jobs.
- Configure and maintain SQL Server High Availability (HA) and Disaster Recovery (DR) solutions.
- Support technologies such as Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
- Manage database users, roles, permissions, authentication, and security policies.
- Perform database migration, patching, version upgrades, and server refresh activities.
- Monitor disk space, database growth, transaction logs, CPU, memory, and database utilization.
- Develop and maintain scripts using T-SQL/PowerShell for database administration and automation.
- Perform root-cause analysis for database incidents and implement preventive measures.
- Work closely with application, infrastructure, development, and support teams.
- Provide production database support and participate in on-call / after-hours support when required.
- Maintain database documentation, operational procedures, and change records.
Technical Skills
- Strong hands-on experience with Microsoft SQL Server.
- Strong knowledge of T-SQL and SQL query optimization.
- Experience with SQL Server Management Studio (SSMS).
- Good understanding of database architecture, indexing, execution plans, locking, blocking, and deadlocks.
- Experience with backup, recovery, HA and DR solutions.
- Knowledge of SQL Server Agent, maintenance plans, monitoring, and alerting.
- Experience with database security and access management.
- Exposure to PowerShell scripting and database automation is preferred.
- Knowledge of Azure SQL Database / Azure SQL Managed Instance / AWS RDS for SQL Server is an advantage.



