Senior DBA Engineer Oracle SQLCloud
St. Louis, MO - USA
Job Summary
Overview
Enterprise Mobilityis a leading provider of mobility solutions owning andoperatingtheEnterprise Rent-A-CarNational Car RentalandAlamo Rent A Carbrands through its integrated global network ofindependent regional subsidiaries. Enterprise Mobility and its affiliates offer extensive car rentalcarsharing 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 9500 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 includes 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.
Responsibilities
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.
Responsibilities include:
- 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
Knowledge skills and abilities:
- Proven ability to safeguard confidential and highly sensitive database content
- Strong communication skills able to articulate complex technical issues clearly
- Strong teamwork decision-making documentation and analytical skills
- Knowledge of backup and recovery technologies and processes relevant to Oracle/PostgreSQL on-
Equal Opportunity Employer/Disability/Veterans
Qualifications
Required:
- 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
Preferred:
- Bachelors 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)
Required Experience:
Senior IC
About Company
What’s a career at Enterprise Mobility all about? It’s a simple idea that leads to amazing careers for those who choose Enterprise Mobility. Search jobs here.