Senior Database Developers

Posted In: Dekalb, Illinois

Description

Participate in the complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems. Design and customize data models for Data warehouse supporting data from multiple sources on real time. Work on Data Admin tasks like creating and updating roles, Scheduling SQL Server Jobs, Creating Backups for databases. Extract data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using SSIS and loaded data into target, by scheduling the sessions. Design, develop and modify SSIS Packages to import and export data from different sources. Participate in ETL architecture enhancements to increase the performance of ETL operations. Implement Event Handler and Error Handling in SSIS packages. Create SSIS packages for Data Conversion using data transformation techniques. Configure the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard. Coordinate with front-end development team for implementing logic in stored procedures and functions. Write complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes. Work on Normalization and De-Normalization of existing tables for faster query retrieval. Participate in the core feature development of the project using technologies like MVC 5, Entity Framework 6, AngularJS, Web API, SQL Server, SSIS, C#, Visual Studio, ASP.Net, TFS, JQuery, HTML and CSS. Design, Develop and Modify web pages using Asp.Net/C#, Java Script, JQuery, CSS and HTML. Develop API functionality using REST services and JSON. Participate in Unit Testing and strongly followed coding standards. Participate in Production support and Maintenance activities. Participate in Fixing Defects for different releases. Maintain Version Control using GitHib.
Requirements: Master’s Degree or foreign degree equivalent in Computer Science, Computer Information Systems or Engineering and one year’s experience in position offered or one year’s experience in IT field (or Bachelor’s Degree and five years’ experience).
Special requirements: Experience with SQL Server, SSIS, C#, Visual Studio, ASP.Net, TFS, JQuery, HTML and CSS. Pre-employment background check and verification of eligibility to work in US required. EEO/AA
Send letter of application, resume and contact information (name/ address/ phone#/ e-mail) for three current professional references by 3/15/19 to (including Ref#10041):
Ms. Strub
Northern Illinois University
148 N. 3rd Street
DeKalb, IL 60115

Share this listing

Contact Form


PDF, Word, or Text file up to 5MB