Job Description

Job Description

Job Purpose:

Responsibilities:

  • Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.
  • Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting.
  • Deploy and maintain database infrastructure on both on-premises servers and AWS cloud platforms, utilizing best practices for scalability, reliability, and cost-efficiency.
  • Collaborate with cross-functional teams to design, implement, and optimize database architectures to meet business requirements and performance goals.
  • Implement and maintain disaster recovery solutions, including backup strategies, replication, and failover procedures, for both on-premises and AWS deployments.
  • Automate routine DBA tasks and workflows using scripting languages.
  • Ensure compliance with security policies, regulatory requirements, and industry best practices for database operations and data protection.
  • Monitor and response to DB alerts from monitoring tools and command center team.
  • Monitor database performance and capacity utilization, proactively identifying and resolving issues to maintain optimal performance and scalability.
  • Provide trend analysis to executive management to help them taking informed decisions regarding resource management.
  • Lead, monitor and provide guidance to junior DBA.
  • Collaborate with cross-functional teams to ensure smooth integration of databases with other systems and applications.
  • Perform database capacity planning and trend analysis.
  • Apply changes to the database following strict procedures of Change management policies and protocol.

    • Must Have:

  • Experience with PostgreSQL database, Enterprise Failover Manager (EFM), Postgres Enterprise Manager (PEM) and PGBACKREST on Linux servers.
  • Proficiency in end-to-end architecture of PostgreSQL database, including database design, development, administrate of large-scale database, OLTP and analytical data structures (logical and physical design)
  • Experience managing PostgreSQL databases in AWS RDS and/or EC2 environments.
  • Proficiency in PostgreSQL troubleshooting, performance tuning, SQL Tuning, access management and security setup, health monitoring and maintenance, PL/PGSQL (triggers, functions, ….)
  • Experience in designing, implementing, and monitoring disaster recovery (DR) solutions for PostgreSQL databases including Backup and restore, Point-in-Time-Recovery (PITR), on-site/offsite replication.
  • Experience managing Amazon RDS implementation of PostgreSQL.
  • Experience in database and data migration from on-premises to cloud.
  • Experience in creating Linux shell scripts.

    • Apply for this Position

    Ready to join ? Click the button below to submit your application.

    Submit Application