Key Responsibilities:

• Install, configure, and manage PostgreSQL databases across various environments.
• Perform database tuning, optimization, and query performance improvements.
• Regularly monitor database performance and ensure high availability.
• Develop, implement, and manage database security policies and procedures.
• Ensure backup and recovery processes are functioning and tested regularly.
• Manage database maintenance activities such as index creation, vacuuming, and performance improvements.
• Ensure database replication and failover mechanisms are operational and tested.
• Design, implement, and manage disaster recovery (DR) solutions, including failover and backup strategies.
• Perform regular backups and restoration tests using native PostgreSQL tools or third-party solutions.
• Diagnose and resolve database-related issues, including performance bottlenecks, deadlocks, and connection issues.
• Collaborate with developers on query optimization and schema design.
• Plan and perform PostgreSQL database upgrades and patch installations.
• Implement and maintain high-availability solutions (e.g., replication, failover, clustering).
• Collaborate with development, DevOps, and IT teams on database architecture and infrastructure.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• 3-5+ years of experience managing and administering PostgreSQL databases.
• Strong understanding of PostgreSQL internals, including MVCC, query execution plans, and memory management.
• Experience with database performance tuning, scaling, and optimization.
• Knowledge of database security best practices, including roles, permissions, and SSL encryption.
• Experience with disaster recovery scenarios, including backup and recovery strategies and testing.
• Familiarity with cloud environments (AWS, Azure, GCP) and PostgreSQL databases in cloud ecosystems.
• Experience with high-availability setups (e.g., replication, failover, clustering).
• Familiarity with monitoring and performance tools such as pg_stat_activity, pgBadger, Prometheus, Grafana, or equivalent.

Preferred Qualifications:

• Experience with MySQL administration (a plus).
• Familiarity with Oracle GoldenGate (a plus).
• Familiarity with EDB (a plus).
• Experience in disaster recovery and high-availability solutions in PostgreSQL and other databases.
• Familiarity with containerized environments (Docker, Kubernetes) and PostgreSQL deployments.
• Certifications in PostgreSQL administration (e.g., Certified PostgreSQL DBA).