20 Aug
|
Arrise Solutions India Private
|
Hyderabad
20 Aug
Arrise Solutions India Private
Hyderabad
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.
- Strong 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.
- Valuable 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, Te
📌 SQL Dba (Hyderabad)
🏢 Arrise Solutions India Private
📍 Hyderabad