SQL Server DBA Administrator

Genpact; Hyderabad; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Genpact in Hyderabad is looking for a SQL Server DBA to join our Database Operations team. The role requires 6+ years of experience with SQL Server, AlwaysOn, and high availability setups.

You will monitor dashboards, troubleshoot performance issues, and manage backups, patching, and upgrades in a 24x7 environment. The ideal candidate will demonstrate strong T-SQL and PowerShell skills, experience with SSRS, and the ability to work across multiple database environments while maintaining security

Qualifications

• 6+ years of rich experience on multiple database technologies primarily SQL server.
• Experience implementing and managing Windows clustering and AlwaysOn Failover Cluster Instances (FCI), Always-On Availability Groups, Mirroring, Log shipping.
• Thorough knowledge of SQL Server installation, configurations, troubleshooting, performance tuning skills.
• Must have strong experience with T-SQL, PowerShell scripting.
• Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
• Experience in database upgrade/migrate, patching, backup recovery of large databases.
• Experience in SQL Server Reporting Services (SSRS) report development.
• Willing to work in 24x7 environment and holidays/weekends as per project demand.

Responsibilities

• Collaborative partner: Support and maintain monitoring products to ensure tool availability and timely customer requests.
• Forward Thinker: Improve performance, automate critical metrics reporting, and ensure reliable notifications.
• Problem Solver: Manage core monitoring infrastructure, upgrades, patches, and vulnerability management.
• Automation and Governance: Document runbooks and standardize workflows for onboarding or instrumentation of databases and middleware.
• Site Reliability Mindset: Contribute to root cause analyses and build automated tools to reduce repetitive tasks.

Skills

SQL Server

AlwaysOn

T-SQL

PowerShell

Backup & Recovery

Performance Tuning

Windows Clustering

DB Migrations

Tools

SSMS

SSRS

Windows Server

Job description

SQL Server DBA Administrator

Experience: 6-10 years

Location: Hyderabad

Immediate joiners preferred

Shift: 24/7

Position Description:

We are looking for SQL Server DBA to join our Database Operations team that works 24x7x365 to ensure our critical systems are up and serving our customers round the clock. The candidate should have the strong mindset to look at the bigger picture, think over and beyond, suggest steps to gain greater control over complex systems.

In this role, the Candidate is responsible for proactively monitoring the key dashboards, analyzing the events and resource contentions and troubleshooting them in a timely manner, provide solutions for resolving them before they create a widespread impact. This role requires strong hands-on experience in database installation, configuration, administration and routine scheduled activities such as patching, backup and recovery, Ops work pockets and performance tuning to quickly understand end to end application flow.

Job Qualifications:

• Install and configure standalone SQL Servers and Always on clusters for Test, Dev, Staging and Production environment.
• Should have practical experience on MS SQL Server 2008/2012/2014/2016/2017 versions.
• Troubleshoot various problems that arise during SQL, service packs installations and fix the issues
• Plan and implement major upgrades, ensuring system integrity and monitoring
• Extensive hands‑on experience in Database migrations from lower to higher versions in
• Database Backup & Recovery
• Evaluate and deploy security patches as necessary
• Review and deploy the scripts into the production.
• Own database maintenance plans, including rebuilding/reorganizing indexes, integrity checks
• Experience with Enterprise environment change control procedure.
• Work with developers to improve database performance, slow running queries / processing
• Ensure high levels of performance, availability, sustainability and security
• Environments Setup High Availability as part Disaster Recovery Strategy for the Databases
• Good practical experience on , Always On, Database Mirroring, Log Shipping
• Implement and maintain database security
• Define and enforce database security best practices, including both user access and data at rest
• Create and configure a single and multi-node SQL Server failover cluster instance
• Add or Remove Nodes in a SQL Server Failover Cluster
• Analyze, solve, and prepare RCA for production outages.
• Debug and troubleshoot database system failures and provide solutions quickly.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends

Qualifications & Requirements

• 6+ years of rich experience on multiple database technologies primarily SQL server
• Thorough knowledge of SQL Server installation, configurations, troubleshooting, performance tuning skills required.
• Experience implementing and managing Windows clustering and AlwaysOn Failover Cluster Instances (FCI), Always-On Availability Groups, Mirroring, Log shipping.
• Thorough knowledge of Windows, 2012, 2016 and preferable 2019.
• Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
• Must have strong experience with TSQL, Powershell scripting.
• Ability to implement automation to reduce manual administrative tasks through use of jobs or other technologies.
• Experience in database upgrade/migrate, patching, backup recovery of large databases.
• Experience in SQL Server Reporting Services (SSRS) report development.
• Excellent verbal and written communication skills, Positive attitude and strong commitment to delivering quality work, Ability to multitask under pressure, prioritize work based on criticality.
• Should be flexible and open to work in 24x7 environment in any shifts, willing to work on holidays, over weekends as per the demand from Project.

Key Responsibilities

• Collaborative partner: Works autonomously and with other engineers and customers to support and maintain monitoring products by ensuring availability of all tools and completing customer requests on-time with quality. Addresses technical challenges and ensures quality through collaborative design and development.
• Forward Thinker: Applies proactive mindset to continually look for ways to improve performance, quality and efficiency. Designs, develops, analyzes, and automates report on critical metrics that provide insights into overall health ensuring the notifications are delivered effectively and efficiently to meet the enterprise availability, stability and reliability goals.
• Problem Solver: Configures, administers and manages core monitoring infrastructure to support the tools (custom or vended), including new releases, upgrades, patch, and vulnerability management. Champions on core observability principles delivery solutions based on effective Application Performance Monitoring, Infrastructure or Platform Monitoring, Real User Monitoring, Synthetics Monitoring, Mobile Monitoring, Network Monitoring and SaaS / Cloud Monitoring.
• Automation and Governance: Administers IT Runbook system to ensure all processes are properly documented and adhered to published standards. Enforces compliance requirements for documentations data integrity, accuracy, and completeness. Helps automate, streamline or rectify workflows required for onboarding or instrumentation of applications, infrastructure, databases, and other middleware tiers to monitoring products.
• Site Reliability Mindset: Participates in root cause analysis exercise and builds post-mortem documents of the critical problems. Identifies opportunities, design and build automated tools that help reduce efforts and saves cost on repeatable tasks for cross-platform products.