Senior Principal Database Engineer - SQL Server
Job Description SummaryThe Enterprise Solutions department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the company's portfolio of products. Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.
Job Description
The Senior Principal Engineer is responsible for the design and development of database objects and procedural code to support various products for the organization. The Senior Principal Engineer also creates programs to populate and maintain the data in the department's transaction processing and data warehousing systems. This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, performance tuning, database unit tests and associated code in a Microsoft SQL Server environment.
Specific Duties, Activities, and Responsibilities
Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
Diagnose and resolve database performance issues.
Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices.
Qualifications:
BS in Computer Science or Information Systems
10
years of experience working with Microsoft SQL Server with emphasis on database code development.
Data modeling tools such as ER/Studio or ERWin
Database design skills including normalization and data warehouse design
T-SQL development skills
Excellent query optimization and performance tuning skills
Strong SSIS skills
Detailed analytical skills
Structured troubleshooting skills
Database unit tests
Experience with data ware housing is a plus
Experience working with very large databases is a plus
Experience in the healthcare industry is a plus
Toolset
Embarcadero ER/Studio
Microsoft SQL Server 2012 and above
Microsoft SQL Server Integration Services (SSIS)
Microsoft SQL Server Reporting Services (SSRS)
Microsoft Visual Studio 2012 and above
Primary Work LocationUSA CA - San Diego TC Bldg C&D
Additional Locations
Work Shift
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
Job Description
The Senior Principal Engineer is responsible for the design and development of database objects and procedural code to support various products for the organization. The Senior Principal Engineer also creates programs to populate and maintain the data in the department's transaction processing and data warehousing systems. This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, performance tuning, database unit tests and associated code in a Microsoft SQL Server environment.
Specific Duties, Activities, and Responsibilities
Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
Diagnose and resolve database performance issues.
Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices.
Qualifications:
BS in Computer Science or Information Systems
10
years of experience working with Microsoft SQL Server with emphasis on database code development.
Data modeling tools such as ER/Studio or ERWin
Database design skills including normalization and data warehouse design
T-SQL development skills
Excellent query optimization and performance tuning skills
Strong SSIS skills
Detailed analytical skills
Structured troubleshooting skills
Database unit tests
Experience with data ware housing is a plus
Experience working with very large databases is a plus
Experience in the healthcare industry is a plus
Toolset
Embarcadero ER/Studio
Microsoft SQL Server 2012 and above
Microsoft SQL Server Integration Services (SSIS)
Microsoft SQL Server Reporting Services (SSRS)
Microsoft Visual Studio 2012 and above
Primary Work LocationUSA CA - San Diego TC Bldg C&D
Additional Locations
Work Shift
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
