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 "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to business_intelligence+unsubscr...@googlegroups.com. To post to this group, send email to business_intelligence@googlegroups.com. Visit this group at http://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/d/optout.