Oracle DBA Lead — RAC, Data Guard & 24x7 Ops

Tata Consultancy Services Limited; Vancouver; On-site; CAD 120,000 - 180,000; Full time

Job summary

Tata Consultancy Services Limited in Vancouver seeks an experienced Oracle DBA to lead end-to-end database operations for the BC Hydro scope. The role focuses on high availability, performance tuning, and disaster recovery for Oracle databases in a large-scale enterprise environment.

You will mentor DBAs, coordinate with application and infrastructure teams, and implement robust runbooks and SOPs while ensuring SLA adherence.

Qualifications

• Minimum 10-15 years of IT experience with strong hands-on Oracle DBA experience in production support and enterprise database administration.

Responsibilities

• Lead end-to-end Oracle DBA operations, technical delivery and L2/L3 support for Oracle databases in the BC Hydro database management scope.
• Administer Oracle databases including installation, configuration, upgrades, patching, cloning, refreshes, database startup/shutdown, storage planning and capacity management.
• Manage and support Oracle high availability and disaster recovery technologies including RAC, Data Guard, ASM, Grid Infrastructure and standby database environments as applicable.
• Plan, validate and support backup and recovery operations using RMAN and related enterprise backup tools, including recovery testing and DR exercise support.
• Monitor database health, availability, performance, space, jobs, alerts and logs using Oracle Enterprise Manager or equivalent monitoring platforms.
• Analyze and tune Oracle database performance using AWR, ASH, explain plans, indexing strategy, SQL tuning, statistics, wait events and resource utilization reports.
• Support security, access management, user/role administration, audit requirements, vulnerability remediation, encryption and compliance controls for Oracle databases.
• Troubleshoot production incidents such as database availability issues, backup failures, archive log issues, storage/disk growth, batch job failures, application connectivity issues and authentication problems.
• Coordinate with application teams, infrastructure teams, backup teams, Unix/Linux administrators, security teams, vendors and customer stakeholders for incident and change resolution.
• Lead technical reviews, guide DBA team members, perform peer reviews, support task allocation and ensure adherence to standards, SOPs and SLA commitments.
• Participate in incident, problem, service request, change, release and knowledge management processes using client-approved service management tools.
• Prepare and maintain runbooks, SOPs, architecture notes, implementation plans, deployment steps, DR test evidence, RCA documents, release notes and knowledge articles

Skills

Oracle DBA

Database performance tuning

Unix/Linux administration

Stakeholder communication

Leadership/mentoring

Tools

RMAN

CommVault

Oracle Enterprise Manager

Oracle Exadata

Job description

Tata Consultancy Services Limited in Vancouver seeks an experienced Oracle DBA to lead end-to-end database operations for the BC Hydro scope. The role focuses on high availability, performance tuning, and disaster recovery for Oracle databases in a large-scale enterprise environment.

You will mentor DBAs, coordinate with application and infrastructure teams, and implement robust runbooks and SOPs while ensuring SLA adherence.