If you’re passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results, then Nationwide’s 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 we’re looking for associates who are passionate about delivering extraordinary care.

WE ARE SEEKING A HIGHLY SKILLED AND MOTIVATED ORACLE DATABASE ADMINISTRATOR (DBA) WITH DEEP EXPERTISE IN PERFORMANCE TUNING TO 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.

TECHNICAL EXPERIENCE REQUIRED:

• Oracle Database (19c and above) on Linux
• Oracle Multitenant Architecture (CDB/PDB)
• Oracle Grid Infrastructure, Dataguard, Goldengate, and ASM
• Oracle Enterprise Manager (basic usage)
• Strong understanding of Oracle Data Dictionary and Registry components
• Experience working with Oracle Support on database-related issues
• Basic knowledge of Oracle Exadata architecture
• Advanced performance tuning skills:
• SQL profiles, SQL plan management, execution plans
• Extended SQL traces, Database Performance Analyzer
• Postgres database knowledge (a plus)
• Experience with Amazon Web Services (AWS)
• Scripting skills in Bash, PL/SQL, and Python (preferred but not required)
  This role does not qualify for employer-sponsored work authorization. Nationwide does not participate in the Stem OPT Extension program.
  

  LI-TN1

JOB DESCRIPTION SUMMARY

If you’re enthusiastic about delivering secure technology solutions to support a company providing extraordinary care to its customers, then Nationwide Technology is the place for you. Nationwide’s 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 Nationwide’s architectural standards, technology roadmaps, industry trends and business requirements. You’ll focus on collaboration, data, systems, storage, middleware, network, security and contact center technology products. You’ll also be accountable for the operational aspects and management for the above products according to the business requirements and defined service level agreements (SLAs).

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 experience with the most complex integrated solutions with an ability to design and develop and modify new and existing solutions for specialized needs. Experience with multiple technologies and within one or more domains. Experience with automation of deployment of solution configurations. Experience in training/guiding less experienced staff. Experience with solutions: IaaS, PaaS, SaaS and 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.

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.

KEY RESPONSIBILITIES:

• Collaborates with Technology Architecture professionals to develop technology product roadmaps.
• 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.
• Designs and implements standard builds/templates for all technology platforms.
• Drives product improvements through optimization, enhancements and the implementation of new features and functions.
• Works continuously with other Technology Engineering teams and Technology Architecture to ensure the success of products.
• Conducts “proof of concept” labs for enhancements, new solutions and competitive bake-offs.
• Designs standard and custom technology solutions for business partner projects, including pre- production testing, performance tuning, handoffs and certification.
• Conducts proactive and reactive monitoring to detect, predict and resolve abnormal conditions in the environment.
• Collaborates with vendors to help drive design innovation in product enhancements and improvements.
• Executes on production engineering processes, incident management, root cause analysis, problem management, change management, release management and knowledge management.
• Provides complex production support for all technology platforms.
• Provides oversight for technical labs and development environments.
  May perform other responsibilities as assigned.
  Reporting Relationships: Reports to AVP, Director or Manager Technology Engineering Manager/Technology Product Manager.