Associate Relational DBA

Posted 3 Days Ago
Be an Early Applicant
Waterford
Junior
Fintech • Payments • Financial Services
The Role
The Associate Relational DBA will support Oracle and PostgreSQL databases, performing administrative tasks, monitoring performance, implementing best practices, and collaborating with teams on database requirements and improvements. Responsibilities include incident reporting, documentation, and troubleshooting within AWS environments.
Summary Generated by Built In

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Associate Relational DBA

About the Role:

The candidate will be a member of the the Relational DB management team within Data Management Services (DMS). The primary role for this position will be as an Oracle Database Administrator supporting Canadian and US requirements with current versions of Oracle and PostgreSQL Databases. A minimum of 1 to 3 year of experience in Information Technology is required as well as experience in relational and other database technologies such as PostgreSQL, MySQL, Redshift, Microsoft SQL Server, and MongoDB to be able to support various teams within DMS.

What will you do?

  • Provide daily status of overnight turnover report indicating any incidents, database notification warnings and actionable items
  • Administrative support of Oracle and PostgreSQL databases including some of its sub-components
  • Support with keeping up-to-date documentation and procedures for all supported database related platforms
  • Some involvement of Oracle server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, readiness programs, new feature exploitation, research and development
  • Work with other Database Administrators or Developers in defining requirements
  • Look for ways to automate and improve infrastructure as code release processes
  • Performance analysis, monitoring, troubleshooting and resolution of issues
  • Contribute to defining, documenting and implementing consistent standards and procedures
  • Contribute ideas for best practice improvements, process improvement, and innovative solutions
  • Assist with the implementation of our Security vulnerability tools product, Imperva
  • Other duties as assigned

What you need to succeed:

  • 1 to 3 years of technical experience working with Oracle hosted on Unix, Linux platforms and AWS
  • 1 to 3 years of technical experience working with PostgreSQL hosted on Linux and AWS platforms
  • University degree in Computer Science or Information technology
  • Knowledge of PLSQL skills including an understanding of system tables, stored procedures, functions, triggers, and SQL tuning
  • May participate in database upgrade, cloning, platform migration, installations, and patching
  • Some experience with Oracle database monitoring and tuning using native Oracle or other third-party tools
  • Knowledge of AWS Cloud computing architecture/design/best practices, and AIX and Linux operating systems
  • DevOps automation tooling such as Ansible, Terraform or Continuous Delivery Director is an asset
  • Knowledge of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies, Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies
  • Excellent interpersonal and communication skills
  • Willingness to provide occasional on-call support/trouble shooting after-hours and weekend to support production implementations, and DR exercises
  • Organizational skills with the ability to handle several tasks efficiently
  • Willingness to share ideas and contribute solutions, take initiative and speak up in at team meetings

What’s in it for you:

  •  Joining an organization that the industry calls one of the best places to work
  •  Being part of our journey in developing the next greatest digital experience Flexible work schedule, within core business working hours, to meet the needs of you and your family

Job Category:

IT - Technology Services

Posting End Date:

11/03/2025

Top Skills

Ansible
AWS
DevOps
Linux
Microsoft Sql Server
MongoDB
MySQL
Oracle
Plsql
Postgres
Redshift
Terraform
Unix
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Toronto, Ontario
499 Employees
On-site Workplace

What We Do

A UK company, Sun Life Financial of Canada is focused on building excellent customer service by offering the highest levels of customer care. We have been serving customers in the UK for over 100 years

Similar Jobs

Waterford, IRL
620 Employees

SRAM, LLC Logo SRAM, LLC

Financial Planning & Analysis Manager

Fitness • Hardware • Mobile • Software • Sports • Transportation • Esports
Waterford, IRL
3800 Employees
Waterford, IRL
41000 Employees

Haleon Logo Haleon

Reliability Engineer

AdTech • Consumer Web • eCommerce
Dungarvan, Waterford, IRL
14788 Employees

Similar Companies Hiring

Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account