Database Developer

CCS Global Tech   •  

Poway, CA

Industry: Data Storage

  •  

Not Specified years

Posted 374 days ago

Database Developer (Multiple Openings):

Job Description: •Participate in database design and application design sessions. •Implement Entity Relationship Diagrams and physical data models using MS Visio/ErWinfor transactional and data warehouse systems.

•Develop database objects like stored procedures, views and functions using SQL Server for various database driven applications. Implement constraints and triggers for database integrity. •Write reliable andoptimized TSQL scripts to implement flawless business logic for transactional, ETL and Reporting applications. •Use SQL Server Indexes and execution plans to perform query optimization. •Assist the database architect in the design of snowflake and stardimensional models and ETL strategies. •Assist the DBA in performing administrative tasks like backup/restore and replication. •Design database schema for staging databases and create SQL scripts for data profiling and cleansing at the staging database.

•Develop ETL packages using SSIS to gather data from various sources and populate the Data warehouse systems as per project needs. •Implement error handling and auditing frameworks for database and ETL processes. •Interact with end users to understand their business reporting needs. •Develop parameterized, drill down as well as ad hoc reports using SSRS as per business needs. •Send the Status Report (daily, weekly etc.) to the project manager. Requirements:Master’s degree in CS, MIS, Engnrgor related ORBachelor’s degree in same fields + 5 yrs of progressive exp. as Database Developer or related. Foreign equivalent degree ok.