Database Architect

Job Title: Database Architect - Expert
Task ID: HBITS-08-14953
Position Duration: 30 Months
Client: State of NY
Agency: Department of Transportation

Please call View phone number on click.appcast.io | View phone number on click.appcast.io | View phone number on click.appcast.io or email at View email address on click.appcast.io

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.

Mandatory Qualifications 1 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. 2 84 months of experience analyzing business processes and translating business, functional, data, and system requirements into enterprise automation designs and technical solutions. 3 72 months of experience integrating enterprise automation solutions with databases, APIs, web services, file-based interfaces, enterprise applications, and external systems. 4 72 months of experience designing and implementing automation controls, including exception handling, validation, logging, monitoring, alerting, audit trails, recovery, reconciliation, and operational support. 5 60 months of experience developing and maintaining data-processing solutions, including ETL/ELT, data ingestion, data transformation, workflow orchestration, scheduling, and data-quality controls. 6 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. 7 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 • Resume
• 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.)
i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

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