Job Description:
Senior SQL Server DBA
Job Location: Hyderabad / Bangalore / Chennai / Noida/ Gurgaon / Pune / Indore / Mumbai/ Kolkata
Responsibilities:
- Minimum of 6+ years in supporting SQL databases in clustered environments.
- Design, implement, and maintain scalable SQL Server database architectures.
- Administer and support SQL Server Always on Availability Groups for high availability and disaster recovery.
- Manage and configure Failover Cluster Instances (FCI) to ensure maximum uptime.
- Implement and maintain log shipping and SQL Server Replication for backup and failover solutions.
- Maintain database Replication (transactional, snapshot, and merge) across multiple instances.
- Implement and manage robust Backup and Restore processes across environments.
- Conduct regular testing of disaster recovery plans to ensure the continuity of business operations.
- Performance tuning as needed to ensure SQL DATABASE is up and running healthy.
- Develop and maintain scripts for database automation, monitoring, and maintenance using PowerShell, T-SQL, or other relevant scripting languages.
- Automate database jobs, backups, indexing, and maintenance tasks to improve efficiency and reduce manual intervention.
- Perform performance tuning and optimization of queries, indexes, and database systems.
- Analyze and resolve complex database issues related to locking, blocking, and deadlocking.
- Knowledge of database security, user permissions, roles, and encryption techniques.
- Critical Database Migration on Production systems using DR setup/Pre-cutover/Cutover.
- Installation/Configuration/Management/Migration of MS-SQL 2012, 2016, 2019 to higher versions on Standard & Clustered environments.
- SQL Server migrations/Upgradations/Vulnerability patching on QA, Test, and Productions.
- Provide on call rotation DATABASE support, identifying and resolving DATABASE issues, problem troubleshooting, root cause analysis.
- End-to-end Database Support for all critical issues.
- Good understating on database change management procedure including drafting change request, technical review, approval, and change implementation in change maintenance window.
Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here.