Expert, Database Architect

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.

— Day-to-Day Tasks —

1. Analyze business processes and system workflows to identify opportunities for automation and optimization

2. Design, develop, and implement RPD-based automation solutions for data ingestion, transformation, and system integration

3. Build and maintain automated workflows and orchestration pipelines across multiple enterprise databases, applications, storage systems and APIs.

4. Integrate RPD / RPA solutions with databases, APIs, file systems, and enterprise applications

5. Monitor, troubleshoot, and optimize automation processes for performance, reliability, and scalability

6. Implement error handling, logging, retry mechanisms, and recovery processes within automated workflows

7. Evaluate and recommend improvements to automation frameworks, tools, and implementation patterns

8. Collaborate with business analysts, developers, and architecture teams to ensure solutions align with enterprise standards

9. Develop and maintain technical documentation for automation workflows, configurations, and processes

10. Manage build phase and quality assured code to ensure fulfilling requirements and adhering to Enterprise Architecture.

11. Create processes to maintain data quality and high accessibility

12. Design and document all components of approved application solutions including system integrations.

13. Write readable, testable code using advanced analytical functions.

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

15. 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., *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.

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