SQL Server DBA Administrator

Experience: 6-10 years

Location: Hyderabad

Immediate joiners preferred

Shift: 24/7 For Immediate response, Please share resume to [email protected] with Sub of "SQL Server DBA" along with notice period.

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 Clustering, 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 setting 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 documentation’s 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.

📌 SQL Server DBA Admin (Hyderabad)
🏢 Genpact
📍 Hyderabad