Sr Database Administrator – Oracle

Hennessy Industries; United States; Remote; USD 98,000 - 125,000; Full time

Job summary

Hennessy Industries seeks an experienced Oracle DBA to manage critical databases within a SaaS environment focused on reliability and performance. You’ll upgrade, patch, and automate database management tools while ensuring optimal database health. Join a team dedicated to delivering exceptional software solutions and leveraging cutting-edge cloud technologies.

Benefits

Medical, dental, and vision benefits

401(k) plan with company matching

Paid time off up to 15 days annually

12 paid holidays including 2 floating holidays

Qualifications

• Minimum of 6 years as Oracle DBA in a SaaS environment.
• 2+ years' experience with AWS RDS and MySQL preferred.
• Knowledge of the fueling industry is a plus.

Responsibilities

• Upgrade and patch Oracle databases with minimal downtime.
• Document operational procedures for critical databases.
• Design automated deployment tools and processes.

Skills

Oracle management

AWS management

Database performance tuning

Backup and recovery automation

Shell scripting

PL/SQL

Terraform

Linux administration

Education

Bachelor's degree in Computer Science or equivalent

Tools

Oracle Enterprise Manager

Amazon Aurora RDS MySQL

Job description

At Invenco, our Database team plays a critical role in powering the backbone of our SaaS applications by managing a robust and sophisticated database environment hosted on AWS. This environment includes Oracle Enterprise running on EC2 instances and Amazon Aurora MySQL on RDS. We are dedicated to maintaining the highest standards of database health, stability, and availability to ensure seamless, uninterrupted service for our customers. By leveraging cutting-edge cloud technologies and best practices, our team drives innovation and reliability in support of Invenco’s mission to deliver exceptional software solutions.

WHAT YOU WILL DO:

• Upgrade and patch 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 CT, must be available to work during times of production upgrades.

ABOUT YOUR EXPERIENCE:

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

Oracle Enterprise Manager 13.5

• Leveraging dynamic groups
• Configuring database monitoring through templates

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
• SQL Performance tuning
• Oracle Restart usage and installation
• Oracle advanced dataguard
• Rolling upgrades with dbms_rolling
• Creating and managing standby databases
• Basic terraform experience
• Linux administration
• Shell scripting
• PL/SQL

Preferred skill sets:
• OCP – Oracle Certified Professional
• Oracle advanced security
• Oracle Goldengate and Veridata
• zero downtime upgrades
• switching sync direction
• advanced Terraform experience
• Ansible
• Github/Bitbucket
• Amazon Aurora RDS MySQL
• Oracle EE on RDS
• MySQL – advanced administration

The base compensation range for this position is $98,000.00 to $125,000.00 per annum. Your actual base salary will be determined based upon numerous factors which may include relevant experience, skills, location (labor market data), credentials (education, certifications), and internal equity.

Vontier partners with you and your family on your health and wellness journey. Visit VontierBenefits.com to view our benefits. We offer a premium suite of health and wellness programs for you and your family, including medical, dental, vision, disability and life insurance. With programs for family planning from Maven Clinic to managing diabetes like Livongo, coverage for women's health, support for adult and elder care, paid parental leave, a generous 401(k) plan with matching company contributions, and more. Vontier is here for all stages of life. We also offer paid time off up to 15 days each year, 12 paid holidays (including 2 floating holidays), and paid sick leave.*

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Sick leave amount may vary based on state or local laws applicable to the applicant’s geographic location. The Company reserves the right to modify this information at any time, subject to applicable law.

WHO IS INVENCO by GVR

Invenco by GVR is a dynamic and innovative force in the technology-driven retail solutions. Born from integrating groups within the Gilbarco Veeder-Root network and the strategic acquisition of technology companies worldwide, our foundation is built on tech expertise. With a diverse set of industry leaders including Orpak, Invenco, Insite360 & GVR, we have formed a network of excellence. Our team members are located in over 20 countries and we are proud of the global diversity of our teams.

WHO IS VONTIER

Vontier (NYSE: VNT) is a global industrial technology company uniting productivity, automation and multi-energy technologies to meet the needs of a rapidly evolving, more connected mobility ecosystem. Leveraging leading market positions, decades of domain expertise and unparalleled portfolio breadth, Vontier enables the way the world moves – delivering smart, safe and sustainable solutions to our customers and the planet. Vontier has a culture of continuous improvement and innovation built upon the foundation of the Vontier Business System and embraced by colleagues worldwide. Additional information about Vontier is available on the Company’s website at www.vontier.com.

At Vontier, we empower you to steer your career in the direction of success with a dynamic, innovative, and inclusive environment.

Our commitment to personal growth, work-life balance, and collaboration fuels a culture where your contributions drive meaningful change. We provide the roadmap for continuous learning, allowing creativity to flourish and ideas to accelerate into impactful solutions that contribute to a sustainable future.

Join our community of passionate people who work together to navigate challenges and seize opportunities. At Vontier, you are not on this journey alone-we are dedicated to equipping you with the tools and support needed to fuel your innovation, lead with impact, and thrive both personally and professionally.

Together, let’s enable the way the world moves!

#LI-LP1 #LI-Remote

"Vontier companies are equal employment employers and evaluate qualified applicants without regard to race, color, national origin, religion, ancestry, sex (including pregnancy, childbirth and related medical conditions), age, marital status, sexual orientation, gender identity or expression, and other characteristics protected by law."