Senior Data Engineer (Oracle)
About The Position
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. We are seeking a multi–DB Platform Operational Support DBA resource primarily skilled with Oracle Database (DBA) along with exposure to MS-SQL, MySQL and Postgres. This DBA role requires expertise in managing and optimizing diverse database technologies to support both on-prem and cloud platforms. This role demands a detail-oriented professional with a deep understanding of RDBMS solutions and a proactive approach to database architecture, security, and performance. You will enjoy the flexibility to telecommute from anywhere within the U.S. as you take on some tough challenges.
Requirements
- High School Diploma/GED
- 5+ years of Oracle Operational DBA experience in the IT industry
- 5+ years of experience supporting/maintaining Databases systems in the Exadata, Unix and Windows environments
- 5+ years of experience with RAC technologies 19c (CRS/ASM/RAC Services)
- 5+ years of experience with Oracle Dataguard
- 5+ years of experience in RMAN refresh/restore operations and Datapump exp/imp
- 5+ years of experience in Database monitoring, Performance tuning, Health Checks, Stats collection, Query Optimizing, Indexes
- 2+ years of experience with other relational Databases such as MS-SQL, MySQL and Postgres
- 2+ years of experience of working with Public Cloud Exadata database administration/migration
- 1+ years of experience of implementing AI-driven tools used in database operations, monitoring, and support environments
- Willingness and ability to provide 24x7 on-call support
Nice To Haves
- Experience with TDE, Wallet, Audit Vault
- Experience with Database RMAN backup/recovery skills (ZDLRA,TSM/TDPO/DDomain)
- Experience with other DBMS platforms such as SQL Server, MySQL, Postgres and DB2 etc. is a plus
- Willing to share knowledge and learn new concepts (cross-train) with colleagues
- Skills in AI usage, Shell Scripting and Automation
Responsibilities
- Provide ongoing operational support for Oracle Databases in all application specific environments (Dev to Prod)
- Perform data migrations (RMAN restore/refresh and datapump exp/imp). Also exposure to migrate DBs from on-prem to Cloud
- Assist in manual and automated application code deployments (DDLs and DMLs)
- Conduct performance tuning to maintain system stability (using Oracle RDBMS tools)
- Troubleshooting to capture incident data and analyze for root cause issues
- Participate in binaries installation, DB creation, configuration, upgrades and DB patching and OS patching activities
- Serve as a good team player by working with colleagues and clients to identify and address overall system problems as needed
- Perform on-call rotation with other colleagues on a weekly rotation basis
- Influence management to adopt new ideas, products, and/or approaches as appropriate
- Develop and enhance automation to streamline database operations and data loading processes
- Utilize PostgreSQL utilities and tools such as pg_ctl, psql, and monitoring/management solutions to maintain the environment
Benefits
- comprehensive benefits package
- incentive and recognition programs
- equity stock purchase
- 401k contribution
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
High school or GED
