Key Responsibilities

- Install, configure, administer, and maintain Microsoft SQL Server databases across Production and non-Production environments.

- Monitor database health, performance, availability, and capacity to ensure optimal system reliability.

- Perform database performance tuning, query optimization, index management, and troubleshooting of production issues.

- Manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, Transactional Replication, Log Shipping, and Backup & Recovery.

- Plan and execute SQL Server upgrades, migrations, patching, and maintenance activities with minimal downtime.

- Collaborate with development teams to optimize database design, SQL queries, and application performance.

- Automate routine DBA activities using T-SQL and PowerShell to improve operational efficiency.

- Implement database security, manage user access, and maintain operational documentation and standards.

- Participate in production incident management, Root Cause Analysis (RCA), and a on-call rotational to provide 24x7 support for business-critical production systems.

Requirements

- 5–8 years of hands-on experience in Microsoft SQL Server Database Administration supporting large production environments.

- Robust experience with SQL Server 2016/2019/2022 administration, installation, configuration, upgrades, and migrations.





- Hands-on experience managing large OLTP databases (5 TB+ preferred) with expertise in performance tuning, query optimization, execution plan analysis, indexing, and statistics.

- Strong knowledge of High Availability (HA) and Disaster Recovery (DR) technologies, including Always On Availability Groups, Transactional Replication, Log Shipping, and Backup & Recovery.

- Good understanding of SQL Server internals, including storage engine, query optimizer, locking, blocking, transactions, indexing, partitioning, and data compression.

- Experience monitoring and troubleshooting CPU, memory, I/O, TempDB, blocking, deadlocks, and other production performance issues.

- Proficiency in T-SQL, SQL Server Agent, Extended Events, Query Store, DMVs, and PowerShell scripting for database administration and automation.

- Experience implementing SQL Server security, including logins, permissions, roles, auditing, and encryption.

- Exposure to enterprise monitoring tools (SQL Sentry, Redgate SQL Monitor, Grafana, SolarWinds, etc.) and cloud platforms such as AWS RDS or Azure SQL is an added advantage.

- Experience with PostgreSQL database administration is an added advantage.

- Strong analytical, troubleshooting, communication, and documentation skills with the ability to support business-critical 24x7 production systems.

📌 SQL Dba (Hyderabad)
🏢 Arrise Solutions India Private
📍 Hyderabad