Haystack
← Back to Jobs
Technology

Oracle Cloud Solution Architect

Trail Blazer Consulting LLCWashington, DC🇺🇸United StatesPosted 7 Aug 2026

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

Data Management Specialist
Level 3


• Lead architecture design
for Oracle Cloud (OCI) solutions, including compute, storage, networking, and
database services.


• Design and implement high
availability and full-service disaster recovery (DR) solutions across OCI
regions.


• Architect migrations from
on-premises Exadata to OCI (EXACS/EXACC), ensuring minimal downtime and data
integrity.


• Collaborate with DBA,
application, infrastructure, and security teams to ensure seamless
integration.


• Provide guidance on Oracle
Autonomous Database, AIOps, and AI-enabled capabilities within OCI.


• Establish best practices
for performance tuning, capacity planning, and cost optimization.


• Ensure compliance with
WMATA cybersecurity standards, FTA guidelines, and regulatory requirements.


• Lead troubleshooting and
root cause analysis for complex production issues.


• Develop architecture
documentation, runbooks, SOPs, and knowledge transfer artifacts.


• Mentor internal teams and
support skill development in OCI technologies.


• Engage with Oracle and
third-party vendors to align solutions with WMATA needs.


• Apply concepts of
application architecture and service orientation to assist customer teams
responsible for developing HA application requirements in specific functional
areas.


• Coordinate work to
prevent overlap and ensure alignment with WMATA Enterprise Architecture
Framework, IT strategy, SDLC, strategic drivers, and standards.


• Prepare as-is and to-be
application architecture artifacts, including system connect diagrams,
application reference models, software requirements documents, interface
descriptions, data dictionaries, performance monitoring and logging
specifications, high availability and scaling designs, DR concepts and
designs, and application staging plans.


• Work with data and
infrastructure architects and software program managers to ensure integrity,
high availability, and scalability of application systems and plans within
the context of the overall Enterprise Architecture.


• Guide the work of
business systems/business case analysts and documentation specialists.


Selection Criteria


Education Bachelor''s degree
in Business, Computer Science, Communications, Finance, or in a related
discipline, or equivalent experience;


Must have minimum
experience (ex:5 years) Level 3 (Senior-level): eight (8) or more years of
relevant experience.


Experience


 


Minimum Requirements:


• Bachelor''s degree in Computer Science, Information
Technology, or related field (or equivalent experience).



• 10+ years of experience in Oracle database
technologies and enterprise architecture.



• 5+ years of hands-on experience with Oracle Cloud
Infrastructure (OCI).



• Strong experience with Oracle Exadata (on-prem and
cloud – EXACS/EXACC).



• Proven experience in large-scale cloud migration
projects (lift-and-shift and modernization).



• Deep understanding of HA/DR architectures, Data
Guard, RMAN, and backup/recovery strategies.



• Experience with networking concepts (VCN, subnets,
load balancers, VPN, FastConnect).



• Strong knowledge of security, identity management,
and compliance frameworks.



• Excellent communication and stakeholder management
skills.



• Exceptional solution architecture experience and
familiarity with architecture patterns and design, with emphasis on
performance tuning, logging, and monitoring, microservices, and cloud; high
availability/scaling solutioning; and software development skills.



• Strong analytical, verbal communication, and written
communication skills.



• Experience using MS Visio or other data or
application visualization software to document application architecture.



• Experience using MS Excel to perform basic software
requirements documentation.



• Familiarity with MS Word and MS PowerPoint.


• Experience coordinating software requirements and
working with development teams.



• Proven ability to plan and deploy custom COTS and
middleware application programs and process improvements.



• Experience managing teams of programmers for the
deployment of large, complex web and mobile applications.



• Experience performing the application architecture
function, from conception to deployment, of a large government multi-agency
solution.



 


Preferred Qualifications:


• Oracle Cloud
certifications (e.g., OCI Architect Professional).


• Experience with
PeopleSoft (FSCM, HCM, EPM) and SOA/OIC integrations.


• Exposure to AI/ML and
AIOps tools within the OCI ecosystem.


• Experience in public
sector or transit systems (highly desirable).


• Knowledge of multi-cloud
or hybrid cloud architectures (AWS/Azure + OCI).


• Familiarity with DevOps,
automation (Terraform, Ansible), and CI/CD pipelines.


• Experience in managing
mission-critical, high-availability environments with near 100% uptime
expectations.


• PMP, TOGAF, or similar
architecture/project management certifications.


• Experience in the transit
industry.


• Experience integrating
legacy applications or data sources across a J2EE, , and/or legacy
mainframe or mini environment.


• At least three (3) years
of experience implementing architectural patterns and designs for web and
mobile applications.


• Hands-on experience
designing and implementing HA and scaling solutions in a complex,
multi-application architecture, including cloud.


• Expertise in integrating
complex HA designs within complex network environments supporting multiple
web and mobile applications.


• Experience planning and
deploying a business process management solution and/or a workflow engine
within a large enterprise software deployment.

Skills

Microservices
Oracle
AWS
Ansible
Azure
Stakeholder Management
Terraform

Similar jobs