Hello, Hope you’re doing great.
Please find the below requirement. Thanks.!!! *Title : Senior SQL Designer/Developer* *Location : Phoenix, AZ* *Duration : 1 Year* *Local Candidates only* *Candidate Responsibilities* The responsibilities for the DB Designer/Developer will include the following: Primary: 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. Qualifications 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 Additional Information Provide their own laptops which must include the following minimum configuration: • Windows 7 64-bit, Enterprise or Professional version • Hardware with enough memory to support the demands of Visual Studio and local development environment • Must include a current version of an industry acceptable virus protection software update daily to the most recent virus patterns • Provide their own development software (Visual Studio 2013 with MSDN Acha Integrated Technology Services Inc., Desk: 703-436-1267 || Email: a...@its-incorp.com ------------------------------------------------------------------------------------------------- 1033 Sterling Road, Suite 205, Herndon VA 20170-3838|| www.its-incorp.com ------------------------------------------------------------------------------------------------- E-Mail is the best way to reach me. <http://www.linkedin.com/in/achaayyappavarma/> -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.