Sr Database Management Analyst

$131,040 - $160,160/Yr

Pacific Life - Newport Beach, CA

Full-time - Mid Level

Newport Beach, CA

Insurance Carriers and Related Activities

About the position

At Pacific Life, we are committed to providing our policyholders with the support they need to secure their futures. As a Sr. Database Administrator, you will play a pivotal role in our mission by architecting and implementing enterprise database solutions that ensure optimal performance, reliability, and scalability of our data infrastructure. This hybrid role allows you to work both in the office and remotely, empowering you to balance your professional and personal life effectively. In this position, you will serve as a subject matter expert (SME) for Oracle, Microsoft SQL Server, and other database technologies. Your responsibilities will include delivering technical expertise in architecting, building, monitoring, and optimizing the performance of our database servers. You will be tasked with building and applying strong security architecture, ensuring consistent patching, updates, and conducting audit log assessments. Staying current with emerging database technologies will be essential, as you will utilize new features to enhance our environment. You will also automate complex workflows to increase efficiency, set up and configure Oracle databases with High Availability configurations, and manage database backup and restore functions. Monitoring database performance and availability metrics will be crucial, and you will take appropriate actions to implement best practices. Additionally, you will provide after-hours DBA support when necessary and collaborate with application development teams during production deployments. Your role will also involve developing standards for data access and database administration, working with Oracle Support for system issues, and creating documentation and troubleshooting guides.

Responsibilities

• Serve as SME (subject matter expert) 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.
• 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.
• Build, monitor, and report on database environment performance and availability metrics and take 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.
• Log service requests and follow up for resolution of critical issues in a timely fashion.
• 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.
• Familiarity 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 ability 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.

Nice-to-haves

• Experience with cloud-native database services in AWS.
• Database administrator certifications.

Benefits

• Medical, Dental, Vision insurance coverage.
• Wellbeing Reimbursement Account for eligible dependents.
• Generous paid time off options including Paid Time Off, Holiday Schedules, and Financial Planning Time Off.
• Paid Parental Leave.
• Adoption Assistance Program.
• Competitive 401k savings plan with company match and additional contributions.