PostgreSQL Database Engineer

Role purpose:

• We are seeking a versatile and skilled Open-Source Database Administrator (DBA) to join our database support team. The successful candidate will be responsible for the installation, configuration, maintenance, management, optimisation, and security of open-source database environments that power critical business applications.
• In this role, you will collaborate closely with business owners, developers, DevOps, Infrastructure, and SecOps teams to ensure the high availability, performance, scalability, and security of critical data platforms.
• This is an excellent opportunity to contribute to the stability and continuous improvement of enterprise database environments while supporting business-critical systems and services.

Role description:

Key Responsibilities

• Open-Source Database Support
• Support the current PostgreSQL open-source databases.
• Future open-source databases can include MySQL, MariaDB, MongoDB, Redis, etc.
• Support cloud database solutions (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL/MySQL).
• Manage & maintain the Oracle Golden Gate (OGG) replication environment which include troubleshooting and resolving issues related to OGG replication.
• Provide 24/7 support for critical systems, including on-call rotations

Design, Install & Maintain

• Design and implement high-availability, replication, and disaster recovery solutions.
• Install, configure, and maintain open source databases such as PostgreSQL, MySQL, and MariaDB in development, test, and production environments.
• Execute patching updates, upgrades & migrations

Monitoring & Capacity Management

• Monitor and tune database performance to meet SLAs.
• Perform capacity planning and resource allocation.

Backup & Recovery

• Develop and manage robust backup and recovery strategies using appropriate tools.
• Ensure active-active and DR environments are all in sync to facilitate BCM activities
• Automation: Automate administrative tasks using scripts, configuration management, IaC and CI/CD tools.
• Team Collaboration: Work closely with your team members in an agile framework to provide open-source database services and support.
• Collaborate with business and IT teams in a project context to work on new initiatives and requirements.
• Security & Risk Management : Ensure data security through proper user management, permissions, and encryption techniques of the databases.
• Documentation & Reporting: Provide regular updates to management on support & project status, challenges, and risks.
• Document database configurations, processes, and best practices.
• Stay current with open source database technologies and contribute to continuous improvement efforts.
• Information Security: Comply with MPA's information security policy, standards and procedures
• Report all suspected security and/or policy breaches and potential security risks to MPA Corporate Security
• Protect MPA's information assets from unauthorized access, disclosure, modification, destruction or interference
• Protect your user accounts and associated passwords.

Competencies / Skills

Technical / Professional Expertise

• Project Management skills
• Excellent problem analysis and resolution skills to support work in reactive and proactive environments
• Good written and verbal skills.
• Proven track record of managing and maintaining PostgreSQL and other open-source databases.
• Should be a good team player and should be able perform well under stress
• Teamwork. Ability to operate effectively in a technically complex environment.
• Act with Simplicity and Speed
• High level of Trust and Trusted Essential:
• Educated to degree level in STEM or equivalent working experience.
• At least 5 years' experience in managing PostgreSQL or open-source databases in a production environment.
• Strong knowledge of PostgreSQL architecture, internals, and tools.
• Hands-on experience with replication, high availability, and disaster recovery.
• Proficiency in writing and tuning SQL queries.
• Have exposure to the SAFe Agile framework.
• Have worked in Hybrid Cloud environments like Microsoft Azure.
• Solid understanding of Linux administration (e.g., RHEL, CentOS, Ubuntu).
• Experience with monitoring tools (e.g., Prometheus, Grafana, Zabbix) and automation frameworks (e.g., Ansible, Terraform).

Desirable:

• Optional Certifications - EDB Certified PostgreSQL Associate/Professional; Relevant cloud platform certifications (AWS, Azure, GCP); Linux administration certifications.
• ITIL Service Management experience
• Demonstrable working knowledge and competence using JIRA and Confluence
• Experience with DevOps and DevSecOps teams.
• Experience working within a multi-national team and serving customers from multiple countries would be of benefit.
• Familiarity with cloud-based database services (AWS RDS, GCP, Azure) is a plus.
• Knowledge of Oracle databases with experience in the RAC, Grid, ASM and data guard technologies.
• Knowledge of Oracle engineered systems (EXADATA & ZFS) and familiarity with Exadata System Software and monitoring tools (e.g., ExaWatcher).