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 dedicated to providing for our policyholders, ensuring they have the support they need for their loved ones, retirement planning, and future savings. We believe in collaboration and innovation, striving to transform not just our company but the entire industry for the better. As a Sr. Database Administrator, you will play a crucial role in our growth and long-term success by architecting and implementing enterprise database solutions that ensure optimal performance, reliability, and scalability of our data infrastructure. This position is hybrid, allowing you to work both in the office and remotely, reflecting our commitment to empowering employees to achieve their best work. In this role, 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 while aligning with organizational goals. You will also be responsible for building and applying strong security architecture, ensuring consistent patching, updates, and conducting audit log assessments. Staying current with emerging database technologies and utilizing new features will be essential to your success. You will automate recurring complex workflows to enhance efficiency, set up and configure Oracle databases with High Availability configurations, and manage database backup and restore functions, including scheduled tests of disaster recovery availability. Monitoring and reporting on database performance and availability metrics will be part of your daily tasks, along with providing after-hours DBA support when necessary. You will support application development teams during their production deployments and participate in developing standards for data access and database administration. Additionally, you will work closely with Oracle Support for system issues and prioritize resolving database security vulnerabilities in a timely manner. Documentation and resource planning will also be key components of your role, ensuring that our database environments are well-managed and optimized for performance.

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

Nice-to-haves

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

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.