Sr Database Management Analyst

Company: Pacific Life
Location: Newport Beach
Posted on: September 29, 2024

Job Description:

Summary: Pacific Life seeks a seasoned Sr. Database Administrator to architect and implement enterprise database solutions, ensuring optimal performance, reliability, and scalability of our data infrastructure.

Providing for loved ones, planning rewarding retirements, and saving enough for the future - our policyholders count on us to be there when it matters most. We collaborate and innovate, pushing one another to transform not just Pacific Life, but the entire industry for the better. It's a big ask, but it's one that we have the power to deliver when we work together.

Pacific Life is looking to invest in bright, agile new talent to ensure we continue to innovate and strengthen relationships with our policyholders. This role is hybrid, empowering employees to get work done both in and out of the office.

As a seasoned Sr. Database Administrator, you'll play a key role in Pacific Life's growth and long-term success by architecting and implementing enterprise database solutions, ensuring optimal performance, reliability, and scalability of our data infrastructure.

Key Responsibilities:

• 
  
• Serve as SME for Oracle, Microsoft SQL Server, and other database technologies.
  
• Deliver technical expertise architecting, building, monitoring, and optimizing the performance of our Oracle & SQL Server database servers while aligning to our organization goals.
  
• Build and apply strong security architecture with industry best practices, consistent patching, updates, and audit log assessments.
  
• Stay current with present and emerging database technologies and utilize new features when applicable in the environment.
  
• Automate reoccurring complex workflows to increase efficiency.
  
• Setup and configure Oracle databases with High Availability configurations such as Oracle Data Guard.
  
• Responsible for database backup and restore functions including scheduled tests of DR availability.
  
• Builds, monitor, and reports on database environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
  
• Provide after-hours DBA support for production databases during weekends or late nights when required.
  
• Support application development teams in their production deployments.
  
• Participate in developing standards for data access and database administration.
  
• Work with Oracle Support for system issues that require product support.
  
• Prioritize resolving database and database server related security vulnerability findings in a timely fashion.
  
• Create documentation/procedures/troubleshooting guides/runbooks on all service areas.
  
• Provide resource and capacity planning and assess our DB environments.
  
  
  Requirements:
  
  
  • 
    
  • BS degree in Computer Science or related field, or equivalent experience.
    
  • 8+ years of professional working experience with MS SQL and Oracle databases with strong experience in the design, development, integration, testing, and implementation.
    
  • Expertise in Oracle and SQL Server databases.
    
  • Familiar working with cloud-native database services in AWS.
    
  • Database administrator certifications are highly desirable.
    
  • Expertise in Performance and SQL Tuning/SQL Profiles for Oracle Databases.
    
  • Excellent troubleshooting skills and be able to assess database performance.
    
  • Demonstrated critical thinking, problem-solving skills, and ability to work under pressure.
    
  • Understanding of business processes and the importance of change management.
    
  • Demonstrated ability to communicate both laterally and up to influence decisions and actions.
    
  • Excellent verbal and written communication skills.
    
  • Ability to work in a fast-paced, dynamic environment.
    
  • Ability to work well independently or in a team setting.
    
    
    Benefits:
    
    
    • 
      
    • Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents.
      
    • Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off.
      
    • Paid Parental Leave as well as an Adoption Assistance Program.
      
    • Competitive 401k savings plan with company match and an additional contribution regardless of participation.
      
      
      EEO Statement:
      
      Pacific Life Insurance Company is an Equal Opportunity /Affirmative Action Employer, M/F/D/V. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at Pacific Life Insurance Company.

Keywords: Pacific Life, Newport Beach , Sr Database Management Analyst, Executive , Newport Beach, California