Job Description:
Trigyn's direct government client has an immediate need for Database Architect in Albany, NY.
Description:
Provides expert-level design and implementation of automation and data processing solutions using RPD, RPA or comparable enterprise automation technologies, supporting workflow orchestration, data ingestion, and system integration across business processes.
• 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:
• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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.
For Immediate Response call 518-805-7401, or send your resume to RecruiterBP@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.