Senior Database Administrator

Cynosure Corporate Solutions; Chennai District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Cynosure Corporate Solutions in Chennai is seeking an experienced Senior Database Administrator to manage production OLTP databases, ensure high availability, performance, and security.

You will proactively tune performance, plan migrations and upgrades, and collaborate with stakeholders to meet critical data needs.

The role requires strong hands-on expertise with MySQL, MS SQL Server, and PostgreSQL, plus backup, security, and high-availability strategies.

Qualifications

• Experience managing OLTP databases (MySQL, SQL Server, PostgreSQL).
• Proficient in performance tuning, indexing, and execution plan analysis.
• Experience with backups, restores, and replication.
• Understanding of database security, roles, and permissions.
• Hands-on with high-availability database systems and migrations.

Responsibilities

• Ensure OLTP databases are stable, secure, and high-performing.
• Investigate and resolve database performance issues proactively.
• Maintain backup policies and routine admin tasks like indexing.
• Identify high-consumption queries and optimize with users.
• Manage access controls and security compliance.
• Build dashboards to identify performance gaps and support triage.
• Collaborate with stakeholders to deliver data outcomes.
• Lead migrations and upgrades of production databases.

Skills

MySQL

MS SQL Server

PostgreSQL

Database performance tuning

Backup and recovery

Security and access control

High availability clustering

Python scripting

Migrations and upgrades

Query optimization

Job description

Cynosure Corporate Solutions | Full time

Cynosure Corporate Solutions is a human capital services company. Our focus is to provide Executive Search, Recruitment, Training, Temporary Staffing services, Statutory Compliance's, and other HR aligned services. We understand the business goals of our clients and their need to align human resources to these goals. We are committed to provide high quality manpower in accordance to global standards and their requirements. Our candidates stand testimony to our professional competency.

We work with clients in IT/ITES, Manufacturing, Automobile, Health, Telecom, Media.

Job Description

We are looking for an experienced Senior Database Administrator to manage and optimize production OLTP databases, ensuring high availability, performance, and security. The role involves proactive performance tuning, database migrations, upgrades, and close collaboration with stakeholders to support business-critical data requirements.

Key Responsibilities:

• Ensure OLTP databases remain stable, secure, and high-performing
  
• Proactively investigate and resolve database performance issues
  
• Maintain backup policies and routine administrative tasks such as indexing and statistics updates
  
• Identify high-consumption queries and work with users to improve efficiency
  
• Manage database access controls and ensure security compliance with IT policies
  
• Build dashboards to identify performance gaps and support incident triage workflows
  
• Collaborate end-to-end with stakeholders to deliver required data outcomes
  
• Develop Python scripts to process and prepare data for consumption
  
• Lead migrations and upgrades of production-critical MySQL databases and Percona Clusters
  
• Plan and execute controlled upgrades with rollback and rollout strategies
  
• Perform version migrations with detailed risk assessment
  
• Manage partitioning and storage strategies aligned with log shipping use cases.
  
• Create and manage clustering and de-clustering for MySQL and MS SQL environments
  

Requirements

• Strong hands-on experience with MySQL, MS SQL Server, and PostgreSQL
  
• Proven expertise in database performance tuning, indexing, and execution plan analysis
  
• Experience setting up and managing backups, restores, and replication
  
• Solid understanding of database security, roles, and permissions
  
• Hands-on experience with high-availability database systems
  
• Experience with production database migrations and upgrades is mandatory