Primary Job Title:
Database Engineer
Alternate/Related Job Titles:
Oracle Database Engineer
Cloud Database Engineer
Database Platform Engineer
AWS Database Engineer
Senior Database Administrator
Location:
Toronto, ON
Onsite Flexibility:
Onsite
Contract Details (Contract roles only):
Job Summary:
We are looking for a dynamic Database Engineer with expertise in Oracle Database, Exadata, and open-source database platforms such as Aurora PostgreSQL. In this role, you will play a key database engineering and technical leadership role in developing and operationalizing the next generation of on-premises and cloud database solutions.
You will work closely with development, QA, AppOps, and platform teams to ensure the 24/7 operational integrity, performance, and security of mission-critical database platforms while supporting cloud transformation initiatives and automation-driven database operations.
Key Responsibilities:
Manage and maintain database systems including Oracle, PostgreSQL, Aurora, AWS RDS, and Exadata to ensure availability, reliability, and optimal performance.
Implement automated solutions for database monitoring and management of transaction processing environments.
Influence database architecture and support migrations from on-prem Oracle environments to AWS-based platforms such as Oracle on AWS and Aurora PostgreSQL.
Implement best practices for database production management including availability, scalability, reliability, and security.
Enhance database observability and monitoring using tools such as AWS CloudWatch, Splunk, and Dynatrace to detect and prevent incidents.
Analyze distributed production environments and optimize performance through automation and resiliency strategies.
Perform SQL tuning and performance optimization by analyzing execution plans and resolving performance bottlenecks.
Manage tablespaces and implement strategies for efficient data storage and space utilization.
Develop automated scripts and validate data accuracy using SQL and PL/SQL.
Plan and execute database backup, recovery, replication, and disaster recovery strategies using technologies such as GoldenGate and AWS DMS.
Implement CI/CD pipelines to automate database deployment, testing, and monitoring.
Drive automation initiatives to streamline database operations and improve efficiency.
Collaborate with application and product teams to support development, testing, and automation initiatives.
Participate in rotating on-call production support for incident management and scheduled changes.
Required Experience:
University degree in Computer Science, Engineering, or an equivalent combination of education and experience.
Strong experience managing Oracle Exadata and AWS RDS environments.
Hands-on experience maintaining Oracle and Aurora PostgreSQL databases in AWS environments.
Experience implementing database backups, restoration processes, replication strategies, and snapshots.
Strong understanding of relational database architecture, SQL optimization, and PL/SQL development.
Nice-to-Have Experience:
Experience with cloud computing technologies and database design in cloud environments.
Experience working with container technologies such as Kubernetes and Docker.
Experience supporting database infrastructure in DevOps environments.
Experience mentoring technical teams and supporting complex database troubleshooting.
Required Skills:
Oracle Database and Exadata administration
SQL performance tuning and query optimization
AWS RDS and Aurora PostgreSQL management
Preferred Skills:
AWS services including EC2, S3, Redshift, and AWS Database Migration Service (DMS)
Infrastructure as Code tools such as Terraform, CloudFormation, and Ansible
CI/CD pipeline implementation
Database observability tools including Splunk and Dynatrace
DevOps and Infrastructure as Code principles
Additional Skills:
AWS Schema Conversion Tool (SCT)
Database migration strategies and execution
Data replication and disaster recovery planning
GoldenGate data replication
Schema design and database operationalization
Database automation and performance monitoring
Incident response and change management support
Technical documentation and knowledge transfer
About the Client:
Leading Canadian financial brand providing secure digital access to funds. Empowering Canadians to manage money on their terms through seamless authentication and secure financial services. The organization is committed to digital prosperity and enabling employees to thrive while building innovative financial solutions.
About GTT:
GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.
Job Number:
26-02324
Hashtags:
#gttca #LI-GTT #LI-Onsite #ZRCA