Senior Database Architect & Data Infrastructure Lead

Talentify; Latham (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Mindlance is seeking an Expert Database Architect and L2 Technical Operational Support for a NYS ITS project with the NYS Department of Transportation. The role focuses on designing data infrastructure, implementing SSDLC, and ensuring secure access for authorized users.

The ideal candidate will collaborate with Agency SMEs and IT teams to deliver robust data solutions, optimize ETL/ELT processes, and produce design reports and architecture improvements while coordinating project milestones.

Qualifications

• Experience designing data infrastructure for authorized access.
• Ability to extract and organize data from multiple sources.
• Proficiency in SSDLC including debugging and configuration.

Responsibilities

• Interact with subject matter experts to understand business needs and design requirements.
• Design data infrastructure to extract and organize data for authorized access.
• Identify data sources and plan storage and organization to support analytics.

Skills

Data architecture

SQL

ETL/ELT

SSDLC

Oracle ODI

Data security

Debugging

Documentation

Tools

Oracle ODI

Job description

Mindlance is seeking an Expert Database Architect and L2 Technical Operational Support for a NYS ITS project with the NYS Department of Transportation. The role focuses on designing data infrastructure, implementing SSDLC, and ensuring secure access for authorized users.

The ideal candidate will collaborate with Agency SMEs and IT teams to deliver robust data solutions, optimize ETL/ELT processes, and produce design reports and architecture improvements while coordinating project milestones.