08-14953-Database Architect-Expert

Job Description Project/Program 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 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 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 Database Architect - 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. Expert - 84+ months: 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. Requested 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. We provide equal employment opportunity for all applicants and employees regardless of race, color, sex, gender identity, gender expression, religion, age, national origin, citizenship, disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military/veteran status, or any other protected basis.