Database Administrator

Key Responsibilities

• Install, configure, administer, monitor, and maintain PostgreSQL databases.
• Ensure high availability (HA), disaster recovery (DR), backup, recovery, and database security.
• Perform database performance tuning, optimization, capacity planning, and troubleshooting.
• Manage PostgreSQL upgrades, patching, replication, and failover environments.
• Develop and maintain automation scripts for database administration tasks.
• Collaborate with development, architecture, infrastructure, and DBA teams to support business-critical applications.
• Support production environments in a 24×7 operational model.

Mandatory Skills

• PostgreSQL Database Administration
• PL/pgSQL
• Performance Tuning & Optimization
• Database Design Principles, Index Management, Integrity Checks, Statistics & Isolation Levels
• PostgreSQL Security
• PgBouncer
• PostgreSQL Backup & Recovery
• PostgreSQL High Availability (HA) & Disaster Recovery (DR)
• PG_Repack

Good to Have

• Enterprise Failover Manager (EFM)
• Streaming Replication
• Cloud (AWS/SaaS), Kubernetes, Docker
• Linux (Ubuntu) Administration
• Integration with Monitoring Tools
• MS SQL Server (Optional)
• Cassandra (Optional)