Consultant, Technology Engineer (Oracle DBA)

If youre passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results then Nationwides Information Technology team could be the place for you! At Nationwide on your side goes beyond just words. Our customers are at the center of everything we do and were looking for associates who are passionate about delivering extraordinary care.

We are seeking a highly skilled and motivatedOracle Database Administrator (DBA)with deep expertise inperformance tuningto join our team.

The ideal candidate will ensure high availability reliability and consistent performance across mission critical systems. This role requires deep Oracle database knowledge strong communication and problem-solving skills and attention to detail. The candidate will have a continuous improvement mindset with the desire to automate processes and reduce manual effort wherever possible.

Key Responsibilities:

• Administer and maintain Oracle databases to ensure optimal performance and uptime.
• Diagnose and resolve complex database performance issues across the full stack.
• Implement and manage database security measures including wallet and password management.
• Collaborate with development and infrastructure teams to design and optimize database solutions.
• Lead and support database migrations including Postgres to RDS and Oracle to cloud platforms.
• Participate in on-call support rotation and respond to critical incidents as needed.

Technical Experience Required:

• Oracle Database (19c and above)on Linux
• Oracle Multitenant Architecture(CDB/PDB)
• Oracle Grid InfrastructureDataguardGoldengate andASM
• Oracle Enterprise Manager(basic usage)
• Strong understanding ofOracle Data Dictionaryand Registry components
• Experience working withOracle Supporton database-related issues
• Basic knowledge ofOracle Exadataarchitecture
• Advancedperformance tuningskills:
  • SQL profiles SQL plan management execution plans
  • Extended SQL traces Database Performance Analyzer
• Postgresdatabase knowledge (a plus)
• Experience withAmazon Web Services (AWS)
• Scripting skills inBashPL/SQL andPython(preferred but not required)

**This role does not qualify for employer-sponsored work authorization. Nationwide does not participate in the StemOPT Extension program.**

#LI-TN1

Job Description Summary

If youre enthusiastic about delivering secure technology solutions to support a company providing extraordinary care to its customers then Nationwide Technology is the place for you. Nationwides industry-leading technology workforce embraces an agile work environment and a collaborative culture to deliver outstanding solutions and results. If that sounds like something you aspire to we want to hear from you!

As a Consultant Technology Engineer you deliver standard and custom supportable technology products. The solutions you build are based on Nationwides architectural standards technology roadmaps industry trends and business requirements. Youll focus on collaboration data systems storage middleware network security and contact center technology products. Youll also be accountable for the operational aspects and management for the above products according to the business requirements and defined service level agreements (SLAs).

Job Description

Key Responsibilities:

• CollaborateswithTechnology Architecture professionalstodeveloptechnologyproductroadmaps.

• Responsible for applying secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.

• Designsandimplementsstandardbuilds/templatesforalltechnologyplatforms.

• Drivesproductimprovementsthroughoptimizationenhancementsandtheimplementation of new features andfunctions.

• WorkscontinuouslywithotherTechnologyEngineeringteamsandTechnology Architectureto ensure the success of products.

• Conductsproofof conceptlabsforenhancementsnewsolutionsandcompetitive bake-offs.

• Designsstandardandcustomtechnologysolutionsfor businesspartnerprojectsincludingpre- productiontestingperformancetuninghandoffsandcertification.

• Conductsproactiveandreactivemonitoringtodetectpredictandresolveabnormal conditions in theenvironment.

• Collaborates with vendors to help drive design innovation inproductenhancements and improvements.

• Executes on production engineering processes incident management rootcauseanalysisproblemmanagementchangemanagementrelease management and knowledgemanagement.

• Providescomplexproductionsupportforalltechnologyplatforms.

• Provides oversight for technical labs and developmentenvironments.

May perform other responsibilities as assigned.

Reporting Relationships: Reports to AVP Director or Manager Technology Engineering Manager/Technology Product Manager.

Typical Skills and Experiences:

Education: Undergraduate studies in computer science management information systems or a related field is preferred.

License/Certification/Designation: Technology certifications or designation are not required but encouraged (i.e. AWS Azure scripting and development languages delivery methods security).

Experience: Six years or more experiencewiththemostcomplexintegrated solutionswith an ability to design and develop and modify new and existing solutions for specialized needs. Experiencewithmultipletechnologiesandwithinoneormoredomains. Experience with automation of deployment of solution configurations. Experienceintraining/guidingless experienced staff. Experience with solutions: IaaS PaaS SaaSand package solutions.

Knowledge Abilities and Skills: Strong communication skills knowledge of planning management and execution of Accelerated Solutions Deliver framework Information Security acumen. Influencing negotiating and priority setting needed. Insurance/financial services industry knowledge a plus.

Other criteria including leadership skills competencies and experiences may take precedence.

Staffing exceptions to the above must be approved by the Vice President and HR Business Partner.

Values: Regularly and consistently demonstrates the Nationwide Values.

Job Conditions:

Overtime Eligibility: Exempt (Not Eligible)

Working Conditions: Normal office environment. Some travel maybe required.

ADA: The above statements cover what are generally believed to be principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties.

Benefits

We have an array of benefits to fit your needs including: medical/dental/vision life insurance short and long term disability coveragepaid time off with newly hired associates receiving a minimum of 18 days paid time off each full calendar year pro-rated quarterly based on hire date nine paid holidays 8 hours of Lifetime paid time off 8 hours of Unity Day paid time off 401(k) with company match company-paid pension plan business casual attire and more. To learn more about the benefits we offer click here.

Nationwide is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive culture where everyone feels challenged appreciated respected and engaged. Nationwide prohibits discrimination and harassment and affords equal employment opportunities to employees and applicants without regard to any characteristic (or classification) protected by applicable law.

Smoke-Free Iowa Statement: Nationwide Mutual Insurance Company its affiliates and subsidiaries comply with the Iowa Smokefree Air Act. Smoking is prohibited in all enclosed areas on or around company premises as well as company issued vehicles. The company offers designated smoking areas in which smoking is permitted at each individual location. The Act prohibits retaliation for reporting complaints or violations. For more information on the Iowa Smokefree Air Act individuals may contact the Smokefree Air Act Helpline at .

NOTE TO EMPLOYMENT AGENCIES:

We value the partnerships we have built with our preferred vendors. Nationwide does not accept unsolicited resumes from employment agencies. All resumes submitted by employment agencies directly to any Nationwide employee or hiring manager in any form without a signed Nationwide Client Services Agreement on file and search engagement for that position will be deemed unsolicited in nature. No fee will be paid in the event the candidate is subsequently hired as a result of the referral or through other means.