Note: The job is a remote job and is open to candidates in USA. Enterprise Mobility is a provider of mobility solutions and transportation services supported by dedicated IT teams. The Senior Database Administrator - ETL will operate and support database environments, maintain database health, build and maintain data pipelines, and implement database changes across on-premises and cloud environments. The role also supports application teams, database releases, troubleshooting, security, backup and recovery, and data movement activities.
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
- 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
- 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)
- 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
- Comprehensive healthcare packages
- 401k matching & profit sharing
- Schedule flexibility
- Work from home opportunities
- Paid time off
- Organizational growth potential
- Opportunity to work fully remote within the United States (except for Alaska and/or Hawaii)
Company Overview