Senior Database Admin (AWS & Postgres)

Title: Senior Database Administrator (Oracle & PostgreSQL – AWS)

Location: Dublin, Ireland

Employment Type: Contract

Experience: 12+ Years

About the Role

TechBlocks is looking for an experienced Senior Database Administrator (DBA) with strong expertise in Oracle, PostgreSQL, and AWS cloud services to manage and support mission-critical production databases.

Key Responsibilities

• Manage and maintain Oracle 19c and PostgreSQL 17 databases on AWS RDS, Aurora, and EC2.
• Ensure database performance, availability, security, and reliability.
• Perform database installations, upgrades, patching, and performance tuning.
• Handle production incidents, root cause analysis (RCA), and troubleshooting.
• Implement backup, recovery, replication, and disaster recovery solutions.
• Monitor database performance using CloudWatch, Oracle OEM, and Foglight.
• Automate DBA tasks using Python, PowerShell, Terraform, and Ansible.
• Collaborate with DevOps and development teams on database deployments and CI/CD.
• Support occasional on-call rotations and weekend deployments.

Required Skills

• 12+ years of hands-on database administration experience.
• Strong expertise in Oracle 19c and PostgreSQL 17.
• Hands-on AWS experience with RDS, Aurora, and EC2.
• Advanced SQL performance tuning, indexing, and query optimization.
• Experience with Oracle RMAN, AWS Backup, and high-availability solutions.
• Strong production support, incident management, and RCA experience.
• Knowledge of scripting, automation, and DevOps tools.
• Excellent troubleshooting and communication skills.

Preferred Skills

• AWS or Oracle certifications.
• Experience supporting enterprise Managed Services environments.
• Knowledge of GitHub Actions, CI/CD, and database automation.