Senior Database Administrator

Introduction

We are looking for candidates with 8+ years of experience for this role.

Project Duration: 6+ Months, - Based on the performance and Productivity.

Max Budget: 12 - 12.2 LPA fixed.

The primary job role of a Senior Database Administrator (DBA) includes overseeing the

management, maintenance, and optimization of databases within the organization. Works on

strategic initiatives to align the database infrastructure with long-term business goals and

ensures that best practices in database management are consistently followed.

Main duties/responsibilities

• Optimize database queries to ensure fast and efficient data retrieval, particularly for

complex or high-volume operations.

• Design and implement effective indexing strategies to reduce query execution times and

improve overall database performance.

• Monitor and profile slow or inefficient queries and recommend best practices for

rewriting or re-architecting queries.

• Continuously analyze execution plans for SQL queries to identify bottlenecks and

optimize them.

• Database Maintenance: Schedule and execute regular maintenance tasks, including

backups, consistency checks, and index rebuilding.

• Health Monitoring: Implement automated monitoring systems to track database

performance, availability, and critical parameters such as CPU usage, memory, disk I/O,

and replication status.

• Proactive Issue Resolution: Diagnose and resolve database issues (e.g., locking,

deadlocks, data corruption) proactively, before they impact users or operations.

• High Availability: Implement and manage database clustering, replication, and failover

strategies to ensure high availability and disaster recovery (e.g., using tools like SQL

Server Always On, Oracle RAC, MySQL Group Replication).

• Capacity Planning: Monitor resource consumption and plan for growth to ensure the

database can scale effectively with increasing data volume and transaction load.

• Resource Optimization: Analyze and optimize resource usage (CPU, memory, disk,

network) to reduce operational costs.

• Licensing Management: Ensure that database licensing models are correctly adhered to

and identify opportunities for reducing licensing costs.

• Cloud Cost Management: Use cost analysis tools (e.g., AWS Cost Explorer, Azure Cost

Management) to monitor and optimize cloud database spend, identifying opportunities

for right sizing or reserving instances.

Primary skills

• 8-10 years of experience in Microsoft SQL Server administration

Qualifications

• Bachelor's degree in computer science, software engineering or a related field

• Microsoft SQL certifications (MTA Database, MCSA: SQL Server, MCSE: Data

Management and Analytics) will be an advantage.

Secondary Skills

• Experience in MySQL, PostgreSQL, and Oracle database administration.

• Exposure to Data Lake, Hadoop, and Azure technologies

• Exposure to DevOps or ITIL

Behavioral competencies

• Communication

• Teamwork

• Digital Mindset

• Operational Excellence

• Analytical Ability

• Customer Centricity

• Business and Market Acumen

• Empathy

• Growth Mindset