PostgreSQL DBA
Posted
Description
Role: PostgreSQL DBA
Location : Dublin Hybrid ( 2-3 days a week onsite)
Job Type: B2B Contact
The DBA will join the Database team within Managed Services. The team maintains cloud-hosted Oracle 19c and PostgreSQL 17 databases on AWS (RDS, Aurora and EC2) for internal and client-facing environments, and the DBA works closely with developers, system administrators and DevOps.
Key responsibilities
- Production support: own stability, performance and availability. Handle high-severity incidents through the SPGI process, including client bridge calls, and lead root cause analysis and change management.
- Database administration: installation, patching and upgrades on AWS; multi-AZ, read replica and cross-region setups; partitioning, compression and indexing.
- Performance tuning: in-depth system, query and index analysis; scalability improvements; guiding application teams on schemas and queries.
- Backup and DR: AWS Backup, RDS snapshots and Oracle RMAN; designing and testing disaster recovery plans.
- Monitoring: proactive alerts with CloudWatch, Lambda and SNS.
- Releases and requests: script database changes, package client releases on time, and meet request SLAs.
- Automation: Python, PowerShell, AWS CLI and GitHub Actions; integrating database changes into CI/CD pipelines.
Tools: OEM, Foglight, SQL Developer, pgAdmin, PL/SQL and PL/pgSQL, shell scripting, Terraform, Ansible, GitHub, Jira, ServiceNow and Confluence.
Requirements
- 12+ years as a DBA, with strong Oracle, PostgreSQL, AWS and performance-tuning skills
- Experience in both development and production environments
- Flexible on shifts, with on-call rotation, weekend deployments and extra hours as needed
- Strong problem-solving, attention to detail and interpersonal skills
Skills
Sign in to read and join the discussion.