Senior Software Engineer II

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.

Provide technical expertise in building architecture, design and engineering database solutions using modernization technology stacks.

Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modelling, data warehouse development, Extract, Transform, and Load (ETL / ELT) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance.

Primary Responsibilities:

• All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
• Linux System Administration
• Develop/implement Linux tooling – Linux utility suite, shell, Python, etc.
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production
• 24×7 rotational on-call support, including driving Root Cause Analysis (RCA), preventative action follow-through, and participation in weekly operations reviews
• Proactive database monitoring and issue resolution
• Database and PL/SQL optimization including performance tuning, query optimization and supportability; experience with Oracle 19c
• Actively participate and contribute to projects involving enterprise systems enhancements
• Participate in project design and Oracle database design decisions. Refine and troubleshoot the design
• Create and maintain appropriate documentation about the database and the data architecture
• Regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports
• Project Estimation process – including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
• Develop and implement Database security policies and procedures, in line with corporate objectives
• Develop database pipelines to automate processes
• Develop Terraform infrastructure as code to speed the delivery of services
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so 

You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Primary Platforms/Technologies Used:

• Oracle RDBMS (19c)
• Oracle ExaData
• Oracle Cloud
• PL/SQL, Perl
• Linux
• Other DB platforms
• Terraform
• GoldenGate

Required Qualifications:

• Bachelor’s degree in computer science, or proven experience as an Oracle Database Administrator
• 7+ years experience with Oracle products and automating services
• SQL Tuning Experience
• Database design, SQL, and stored procedure development experience
• Proven experience participating in team software development projects
  Experience with Goldengate PaaS and automating Goldengate services
• Extensive experience with GoldenGate
• Experience building pipelines to support database automation
• Proficiency with network troubleshooting tools and techniques
• Proven analytical and communication skills
• Ability to build infrastructure as code leveraging tools like Terraform

Preferred Qualifications: 

• Bachelor’s degree in computer science, or proven experience as an Oracle Database Administrator
• SQL Tuning Experience
• Database design, SQL, and stored procedure development experience
• Proven experience participating in team software development projects
• Experience with AI tools to help speed delivery
• Proven analytical and communication skills

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone – of every race, gender, sexuality, age, location and income – deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes – an enterprise priority reflected in our mission.

#NJP #Nic