Database Architect

i-Link Solutions; City of Albany (NY); On-site; USD 150,000 - 190,000; Full time

Job summary

Department of Transportation is seeking a Database Architect - Expert to analyze business processes and design advanced automation solutions. You will develop and maintain RPD-based automation for data ingestion, transformation, and system integration across enterprise databases and applications.

The role requires extensive experience in automation design, architecture guidance, and cross-functional leadership to ensure solutions align with enterprise standards and deliver scalable, reliable

Qualifications

• 84 months of experience designing, developing, implementing, and supporting enterprise automation solutions using RPA, RPD, or comparable technologies.
• 72 months of experience integrating automation with databases, APIs, web services, file interfaces, and external systems.
• 60 months of experience developing data-processing solutions, including ETL/ELT, data ingestion, transformation, and data-quality controls.
• 36 months of technical leadership, architecture guidance, and mentoring cross-functional teams.

Responsibilities

• Analyze business processes and workflows to identify automation opportunities.
• Design, develop, and implement RPD-based automation for data ingestion and transformation.
• Build and maintain automated workflows across databases, apps, storage, and APIs.
• Integrate RPD/RPA solutions with databases, APIs, files, and enterprise applications.
• Monitor and optimize automation for performance, reliability, and scale.
• Implement error handling, logging, retries, and recovery within workflows.

Skills

Enterprise automation design

System analysis

Technical leadership

Architecture guidance

Tools

RPD

RPA

ETL/ELT

Job description

Agency: Department of Transportation

Task ID: HBITS-08-14953

Position Duration: 30 Months

Client: State of NY

Job Title: Database Architect - Expert

Description

• Analyze business processes and system workflows to identify opportunities for automation and optimization
• Design, develop, and implement RPD-based automation solutions for data ingestion, transformation, and system integration
• Build and maintain automated workflows and orchestration pipelines across multiple enterprise databases, applications, storage systems and APIs.
• Integrate RPD / RPA solutions with databases, APIs, file systems, and enterprise applications
• Monitor, troubleshoot, and optimize automation processes for performance, reliability, and scalability
• Implement error handling, logging, retry mechanisms, and recovery processes within automated workflows
• Evaluate and recommend improvements to automation frameworks, tools, and implementation patterns
• Collaborate with business analysts, developers, and architecture teams to ensure solutions align with enterprise standards
• Develop and maintain technical documentation for automation workflows, configurations, and processes
• Manage build phase and quality assured code to ensure fulfilling requirements and adhering to Enterprise Architecture.
• Create processes to maintain data quality and high accessibility
• Design and document all components of approved application solutions including system integrations.
• Write readable, testable code using advanced analytical functions.
• Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs.
• Support testing, debugging, deployment, and ongoing maintenance of automation solutions across environments and documentation including, but not limited to: perform system testing and development of testing plans.

Qualifications

Mandatory Qualifications

84 months of experience designing, developing, implementing, and supporting enterprise automation solutions using RPA, RPD, or comparable enterprise automation technologies, including reusable workflows, components, and business processes. 84 months of experience analyzing business processes and translating business, functional, data, and system requirements into enterprise automation designs and technical solutions. 72 months of experience integrating enterprise automation solutions with databases, APIs, web services, file-based interfaces, enterprise applications, and external systems. 72 months of experience designing and implementing automation controls, including exception handling, validation, logging, monitoring, alerting, audit trails, recovery, reconciliation, and operational support. 60 months of experience developing and maintaining data-processing solutions, including ETL/ELT, data ingestion, data transformation, workflow orchestration, scheduling, and data-quality controls. 48 months of experience designing and working with enterprise databases and data models, including conceptual, logical, and physical data models, transactional data structures, analytical data structures, and data warehouses. 36 months of experience providing technical leadership, architecture guidance, design reviews, and mentoring to cross-functional teams including business analysts, developers, and architecture teams implementing enterprise automation and system-integration solutions within a large and complex organization. environment meeting at least two or three of the following criteria:

• User/Staff Scale: An organization with 5,000+ employees OR an IT system serving 10,000+ active internal/external users (e.g., citizens, business partners, or staff).
• System Integration Complexity: An IT environment where solutions must integrate across 5 or more distinct enterprise-level systems (e.g., ERP, CRM, custom databases, mainframe legacy systems, and external APIs).
• Data & Transaction Volume: Systems processing hundreds of thousands of daily transactions or managing multi-terabyte data environments.
• Regulatory & Security Environment: Organizations operating under strict, audited compliance frameworks such as HIPAA, IRS Publication 1075, PCI-DSS, FedRAMP, or NIST 800-53.
• Geographic or Divisional Scope: A federated or multi-divisional organization (such as a state-level agency, federal agency, or multinational corporation) with decentralized business units. Required Documentation
• Résumé
• Copy of Candidate Identification

(i.e., Driver's License/Green Card/Visa and Passport if applicable)

• Any documents referenced in the above Requested Qualifications

(i.e., professional certifications, degrees, etc.)

Disclaimer

i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability