Database Developer
Database Developer
Participate in database design and application design sessions. Implement Entity Relationship Diagrams and physical data models using MS Visio/ErWin for 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 and optimized 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 star dimensional 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, Engineering, or related. In lieu of Master's degree, a Bachelor's degree in CS, MIS, Engineering, or related plus five years of progressive experience in Database Developer or related occupation will be accepted.
- Foreign equivalent degrees are ok.
- Work Hours: Monday-Friday, 8:00 a.m. to 5:00 p.m., 40 hours/week.
- Travel/relocation to client site locations as needed.
- Mail resume to: CCS Inc., Attn HR 13475 Danielson St. # 220, Poway, CA 92064.
- Please specify job title you are applying for.