Engineer 2, DBA Oracle
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
Join the Rental Database team as an Engineer 2 DBA supporting the databases that power core Rental operations for Enterprise Mobility. The team implements secures monitors and maintains on-premises Oracle and cloud-based database platforms that support reservations rental agreements rate and pricing management messaging and related financial processing systems. As part of the Rental Operations team youll partner closely with application development teams across departments to support a portfolio of critical globally used systems.
Youll work across multiple product areas and collaborate with System DBAs Performance DBAs developers and business stakeholders. The team supports production development test and reporting environments in a fast-paced setting with a strong focus on reliability operational efficiency and proactive issue identification. We are also actively modernizing and migrating key database platforms to the cloud.
In this role youll help maintain the stability and performance of our database environments while supporting application teams and release cycles. Youll work with Oracle and PostgreSQL databases to review and implement changes troubleshoot issues and ensure updates are deployed safely and efficiently across both on-prem and cloud platforms.
Responsibilities include:
- Implementation of approved DDL and DML changes in both prod and non-prod environments
- Manage and use database scripts in Bitbucket 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 application SQL 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
- 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
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
- 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:
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.