Senior SQL Database Administrator

Kriyalogic; Chennai District; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Kriyalogic is seeking a Senior Database Administrator to manage mission-critical backend systems for multiple business verticals. You will specialize in MySQL and PostgreSQL administration on Linux, support Apache SOLR, and work with AWS cloud services.

The role requires hands-on production support, 24x7 on-call availability, SLA ownership, and a proactive approach to performance optimization, high availability, and system reliability.

Qualifications

• BE/B.Tech/ME/M.Tech or equivalent qualification.
• 5-7 years of relevant experience in database administration (production environments preferred).

Responsibilities

• Administer, configure, and manage MySQL clusters and PostgreSQL databases in production and non-production environments.
• Install, configure, and support Apache SOLR search platforms.
• Support infrastructure setup, upgrades, migrations, and enhancements for internal/external projects.
• Ensure high availability, performance, and reliability of database systems; diagnose and resolve production issues within SLA.
• Perform RCA for recurring incidents and implement permanent corrective actions.
• Design, implement, audit, and validate backup and disaster recovery strategies including testing.
• Perform performance monitoring, tuning, query optimization, and capacity planning.
• Collaborate with Development, Security, DevOps, and Operations teams; automate routine tasks with shell scripting.

Skills

MySQL

PostgreSQL

Linux

Apache SOLR

AWS

Shell scripting

Education

BE / B.Tech / ME / M.Tech or equivalent qualification

Tools

Monitoring tools

Job description

• We are seeking a highly skilled and experienced Senior Database Administrator (DBA) to manage and support mission-critical backend systems across multiple business verticals.
• The ideal candidate should possess strong expertise in MySQL and PostgreSQL database administration, Linux systems, Apache SOLR, and cloud platforms (AWS).
• The role requires hands-on production support experience, 24x7 on-call availability, SLA ownership, and a proactive approach toward performance optimization, high availability, and system reliability.
• The candidate would be responsible for managing Development, QA, COLO, DR, and Production environments.

Key Responsibilities

• Administer, configure, and manage MySQL clusters and PostgreSQL databases in production and non-production environments
• Install, configure, and support Apache SOLR search platforms
• Support internal and external projects including infrastructure setup, upgrades, migrations, and enhancements
• Ensure high availability (HA), performance, and reliability of database systems Diagnose and resolve production issues within defined SLAs
• Perform Root Cause Analysis (RCA) for recurring incidents and implement permanent corrective actions
• Proactively monitor systems and mitigate potential risks before business impact Design, implement, audit, and validate backup and disaster recovery strategies (including regular recovery testing)
• Perform performance monitoring, tuning, query optimization, and capacity planning
• Execute change management activities following organizational policies
• Collaborate with Development, Security, DevOps, and Operations teams Ensure compliance with security standards and best practices Automate routine operational tasks using shell scripting or relevant tools
• Provide 24x7 on-call support Drive AI-driven automation initiatives and continuous operational improvements
• Work collaboratively with the team members when required and train others.

Skill & Competencies

• Strong troubleshooting expertise on Linux platforms (OS, logs, performance analysis, shell scripting)
• Hands-on experience in MySQL clustering and PostgreSQL administration Strong understanding of new tools configuration
• Proficiency in database design, schema management, indexing strategies, and query optimization Experience with monitoring, logging, and alerting tools
• Knowledge of backup, replication, and disaster recovery methodologies Experience managing cloud-based database services such as AWS RDS (or equivalent cloud database service)
• Good understanding of NoSQL databases such as MongoDB, Cassandra Experience with data warehouse environments
• Solid experience in production database support management
• Strong analytical, troubleshooting, and problem-solving skills in complex production environments

Education & Experience

• BE / B.Tech / ME / M.Tech or equivalent qualification
• 5-7 years of relevant experience in database administration (preferably in production environments) Added Advantage.