What are the responsibilities and job description for the AnnalyCap-SQL DBA position at Xoriant Corporation?
Job Requirements
.MS-SQL DBA
Role: Senior MS-SQL Database Administrator (DBA)
Experience: 10 years
Key Responsibilities
Required Skills
Preferred: Experience with Azure SQL / SQL Managed Instance, cloud database migration, Dynatrace/SCOM, and DBA automation.
.MS-SQL DBA
Role: Senior MS-SQL Database Administrator (DBA)
Experience: 10 years
Key Responsibilities
- Manage, administer, and support MS-SQL Server 2012-2022 environments across development, QA, and production.
- Perform database performance tuning, query optimization, indexing, capacity planning, and troubleshooting.
- Manage backup, restore, disaster recovery, and high-availability solutions.
- Configure and support Always On Availability Groups, Failover Clustering, and Replication.
- Monitor database health, blocking, deadlocks, resource utilization, and SQL Server jobs.
- Manage database security including logins, users, roles, permissions, encryption, and auditing.
- Lead SQL Server upgrades, migrations, patching, and version upgrades from legacy environments to newer versions.
- Automate DBA activities using T-SQL and PowerShell.
- Provide production support and participate in 24x7 on-call/incident management as required.
- Collaborate with application, infrastructure, cloud, and development teams to resolve database issues.
Required Skills
- 10 years of hands-on SQL Server DBA experience.
- Strong experience across SQL Server 2012, 2014, 2016, 2017, 2019, and 2022.
- Expert knowledge of T-SQL, SQL Server internals, performance tuning, and troubleshooting.
- Strong experience with Always On, HA/DR, backup & recovery, replication, and database migrations.
- Proficiency with SSMS, SQL Server Agent, Extended Events/Profiler, and PowerShell.
- Experience supporting large-scale, mission-critical production databases.
- Strong understanding of database security, monitoring, and operational best practices.
Preferred: Experience with Azure SQL / SQL Managed Instance, cloud database migration, Dynatrace/SCOM, and DBA automation.