Database Architect

JSM Consulting Inc
  • Albany, NY
  • Quick Apply
1 day ago

Job Description



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

Numbers & Facts

LocationAlbany, NY

Skills

  • Application Programming Interface (API)unmatched
  • Automationunmatched
  • Business Analysisunmatched
  • Business Processesunmatched
  • Cross-Functionalunmatched
  • Customer Relationship Management (CRM) Systemsunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Structuresunmatched
  • Data Warehousingunmatched
  • Database Architectureunmatched
  • Database Designunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • ERP (Enterprise Resource Planning)unmatched
  • Enterprise Applicationsunmatched
  • Error Handlingunmatched
  • Federal Governmentunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • Information Technology & Information Systemsunmatched
  • Mainframe Computerunmatched
  • Maintain Complianceunmatched
  • Mentoringunmatched
  • Operational Supportunmatched
  • PCI-DSSunmatched
  • Process Analysisunmatched
  • Publicationsunmatched
  • Reconciliationunmatched
  • Regulationsunmatched
  • System Integration (SI)unmatched
  • Technical Leadershipunmatched
  • Technical/Engineering Designunmatched
  • U.S. National Institute of Standards and Technology (NIST)unmatched
  • Web Servicesunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder