Overview

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

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

Qualifications

• 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