Senior Cloud DBA – Oracle & PostgreSQL (AWS)

IntelliConsult; Dublin; On-site; EUR 90,000 - 130,000; Full time

Job summary

IntelliConsult in Ireland seeks an experienced DBA to own the stability and performance of production databases on AWS (Oracle 19c, Postgres 17) across RDS, Aurora, and EC2.

You will lead incident response, change management, backup strategies, and performance tuning while collaborating with DevOps and development teams. On-call rotations may apply. The role demands strong scripting, automation, and documentation to ensure continuous availability and scalable database architectures.

Qualifications

• 12+ years of experience as a DBA with emphasis on Oracle, Postgres, AWS and performance tuning.
• Experience in development and production environments.
• Willingness to work shifts and extra hours as needed.
• Strong interpersonal skills and ability to operate in a dynamic environment.

Responsibilities

• Own the stability, performance, and availability of all production database environments.
• Handle incident resolution, root cause analysis, and prevention strategies.
• Define and enforce database standards, guardrails, and best practices.
• Perform Change Management.
• Administer Oracle and PostgreSQL databases on AWS RDS, Aurora, and EC2.
• Install, patch, and upgrade databases on AWS infrastructure.
• Manage multi-AZ deployments, Read Replicas, and cross-region architectures.
• Implement partitioning, compression, and indexing to optimize performance.
• Conduct deep performance analysis at system, query, and indexing levels.
• Guide app teams in schema and query optimization.
• Design automated backup strategies using AWS Backup and RDS Snapshots; use RMAN where appropriate.
• Document architectures, configurations, backup strategies, and recovery plans.
• Drive automation of DBA tasks using PowerShell, Python, AWS CLI, GitHub Actions.

Skills

DBA experience

Oracle & PostgreSQL performance tuning

AWS cloud

Incident management

SLA adherence

Cross-functional collaboration

On-call / weekend deployments

Tools

SQL Developer

PGAdmin

Shell scripting

PowerShell

PL/SQL

PG/SQL

GitHub

Terraform

Ansible

JIRA

ServiceNow

Confluence

AWS Backup

CloudWatch

Job description

IntelliConsult in Ireland seeks an experienced DBA to own the stability and performance of production databases on AWS (Oracle 19c, Postgres 17) across RDS, Aurora, and EC2.

You will lead incident response, change management, backup strategies, and performance tuning while collaborating with DevOps and development teams. On-call rotations may apply. The role demands strong scripting, automation, and documentation to ensure continuous availability and scalable database architectures.