Senior Database Admin (AWS & Postgres)

Techblocks Inc.; Dublin; Hybrid; EUR 90,000 - 120,000; Part time

Job summary

Techblocks Inc. in Dublin, Ireland, is seeking a Senior Database Administrator to manage production databases with Oracle, PostgreSQL, and AWS.

You will oversee deployments on RDS, Aurora, and EC2, optimize performance, implement backups, DR, and work closely with DevOps on CI/CD while supporting on-call rotations. The role requires 12+ years of hands-on experience and strong expertise in Oracle 19c, PostgreSQL 17, and AWS services.

Qualifications

• 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 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.

Responsibilities

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

Skills

Oracle 19c

PostgreSQL 17

AWS Cloud

SQL performance tuning

RMAN/Backups

Incident management

Automation with Python

CI/CD practices

DevOps collaboration

Tools

AWS RDS

Aurora

EC2

Oracle OEM

FogLight

CloudWatch

Job description

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.