Note: The job is a remote job and is open to candidates in USA. 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. The Engineer 2, DBA/ETL will play a key role in the day-to-day operation, stability, data movement, transformation, and support of database environments, focusing on maintaining database health and building data pipelines.
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
Skills
- 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
- 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
Benefits
- Market-competitive pay
- Comprehensive healthcare packages
- 401k matching & profit sharing
- Schedule flexibility
- Work from home opportunities
- Paid time off
- Organizational growth potential
Company Overview