Senior ORACLE DBA

Cognizant; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

Cognizant's CIS Practice in Toronto seeks a Senior Oracle DBA to manage Oracle and DB2 databases, monitor health, handle incidents, backups, and performance tuning in a secure, production environment.

You will maintain access controls, run stats, perform patching, and document changes, with a focus on reliability and continuous modernization for client infrastructure.

Qualifications

• Must have Oracle and Db2 expertise.
• Experience with RMAN backups and DB2 backups/restores.
• Able to monitor, troubleshoot, and tune performance.

Responsibilities

• Monitoring & health checks across Oracle/DB2 environments.
• Incident handling from L1 to L3 escalation.
• Backup & recovery operations using RMAN or DB2 tools.
• Space, log management, and tablespace handling.
• Basic performance troubleshooting and locking issues.
• User and access management and password resets.
• Maintenance tasks including statistics gathering and index maintenance.
• Documentation and change execution with rollback plans.

Skills

Oracle

Db2

Job description

About the group:

Cognizant's Cloud, Infrastructure, and Security Services Practice (CIS), is all about accepting digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the constantly evolving needs of the digital era. Our broad approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to own the business in a secure environment.

*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*

Role: Senior ORACLE DBA

Location: Toronto , ON

Roles/Responsibilities

Mandatory Skills: Oracle, Db2

• Monitoring & health checks - Monitor instance/database availability, tablespace and archive log space, alert logs (Oracle) or diagnostic logs (DB2), and job/scheduler status using OEM, DB2 Health Monitor, or third-party tools (Nagios/SCOM).


• Incident/ticket handling - Own L1 tickets independently (connectivity issues, login/access requests, job failures, space alerts) and escalade deep performance tuning, corruption, or RAC/pureScale issues to L2/L3.


• Backup & recovery operations - Execute and verify RMAN backups (Oracle) or db2 backup/db2 restore (DB2) jobs; perform restores/recoveries on request, validate backup completion via logs, and confirm archive log management (archive log list, DB2 log archiving) is functioning.


• Space & log management - Monitor and extend tablespaces/datafiles (Oracle) or table spaces/containers (DB2); manage redo log switches and archive destinations (Oracle) or transaction log space (DB2), resolving "tablespace full" or "log full" alerts per runbook.


• Basic performance troubleshooting - Identify blocking sessions/locks using v$session, v$lock (Oracle) or db2pd, LIST APPLICATIONS (DB2); kill blocking sessions per SOP, spot long-running or high-resource SQL, and upscale execution-plan/tuning issues to L2.


• User & access management - Create/modify users and roles (CREATE USER, GRANT/REVOKE in Oracle; GRANT/REVOKE authorities/privileges in DB2), manage profiles, and handle password resets under change-control.


• Maintenance tasks - Run statistics gathering (DBMS_STATS in Oracle, RUNSTATS in DB2), index rebuilds/reorgs (REORG in DB2), integrity checks, and assist with patching (PSU/RU for Oracle, fix packs for DB2).


• Documentation & change execution - Maintain SOPs, log root causes for recurring issues, update knowledge base, and implement pre-approved schema/config changes during change windows with rollback plans ready.

Compensation

We are offering between $90,000 - $110,000. Applications will be accepted until Oct 9, 2026.Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.

Disclaimer

The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*