Back to search

Database Administrator

Senior Oracle DBA responsible for database administration, performance tuning, cloud migrations, and release automation in a hybrid Toronto office.

  • Toronto, Ontario, Canada
  • Full-time
  • Hybrid
  • Posted Nov 3, 2026

Responsibilities

  • Collaborate with application development teams on data modeling, schema design, and deployment of complex PLSQL packages, procedures, triggers, and views.
  • Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
  • Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
  • Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
  • Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
  • Participate in database capacity planning, failover drills, and disaster recovery design.
  • Support production deployment and other maintenance activities over weekend and after office hours on weekdays as needed.

Requirements

  • Experience in a Oracle Database
  • Experience in a Cloud Databases

Nice to have: Oracle Exadata administration, Smart Scan, Hybrid Columnar Compression, AWS Certified Database Specialty, Oracle certifications

Skills

Oracle Database AdministrationOracle 12c/19cAWS RDSAmazon AuroraPostgreSQLPLSQLSQL query tuningExecution plan analysisCloud MigrationCICD integrationShell scripting (Bash)PythonOracleAWSPostgreSQLBashPythonAWS DMSAWS SCT

Full description

Description: Senior Oracle DBA - Database administration - Oracle Database (12c/19c+), AWS & Cloud Databases, Hands-on working knowledge of PostgreSQL architecture, Cloud Migration Experience Toronto, ON - Hybrid (3 Days WFO) Duration - 12 months Experience Required: 8-10 yrs Role Descriptions: 1.Collaborate with application development teams on data modeling| schema design| and deployment of complex PLSQL packages| procedures| triggers| and views. 2.Analyze execution plans| perform SQL query tuning| and optimize index structures to eliminate bottlenecks in high-throughput transactional environments. 3.Lead database release automation| code reviews| and schema migrations across development| staging| and production environments 4.Monitor database application health| identify lock contention| resolve deadlocks| and troubleshoot latency issues. 5.Partner with infrastructure and cloud teams to design| test| and execute on-premises to AWS cloud database migrations. 6.Participate in database capacity planning| failover drills| and disaster recovery design. 7.Support production deployment and other maintenance activities over weekend and after office hours on weekdays as needed. Required Exp 1 - 8-10 years of experience in Oracle Database Administration 2.Oracle Application DBA Expertise 8 years specializing in Oracle Database (12c19c) application support| advanced PLSQL programming| execution plan analysis| and performance diagnostics (AWR| ASH| ADDM). 3.AWS Cloud Databases Practical experience administering managed database services including Amazon RDS (OraclePostgreSQL) and Amazon Aurora. 4.PostgreSQL Hands-on working knowledge of PostgreSQL architecture| schema design| and performance optimization. 5.Cloud Migration Experience Strong| proven track record of migrating on-premises databases to AWS environments (using tools such as AWS DMS| SCT| or native utilities). 6.Collaboration Release Management Solid background in CICD integration for database deployments and working alongside Agile engineering teams. 7.Ability to work with offshore teams for maintenance and production support activitiesNICE TO HAVE skillsExperience with Oracle Exadata administration and performance tuning features (Smart Scan| Hybrid Columnar Compression).Proficiency in shell scripting (Bash) and automation using Python.Relevant AWS (e.g.| AWS Certified Database Specialty) or Oracle certifications Custom Fields: Name: Work Assignment Location Value: Hybrid Name: Parent Value: IS-BFSI-Canada-2-Parent Name: Work Location CDF Value: ~TCCI Canada Corporate~ Name: Type of Asset Value: None Name: Business Vertical Value: CL-BFSI Americas 2 Name: Assets Value: None Name: Requisition ID Value: 11002262 Name: Child Value: IS-BFSI-Canada-2-Group1

Database Administrator at Artech LLC | Referso Jobs