Principal Architect - Oracle, CDC, and MQ

Ingram Micro • Irvine, CA

2d

About The Position

Accelerate your career. Join the organization that's driving the world's technology and shape the future. Ingram Micro is a leading technology company for the global information technology ecosystem. With the ability to reach nearly 90% of the global population, we play a vital role in the worldwide IT sales channel, bringing products and services from technology manufacturers and cloud providers to business-to-business technology experts. Our market reach, diverse solutions and services portfolio, and digital platform Ingram Micro Xvantage™ set us apart. Learn more at www.ingrammicro.com Come join our team where you’ll make technology happen in surprising ways. Let’s shape tomorrow - it’ll be a fun journey! We are seeking a Principal Database Architect to lead the design and evolution of enterprise-scale Oracle database pipeline, driving strategy across Oracle platforms, change data capture (CDC), messaging and MQ frameworks, and end-to-end data pipeline architecture in alignment with business domain context. Your role: This Senior level Oracle/CDC/MQ Subject Matter Expert: Take end-to-end ownership of the Oracle database pipeline, including mainframe-sourced data replication. Act as a bridge between technical teams and business stakeholders, analyzing complex business data to ensure database architectures accurately reflect business processes. Map complex mainframe structures to Oracle database tables, utilizing deep field-level and copybook-level understanding to preserve business logic. Perform hands-on engineering using PL/SQL, including Oracle triggers, procedures, packages, and conduct advanced performance tuning. Partner directly with business units to map business rules and data lifecycles (such as customer, vendor, and order data) to technical Oracle solutions, ensuring strict data integrity and reconciliation accuracy. Design, support, and troubleshoot MQ architecture across mainframe, Linux, and cloud environments. Manage Splitter operations, queue-level troubleshooting, backlog analysis, and message integrity checks. Monitor and administer daily CDC/MQ latency, including producing MD Orders latency reports for architecture and business teams. Provide day-to-day operational support, rapid incident response, and cross-domain debugging across Mainframe replication, CDC processing, MQ message flow, JDB/Oracle ingestion, and Oracle reconciliation. Serve as a critical technical lead for multi-year modernization programs, including Mainframe Re-platforming, GCP data migration, and CDC modernization. Identify opportunities and develop solutions to automate, stabilize, and improve the efficiency of ongoing Oracle consumer operations. Oracle, CDC, and MQ Process and Methodology Understanding: Understanding of complex data integration methodologies and experience collaborating with cross-functional development and architecture teams. Comply with established levels of service and support on Oracle databases and MQ systems to ensure minimal latency, prevent data integrity gaps, and avoid system downtime. Work closely with cross-platform team members to optimize performance and troubleshoot anomalies end-to-end. Uses performance monitoring tools to identify and correct inefficient database operations. Serve as a primary resource and subject matter expert in assessing CDC architecture, evaluating tooling, and supporting SAP/Oracle integrations. Recommend and initiate change requests as needed to support business rule changes and enhance system functionality. Submit summaries of change control, latency monitoring, and status reports regularly. Duties include resolving and analyzing cross-platform data flow problems and documenting and implementing solutions or workarounds. The responsibilities also include supporting the data team during system testing, minimizing defects during critical transformation cutovers. Actively participate in system design for cloud migration pipelines, ensuring data reliability commitments are met.

Requirements

• A bachelor’s degree in computer science, engineering, science and math or related technical discipline is required.
• 7–10 years of continuous relevant technical experience in Data Architecture, Database Administration, or Middleware support, with a strong focus on Oracle, CDC, and MQ ecosystems.
• Strong business acumen with the proven ability to look beyond the technical pipeline to understand the meaning, lifecycle, and business value of the data being processed.
• Advanced proficiency in Oracle database engineering, PL/SQL development, data reconciliation, and performance tuning.
• Experience reconciling complex financial or operational data (e.g., regional sales and tax reporting) against business targets to ensure data accuracy across systems.
• Extensive source-system expertise across mainframe technologies, specifically IMS, DB2 and VSAM.
• Thorough knowledge of Change Data Capture (CDC) processing and JDB ingestion.
• Deep, hands-on experience with message queuing (MQ) architecture and cross-team debugging across distributed and mainframe platforms.
• Experience with cloud data migrations (preferably GCP) and modernization of legacy mainframe systems.
• Good communications skills including strong verbal, written, and presentation skills, with the ability to articulate complex cross-domain issues to various stakeholders.
• Strong understanding of high availability concepts, message integrity, and latency reduction in large-scale data pipelines.
• Ability to work across multiple international time zones with offshore teams and external vendors as needed.

Nice To Haves

• A graduate degree in technology, business or management is preferred.
• Deep knowledge of Impulse data (orders, invoices, customers, vendors, coded values) is highly preferred.
• Experience with Java and Cobol programming is preferred.

Responsibilities

• Take end-to-end ownership of the Oracle database pipeline, including mainframe-sourced data replication.
• Act as a bridge between technical teams and business stakeholders, analyzing complex business data to ensure database architectures accurately reflect business processes.
• Map complex mainframe structures to Oracle database tables, utilizing deep field-level and copybook-level understanding to preserve business logic.
• Perform hands-on engineering using PL/SQL, including Oracle triggers, procedures, packages, and conduct advanced performance tuning.
• Partner directly with business units to map business rules and data lifecycles (such as customer, vendor, and order data) to technical Oracle solutions, ensuring strict data integrity and reconciliation accuracy.
• Design, support, and troubleshoot MQ architecture across mainframe, Linux, and cloud environments.
• Manage Splitter operations, queue-level troubleshooting, backlog analysis, and message integrity checks.
• Monitor and administer daily CDC/MQ latency, including producing MD Orders latency reports for architecture and business teams.
• Provide day-to-day operational support, rapid incident response, and cross-domain debugging across Mainframe replication, CDC processing, MQ message flow, JDB/Oracle ingestion, and Oracle reconciliation.
• Serve as a critical technical lead for multi-year modernization programs, including Mainframe Re-platforming, GCP data migration, and CDC modernization.
• Identify opportunities and develop solutions to automate, stabilize, and improve the efficiency of ongoing Oracle consumer operations.
• Comply with established levels of service and support on Oracle databases and MQ systems to ensure minimal latency, prevent data integrity gaps, and avoid system downtime.
• Work closely with cross-platform team members to optimize performance and troubleshoot anomalies end-to-end.
• Uses performance monitoring tools to identify and correct inefficient database operations.
• Serve as a primary resource and subject matter expert in assessing CDC architecture, evaluating tooling, and supporting SAP/Oracle integrations.
• Recommend and initiate change requests as needed to support business rule changes and enhance system functionality.
• Submit summaries of change control, latency monitoring, and status reports regularly.
• Duties include resolving and analyzing cross-platform data flow problems and documenting and implementing solutions or workarounds.
• The responsibilities also include supporting the data team during system testing, minimizing defects during critical transformation cutovers.
• Actively participate in system design for cloud migration pipelines, ensuring data reliability commitments are met.

Benefits

• U.S.-based employees have access to healthcare benefits, paid time off, parental leave, a 401(k) plan and company match, short-term and long-term disability coverage, basic life insurance, and wellbeing benefits, among others.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior