Oracle Database

SFE; California; On-site; USD 140,000 - 180,000; Full time

Job summary

SFE in Woodland Hills, CA invites an experienced Oracle Database Architect to lead enterprise database architecture across Oracle, SQL Server, and Db2, ensuring secure, scalable platforms for transactional, analytical, and integration workloads.

You will mentor engineers, design high-availability solutions with Oracle RAC and Data Guard, and guide modernization, migration, and cloud-adoption initiatives with minimal downtime.

Qualifications

• Must define enterprise database architecture principles and roadmaps.
• Experience designing HA/DR architectures using Oracle RAC, Data Guard, and SQL Server Always On.
• Experience in data modelling, schema design, indexing, partitioning, and capacity planning.
• Proven ability to lead modernization, migration, and cloud adoption with minimal downtime.
• Strong knowledge of security controls, backup, recovery, and compliance for relational databases.

Responsibilities

• Define standards for provisioning, patching, monitoring, and automation.
• Collaborate with cross-functional teams to resolve complex architectural issues.
• Create architecture diagrams, data-flow diagrams, runbooks, and migration plans.
• Provide technical leadership and mentorship to database engineers.
• Review performance, tuning, and optimization recommendations.

Skills

Oracle Database 12c/19c

RAC

Data Guard

SQL/PLSQL

Performance tuning

Backup & recovery

Multitenant architecture

High availability

Data modelling

Partitioning

Indexing

Capacity planning

Security controls

Tools

GoldenGate

Enterprise Manager

Job description

Role Oracle Database

Location

Woodland Hills, CA (Onsite)

Fulltime

Job Description

• 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 modelling, 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 behaviour, 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, Golden Gate, 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, pure Scale or cluster integration, backup and recovery, replication, utilities, package management, workload management, performance tuning, and administration tools.
• Architecture and modelling: Relational data modelling, 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.