PostgresSQL DBA Professional

PostgreSQL DBA (Multi-Cloud)

Position: PostgreSQL Database Administrator (DBA) - Multi-Cloud

Experience: 8-12 Year

Payroll: Orion eSolutions Payroll

Work Mode: As Per Business Requirement

Job Summary

We are seeking an experienced PostgreSQL DBA with strong expertise in PostgreSQL administration, database architecture, performance optimization, and cloud-based database environments. The ideal candidate should have extensive hands-on experience managing mission-critical PostgreSQL databases, ensuring high availability, disaster recovery, security, and performance tuning in enterprise environments.

The candidate should also possess strong system administration knowledge from a database perspective and have experience working on at least one major cloud platform (AWS, Azure, or Google Cloud Platform). Multi-cloud experience will be an added advantage.

Key Responsibilities

PostgreSQL Database Administration

- Install, configure, upgrade, and maintain PostgreSQL databases.

- Manage PostgreSQL architecture, storage, and database internals.

- Perform database capacity planning and health monitoring.

- Ensure database availability, reliability, and scalability.

High Availability Disaster Recovery

- Design and maintain PostgreSQL High Availability (HA) solutions.

- Configure streaming replication, failover, and switchover mechanisms. - Plan and execute backup and recovery strategies.

- Perform disaster recovery testing and validation.

Performance Optimization

- Monitor database performance and troubleshoot bottlenecks.

- Optimize SQL queries, indexes, and database configuration.

- Manage VACUUM, AutoVACUUM, and database maintenance activities. - Implement proactive monitoring and observability solutions.

Security Compliance

- Manage database authentication and authorization.

- Implement role-based access control (RBAC).

- Ensure database security, encryption, auditing, and compliance best practices. Infrastructure Cloud Administration

- Support Linux/Unix systems from a database administration perspective. - Deploy and manage PostgreSQL databases on cloud platforms.

- Collaborate with infrastructure, DevOps, and application teams.

Required Skills

- 8-12 years of hands-on PostgreSQL DBA experience.

- Strong understanding of PostgreSQL Internals and Database Architecture. - Expertise in PostgreSQL VACUUM and AutoVACUUM management. - Experience with PostgreSQL Vector Extension (pgvector).

- Strong PostgreSQL performance tuning and optimization skills.

- Hands-on experience with High Availability and Replication.

- Backup Recovery (PITR, WAL, Disaster Recovery).

- Linux/Unix administration from a database perspective.

- Experience with at least one cloud platform:

o AWS

o Microsoft Azure

o Google Cloud Platform (GCP)

Preferred Skills

- Multi-cloud database administration.

- Experience with MySQL, SQL Server, or Oracle.

- Experience with NoSQL databases such as MongoDB or Cassandra. - Cross-database migration experience.

- Database optimization and query tuning.

- Experience working in DevOps, SecOps, or ITOps environments.

- Familiarity with Infrastructure as Code and automation tools.

Qualifications

- Bachelor s degree in Computer Science, Information Technology, or a related field. - Relevant PostgreSQL and Cloud certifications are preferred.