Oracle / PostgreSQL Database Administrator

17 hours ago

Mississauga, Ontario, Canada TD Full-time
  • Patch deployment

Work Location

Mississauga, Ontario, Canada

Hours

37.5

Line Of Business

Technology Solutions

Pay Details

$81,600 - $115,200 CAD TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

Job Description

The Oracle/PostgreSQL Database Administrator is responsible for the administration, reliability, security, recoverability, and performance of mission-critical database platforms supporting enterprise applications and services. This role operates within the Technology Operations team with primary accountability for Incident Management, Change Management, Problem Management, Database Security, Compliance, and Operational Excellence.

The successful candidate will possess strong expertise in Oracle and PostgreSQL database technologies, including high availability, backup and recovery, replication, performance tuning, automation, patch management, audit readiness, and security controls. The role requires a proactive problem solver who can lead complex incident resolution, conduct root cause analysis, drive automation initiatives, and continuously improve database reliability and operational efficiency across enterprise environments.

Key Accountabilities

Database Administration & Operations

  • Administer, monitor, maintain, and support Oracle and PostgreSQL databases across production, non-production, cloud, and on-premises environments.
  • Ensure high availability, performance, recoverability, security, and operational stability of database platforms.
  • Perform database installation, configuration, upgrades, migrations, cloning, provisioning, decommissioning, and lifecycle management activities.
  • Manage database storage, schemas, users, privileges, data integrity, and capacity planning.
  • Support highly available and mission-critical database environments with strict uptime and recoverability requirements.

Incident Management

  • Lead technical diagnosis and resolution of database-related incidents and service disruptions.
  • Act as a senior escalation point for Severity 1, Severity 2, and high-impact production incidents.
  • Restore service quickly while minimizing business impact and operational risk.
  • Collaborate with application, infrastructure, network, security, and vendor support teams during incident management activities.
  • Participate in 24x7 on-call support rotations and provide timely incident response.

Problem Management

  • Conduct detailed root cause analysis (RCA) for recurring and high-severity incidents.
  • Identify underlying systemic issues and implement permanent corrective actions.
  • Develop preventative measures to improve platform stability and reliability.
  • Create and maintain troubleshooting guides, runbooks, knowledge articles, and operational procedures.
  • Drive continuous service improvement initiatives focused on reducing operational risk and increasing resiliency.

Change Management

  • Plan, assess, implement, and validate database-related changes in accordance with enterprise change management processes.
  • Perform risk assessments, impact analyses, implementation planning, validation testing, and rollback planning.
  • Support infrastructure upgrades, database upgrades, cloud migrations, platform refreshes, and technology modernization initiatives.
  • Ensure all changes meet operational readiness, security, and compliance requirements before implementation.

Database Patching & Lifecycle Management

  • Plan and execute Oracle and PostgreSQL database patching activities, including Release Updates (RU), Release Update Revisions (RUR), Critical Patch Updates (CPU), security patches, and version upgrades.
  • Maintain database platform currency and compliance with enterprise vulnerability management standards.
  • Validate patch deployments through testing, monitoring, and post-implementation verification.
  • Develop automation and standardized procedures for patch deployment and validation activities.
  • Support platform modernization and end-of-life remediation initiatives.

Performance Monitoring & Tuning