Back to Search New Search

SQL Developer

Pacific Life Insurance Company Aliso Viejo, CA

Job Description

Currently, we are seeking a talented SQL Developer to join the Life Insurance Division in Aliso Viejo. The Life Insurance Division works with financial and insurance professionals to give families and businesses the life insurance coverage needed to help meet important financial protection, wealth accumulation, and wealth preservation goals.


The SQL developer position will be a member of a highly technical team and will be responsible for the design, development, delivery and support of SQL solutions within the organization. The applicant must have a strong working knowledge of SQL Server 2012+ databases. This includes developing complex queries, performance tuning, optimization and developing complex stored procedures. The candidate must have strong written and verbal communication skills and the ability to explain logic behind their analysis/ideas in a clear and concise manner. This team will participate in a Salesforce transformation and implementation, moving to an AWS Cloud environment and data consolidation across the enterprise. A thirst and curiosity for learning innovative technologies is important and even better if complimented with a can-do attitude.

 Understand architecture behind existing ETL solutions (in SSIS and PowerCenter) and provide support, improvements and performance tuning where necessary.
 Participate in Analysis, design, development, deployment and testing of Data warehousing systems on OLAP and OLTP environment and implementation of Database Management Systems
 Database Modeling/Designing using ERStudio to design Conceptual/Logical/Physical Modeling, Forward/Reverse engineering and ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.
 Implementation of Data Warehousing, Data Marts, Star and Snow Flake Schema Modeling, Dimensional Modeling on OLTP and OLAP concepts
 Ability to manage multiple projects with competing demands and the ability to adapt and change.
 Prepares design documentation, mock-ups, and prototypes
 Participates in code reviews


 A skilled technician who can work with both business and technology partners. 5+ years in Information Technology industry experience including:
 Three plus years of current, hands on database development Skills (particularly implementing SQL Server 2012+ technologies)
 Exceptional skills in development of complex stored procedures and advanced SQL techniques to optimize system performance and generate multiple types of outputs: XML, Pivoted results, Data Sets
 Understand normalized and star-schema (dimensional) physical models and logical modeling concepts
 Extensive programming experience in T-SQL, tuning and optimization
 Extensive experience determining, developing, testing, and implementing system requirements and specifications
 Ability to communicate with a wide range of audiences including management, development, and operational units
 Ability to develop technical documentation and executive summaries describing technical design and architectural concepts
 Self-Motivated and quick learner
 Strong analytical and technical design skills

 Hands on .Net development using Visual Studio 2012 or higher
 Familiarity working with Database Source Code management with TFS
 Familiarity working with Automated Database Deployments using TFS Release Manager
 Experience with Informatica PowerCenter v9.6+ including installation and upgrade
 Knowledge with QlikView to create dashboards and visualize data
 Knowledge with ERStudio to manage ER Diagrams


Job Details

Date Posted July 5, 2018
Date Closes August 4, 2018
Requisition 429817
Located In Aliso viejo, CA
SOC Category 00-0000.00