Senior Etl Informatica Developer Jobs in O Fallon, MO

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 offers the opportunity to work fully remote within the United States (except for Alaska and/or Hawaii). Team members who choose virtual / remote work should have an adequate space to serve as their home office, and must be able to work a schedule within U.S. Central Standard Time core business hours. This position will require employees to come on site to one of our St. Louis campus locations a few times per year for meetings/events or as needed. #LI-REMOTE

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 PowerDesigner 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 validation activities
• Facilitate user access management and support data security practices, including PII awareness and customer data redaction requests Available for on call rotation with team, tentatively every 2 weeks, as well as light on call after hours support, as determined by patching requests and incidents in team queue

Knowledge, Skills, and Abilities:

• Proficient Oracle DBA knowledge including upgrades, patching, RMAN backup/recovery
• Strong communication skills with the ability to transcend the organization with appropriate levels of detail
• Strong teamwork, decision-making, documentation and analytical skills
• Knowledge of Service Management best practices (Incident, Problem, and Change Management)

Equal Opportunity Employer/Disability/Veterans

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 the United States (does not include Alaska or Hawaii)
• Must be able to work a schedule within U.S. Central Standard Time core business hours.
• 3+ years of experience in an Oracle DBA or related role, and experience with Oracle Enterprise Manager (OEM) version 10g or higher
• 3+ years of experience with multiple facets of Oracle Data Guard, including physical and Active DG
• 3+ years of AWS/Database using postgresSQL and mySQL
• Experience with Unix scripting
• Experience with SAS Data Integration Studio (SAS-DI)
• SQL expertise in Oracle, Teradata, and IBM Workload Scheduler
• Experience protecting Confidential and Highly Confidential database content
• Must be committed to incorporating security into all decisions and daily job responsibilities

Preferred:

• Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field preferred
• Experience with Oracle 19C is preferred
• Experience with one of more of the following databases: MSSQL Server, and/or Open database platforms such MariaDB, MySQL or PostgreSQL is preferred
• Experience with Terraform and Bitbucket preferred
• Knowledge of database encryption is preferred
• Familiarity with cloud solutions like Amazon and Azure is preferred
• Knowledge of PCI or other IT Security compliance standard is preferred
• Knowledge of Data Governance best practices is preferred