Senior Database Administrator - ETL

About the role

Enterprise Mobility is seeking an experienced Engineer 2, DBA/ETL to join the IT Risk Management department. This role focuses on the day-to-day operation, stability, data movement, transformation, and support of database environments.

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
• Aid 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
• Maintain 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

Requirements

• 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 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

Qualifications

• 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

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)

Benefits

Enterprise Mobility offers 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.

Pay

Market-competitive pay based on experience and qualifications.

Schedule

This position is available 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.

Equal Opportunity Employer/Disability/Veterans

Enterprise Mobility is an Equal Opportunity Employer. We consider applicants without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other protected characteristic.