• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Senior SQL Developer (Onsite)

In United States

Save this job

Senior SQL Developer (Onsite)   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Senior SQL Developer (Onsite)

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Lansing, MI United States

JOB DESCRIPTION:

108283 - Programmer Analyst 6 - Data Migration - IT - DTMB - Agency Services - DIFS - Lansing, MI

POsition : Senior SQL Developer (ONsite)

Location : Lansing, MI

Client : IT-DTMB-DIFS

Duration: 1 year

Top Skills & Years of Experience:


The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database.
• Experience with Microsoft SSIS
• Experience with Microsoft SQL Server
• Knowledge of T-SQL
• Ability to write complex SQL statements
• Experience with AMANDA solution from Granicus (formerly Calytera)

Interview Process: MS Teams Video using integrated audio. Camera MUST be on.
Remote or On-site? Local preferred - remote work allowed. (May NOT need to relocate)

Must provide own equipment – Remote work is acceptable, but onsite visits may be required at key points in the project

Job Title: Data Migration Specialist


Job Description


The Data Migration Specialist is responsible for migrating data from Oracle to MS SQL Server database. The ideal candidate would have participated in large data migration projects, and have experience migrating data to MS SQL Server. Experience with the AMANDA database is a plus. AMANDA is a solution from Granicus (formerly Calytera). THIS IS NOT THE ADVANCED MARYLAND AUTOMATIC NETWORK DISK ARCHIVER (AMANDA).

Responsibilities 


 Adhere to data standards and scripting standards set at the project level
 Analyze existing Oracle and MS Access databases
 Work with Business Analysts to understand the requirements and identify gaps between requirements and data in existing databases.
 Map existing databases fields to new AMANDA database fields
 Document and validate data mapping with the Project team. 
 Develop and document the data migration plan in collaboration with Data Architect.
 Execute data migration plan by migrating data from the source databases to the AMANDA database.
 Apply the data governance rules as well as data retention policies to data migration
 Support efforts to cleanse source data via scripts and/or reports identifying data requiring manual cleansing
 Review AMANDA table structure based on the design in AMANDA for mapping the data from source to Amanda database structure
 Collaborate with other Data Migration Specialists and review each other's scripts to ensure consistency
 Test data migration processes and validate data was migrated correctly.
 Manage data migration scripts by versioning them via source control 
 Constantly work to fine-tune data migration scripts to improve performance. 
 Collaborate with the QA team on data migration activities 
 Coordinate with Data Architect for various technical documentation


Client Skills Matrix


 Minimum 5 years' experience with Microsoft SQL Server
 Ability to write complex SQL statements to query data in MS SQL server and Oracle
 Experience writing SQL stored procedures and functions
 Ability to tune SQL queries for better performance
 Experience using version management tools (Git is a plus)
 Experience with Azure DevOps
 Experience with Agile Methodology (Kanban is a plus)
 Knowledge of AMANDA database structure and table relationships is a plus
Highly Desired Skills
 Experience with MS SQL Server and Oracle databases

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904335463300

LOCATION:

United States

CITY:

Lansing, MI

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Senior SQL Developer (Onsite)    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<p><b>108283 - Programmer Analyst 6 - Data Migration - IT - DTMB - Agency Services - DIFS - Lansing, MI</b></p> <p>POsition : Senior SQL Developer (ONsite)</p> <p>Location : Lansing, MI</p> <p>Client : IT-DTMB-DIFS</p> <p>Duration: 1 year</p> <p><strong>Top Skills & Years of Experience:</strong></p> <p><br /> The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database.<br /> • Experience with Microsoft SSIS<br /> • Experience with Microsoft SQL Server<br /> • Knowledge of T-SQL<br /> • Ability to write complex SQL statements<br /> • Experience with AMANDA solution from Granicus (formerly Calytera)<br /> <br /> Interview Process: MS Teams Video using integrated audio. Camera MUST be on.<br /> Remote or On-site? Local preferred - remote work allowed. (May NOT need to relocate)<br /> <br /> Must provide own equipment – Remote work is acceptable, but onsite visits may be required at key points in the project</p> <p><strong>Job Title: Data Migration Specialist</strong></p> <p><br /> <strong>Job Description</strong></p> <p><br /> The Data Migration Specialist is responsible for migrating data from Oracle to MS SQL Server database. The ideal candidate would have participated in large data migration projects, and have experience migrating data to MS SQL Server. Experience with the AMANDA database is a plus. AMANDA is a solution from Granicus (formerly Calytera). THIS IS NOT THE ADVANCED MARYLAND AUTOMATIC NETWORK DISK ARCHIVER (AMANDA).</p> <p><strong>Responsibilities </strong></p> <p><br />  Adhere to data standards and scripting standards set at the project level<br />  Analyze existing Oracle and MS Access databases<br />  Work with Business Analysts to understand the requirements and identify gaps between requirements and data in existing databases.<br />  Map existing databases fields to new AMANDA database fields<br />  Document and validate data mapping with the Project team. <br />  Develop and document the data migration plan in collaboration with Data Architect.<br />  Execute data migration plan by migrating data from the source databases to the AMANDA database.<br />  Apply the data governance rules as well as data retention policies to data migration<br />  Support efforts to cleanse source data via scripts and/or reports identifying data requiring manual cleansing<br />  Review AMANDA table structure based on the design in AMANDA for mapping the data from source to Amanda database structure<br />  Collaborate with other Data Migration Specialists and review each other's scripts to ensure consistency<br />  Test data migration processes and validate data was migrated correctly.<br />  Manage data migration scripts by versioning them via source control <br />  Constantly work to fine-tune data migration scripts to improve performance. <br />  Collaborate with the QA team on data migration activities <br />  Coordinate with Data Architect for various technical documentation</p> <p><br /> <strong>Client Skills Matrix</strong></p> <p><br />  Minimum 5 years' experience with Microsoft SQL Server<br />  Ability to write complex SQL statements to query data in MS SQL server and Oracle<br />  Experience writing SQL stored procedures and functions<br />  Ability to tune SQL queries for better performance<br />  Experience using version management tools (Git is a plus)<br />  Experience with Azure DevOps<br />  Experience with Agile Methodology (Kanban is a plus)<br />  Knowledge of AMANDA database structure and table relationships is a plus<br /> Highly Desired Skills<br />  Experience with MS SQL Server and Oracle databases</p>


Please wait..!!