Location: San Diego, California - 92121
Duration: 12 months temp to hire
The database developer is responsible for the design and development of database objects and procedural code to support various products for the organization. The database developer 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, and associated code in a Microsoft SQL Server environment.
Responsibilities
1. Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
2. Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
3. Design, develop and maintain SQL Server Reporting Services reports.
4. Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
5. Diagnose and resolve database performance issues.
Toolset
· Embarcadero ER/Studio
· Microsoft SQL Server 2008 and above
· Microsoft SQL Server Integration Services (SSIS)
· Microsoft SQL Server Reporting Services (SSRS)
· Microsoft Visual Studio 2008 and above
· BS in Computer Science or Information Systems
· 5+ years of experience working with Microsoft SQL Server with emphasis on database code and Reporting Services development.
All your information will be kept confidential according to EEO guidelines.