Oracle PostgreSQL Database Administrator

Work Location:

Hours:

Line of Business:

Pay Details:

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 candidates 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 (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 worlds 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 95000 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:
Were delighted that youre considering building a career with TD. Through regular development conversations training programs and a competitive benefits plan were 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 youre interested in a specific career path or are looking to build certain skills we want to help you succeed. Youll 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 youre 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.

Were 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 youve got everything you need to succeed in your new role.

Interview Process
Well 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 youd 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):