Enterprise Data Architect - HBITS-08-15049

Greycell Labs Inc; City of Albany (NY); On-site; USD 96,000 - 152,000; Full time

Job summary

Greycell Labs Inc in Albany, NY seeks an on-site Enterprise Data Architect for a 24-month contract to design and maintain enterprise data models and complex SQL in SQL Server and DB2 environments.

Responsibilities include data modeling, data conversion planning, metadata management, and collaboration with business stakeholders to support HESC's initiatives. Visa sponsorship is not available.

Qualifications

• 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 SQL Server and IBM DB2 databases.
• 84 months of experience with SQL Server Management Studio and related tools (SSMS Job Scheduler, SSIS, SSRS, Export/Import tools).
• 84 months of experience using SQL and PL/SQL programming languages.
• 60 months of experience performance tuning complex SQL for SQL Server and DB2.
• 12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives.
• Hybrid Database Environment Experience.
• 24 months designing enterprise data models and writing complex SQL for IBM DB2 z/OS and SQL Server environments using ER/Studio, QMF, TSO, SSMS, Redgate.
• Professional Database Certification.

Responsibilities

• Design, implement, and maintain enterprise database solutions.
• Collaborate with stakeholders to support strategic initiatives.
• Create data models, mappings, and metadata management documents.
• Lead data architecture modernization initiatives and audits.

Skills

Data modeling

SQL

Enterprise DB2/SQL Server

ER/Studio Data Architect

SSMS/SSIS/SSRS

Data conversion & mapping

Tools

ER/Studio Data Architect

SSMS

SSIS

SSRS

Redgate SQL Compare

QMF for Workstation

TSO

Job description

Job Title: ON-SITE - Enterprise Data Architect - HBITS-08-15049

Location: Albany, NY, 12255

Duration: 24 Months

Job Description

• 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.

Project: Grants & Scholarships

Detailed Job Description: The consultant will work closely with business stakeholders, agency representatives, solution architects, project managers, developers, and quality assurance teams to design, implement, and maintain enterprise database solutions supporting HESC's strategic initiatives

Note: Sorry we do not Sponsor Visa