Oracle Database Architect

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.

Salary Range- $95,000-$120,000 a year