Senior Database Administrator - ETL

Overview

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, car sharing, 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 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.

We have an exciting opportunity in the IT Risk Management department for an Engineer 2, DBA/ETL position. The Risk Management team is focused on the development of products (UI and APIs) for the claims management lifecycle, including claim processing, vehicle repair and damage recovery processes. Risk Management continuously strives to ensure the alignment of projects and products with organizational goals and objectives.

The Engineer 2, DBA/ETL will play a key role in the day-to-day operation, stability, data movement, transformation, and support of our database environments. Here, you will focus on supporting application teams, maintaining database health, building and maintaining data pipelines and ensuring that database changes are implemented safely and efficiently across both on‑prem and cloud environments. You will work with Oracle, PostgreSQL databases and tools including SAS Data Integration Studio and IBM Workload Scheduler, and collaborate with development teams to review database changes, troubleshoot issues, and support application releases.

Key Responsibilities:

• Implement and support tasks such as patching coordination, backup and recovery procedures, database utilities, and data replication technologies for both PROD and NON-PROD environments
• Assist with Data Guard implementation and support tasks
• Modify database changes using Power Designer and creating sql scripts to implement
• Facilitate corrections to the database infrastructure, and repairs to the system or database
• Perform MySQL data audit scripts
• 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…