21 Aug
|
Arrise Solutions India Private
|
India
21 Aug
Arrise Solutions India Private
India
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.
Solid 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 (India)
🏢 Arrise Solutions India Private
📍 India