Oracle / PostgreSQL Database Administrator

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

• Monitor and optimize database performance, availability, utilization, and capacity.
• Analyze SQL execution plans and optimize queries, indexes, partitioning strategies, and database configurations.
• Diagnose performance bottlenecks across application, database, storage, and infrastructure layers.
• Conduct proactive health assessments and performance reviews.
• Partner with development teams to improve application database interactions and overall system performance.

Backup, Recovery & Business Continuity

• Administer Oracle Recovery Manager (RMAN) and Oracle Zero Data Loss Recovery Appliance (ZDLRA) environments.
• Design and maintain backup, recovery, retention, and replication strategies.
• Perform backup validation, recovery exercises, disaster recovery testing, and restoration activities.
• Ensure compliance with Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Support business continuity and disaster recovery planning initiatives.

Replication, High Availability & Data Movement

• Administer and support Oracle GoldenGate replication environments.
• Configure, monitor, troubleshoot, and optimize GoldenGate Extract, Pump, and Replicat processes.
• Support real-time data replication, cloud migration, database upgrades, and platform migration initiatives.
• Manage Oracle Data Guard, RAC, PostgreSQL Streaming Replication, PostgreSQL Logical Replication, and high availability technologies.
• Troubleshoot replication lag, synchronization issues, failovers, and data consistency challenges.

Database Security

• Implement and maintain database security controls in accordance with enterprise standards and regulatory requirements.
• Manage authentication, authorization, role-based access controls, encryption, certificates, wallets, and privileged access management.
• Support database hardening, security reviews, penetration testing remediation, and vulnerability assessments.
• Manage Oracle Wallet, Oracle Key Vault, SSL/TLS encryption, Transparent Data Encryption (TDE), and related security technologies.
• Support cyber security investigations, threat remediation, and security incident response activities.

Audit, Compliance & Risk Management

• Support internal and external audits by providing evidence, controls documentation, compliance reporting, and remediation plans.
• Ensure database platforms comply with regulatory, corporate governance, and security requirements.
• Monitor compliance controls and remediate identified gaps.
• Participate in risk assessments, control testing, audit reviews, and governance activities.
• Implement and maintain database auditing, activity monitoring, access reviews, and compliance reporting.
• Maintain audit-ready documentation, procedures, standards, and operational records.

Automation & Operational Excellence

• Design, develop, and implement automation solutions to reduce manual effort and improve operational efficiency.
• Develop scripts and automation frameworks using Python, Shell Scripting, PowerShell, Ansible, Terraform, SQL, PL/SQL, and PostgreSQL tools.
• Automate routine operational tasks including:
  • Health checks
  • Database provisioning
  • Backup validation
  • Monitoring and alerting
  • Patch deployment
  • Compliance reporting
  • Recovery validation
  • Incident remediation
• Contribute to DevOps, Infrastructure-as-Code (IaC), self-healing, and Site Reliability Engineering (SRE) initiatives.

EXPERIENCE & EDUCATION:

• 5+ years of database administration experience for Intermediate level.
• 10+ years of database administration experience for Senior/Expert level.
• Experience supporting large-scale, mission-critical database environments.
• Proven experience in Incident, Problem, and Change Management within enterprise organizations.

Oracle Skills

• Oracle Database Administration (19c, 26ai)
• Oracle RAC
• Oracle Data Guard
• Oracle ASM
• Oracle Enterprise Manager (OEM)
• Oracle Recovery Manager (RMAN)
• Oracle GoldenGate
• Oracle Zero Data Loss Recovery Appliance (ZDLRA)
• Oracle Exadata / Exadata Cloud@Customer (ExaCC)
• Oracle Key Vault
• Oracle Wallet
• Oracle Cloud Infrastructure (OCI)
• Oracle Maximum Availability Architecture (MAA)

PostgreSQL Skills

• PostgreSQL Administration and Architecture
• PostgreSQL Performance Tuning
• PostgreSQL Backup and Recovery
• PostgreSQL Streaming Replication
• PostgreSQL Logical Replication
• PostgreSQL High Availability Solutions
• PostgreSQL Security Administration
• PostgreSQL Upgrades and Migrations

Security, Audit & Compliance Skills

• Database Security Architecture
• Database Vulnerability Management
• Security Patching and Remediation
• Encryption at Rest and In Transit
• Database Activity Monitoring
• Regulatory Compliance and Audit Support
• Risk and Control Management
• Security Incident Response
• Database Auditing and Compliance Reporting
• Privileged Access Management (PAM)

Automation & DevOps Skills

• Python
• Shell Scripting
• PowerShell
• Ansible
• Terraform
• Git
• CI/CD Pipelines
• Infrastructure as Code (IaC)
• Automated Database Provisioning and Patching

Operating Systems & Tools

• Linux/Unix Administration
• Enterprise Monitoring Platforms
• Capacity Planning Tools
• Observability and APM Tools
• ServiceNow or equivalent ITSM platforms

Preferred Qualifications

• Experience supporting Oracle Exadata, ExaCC, ZDLRA, and GoldenGate in large enterprise environments.
• Experience with cloud database services on OCI, Azure, AWS, or Google Cloud.
• Knowledge of financial services, banking, or highly regulated industry environments.
• ITIL Foundation or advanced ITIL certification.
• Experience with SRE, DevOps, Agile, and Continuous Delivery practices.
• Experience managing multi-terabyte high-availability database environments.

Key Competencies

• Advanced troubleshooting and analytical skills.
• Strong incident command and crisis management capabilities.
• Exceptional root cause analysis and problem-solving abilities.
• Strong communication and stakeholder management skills.
• Ability to make sound technical decisions under pressure.
• Strong customer and service-oriented mindset.
• Commitment to operational excellence and continuous improvement.
• Ability to work independently and collaboratively across technology domains.

Who We Are:

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we strive to make every interaction, product, and experience remarkably human and refreshingly simple for over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, that is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues and communities.

Our Total Rewards Package
Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more

Additional Information:
We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

Colleague Development

If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities.

If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact.  

We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals. Here at TD, we hire and develop the best.

Training & Onboarding
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process 
We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation
Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Language Requirement (Quebec only):

Sans Objet