The responsibilities for the DB Designer/Developer will include the following:
Design of new target database
• Review and understand system requirements and translate to database entities
• Ability to develop and understand logical and physical database entity relationship diagrams and models.
• Develop database for usability, performance and normalization
Conversion of data from the legacy Informix application to a SQL 2014 database
• Design, development and implementation of data conversion processes from the legacy system to the new system
• Complete documentation of data conversion activities and processes
• Understand the legacy RFR database structure and functionality
• Understand the new RFR database structure and functionality
• Map data elements from legacy system to new system
• Provide data scrubbing activities are required which may include pre conversion or post conversion cleanup or both
• Assist QA in development of test plans to validate that all data was successfully migrated
Secondary:
Assist in the development of the application to support a robust and highly performing database.
• Fine tune the RFR database to ensure production ready performance
• Maintain system documentation related to the database architecture and development standards
• Mentor and provide knowledge transfer to COSC team members who will be supporting the application post production.
Application Software Experience:
• Database design
• Database Entity Relationship Diagraming tools
• Data conversion and data mapping of large enterprise databases
• Database ETL (Extract/Transform/Load) tools and methodologies
• Informix Dynamic Server Version 7
• Microsoft SQL Server 2014
• T-SQL, SSIS or other ETL activities
• Stored Procedure development
Preferred Experience:
• ORM experience with Entity Framework
• WCF RIA services experiences with custom domain services
• Experience with Visual Studio 2013
• Experience with .Net 4.0 and AngularJS development
• Experience with Team Foundation Server
• Experience with SSRS and SSAS
• Prior experience with systems within the justice and law enforcement community
- "All your information will be kept confidential according to EEO guidelines". - All candidates who are authorized to work in US are encouraged to apply. - Candidates must clear the Background check prior to commencing the assignment.
THIRD PARTY CANDIDATES:
Email your candidate/s resume to pete dot tylor at idealforce.com along with the following details: Rate, Current location and Availability.
Disclaimer :
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
IDEALFORCE has a CONTRACT position available immediately for a Sr .NET Developer (Programmer 3/PR3) to join our customer in Columbus, OH. This is an ONSITE position and requires an IN-PERSON interview. Please find below additional details about this job.