Oracle DBA (AWS , PostgreSQL)

Smartedge Client is looking for an individual to help with their Oracle DBA (AWS , PostgreSQL) @ Dublin, Ireland (Hybrid Working)

Job Description :

The Database team is responsible for managing and supporting our 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 via SPGI process 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 SLA’s
• Modelling and scripting database changes for all our products
• Ensure client releases are packaged and made available in a timely manner
• Be available for occasional on-call rotation or weekend deployments

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

• 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
• 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.
• 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.
• 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.
• Configure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch, lambda and AWS SNS.
• Collaboration & 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.
• 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.
• Oracle Enterprise Manager (OEM), Foglight
• SQL Developer, PGAdmin
• Shell scripting, PowerShell, PL/SQL, PG/SQL
• GitHub, Terraform, Ansible,
• JIRA, Service Now, Confluence
• AWS native services including AWS Backup
• Strong 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
• Strong attention to detail

If this sounds like a role you would be interested in or if you know someone in this field.

Connect with me or email me at vineetha.s@smartedgesolutions.co.uk

Alternatively, you can call me on Tel: +44(0)203 500 2108.