Sr Oracle Database Admin

$80,000 - $110,000/Yr

The Hertz Corporation - Estero, FL

posted 3 months ago

Full-time - Mid Level
Estero, FL
5,001-10,000 employees
Rental and Leasing Services

About the position

The Sr Oracle Database Admin role at Hertz is pivotal in ensuring the governance, availability, and deployment of database systems both on-premises and in the cloud. This position serves as a crucial link between development and operations, applying a software engineering mindset to system administration tasks. Daily responsibilities encompass a wide range of activities including solution architecture, infrastructure monitoring, incident response, and the automation of infrastructure and application deployments across all software development lifecycles. The role directly influences financial performance through application availability, compliance, and innovation, making it essential for the organization's success. In this position, you will manage highly available and scalable Oracle, MySQL, and DB2 databases, as well as AWS RDS MySQL, PostgreSQL, and Aurora databases. You will be responsible for database migrations to the AWS Cloud, designing highly available and scalable database solutions, and advocating best practices across both on-premises and AWS Cloud environments. Additionally, you will design and implement disaster recovery solutions for large-scale database systems, collaborating with various teams to deploy and support databases on EC2, AWS RDS, and VMware platforms. Your role will also involve advanced troubleshooting skills, focusing on database performance tuning, issue resolution, and ongoing replication issues. You will automate day-to-day administration and database maintenance tasks, execute large-scale database patching, upgrades, and migrations, and define best practices around database security to ensure compliance across all systems. Providing on-call support for production database systems and mentoring team members to build cloud knowledge will also be key aspects of your responsibilities. Clear and regular communication with project teams and management is essential to drive team success and continuous improvement in processes.

Responsibilities

  • Manage highly available and scalable Oracle/MySQL/DB2 databases, AWS RDS MySQL/PostgreSQL/Aurora MySQL/Aurora PostgreSQL Database on AWS.
  • Oversee database migrations to AWS Cloud.
  • Design highly available (HA) and scalable database solutions and advocate best practices across on-prem and AWS Cloud.
  • Implement disaster recovery (DR) solutions for large-scale database systems.
  • Collaborate with architecture, engineering, support, and teams in designing, deploying, and supporting database solutions.
  • Design, deploy, and support databases on EC2, AWS RDS, and VMware platform.
  • Develop and support HA/DR solutions for SQL Server and Oracle Databases in a hybrid environment.
  • Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
  • Handle multiple projects and deadlines in a fast-paced environment independently.
  • Perform advanced troubleshooting: Database performance tuning, issue resolutions, ongoing replication issues.
  • Automate day-to-day administration and database maintenance in the Cloud/or on-premises.
  • Design and execute large-scale database patching, upgrades, and migrations including OnPrem and in Cloud.
  • Define and manage best practices around database security and ensure compliance across all database systems.
  • Provide on-call support for production database systems.
  • Drive continuous improvement and automation as much as possible.
  • Communicate clearly and regularly with project teams and management.
  • Mentor team members and build cloud knowledge within the team.

Requirements

  • Hands-on experience with relational and non-relational databases (Oracle/SQL Server/DB2/PostgreSQL/MySQL) on AWS and/or on-prem infrastructure.
  • Experience in deploying databases (on-prem/AWS) and production support with performance tuning and root cause analysis.
  • Minimum 8-10 years of overall experience.
  • 3+ years' experience with AWS Services like AWS RDS, Aurora, EC2, S3, DMS, AWS Backups, and DynamoDB.
  • 3+ years' experience with the design and deployment of Amazon Machine Images (AMI) for Database.
  • 8+ years of Oracle experience in a Production Environment: Install, Configure, Patch, Upgrade, and Support databases in Production.
  • 6+ years of SQL Server experience in a Production Environment: Install, Configure, Patch, Upgrade, and Support databases in Production.
  • 5+ years of Db2 experience in a Production Environment: Install, Configure, Patch, Upgrade, and Support databases in Production, knowledge with qrep.
  • Experience with AWS Cloud Service Provider Architecture deployment use cases and best practices.
  • Oracle DataPump and RMAN: Backup and Recovery.
  • 5+ years' experience with Oracle Golden Gate Replication: Install, Configure, Upgrade, Support, & Troubleshoot.
  • 5+ years' experience with SQL Server Always-On: Install, Configure, Upgrade, Support, & Troubleshoot.
  • UNIX / Linux OS Performance tuning.
  • SQL, Shell Scripting.
  • Experience in database migrations from on-prem to AWS Cloud, replication technologies like Oracle Golden Gate/HVR.
  • Agile methodology experience, including Scrum Ceremonies and work management tools (e.g., JIRA, Confluence).
  • Excellent communication skills.

Nice-to-haves

  • AWS Certification - Database, AWS Certified Solutions Architect.
  • SQL Server, Oracle Certified Professional.

Benefits

  • Up to 40% off the base rate of any standard Hertz rental.
  • Paid Time Off.
  • Medical, Dental & Vision plan options.
  • Retirement programs, including 401(k) employer matching.
  • Paid Parental Leave & Adoption Assistance.
  • Employee Assistance Program for employees & family.
  • Educational Reimbursement & Discounts.
  • Voluntary Insurance Programs - Pet, Legal/Identity Theft, Critical Illness.
  • Perks & Discounts - Theme Park Tickets, Gym Discounts & more.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service