Senior Database Administrator
Summary
Contract Senior DBA in Dublin (hybrid, 2 days onsite) administering Oracle 19c and PostgreSQL 17 databases on AWS (RDS, Aurora, EC2) for managed-services clients of a global financial data and analytics organization, focusing on performance tuning, backup/DR, monitoring, automation, and on-call incident support.
Senior Database Administrator (Oracle & PostgreSQL, AWS)
Location: Dublin 2, Hybrid (2 days onsite)
Job Type: Contract
Experience: 10+ years
Rate: Best in the industry
Diatom Technologies is hiring a Senior Database Administrator for a leading global financial data and analytics organization in Dublin.
The Database team is responsible for managing and supporting Managed Services clients. The role involves being a member of the database team within Managed Services, which is responsible for maintaining managed services databases on the cloud (Oracle 19c, Postgres 17), including:
- Management of all managed services environments (internal and client-facing)
- Provide support for any database related issues to all clients, particularly managed services clients
- Manage high severity incidents and work with all stakeholders to resolve issues as soon as possible, including attending client bridge calls
- Ensure database requests are dealt with within defined SLAs
- Modelling and scripting database changes for all products
- Ensure client releases are packaged and made available in a timely manner
- Be available for occasional on-call rotation or weekend deployments
The cloud is hosted on AWS and includes Amazon RDS, Amazon EC2 and Amazon Aurora. The role requires expertise in database performance tuning, security, cloud-based best practices and ensuring continuous availability. The DBA will collaborate closely with developers, system administrators and DevOps teams to ensure efficient database integration with business applications.
Production Stability and Reliability:
- Own the stability, performance and availability of all production database environments
- Work on incident resolution, root cause analysis and prevention strategies
- Define and enforce database operational standards, guardrails and best practices
- Perform change management
Database Management and Maintenance:
- Administer and maintain Oracle and PostgreSQL databases hosted on Amazon RDS, Amazon Aurora and Amazon EC2
- Perform database installations, patching and upgrades on AWS infrastructure
- Configure and manage multi-AZ deployments, Read Replicas and cross-region architectures
- Implement database partitioning, compression and indexing to optimize performance
Performance Engineering:
- Conduct deep performance analysis at the system, query and indexing levels
- Recommend and implement architectural improvements for scalability
- Guide application teams in schema and query optimization
Backup and Recovery:
- Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots for RDS Oracle and Aurora Postgres
- Use Oracle RMAN for Oracle database backups and recovery
- Develop and test disaster recovery plans
Monitoring and Alerting:
- Configure proactive alerts for performance issues, storage limits and availability risks using CloudWatch, Lambda and AWS SNS
Collaboration and Documentation:
- Collaborate with developers, cloud architects and DevOps teams to integrate database changes into CI/CD pipelines
- Document database architectures, configurations, backup strategies and recovery plans
Automation and Innovation:
- Drive automation of operational DBA tasks using PowerShell, Python, AWS CLI, GitHub Actions or similar tools
- Evaluate and implement new database technologies, monitoring solutions and optimization tools
Tools and Technologies:
- Oracle Enterprise Manager (OEM), Foglight
- SQL Developer, PGAdmin
- Shell scripting, PowerShell, PL/SQL, PG/SQL
- GitHub, Terraform, Ansible
- JIRA, ServiceNow, Confluence
- AWS native services including AWS Backup
What we are looking for:
- 10+ years of experience as a DBA, with a strong emphasis on Oracle, Postgres, AWS and performance tuning
- Familiar with working in both development and production environments
- Willingness to work any shift and to perform additional hours as needed
- Good interpersonal skills and ability to operate in a dynamic environment
- Excellent problem-solving skills
Skills
Sign in to read and join the discussion.