Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
SSIS Analysis Mapping SSMS Tools SQL Stored Procedures Data Modeling Tools DataBase
 
Requirement id 103425
Job title Consultant
Job location in Trenton, NJ
Skills required SQL Server DBA, Data Migration, SSIS, Analysis Mapping SSMS Tools SQL Stored P
Open Date 12-Feb-2020
Close Date
Job type Contract
Duration 5 Months
Compensation DOE
Status requirement ---
Job interview type ---
Apply
   Email Recruiter: coolsoft
Job Description Consultant: SQL Server DBA, Data Migration, SSIS, Analysis Mapping SSMS Tools SQL Stored P

Start Date : 02/17/2020
End Date : 06/30/2020
Submission Dead Line : 02/17/2020
Client Info : DOH

Note:

* Agency Interview Type: In Person Only

Description:

Provides technical leadership for architecture, design, documentation nd maintenance of an internal database and related systems.

Please note - this project, while funded currently to the end of the fiscal year, is expected to run about 12 months in length.

This role is for a Technical Architect/Database developer that has managed and conducted the analysis for full scale migrations of Relational Databases.

Candidate should show proficiency in conducting AS-IS/To-Be Assessments and walk throughs of existing database structures, creating the new structures and managing the to specific milestones while retaining all artifact related to the implementation.

This candidate will use data modeling tools and the latest SQL Server technology to deliver the data migration effort for the implementation of an enterprise wide software application using SQL Server Administration and Integration Services. The position achieves this through the effective planning, capture and translation of data migration requirements into the design and execution of the migration effort for the VERI platform.

Key Accountabilities
1. Data Migration Planning
a. Identifies, documents and validates data migration scope, risks, constraints, dependencies and assumptions
b. Develops, documents and validates data migration strategy

2. Data Migration Analysis
a. Engages key users and stakeholders in defining data migration requirements
b. Identifies, documents and validates data migration requirements, technology and IT infrastructure requirements and expectations
c. Identifies source data requirements
d. Assesses source data quality
e. Defines business rules for handling source data
f. Identifies, documents and validates target data requirements
g. Maps and specifies the required transformations from the source data to the target data
h. Validates data migration requirements with key users and stakeholders

3. Data Migration Design
a. Designs a staging area for conducting data transformation and fixing errors
b. Designs target data architecture
c. Maps source, staging and target data architectures to each other including rules and transformations
d. Identifies data migration technology
e. Designs data migration procedures
f. Designs data cleansing procedures
g. Designs data conversion procedures
h. Designs data validation procedures
i. Validates data migration design specifications with key users and stakeholders

4. Data Migration execution
a. Tests data migration procedures
b. Creates and populates staging areas
c. Cleanses data
d. Converts/transforms data
e. Performs trial data migrations into staging
f. Performs data migration into production
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 103425 while calling.
 
Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1),
 
 SQL Server DBA job openings in other states
Jobs List

Software Developer - 460
Create date: 28-Apr-2025
Start Date :5/19/2025
End Date :12-18 Months from start date

Submission Deadline :05/12/2025

Description :

Software Developer. Oakland County is seeking a skilled (4+ years) Software Developer proficient in Java and .NET to design, develop, and maintain secure, scalable applications in a Win.... (This job is for - ASPNet Jobs in MI Pontiac Developer - (in Pontiac, MI))

JFS-Product Specialist 5 /PS 5 (SQL Server DBA) (749345)
Create date: 14-Oct-2024
No of Submissions : 3

start date : 11/04/2024

End date : 06/30/2025

submission deadline : 10/17/2024

client info : JFS

Description :

Years of Relevant Experience:


9+ years experience

Preferred Education:
job Jobs in OH Columbus Specialist - (in Columbus, OH))

NDE/IT Applications Developer Senior - DevOps - 59333
Create date: 11-Oct-2022
start date:11/1/2022
End date:10/31/2023

submission deadline:10/17/2022

client info : NeEDU

Description:

NDE/IT Applications Developer Senior – DevOps

This position will assist in providing hands-on guidance on topics such as branching and mer.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE))

Programmer Analyst 6 - 105559 - SP
Create date: 09-Jun-2022
start date:6/27/2022
End date:06/30/2023

submission deadline:6/16 at 10am EST

client info : DIFS

Note:

* Interview Process: MS Teams Video using integrated audio. Camera MUST be on.

* Duration: 1 year

* Remote or On-site? Local preferred - remote work allowed. (May NOT need t.... (This job is for - SSIST SQL Jobs in MI Lansing Analyst - (in Lansing, MI))

SOFTWARE ARCHITECT- CONSULTANT - 10389-1
Create date: 25-May-2022
start date:6/6/2022

submission deadline:5/31/2022

client info : Judicial Department

Note:

* Q INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

* A Phone interview

Description:

• UNDER LIM.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC))
 
 
(Consultant: SQL Server DBA, Data Migration, SSIS, Analysis Mapping SSMS Tools SQL Stored P in Trenton, NJ)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us