About the role
We are looking for a skilled Database Engineer with strong hands-on experience in database administration, engineering, high availability, replication, disaster recovery and cloud database operations.
The candidate will be responsible for end-to-end database lifecycle management, including deployment, configuration, monitoring, performance optimization, backup and recovery, upgrades, migration and production troubleshooting.
The role requires an engineer capable of independently handling complex database issues, designing reliable solutions, improving existing database infrastructure and implementing automation to enhance operational efficiency and availability.
Key Responsibilities
- Manage and administer PostgreSQL, Percona PostgreSQL, MySQL, Percona XtraDB Cluster (PXC), MongoDB and Oracle database environments.
- Handle end-to-end database administration, including installation, configuration, provisioning, upgrades, patching, migration and decommissioning.
- Design, configure, manage and troubleshoot database replication and high-availability architectures.
- Perform PostgreSQL streaming replication setup, replication slot management, WAL archiving, standby initialization and replication troubleshooting.
- Manage MySQL replication, GTID-based replication, Percona XtraDB Cluster and cluster recovery.
- Implement and validate database backup and recovery solutions, including full backups, incremental backups and Point-in-Time Recovery (PITR).
- Plan, execute and document disaster recovery drills, failover and switchover procedures, and database restoration tests.
- Work with Kubernetes-based database deployments using Percona Operators and Crunchy Data PostgreSQL Operator.
- Perform database major-version upgrades, patching, migrations and compatibility assessments with minimal downtime.
- Investigate and resolve complex production issues involving database performance, replication, storage, connectivity, locks, deadlocks and availability.
- Analyze database performance metrics, execution plans, indexing strategies, resource consumption and query bottlenecks.
- Identify recurring operational issues and develop sustainable technical solutions to improve database reliability and performance.
- Design and implement automation for database health checks, replication monitoring, capacity management and routine administration.
- Perform database capacity planning, storage management and proactive performance analysis.
- Work with application, infrastructure and development teams to resolve issues and implement database improvements.
- Handle production incidents, root cause analysis, change management and maintenance activities.
- Develop and maintain technical documentation, operational runbooks, recovery procedures and architecture improvements.
Required Technical Skills
Database Administration & Engineering
- Strong hands-on experience with PostgreSQL and Percona Distribution for PostgreSQL.
- Good experience with MySQL and Percona XtraDB Cluster.
- Knowledge of MongoDB and Oracle database administration.
- Strong understanding of database architecture, replication, high availability and disaster recovery.
- Experience in database installation, configuration, performance tuning, upgrades and migrations.
- Hands-on experience with database backup, restoration and Point-in-Time Recovery.
- Ability to independently troubleshoot production database incidents.
Replication, High Availability & Disaster Recovery
- PostgreSQL streaming replication, WAL management and replication slots.
- MySQL replication, GTID and cluster recovery.
- Database failover, switchover and standby recovery.
- Backup validation, disaster recovery testing and restoration drills.
- Understanding of RPO, RTO, data consistency and database recovery strategies.
- Familiarity with tools such as pgBackRest, Patroni, PgBouncer and HAProxy.
Kubernetes & Cloud Infrastructure
- Experience managing databases deployed on Kubernetes.
- Knowledge of Percona Operators for PostgreSQL and MySQL, and Crunchy Data PostgreSQL Operator.
- Understanding of pods, StatefulSets, PVCs, storage classes, services and Kubernetes networking.
- Experience with Linux-based database infrastructure.
- Familiarity with AWS or Microsoft Azure database services.
Monitoring, Troubleshooting & Automation
- Experience with Percona Monitoring and Management (PMM), Grafana and Prometheus.
- Strong troubleshooting skills in database performance, replication lag, connection issues and resource utilization.
- Knowledge of SQL query analysis, execution plans and indexing.
- Scripting experience with Bash or Python.
- Ability to design new monitoring and automation solutions for recurring operational issues.
Good-to-Have Skills
- Oracle RMAN, ASM, Data Guard and database patching.
- MongoDB replica sets, backup and recovery.
- Ceph and S3-compatible object storage.
- AWS RDS and Azure managed database services.
- Database migration and modernization projects.
- Infrastructure automation and CI/CD practices.
- Experience with enterprise production environments and ITIL processes.
Professional Skills
- Strong problem-solving and analytical abilities.
- Ability to independently own database incidents from investigation through resolution.
- Proactive approach to identifying risks and improving existing database solutions.
- Ability to design, propose and implement technical improvements.
- Good communication and collaboration skills.
- Experience coordinating with application teams, infrastructure teams and customers.
- Willingness to participate in production support, planned maintenance and disaster recovery activities.