Oracle Database Architect

Tata Consultancy Services; Los Angeles (CA); On-site; USD 95,000 - 120,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Database Architect in Los Angeles, CA to define enterprise database architecture principles and roadmaps across Oracle, SQL Server, and IBM Db2. You will design scalable, secure, and highly available platforms for transactional, reporting, analytics, and integration workloads, and lead modernization and cloud-adoption initiatives.

Responsibilities include data modeling, disaster recovery design, backup and recovery planning, performance tuning,

Qualifications

• Defined enterprise database architecture principles and roadmaps for Oracle, SQL Server, and Db2.
• Lead secure, scalable, highly available database platforms for transactional, analytics and integration workloads.
• Lead data modeling, schema design, normalization, denormalization, indexing, and capacity planning.

Responsibilities

• Design high-availability and disaster-recovery solutions (Oracle RAC, Data Guard; SQL Server AGs; Db2 HADR).
• Define backup, recovery, replication, failover, business continuity strategies and coordinate recovery testing.
• Guide modernization, consolidation, upgrades, migrations, and cloud adoption with minimal business disruption.
• Assess application data-access patterns and recommend relational DB technologies and deployment models.
• Establish database security controls including encryption, auditing, masking, and privilege management.
• Review performance baselines, execution plans, workload behavior, and optimize configurations.
• Define standards for provisioning, patching, monitoring, maintenance, release management, and automation.
• Collaborate with application, infrastructure, cloud, security, data and ops teams to reduce architectural risk.
• Create architecture diagrams, runbooks, migration plans, and technical decision records.
• Provide technical leadership and mentor DB engineers and admins.

Skills

Oracle

SQL Server

IBM Db2

Architecture & modeling

Security & compliance

Automation & operations

Cloud & hybrid

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 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.

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 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