Postgresql Administrator

Job Summary:

The PostgreSQL Administrator is responsible for the installation, configuration, maintenance, and performance tuning of PostgreSQL database systems. This role ensures high availability, security, and optimal performance of databases supporting business applications.

Key Responsibilities:

• Install, configure, and upgrade PostgreSQL database systems
• Monitor database performance and perform tuning to ensure optimal efficiency
• Implement backup and recovery strategies, including PITR and replication
• Manage database security including user roles, permissions, and data encryption
• Perform regular database maintenance including vacuuming, indexing, and log rotation
• Set up and manage high availability and failover mechanisms
• Troubleshoot and resolve database-related issues in development and production environments
• Automate routine tasks using scripting tools
• Work with development and DevOps teams on database schema changes and deployments
• Maintain documentation for configurations, processes, and policies

Required Skills and Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field
• 3+ years of experience in PostgreSQL database administration
• Strong knowledge of PostgreSQL architecture, SQL, and PL/pgSQL
• Experience with backup/recovery, replication (streaming/logical), and performance tuning
• Proficiency in Linux/Unix systems and shell scripting

Preferred Qualifications:

• Experience with cloud-based PostgreSQL (AWS RDS, Azure Database for PostgreSQL, GCP)
• Familiarity with monitoring tools like pgAdmin, Prometheus, or Zabbix
• Knowledge of security practices, audit logging, and GDPR/PCI compliance
• Experience with CI/CD and DevOps integration