Oracle Database Architect

Job Title: Oracle Database Architect

Job Location: Woodland Hills, CA Onsite

Job type: Full-Time

Job Description

Experience: 8 12 Years

Oracle Database Architect

Define enterprise database architecture principles, reference designs, standards, patterns, and technology roadmaps for Oracle, Microsoft SQL Server, and IBM Db2.

Design secure, scalable, highly available, and resilient database platforms for transactional, reporting, analytics, and integration workloads.

Lead logical and physical data modeling, schema design, normalization and denormalization decisions, indexing, partitioning, data distribution, and capacity planning.

Design high-availability and disaster-recovery solutions using Oracle RAC and Data Guard, SQL Server Always On Availability Groups, and Db2 HADR and cluster technologies.

Define backup, recovery, replication, failover, business continuity, RTO, and RPO strategies; coordinate recovery testing and document results.

Lead database modernization, consolidation, upgrade, migration, and cloud-adoption initiatives with minimal business disruption.

Assess application data-access patterns and recommend appropriate relational database technologies, deployment models, and integration approaches.

Establish database security controls for authentication, authorization, privileged access, encryption, key management, auditing, masking, and vulnerability remediation.

Review performance baselines, execution plans, workload behavior, resource utilization, and database configurations; recommend tuning and optimization actions.

Define standards for database provisioning, patching, configuration, monitoring, maintenance, release management, and automation.

Collaborate with application, infrastructure, cloud, security, data, and operations teams to resolve complex technical issues and reduce architectural risk.

Create architecture diagrams, design documents, data-flow diagrams, standards, operational runbooks, migration plans, and technical decision records.

Provide technical leadership, mentor database engineers and administrators, conduct architecture reviews, and communicate decisions to technical and business stakeholders.

Required Technical Skills

Oracle: Oracle Database 12c/19c or later, RAC, Data Guard, RMAN, ASM, GoldenGate, multitenant architecture, Enterprise Manager, SQL, PL/SQL, performance diagnostics, patching, backup, and recovery.

Microsoft SQL Server: SQL Server 2016 or later, Always On Availability Groups, Failover Cluster Instances, replication, backup and restore, SQL Server Agent, SSIS, SSRS, T-SQL, execution-plan analysis, indexing, and performance monitoring.

IBM Db2: Db2 LUW and/or Db2 for z/OS, HADR, pureScale or cluster integration, backup and recovery, replication, utilities, package management, workload management, performance tuning, and administration tools.

Architecture and modeling: Relational data modeling, schema design, referential integrity, normalization, denormalization, partitioning, indexing, archival, data lifecycle, and capacity planning.

Security and compliance: Role-based access, least privilege, encryption at rest and in transit, key management, auditing, data masking, vulnerability management, and regulatory controls.

Automation and operations: Shell scripting, PowerShell, Python, SQL scripting, Git, CI/CD, Infrastructure as Code concepts, monitoring, observability, configuration management, and IT service-management practices.

Cloud and hybrid platforms: Experience deploying or migrating relational databases on AWS, Microsoft Azure, Oracle Cloud Infrastructure, or hybrid environments.