Database Administrator - PostgreSQL

Description :

Requirements :

- Database Management : Install, configure, tune, and maintain PostgreSQL instances (including Aurora/Cloud) for high availability and performance.

- Performance Tuning : Deep dive into query optimisation, indexing, resource monitoring, and troubleshooting using tools.

- Integration & Data Lakehouse : Manage PostgreSQL's role in data warehousing, integrating with Iceberg for analytical workloads, potentially using extensions.

- Automation : Write robust scripts (Bash, Python) for routine tasks, backups (pg_dump/barman), monitoring, and deployments.

- High Availability & Disaster Recovery : Implement and manage replication (streaming/logical), backups, and recovery strategies.

- Security : Manage access, roles, privileges, and secure configurations.

- Cloud Expertise : Experience with AWS RDS/Aurora PostgreSQL is a strong plus.

- PostgreSQL : Architecture, internals, configuration, tuning, extensions (PostGIS, etc.), PL/pgSQL.

- Data Platforms : Experience with Apache Iceberg, data lakehouse concepts, and modern data warehousing.

- Scripting : Proficiency in Bash, Python (or similar) for automation.

- Cloud : Aurora experience is highly desirable.

- Linux : Strong OS-level skills for DBA tasks (system monitoring, file systems).

- SQL : Advanced SQL for complex queries, procedures, and functions.

Key Responsibilities :

- Install, configure, upgrade, and maintain PostgreSQL databases (on-prem and cloud).

- Manage AWS RDS / Aurora PostgreSQL environments for high availability, scalability, and performance.

- Monitor database health, capacity, and performance using appropriate tools.

- Troubleshoot and resolve database issues across production and non-production environments.

- Perform deep query optimization, indexing strategies, and execution plan analysis.

- Tune PostgreSQL configuration parameters for optimal resource utilization.

- Proactively identify performance bottlenecks and implement corrective actions.

- Design, implement, and manage replication strategies (streaming and logical replication).

- Maintain reliable backup and recovery processes using tools such as pg_dump, pg_basebackup, barman, or equivalent.

- Execute and validate disaster recovery and failover procedures.

- Develop and maintain automation scripts using Bash and Python for routine DBA tasks.

- Automate deployments, backups, monitoring, and maintenance activities.

- Improve operational efficiency through scripting and tooling.

- Support PostgreSQLs role in data warehousing and analytical workloads.

- Integrate PostgreSQL with Apache Iceberg and modern data lakehouse architectures (where applicable).

- Manage and tune PostgreSQL extensions such as PostGIS and others as required.

- Manage database roles, access controls, and privileges.

- Implement and enforce secure configurations, encryption, and auditing best practices.

- Ensure compliance with organizational security and data governance standards.