Oracle Database Architect

Volto Consulting; Los Angeles (CA); On-site; USD 150,000 - 210,000; Full time

Job summary

Volto Consulting in Woodland Hills, CA is seeking an experienced Oracle Database Architect to define enterprise database architecture principles, reference designs, standards, patterns, and roadmaps for Oracle, Microsoft SQL Server, and IBM Db2.

Lead design of secure, scalable, highly available database platforms for transactional, reporting, analytics, and integration workloads; drive data modeling, backup/recovery strategies, and modernization initiatives with minimal business disruption.

Qualifications

• 8–12 years of experience in enterprise database architecture.
• Ability to lead logical and physical data modeling and schema design.
• Experience with security controls, backup/recovery, and performance tuning.

Responsibilities

• Define enterprise architecture principles, reference designs, standards and roadmaps for Oracle, SQL Server and Db2.
• Design secure, scalable, highly available database platforms for transactional, reporting and analytics workloads.
• Lead data modeling, partitioning, indexing, and capacity planning; drive DR and high-availability solutions.

Skills

Oracle

Data modeling

Performance tuning

Cloud/hybrid platforms

Scripting (PowerShell, Python)

Tools

Oracle RMAN

GoldenGate

Data Guard

Always On

DB2 HADR

Job description

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

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.