Database Administrator (DBA) – SQL

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.