Senior Data Modeler

Albany, NY, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Contract Corp To Corp
Contract Independent
24 Months
No Travel Required
Able to Sponsor
On-site
$66/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Modeler
  • Data Architect
  • Database Architect
  • ER/Studio Data Architect
  • ER/Studio
  • Logical Data Modeling
  • Physical Data Modeling
  • DDL
  • DML
  • SQL Server
  • Microsoft SQL Server
  • IBM DB2
  • DB2 z/OS
  • Complex SQL
  • SQL Performance Tuning
  • PL/SQL
  • SSMS
  • SSIS
  • SSRS
  • QMF for Workstation
  • TSO
  • Redgate SQL Compare
  • Data Conversion
  • Data Mapping
  • Gap Analysis
  • Data Architecture
  • Database Modernization
  • Metadata Management
  • Stored Procedures
  • Database Design

Summary

We have an urgent opening for State of NY Job id : HBITS-08-15049 below I have mentioned Complete Job Description.

We are open for C2C or W2 or 1099.

 

Note –

"We will need Visa copy, PP No, Driver License, and Education certificate copy along with three Professional References for submission to client"

 

If interested please attach your latest updated resume, and do let me know what is the best time to discuss

 

Position Name: Sr Database Admin

Location: Albany, NY (Onsite)

Duration- 24 Months

Job id: HBITS-08-15049

Note - "We will need Visa copy, PP No, Driver License, and Education certificate copy along with three Professional References for submission to client"

If interested please attach your latest updated resume, and do let me know what is the best time to discuss

 

JD:

•       84 months of experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.                                            

•       84 months of experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.      

•       84 months of experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.                               

•       84 months of experience working with SQL Server Management Studio (SSMS), SSMS Job Scheduler, SSIS, SSRS, Export/Import tools, ER/Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.                                 

•       84 months of experience using SQL and PL/SQL programming languages.                                            

•       60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.                   

Specialized Data Modeling Experience

•       12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives, including logical and physical data modeling, metadata management, database design, and DDL generation."                                   

Hybrid Database Environment Experience

•       24 months of experience designing enterprise data models and writing complex SQL for IBM DB2 z/OS and Microsoft SQL Server environments utilizing ER/Studio Data Architect, QMF for Workstation, TSO, SQL Server Management Studio (SSMS), and Redgate SQL Compare.                                

Professional Database Certification

•       Candidate must possess at least one of the following certifications:

•       Microsoft Certified: Azure Database Administrator Associate (DP-300)

•       Microsoft Certified: Azure Data Engineer Associate (DP-203)

•       IBM Certified Database Administrator - DB2

•       IBM Certified Application Developer - DB2                                         

Candidate must have at least 12 months experience in the following:

•       Experience leading enterprise data architecture and database modernization initiatives.

•       Experience preparing technical documentation for audits, compliance reviews, and regulatory reporting.

•       Experience participating in Agile and Scrum-based project environments."                                          

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: avenj001
  • Position Id: 9118439
  • Posted 1 day ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.