Job Description

Important Info: For this position you need to be located in Buenos Aires (ARG)

Join our team managing a large-scale database environment on AWS, including Oracle Enterprise on EC2 and Aurora MySQL on RDS. This role focuses on ensuring our database infrastructure remains healthy, stable, and highly available to support our mission-critical SaaS applications.

Responsibilities:

• Upgrading and patching Oracle databases using various techniques for minimal downtime.
• Document and maintain operational procedures and standards for business critical databases.
• Manage the operational aspects of Cloud-based and on-prem databases, including security, auditing, backup, and recovery.
• Design and implement automated deployment tools and processes.
• Maintain and support development, test and production databases for user access, table changes, performance, and troubleshooting.
• Monitor database performance and ensure database availability.
• Test and implement new database features for general use.
• Automate and test backup and recovery solutions for highly available databases across multiple technologies.
• Help design and evaluate major changes to standards and procedures related to database technology direction changes.
• Participate in on-call support.
• Production outage window is typically 9pm Central, so this person needs to be willing to work at that time during times of production upgrades.

Requirements:

• At least 6 years of experience as an Oracle production DBA in a SaaS environment.
• At least 2 years of experience with AWS RDS and MySQL.
• Knowledge of the fueling industry is a plus.

Skill sets:

• Oracle Enterprise Manager 13.5.
• Leveraging dynamic groups.
• Configuring database monitoring through templates.
• Setting up OEM for HA.

Backup and recovery:

• Oracle secure backup – encrypted backups to s3.
• Managing backups through OEM dynamic groups.
• Scripting rman automation for non-production refreshes.

Oracle Real Application Testing:

• Oracle Replay.
• SQL Performance analyzer.
• Cloning databases for replay.
• Oracle tuning and diagnostics.
• Oracle restart usage and installation.
• Oracle advanced dataguard rolling upgrades with dbms_rolling.
• SQL Performance tuning.
• Basic terraform experience.
• Linux.
• Shell scripting.
• PL/SQL.

Preferred skill sets:

• Oracle advanced security.
• Oracle Goldengate andVeridata.
• Advanced Terraform experience.
• Ansible.
• Github/Bitbucket.
• Amazon Aurora RDS MySQL.
• Oracle EE on RDS.
• MySQL – advanced administration.