Database Administrator - PostgreSQL

Role Overview

Responsibilities

• Install, configure, and upgrade PostgreSQL databases in high-availability environments
• Design and implement database architecture, including replication, partitioning, and sharding
• Perform daily database administration tasks including backups, restores, monitoring, and
  

• Optimize queries, indexes, and overall performance of PostgreSQL systems
• Ensure high availability and disaster recovery by configuring replication (Streaming, Logical)
  

• Implement and maintain security policies, user access control, and encryption
• Monitor database health using tools such as pgAdmin, Nagios, Zabbix, or Troubleshoot database-related issues in development, test, and production environments
• Automate routine tasks using shell scripting, Python, or Ansible
• Work with DevOps/SRE teams to integrate PostgreSQL into CI/CD pipelines and cloud Technical Skills : PostgreSQL Expertise :
• Proven experience with PostgreSQL 11+ (latest version experience preferred)
• Strong knowledge of SQL, PL/pgSQL, database objects, and data types
• Experience with PostgreSQL replication : streaming, logical, and hot standby
• Deep understanding of VACUUM, ANALYZE, autovacuum configuration and tuning
• Knowledge of PostGIS, pgBouncer, and pg_stat_statements is a Tuning & Monitoring :
• Query optimization and slow query analysis using EXPLAIN and ANALYZE
• Experience with database performance monitoring tools (e.g., pg_stat_activity, pgBadger)
• Strong debugging and troubleshooting of locking, deadlocks, and resource contention & DevOps Integration :
• PostgreSQL experience on AWS RDS, Azure Database for PostgreSQL, or GCP Cloud SQL
• Familiarity with IaC tools like Terraform or CloudFormation is a plus
• Experience with CI/CD integration and containerization tools (Docker, Kubernetes) for DB & Compliance :
• Implement role-based access control, data masking, and audit logging
• Ensure compliance with standards like GDPR, ISO 27001, or SOC 2 where :
• Bachelors or Masters degree in Computer Science, Information Technology, or a related field
• Minimum 4+ years of experience in PostgreSQL database administration
• PostgreSQL certification (e.g., EDB Certified Associate/Professional) is a plus
• Experience in 24x7 production environments supporting high-volume Experience :
• Exposure to multi-tenant architectures
• Experience migrating from Oracle/MySQL to PostgreSQL
• Knowledge of NoSQL systems (MongoDB, Redis) is a plus
• Understanding of data warehousing and ETL processes