ORACLE & POSTGRESQL DATABASE ADMINISTRATOR (DBA) (HYBRID)

ORACLE & POSTGRESQL DATABASE ADMINISTRATOR (DBA) (HYBRID LISBON)

Portuguese company hires for hybrid position

📍 Location: Lisbon, Portugal

⚠️ Only candidates already based in Portugal will be considered

💼 Work Model: Hybrid – 3 days per week in the office

🕘 Working Hours: 9 AM – 6 PM

🗣️ Language Requirements: Portuguese C2 and English B2+ (mandatory)

🕓 Seniority: Mid-level (3+ years)

📅 Start Date: January 4, 2027

📆 Project Duration: 36 months, with possibility of renewal

💲Rate Between €4000 - 4500 RV or Unipessoal (preferred) / €2000 - 2500/month gross under an employment contract (CTI), depending on proven experience

⚠️ Instructions: Please send your CV in English and make sure to include all skills and experience that match the requirements of the opportunity. This will significantly increase your chances of success.

About The Opportunity

We are looking for an experienced Database Administrator for our cliente with at least 3 years of hands-on experience in both Oracle and PostgreSQL database environments. The ideal candidate will combine solid Oracle administration expertise, including RAC, Data Guard, and RMAN, with advanced PostgreSQL skills in high availability, replication, performance tuning, and backup management. Practical experience with Patroni, EDB BDR, PGBackRest, and Barman is essential. This role requires a versatile professional capable of managing and optimising complex, business-critical database infrastructures across both technologies.

Responsibilities

• Install, configure, administer and maintain Oracle and PostgreSQL database environments.
• Ensure the performance, availability, security and reliability of OLTP and OLAP systems.
• Manage Oracle database environments, including legacy and modern versions.
• Implement and maintain Oracle high-availability solutions using RAC, failover and Data Guard.
• Perform Oracle backup and recovery operations using RMAN.
• Execute Oracle database migrations, upgrades, patching and performance tuning.
• Install, configure and administer PostgreSQL 13 and later versions.
• Implement PostgreSQL high-availability and automatic failover solutions using Patroni.
• Manage advanced replication and distributed database architectures using EDB BDR.
• Design and maintain PostgreSQL backup and recovery strategies using PGBackRest and Barman.
• Monitor PostgreSQL database environments using PGWatch, Grafana and log analysis tools.
• Optimise database performance through query tuning, partitioning strategies and VACUUM optimisation.
• Implement security best practices across Oracle and PostgreSQL environments.
• Troubleshoot complex database incidents and performance issues.
• Maintain technical documentation and contribute to operational improvements.
• Collaborate with infrastructure, development and technical operations teams.
  
  

Requirements

Oracle Database Administration

• More than 3 years of professional experience administering Oracle databases in OLTP and OLAP environments.
• Experience with Oracle Database versions 7, 8i, 9i, 10g, 11g, 12c, 18c and 19c.
• Hands-on experience with Oracle RAC, failover and Data Guard.
• Experience with Oracle RMAN backup and recovery.
• Proven experience in migrations, upgrades and patching.
• Strong knowledge of database performance analysis and tuning.
• Experience with Oracle Grid Control.
  
  

PostgreSQL Database Administration

• More than 3 years of professional experience administering open-source databases, particularly PostgreSQL.
• Experience installing, configuring and managing PostgreSQL 13 or later.
• Strong understanding of PostgreSQL security and administration best practices.
• Experience with database migrations, upgrades and patch management.
• Proven expertise in PostgreSQL performance tuning and active log monitoring.
• Hands-on experience with PostgreSQL high-availability architectures, including Patroni and EDB BDR.
• Experience implementing Patroni for automated failover.
• Knowledge of table partitioning and VACUUM optimisation.
• Experience with database monitoring using PGWatch and Grafana.
• Experience implementing backups using PGBackRest and Barman.
  
  

Additional Technical And Professional Requirements

• Good knowledge of Linux, HP-UX and Windows operating systems.
• Experience supporting highly complex and business-critical database environments.
• Knowledge of ISO 20000 and ISO 27001 standards.
• Strong troubleshooting and analytical skills.
• Excellent organisational, communication and problem-solving abilities.
• Ability to manage technical priorities independently and collaborate with multidisciplinary teams.
  
  

Required Certifications

• Oracle Certified Professional (OCP) – 11g and 12c.
• Oracle Database SQL Certified Expert.
• Certified PostgreSQL DBA (CPSDBA).
• EDB PostgreSQL 13 Professional Certification.
• Relevant ISO 20000 and ISO 27001 qualifications or certifications.
  
  

Additional Information

The successful candidate will join a long-term project involving the administration, optimisation and operational support of complex Oracle and PostgreSQL database environments, with a strong focus on high availability, resilience and performance.

5 Questions for Candidates

• Do you have at least 3 years of hands-on experience administering both Oracle and PostgreSQL databases?
• What is your experience with Oracle RAC, Data Guard, RMAN, and Grid Control?
• Have you implemented PostgreSQL solutions using Patroni, EDB BDR, PGBackRest, and Barman?
• Which of the required Oracle, PostgreSQL, and ISO certifications do you currently hold?
• Are you available to work on-site in Lisbon 3 days per week starting January 4, 2027, and are you aligned with the proposed contract and compensation conditions?
  
  

Keywords

Oracle DBA, PostgreSQL DBA, Oracle RAC, Data Guard, RMAN, Oracle Grid Control, PostgreSQL 13+, Patroni, EDB BDR, PGBackRest, Barman, High Availability, Replication, Performance Tuning, SQL, OLTP, OLAP, PGWatch, Grafana, Linux, HP-UX, ISO 20000, ISO 27001.

#GT