Consultant-DBA Admin

Computacenter; Dadri; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Computacenter seeks an experienced DBA to manage SQL Server environments in production. Requires extensive SQL Server knowledge across 2008–2019, with hands-on design, configuration, and administration of databases.

You will automate DBA tasks, tune performance, implement high-availability/recovery solutions, and provide on-call support to ensure uptime. Must handle large datasets and operate across prod and non-prod environments.

Qualifications

• Extensive knowledge in SQL Server technologies with 4+ years of experience.
• Experience with MS SQL Server 2008–2019.
• Designs, configures, implements, and administers all databases.
• Automating DBA tasks, database tuning and capacity planning.
• On-call DBA support during off-peak hours and weekends as needed.
• Troubleshooting prod/non-prod database issues and performance tuning.

Responsibilities

• Maintain and tune databases to meet SLA and performance metrics.
• Handle production issues and projects independently without guidance.
• Implement HA/DR solutions such as Always On and Mirroring.
• Perform backups, recoveries, and monitoring for database health.
• Analyze and report performance of database operations against key metrics.
• Provide on-call support during off-hours and weekends as needed.

Skills

SQL Server

DBA

Performance tuning

HA/DR Always On

Backup & Recovery

On-call support

Job description

Role & responsibilities

What You Will Do

• Candidate should have extensive knowledge in SQL Server Technologies with at least 4+ years of experience.
• Should be a self-starter and handle Prod Issues & Projects without any guidance.
• Strong experience with MS SQL Server 2008/2008 R2/2012/2014/ 2016/2017/2019, over 3+ yrs of experience with SQL 2016 & SQL 2017.
• Designs, configures, implements, and administers all databases for the respective parties involved.
• Possesses and applies broad knowledge of database principles and practices.
• Identifies and resolves all issues related to database systems to ensure that systems are online and without service interruption.
• Experience with automating DBA tasks, database tuning and capacity planning.
• Resolved Database Access Requests, Incidents & remediated CIS Compliance db items.
• Provide On Call DBA Support during weekday off peak business hours & weekends as needed.
• Analyze and report the performance of database operations against the key database performance metrics.
• Meets performance standards in accordance to service level agreements set by the company.
• Experience in troubleshooting Databases using Database Diagnostic & Compliance Management tools.
• Work on production issues in performance tuning, blocking/locking/deadlocks, Mirroring, Always on, memory pressure, CPU, I/O latency and capacity management.
• Experience in High Availability and Disaster Recovery Solutions using SQL Server Always on Technology.
• Managed databases Small/Medium dbs & VLDB ranging from 10GB to 5TB.
• Implemented & Maintained Standard SQL Maintenance Jobs.
• Implement & Maintain HADR solutions such as Always on, Mirroring, Replication.
• Experience in Database Backup and Recovery & Monitoring solutions.
• Solid Experience in troubleshooting Database issues in Prod & Non-Prod environments.
• Extensive experience in Performance Tuning of queries and stored procedures & optimize execution plans.