PostgreSQL DBA

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).
تاريخ النشر: ١٩ أكتوبر ٢٠٢٤
الناشر: LinkedIn
تاريخ النشر: ١٩ أكتوبر ٢٠٢٤
الناشر: LinkedIn