Principal DB Architect - Data Platforms - I&D

Capgemini
St. Louis, MO, United States
24 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Compensation
$76,918.0 - $120,203.0
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Amazon Web Services Amazon Elastic Compute Cloud Systems Engineering User Authentication Build Automation Cloud Computing Cloud Engineering Configuration Management Databases Continuous Integration Extract Transform Load (ETL)
+49 more
Data Masking Data Warehousing Database Security Oracle Data Guard DevOps Oracle Exadata Github Monitoring of Systems Python (Programming Language) PostgreSQL Machine Learning Microsoft SQL Server MongoDB NoSQL Online Transaction Processing Oracle Databases Oracle (Applications) Oracle Rac Performance Tuning Role-Based Access Control Redis Ansible Prometheus Recovery Manager (RMAN) Shell Script Datadog Scripting Data Storage Management Google Cloud Oracle Enterprise Manager Grafana Database Optimization Multi-Cloud Reliability of Systems Generative AI Amazon Virtual Private Cloud (VPC) Database Migration Kubernetes Data Management Machine Learning Operations Cloud Migration Database Monitoring Terraform Oracle Cloud Infrastructure Multiplatform Sql Tuning Legacy Systems Jenkins Microservices

Job description

performance tuning Security & Compliance CI/CD Python oracle rac Google Cloud Platform (GCP) production support database migration shell scripting AI/ML

The Enterprise Database Services (DBS) organization is responsible for managing and transforming a large-scale, mission-critical database ecosystem supporting thousands of applications across on-premises, Exadata platforms, and multi-cloud environments (OCI, AWS, GCP).

As part of our 2026 strategic transformation, we are driving:

  • Exadata modernization (X6-X7/X9 ExaCC / Exadata@Cloud)
  • Cloud-first database migration strategy (OCI, AWS, GCP)
  • DBaaS and full lifecycle automation
  • AI/ML-driven database operations and observability
  • Enterprise audit, compliance, and security standardization, * We are seeking a highly experienced Senior Oracle Database Engineer / Lead to play a critical role in designing, engineering, and operating enterprise database platforms while driving modernization, automation, and cloud adoption initiatives.
  • This role will act as a technical leader and subject matter expert (SME) across Oracle platforms and will contribute to cross-platform database strategy, ensuring scalability, reliability, security, and cost optimization across the enterprise.

Responsibilities:

Oracle Platform Engineering & Lifecycle Management:

  • Architect, deploy, and manage Oracle databases (11g, 12c, 19c, 23c) across OLTP, Data Warehouse, and mixed workloads

Lead engineering and operations of:

  • Oracle RAC (Real Application Clusters)
  • Data Guard (Active/Standby, DR strategy)
  • GoldenGate (real-time replication, zero-downtime migrations)
  • ASM (Automatic Storage Management)

Manage full database lifecycle:

  • Provisioning, cloning, patching (RU/RUR cycles), upgrades, decommissioning
  • Drive standardization of database configurations, naming, and deployment models

Exadata & Engineered Systems Leadership:

Lead operations and engineering for:

  • Exadata X6, X7, X8, X9 platforms
  • Exadata Cloud@Customer (ExaCC)
  • Exadata Cloud / Exadata@GCP

Plan and execute:

  • Platform upgrades and consolidations
  • Decommissioning of legacy systems (X6 phase-out)

Optimize workloads for:

  • Smart Scan, storage indexes, I/O performance

Partner with vendors (Oracle) for:

  • Patch strategy, performance tuning, and escalations

Cloud Transformation & Migration:

Lead large-scale database migrations to:

  • OCI (ExaCC, DBCS)
  • AWS (RDS, Aurora, EC2-based Oracle)
  • GCP (AlloyDB, Exadata@GCP)

Execute migration strategies:

  • GoldenGate (zero downtime)
  • Data Pump, RMAN, logical replication

Design and implement:

  • Hybrid and multi-cloud database architectures
  • Landing zones and network integrations (VPC, Transit VPC, Private endpoints)

Drive cost optimization strategies:

  • BYOL vs License-Included
  • Resource right-sizing and storage optimization

Database Automation & DBaaS (DevOps):

  • Design and implement Database-as-a-Service (DBaaS) frameworks

Build automation using:

  • Terraform (IaC for infra provisioning)
  • Ansible (configuration management)
  • Python / Shell scripting (custom automation)

Integrate database workflows into:

  • CI/CD pipelines (Jenkins, GitHub Actions)
  • Enable:
  • Self-service database provisioning
  • Automated patching and compliance enforcement

Reduce manual effort through:

  • Standardized templates and reusable modules

Performance Engineering & Optimization:

Conduct deep performance analysis using:

  • AWR, ASH, ADDM reports

Perform:

  • SQL tuning, indexing strategies, execution plan analysis

Optimize:

  • High-throughput transactional systems
  • Batch and ETL workloads

Drive:

  • Capacity planning, forecasting, and workload balancing

Observability, Monitoring & AI/ML Integration:

Implement enterprise monitoring using:

  • Oracle Enterprise Manager (OEM)
  • Foglight
  • Datadog, Prometheus, Grafana

Develop and support:

  • AI/ML-based predictive failure detection
  • Anomaly detection models for performance and capacity

Leverage Generative AI tools to:

  • Automate incident triage
  • Improve operational efficiency

Partner with AI/ML teams to build:

  • Next-gen intelligent database operations (AIOps)

Security, Risk & Compliance:

Enforce enterprise database security standards:

  • TDE (Transparent Data Encryption)
  • Data masking, auditing, and access controls

Support compliance frameworks:

  • SOX, internal audit, risk exceptions

Integrate with enterprise tools:

  • Imperva (database activity monitoring)
  • Archer, Kenna (risk tracking)

Ensure:

  • Secure authentication (SSO, EntraID integration)
  • Role-based access control (RBAC)

Multi-Platform Database Ecosystem Support:

Collaborate across heterogeneous database platforms:

  • SQL Server
  • PostgreSQL
  • MongoDB / DocumentDB
  • Redis / NoSQL systems

Support enterprise initiatives:

  • Database consolidation
  • Cross-platform migration strategies

Leadership, Collaboration & Governance:

  • Act as a technical lead / SME for Oracle platforms

Mentor junior engineers and drive:

  • Cross-training initiatives (70%+ skill coverage goals)

Partner with:

  • Architecture, Cloud Engineering, Security, Application teams

Contribute to:

  • Database governance boards
  • Standards, RACI models, and intake processes

Participate in:

  • 24x7 production support and escalation handling, * Enterprise Database Architecture
  • Cloud & Hybrid Infrastructure
  • Automation & DevOps (DBaaS)
  • Performance & Scalability Engineering
  • Security & Compliance Governance
  • AI/ML & Observability
  • Leadership & Stakeholder Management

Business Impact / Why This Role Matters:

  • Enables successful execution of 2026 cloud migration programs
  • Supports Exadata modernization and consolidation strategy
  • Drives automation and DBaaS transformation, reducing operational overhead
  • Improves system reliability, performance, and security posture
  • Contributes to AI/ML-driven next-generation database operations

Mitigates risks to:

  • Production stability
  • Migration timelines
  • Compliance and audit readiness

Requirements

  • 10+ years of experience in Oracle Database Engineering / Administration

Deep expertise in:

  • RAC, Data Guard, GoldenGate, ASM
  • Exadata platforms (on-prem and cloud)

Strong experience in:

  • Performance tuning and troubleshooting large-scale systems

Hands-on experience with:

  • Cloud platforms (OCI, AWS, GCP)
  • Automation tools (Terraform, Ansible)
  • Scripting (Python, Shell)

Experience in:

  • High-availability and mission-critical production environments

Preferred Qualifications:

Experience with:

  • Exadata Cloud@Customer (ExaCC) / Exadata@GCP

Exposure to:

  • AI/ML applications in database operations

Knowledge of:

  • Kubernetes, containers, microservices

Experience with:

  • Enterprise audit and compliance frameworks
  • License optimization and cost modeling

Benefits & conditions

$36.98 - $57.79 an hour - Contract, Pulled from the full job description

  • Health insurance
  • Retirement plan
  • Vision insurance
  • Dental insurance, The pay range that the employer in good faith reasonably expects to pay for this position is $36.98/hour - $57.79/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:55 min

Demonstrating semantic routing thresholds with the Redis vector library

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:17 min

Mapping the maturity roadmap for scaled devops adoption

Dominik Krichbaum Dominik Krichbaum · World Congress 2026 Europe

1:34 min

Pivoting careers into specialized platform engineering roles

Xavier Portilla Edo · LIVE

3:42 min

Comparing in-memory and Redis storage for cache scalability

Simone Sanfratello · World Congress 2022

Videos

See all

Related articles

See all