Senior Database Management Analyst

$131,040 - $160,160/Yr

Pacific Life - Newport Beach, CA

Full-time - Mid Level

Hybrid - Newport Beach, CA

Insurance Carriers and Related Activities

About the position

The Sr. Database Administrator at Pacific Life plays a crucial role in architecting and implementing enterprise database solutions, ensuring optimal performance, reliability, and scalability of the data infrastructure. This hybrid position emphasizes collaboration and innovation, contributing to the company's growth and long-term success while supporting the needs of policyholders.

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 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 recurring 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.

Benefits

• Medical, Dental, Vision insurance coverage starting Day 1.
• 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 and Adoption Assistance Program.
• Competitive 401k savings plan with company match and additional contributions.