PostgreSQL Database Administrator

Your digital journey starts here!

Create. Grow. Deliver our story to millions.

#BTCode, where technology meets creativity. Code is our universal language and innovation is the fuel that propels us into the future.

Role Overview:

We are looking for a PostgreSQL Database Administrator to manage, secure, optimize, and ensure the availability of critical PostgreSQL environments. The role also requires Oracle Database administration knowledge to support hybrid database landscapes and maintain operational continuity across existing platforms.

Key Responsibilities:

PostgreSQL Administration

• Install, configure, and administer PostgreSQL environments across Production, Disaster Recovery, Test, and Development.

• Design, implement, and maintain High Availability and Disaster Recovery solutions (Patroni, repmgr, pg_auto_failover, EDB, streaming replication, etc.).

• Manage backup and recovery solutions using pgBackRest, Barman, or similar technologies.

• Monitor database environments and proactively identify and resolve incidents.

• Analyze and optimize SQL performance and PostgreSQL configurations.

• Perform database upgrades, patching, and version migrations.

• Configure and maintain database security in line with organizational standards.

• Automate operational tasks through scripting and administration tools.

Oracle Database Support

• Provide basic to intermediate Oracle Database administration support.

• Understand and apply Oracle backup and recovery concepts using RMAN.

• Work with Oracle technologies such as RAC, Data Guard, and ASM.

• Perform day-to-day operational tasks under the guidance of senior Oracle DBAs when required.

• Contribute to Oracle-to-PostgreSQL migration initiatives.

• Previous Oracle DBA experience is considered an advantage but is not mandatory.

Operations & Support

• Participate in Incident, Problem, and Change Management processes.

• Troubleshoot critical incidents and perform root cause analysis.

• Create and maintain technical documentation and operational procedures.

• Collaborate with infrastructure, application, security, and development teams.

• Ensure compliance with audit, security, and regulatory requirements.

Required Experience & Technical Skills

• Experience managing mission-critical 24/7 database environments.

• Strong PostgreSQL administration expertise.

• Linux Enterprise administration experience.

• Knowledge of storage, filesystems, and networking concepts.

• Bash scripting skills.

• Strong troubleshooting and performance tuning capabilities.

Nice to Have

• Experience in the financial or banking sector.

• Experience with OpenShift, Kubernetes, or cloud platforms.

• Experience with EDB Postgres Advanced Server.

• Experience with Ansible.

• Previous involvement in Oracle-to-PostgreSQL migration projects.