More jobs:
Oracle Database Architect
Job in
Los Angeles, Los Angeles County, California, 90079, USA
Listed on 2026-10-16
Listing for:
Tata Consultancy Services
Full Time
position Listed on 2026-10-16
Job specializations:
-
IT/Tech
Database Administrator, Data Engineering
Job Description & How to Apply Below
- 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.
- 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.
- 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,…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×