Padmi

Senior Database Specialist - PostgreSQL & MySQL

HyderabadPosted 2 months ago
Infrastructure And DatabasesSeniorFull Time; Regular
Apply at CtrlS Datacenters

Opens the source posting on shine.com

Source description

About the role

View original

We are seeking an experienced PostgreSQL / MySQL Cross DB Administrator to manage, maintain, and optimize enterprise database environments across PostgreSQL and MySQL platforms within large-scale data center infrastructure. The candidate will be responsible for database administration, performance tuning, replication, backup & recovery, security, migrations, and production support for mission-critical applications. The ideal candidate should have strong expertise in both PostgreSQL and MySQL databases, Linux administration, and high-availability database environments. Key Responsibilities 4- 9 Years of Hands on Install, configure, administer, and support PostgreSQL and MySQL databases across production and non-production environments. Monitor database performance, optimize queries, indexes, and storage utilization. Configure and manage replication, clustering, and high availability solutions for PostgreSQL and MySQL. Perform backup, restore, disaster recovery, and failover activities. Troubleshoot database issues including slow queries, locking, replication lag, and performance bottlenecks. Support database migrations, upgrades, patching, and cross-platform database activities. Implement database security, user management, auditing, and access controls. Work closely with infrastructure, application, and DevOps teams for deployments and operational support. Automate routine DBA activities using shell scripting or Python. Maintain database documentation, SOPs, architecture diagrams, and operational procedures. Participate in 24x7 production support and on-call activities when required. Required Technical Skills Performance Tuning & Query Optimization Streaming & Logical Replication High Availability Solutions (Patroni, repmgr, Pgpool-II) Backup & Recovery: pg_dump pg_basebackup WAL Archiving pgBackRest / Barman MySQL Skills MySQL Administration MySQL Replication MySQL Performance Tuning Backup & Recovery: HA concepts for MySQL Common Technical Skills Shell Scripting / Bash / Python Database Monitoring Tools: Grafana Production Support Experience Data Center Operations Knowledge Database Security & Access Management Capacity Planning & Performance Monitoring Preferred Skills Experience with cloud platforms (AWS/Azure/GCP) Exposure to Docker & Kubernetes CI/CD and DevOps exposure Experience handling large-scale enterprise databases Knowledge of ITIL processes Educational Qualification Bachelors Degree in Computer Science, IT, or related discipline Soft Skills Strong troubleshooting and analytical skills Good communication and stakeholder coordination Ability to work under pressure in production environments Strong documentation and reporting skills Location :Hyderabad (Work from Office only) We are seeking an experienced PostgreSQL / MySQL Cross DB Administrator to manage, maintain, and optimize enterprise database environments across PostgreSQL and MySQL platforms within large-scale data center infrastructure. The candidate will be responsible for database administration, performance tuning, replication, backup & recovery, security, migrations, and production support for mission-critical applications. The ideal candidate should have strong expertise in both PostgreSQL and MySQL databases, Linux administration, and high-availability database environments. Key Responsibilities 4- 9 Years of Hands on Install, configure, administer, and support PostgreSQL and MySQL databases across production and non-production environments. Monitor database performance, optimize queries, indexes, and storage utilization. Configure and manage replication, clustering, and high availability solutions for PostgreSQL and MySQL. Perform backup, restore, disaster recovery, and failover activities. Troubleshoot database issues including slow queries, locking, replication lag, and performance bottlenecks. Support database migrations, upgrades, patching, and cross-platform database activities. Implement database security, user management, auditing, and access controls. Work closely with infrastructure, application, and DevOps teams for deployments and operational support. Automate routine DBA activities using shell scripting or Python. Maintain database documentation, SOPs, architecture diagrams, and operational procedures. Participate in 24x7 production support and on-call activities when required. Required Technical Skills Performance Tuning & Query Optimization Streaming & Logical Replication High Availability Solutions (Patroni, repmgr, Pgpool-II) Backup & Recovery: pg_dump pg_basebackup WAL Archiving pgBackRest / Barman MySQL Skills MySQL Administration MySQL Replication MySQL Performance Tuning Backup & Recovery: HA concepts for MySQL Common Technical Skills Shell Scripting / Bash / Python Database Monitoring Tools: Grafana Production Support Experience Data Center Operations Knowledge Database Security & Access Management Capacity Planning & Performance Monitoring Preferred Skills Experience with clou

One address, no account. We’ll tell you when matching roles go live.

More at CtrlS Datacenters

Related open roles

View all roles
Senior Database Specialist - PostgreSQL & MySQL at CtrlS Datacenters · Padmi