Senior Database Administrator

Location: Bengaluru

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, or disability status. EEO/Disabled/Vets

Job Description :

Title:

Senior Database Administrator - MS-SQL (L3)

Location:

Bengaluru

Working Type:
Hybrid

Overview of Role:

The MS-SQL DBA will be primarily experienced in MS-SQL RDBMS with knowledge of Cloud technologies. Additionally, they'll be involved in administration of databases and their eco-systems; will support release, incident, problem, business continuity management practices; will patch, upgrade and comply with audit controls; will continuously improve database service quality to ensure stability and high availability. You are experienced in implementing; securing, supporting and upgrading enterprise infrastructure, ensuring the infrastructure, which runs corporate applications, are correctly monitored and highly available as required.

Candidates should have 8-12 years of experience in a DBA role and are expected to work in a rotating 24 x 5 model and also provide on-call support as required by business.

Key Responsibilities

Database Performance Monitoring & Optimization:

Regularly monitor database performance metrics (e.g., CPU usage, memory, disk I/O, query execution time).
Proactively identify performance bottlenecks and optimize SQL queries, indexes, and database schema to improve efficiency.
Perform query tuning, indexing strategies, and resolve deadlocks or resource contention issues.
Use SQL Profiler, Extended Events, and Dynamic Management Views (DMVs) for troubleshooting performance problems.

Backup, Recovery, and Data Integrity:

Manage and implement backup strategies (full, differential, and transaction log backups).
Ensure data integrity by running consistency checks (e.g., DBCC CHECKDB) and resolving any corruption issues.
Test and verify backup and restore procedures regularly to ensure fast recovery during failures.
Plan for and execute database restores when necessary, including point-in-time recovery.
High Availability & Disaster Recovery (HA/DR):
Implement and maintain High Availability solutions (e.g., SQL Server Always On Availability Groups, Database Mirroring, Failover Clustering).
Design and configure Disaster Recovery solutions for SQL Server environments.
Ensure seamless failover operations and minimal downtime during server or database outages.

Database Security & Compliance:

Implement and enforce database security policies (e.g., access control, encryption, auditing).
Ensure compliance with data privacy regulations and industry standards (e.g., GDPR, HIPAA, PCI-DSS).
Maintain SQL Server security best practices, including least privilege access, encryption at rest and in transit, and regular security patching.

Database Maintenance &

Housekeeping:

Perform routine database maintenance tasks, such as index rebuilds, statistics updates, and cleaning up historical data to optimize performance.
Configure and manage maintenance plans and jobs using SQL Server Agent or other automation tools.
Manage and monitor SQL Server Agent jobs to ensure they run without errors.

Troubleshooting and Incident Management:

Act as the primary point of escalation for complex database-related issues (e.g., performance degradation, corruption, failed jobs).
Work with the application and systems teams to diagnose and resolve database problems affecting application performance.
Analyze SQL Server logs, Windows Event logs, and SQL Server Error logs to identify and resolve database-related issues.

Patch Management & Upgrades:

Apply patches, updates, and service packs to SQL Server instances to maintain system security and stability.
Test database upgrades and migrations from older versions of SQL Server or across different platforms (e.g., from on-premises to cloud-based systems).
Ensure minimal downtime during patching and upgrade activities.
Automation & Scripting:
Write and maintain T-SQL scripts to automate tasks like backup, index maintenance, and health checks.
Develop Power Shell scripts or use other automation tools for repetitive tasks or complex configurations.
Use automation for…