Senior DBA Engineer - Oracle SQL/Cloud

Enterprise Holdings•Clayton, MO

1d•Hybrid

About The Position

Enterprise Mobility is a leading provider of mobility solutions, owning and operating the Enterprise Rent-A-Car, National Car Rental and Alamo Rent A Car brands through its integrated global network of independent regional subsidiaries. Enterprise Mobility and its affiliates offer extensive car rental, carsharing, truck rental, fleet management, retail car sales, as well as travel management and other transportation services, to make travel easier and more convenient for customers. Privately held by the Taylor family of St. Louis, Enterprise Mobility together with its affiliate Enterprise Fleet Management manages a diverse fleet of 2.4 million vehicles and accounted for nearly $39 billion in revenue through a network of more than 9,500 fully-staffed neighborhood and airport rental locations in more than 90 countries and territories. At the center of it all, our dedicated IT teams innovate, design and develop the technology that is redefining how customers rent, buy and share vehicles from our family of brands. Here, you will be part of a diverse and talented team that creates and delivers powerful technology solutions for our customers and employees across the world with the resources and support to develop in a variety of career paths. As an Enterprise Mobility team member, we offer an excellent package with market-competitive pay, comprehensive healthcare packages, 401k matching & profit sharing, schedule flexibility, work from home opportunities, paid time off, and organizational growth potential. This position is eligible for a hybrid work schedule, which is the ability to work from home, while also requiring to be in person as needed at our Lakeside and/or Clayton Corporate HQ campus locations in St. Louis, Missouri. The Rental Billing department is responsible for maintaining and managing the billing and invoicing software that produces outputs for our customers globally. This includes maintaining and managing interfaces with internal applications and delivering electronic data to external organizations and customers. This is an exciting time to be part of the billing team as we continue expanding globally and increasing our footprint across both on-prem and cloud-based database platforms. This posting is for an Engineer 2, DBA in the Rental Billing area. The position will have the opportunity to support several application development teams across multiple departments as part of the platform and infrastructure team. The candidate can anticipate working with various internal software products, including Rental Financial Systems, Bill Delivery, Foreign Rental Billing, COMPS, and Account Maintenance. These products support our accounting, invoicing, processing, and calculations for our company and all global customers. There will be no shortage of opportunities to develop relationships with contributors from the development teams as well as customers and sponsors of our products, along with the opportunity to champion teamwork as we continue to evolve our support model with a focus on operational efficiency, reliability, and proactive issue identification. As an Engineer 2, DBA, you will play a key role in the day-to-day operation, stability, and support of our database environments. This role is focused on supporting application teams, maintaining database health, and ensuring that database changes are implemented safely and efficiently across both on-prem and cloud environments. You will work with Oracle and PostgreSQL databases and collaborate closely with development teams to review database changes, troubleshoot issues, and support application releases.

Requirements

Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
Must reside in St. Louis, Missouri, or immediate surrounding area
3+ years of administering databases in a production environment, with strong experience in Oracle or PostgreSQL
Experience working in both on-prem and cloud-based environments, or strong experience in one with demonstrated aptitude to support and learn the other
Strong SQL skills, including the ability to write and read complex queries, review changes, and identify inefficient or incorrect scripts
Experience supporting application development teams with troubleshooting, release coordination, and change review
Experience with database user administration, access control, and least-privilege practices
Experience with database monitoring, alerting, and basic performance analysis
Experience with using version control (such as Git or Bitbucket) for committing, reviewing, and pulling database changes as part of the deployment workflow
Must be committed to incorporating security into all decisions and daily job responsibilities

Nice To Haves

Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field preferred
Experience with cloud-managed database services (AWS RDS, Aurora, etc), including backup, replication, and failover
Experience with PL/SQL or PL/pgSQL stored procedures and functions
Practical experience with Oracle tools such as OEM, RMAN, and Data Guard
Experience working with infrastructure-as-code tools such as Terraform for cloud configuration and support
Experience working in a Unix command line environment and with scripting languages (Shell, Python, Perl, etc)
Knowledge of Agile methodology and tools like JIRA and Confluence
Understanding of data governance and security standards (such as PCI)

Responsibilities

Implementation of approved DDL and DML changes in both prod and non-prod environments
Commit and manage database scripts in Bitbucket and pull approved changes for deployment in support of release and change management process
Review and approve application-driven database changes, to ensure compliance with performance, security, operational, and recoverability standards
Review SQL from application teams for correctness, efficiency, and safety
Develop and maintain a working understanding of the application data models, including core tables, relationships, data flows, and how applications use the schema, to support troubleshooting and change review
Monitor database health, performance, and capacity and act on alerts
Support application teams in troubleshooting database related issues
Support release cycles and assist with database patching, upgrades, and routine maintenance activities
Support backup, recovery, and restore validation activities
Facilitate user access management and support data security practices, including PII awareness and customer data redaction requests
Participate in an on-call rotation that includes some light after-hours support