Closed listing
Senior ORACLE DBA
- Toronto, ON, Canada
Compensation: We are offering between $90,000 – $110,000. · Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- Compensation: We are offering between $90,000 – $110,000.
- Job type
- Full-time
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
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.
Location: Toronto , ON
Roles/Responsibilities
Mandatory Skills: Oracle, Db2
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*
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*
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 escalate 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 escalate 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.
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*
More about this job
Responsibilities
Monitor Oracle and Db2 database health, handle routine incidents, and perform backup and recovery, space and log management, access administration, and maintenance tasks. Document recurring issues and procedures, execute approved changes, and escalate complex performance or database issues to higher-level teams.
Requirements
The role requires practical Oracle and Db2 administration skills, including monitoring, backup and recovery, space management, basic performance troubleshooting, access management, and maintenance. It also requires handling L1 tickets, following runbooks and change controls, and documenting procedures; no education or years-of-experience requirement is specified.
Skills
- Oracle Database Administration
- Db2 Database Administration
- Database Monitoring
- Incident Management
- Backup and Recovery
- Tablespace and Log Management
- Performance Troubleshooting
- User and Access Management
- Database Maintenance
- RMAN
- SQL
- Oracle RAC
- Db2 pureScale
- Database Patching
- Change Management
- Technical Documentation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Consulting
Keywords
- Oracle
- Db2
- Oracle Enterprise Manager
- Db2 Health Monitor
- Nagios
- SCOM
- RMAN
- Database Backup and Recovery
- Tablespaces
- Datafiles
- Archive Logs
- Transaction Logs
- SQL
- V$SESSION
- V$LOCK
- DB2PD
- LIST APPLICATIONS
- DBMS_STATS
- RUNSTATS
- Database Reorganization
- Oracle RAC
- Db2 pureScale
- Oracle PSU/RU
- Db2 Fix Packs
- Incident Management
- Change Control
- Runbooks
- Root Cause Documentation
- Database Monitoring