Publicis Sapient - Database Administrator - PostgreSQL

Description:

Purpose : Capabilities, Experience & Qualification Requirements

Why do we need this role ?

Role of Junior DBA is to automate, maintain and provide BAU support, for PostgresSQL environments, particularly those based on Crunchy.

This engineer will play a critical role in ensuring the security, availability, and performance of our databases, while also supporting engineering teams in feature development and infrastructure automation

The Infrastructure engineer role in core banking modernization is critical to ensure secure and reliable operations of cloud infra to run Mission, Customer and Country critical applications including core ledger with relational database and docker containers as key components

What and how is it expected to contribute to results ?

They will be a team player who is customer focused and committed to delivering quality integration solution.

They will provide critical thinking and a high degree of technical innovation and attention to detail while being recognised as a trusted advisor to the team and stakeholders.

Their characteristics will include being versatile, displaying leadership qualities and enthusiasm to take on new problems and assist NAB in moving technology forward to benefit our customers

As well as the technical skills we are looking for someone who is a great communicator, solutions driven and thrives in working in a team to achieve the project goals.

Essential capabilities :

- Deliver Business-as-Usual (BAU) PostgreSQL support across multi-cloud environments.

- Maintain and optimize PostgreSQL database environments with adherence to SLAs.

- Leverage Ansible for database automation, working closely with Crunchy PostgreSQL tooling.

- Develop, maintain, and troubleshoot Unix Shell scripts to support system integration and process automation.

- Collaborate with cross-functional engineering teams to ensure seamless integration of automation pipelines.

- Facilitate a smooth handover from the existing support arrangement ending December 31, 2025.

- Participate in database-related feature development and infrastructure enhancements.

- Ensure high availability, reliability, and disaster recovery readiness of the database ecosystem.

- Maintain currency of PostgreSQL database software and supporting tools (patching and upgrades).

- Develop and maintain automation tools for building, deploying and managing PostgreSQL databases

- Support the Crunchy Ansible Playbooks

- Patching of databases and clustering software (Patroni), Upgrades, Product enhancement

- Work in an agile environment, attending stand-ups, retros, planning, showcases and other agile meetings and ceremonies

- Work closely with scrum masters, asset designers and data consulting team to determine platform requirements and priorities

- Demonstrate strong technical thought leadership that helps resolve technical barriers and roadblocks impacting delivery teams

- Showcase work to stakeholders

- Automate using Ansible, PostgreSQL

- Design and maintain the Cloud environments

Technical capabilities :

- 5+ years PostgreSQL DBA experience (Not a guru but above average)

- Experienced with Patroni clustering

- Hands on Bash Shell scripting

- Ansible experience

- Bonus Crunchy PostgreSQL

- Crunchy Automation PostgreSQL experience is a huge bonus

- Hands on experience with Clustered PostgreSQL databases especially knowledge of Patroni.

- Deep understanding of PostgreSQL Infrastructure, clustering, and replication

- Strong expertise in PostgreSQL administration and Support

- Strong knowledge of Linux/Unix

- Well above average Bash shell scripting

- Proficient in PostgreSQL db backups (pgbackrest), Recovery, BAU Support, performance tuning, PostgreSQL concepts

- Experience supporting DBs in Cloud Environments (AWS, Azure, GCP)

- Contribute to end-to-end automation and database workflows.

- Understanding of Monitoring and Alerting needs for large scale systems

Experience :

It is expected that the role holder will most likely have the following qualifications and experience :

- Proven experience in PostgreSQL administration and performance tuning.

- Hands-on expertise with Ansible for configuration management and automation.

- Strong Unix/Linux Shell scripting abilities.

- Solid understanding of backup/restore procedures and high availability setups.

- Capability to understand and contribute to end-to-end automation and database workflows.

- Experience working in multi-cloud or hybrid environments.

- Exposure to FOAK (First-Of-A-Kind) database solutions is an advantage.

- Excellent analytical and problem-solving skills.

- Collaborative mindset with the ability to work across engineering and operations teams.

Qualification Requirements :

- Tertiary qualification in technology related degree