Senior Database Administrator - PostgreSQL

Title : Senior PostgreSQL DBA

Employment Type : C2H

Experience Required : 8+ years overall DBA experience | Minimum 3 years dedicated PostgreSQL administration

Role Overview :

The ideal candidate will have deep expertise in performance tuning, schema design, backup strategies, replication, and disaster recovery, while also contributing to automation and DevOps integration.

Key Responsibilities :

Database Administration & Optimization :

- Conduct query tuning, index optimization, and schema refactoring for high-performance workloads.

- Perform database health checks, capacity planning, and proactive performance monitoring.

Data Security, Backup & Recovery :

- Design and execute disaster recovery and high availability plans.

Automation & DevOps Integration :

- Support CI/CD pipelines and database deployments in cloud-native architectures.

Cloud & Hybrid Infrastructure :

- Manage multi-cloud PostgreSQL environments with consistent performance and security standards.

Collaboration & Documentation :

- Maintain detailed SOPs, architecture diagrams, and process documentation in Jira, GitHub, and relevant tools.

Required Skills & Expertise :

PostgreSQL Administration :

- Strong skills in indexing strategies, query execution plans, schema changes, joins, and primary key management.

General DBA Proficiency :

Cloud & Infrastructure :

- Exposure to cloud-native tools and deployment models.

Linux/Unix OS :

Automation & Scripting :

Collaboration Tools :

Preferred Skills :

- Advanced EnterpriseDB (EDB) Postgres administration.

- Terraform/Ansible automation expertise.

- Multi-cloud deployment experience.

- Familiarity with CI/CD pipelines for database deployments.