08-14953-Database Architect-Expert

About the Role

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.

Responsibilities

• 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 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 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 system testing and development of testing plans.

Requirements

• 84+ months of experience as a Database Architect, determining database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems; providing database support by coding utilities, responding to user questions, and resolving problems.
• 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.

Environment

Experience must be 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.