Closed listing
Senior Data Engineer
- Toronto, ON, Canada
- Greater Toronto Area, Canada, Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Closing date
- Experience
- 8–12 years of experience in database development, Developer DBA, or data engineering roles.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Senior Data Engineer (Developer DBA)
Our client is seeking a Senior Data Engineer / Developer DBA to join their technology team. This is an 80% database development and 20% data engineering role, ideal for a hands-on technical professional with strong Oracle, SQL/PLSQL, data modeling, and database performance experience.
You’ll act as a Database SME across multiple projects, contributing to solution design, development, optimization, and full implementation in a fast-paced environment.
Key Responsibilities
- Design and develop logical/physical data models and database schemas.
- Develop and optimize SQL/PLSQL, packages, procedures, and database objects.
- Troubleshoot and improve database performance, scalability, and efficiency.
- Support ELT processes and data pipelines using tools such as Talend, Azure Synapse, and Microsoft Fabric.
- Develop database automation and scripting using Bash.
- Support cloud and database modernization initiatives across private cloud, Azure, and Oracle OCI.
- Research and resolve complex database issues and recommend technical solutions.
- Manage multiple projects and priorities while delivering high-quality solutions.
Required Qualifications
- 8–12 years of experience in database development, Developer DBA, or data engineering roles.
- Strong hands-on experience with Oracle 19c/23ai and Exadata Cloud at Customer (ExaCC).
- Advanced SQL and PL/SQL development experience.
- Strong knowledge of data modeling, schema design, normalization, and relational databases.
- Proven database performance tuning and troubleshooting experience.
- Experience with Bash or similar scripting languages.
- Experience developing ELT processes and data pipelines.
- Experience with Azure Synapse, Microsoft Fabric, and/or Talend.
- Understanding of cloud technologies, particularly Azure and/or Oracle OCI.
- Strong problem-solving skills and ability to manage multiple projects in a high-pressure environment.
Nice to Have
- FinTech or financial services experience.
- Automated database deployment / database DevOps experience.
- Experience with Oracle Cloud migration or modernization initiatives.
More about this job
Responsibilities
The role involves designing and developing logical and physical data models and optimizing SQL/PLSQL objects. The candidate will act as a Database SME to support ELT processes and cloud modernization initiatives across Azure and Oracle OCI.
Requirements
Requires 8-12 years of experience in database development or data engineering with strong expertise in Oracle 19c/23ai and Exadata. Proficiency in SQL, PL/SQL, data modeling, and cloud platforms like Azure or OCI is essential.
Skills
- Oracle 19c/23ai
- SQL
- PL/SQL
- Data Modeling
- Database Performance Tuning
- Exadata Cloud at Customer
- Bash Scripting
- ELT Processes
- Azure Synapse
- Microsoft Fabric
- Talend
- Azure
- Oracle OCI
- Schema Design
- Database Automation
- Relational Databases
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
- Engineering
Keywords
- Oracle 19c
- Oracle 23ai
- Exadata Cloud at Customer
- SQL
- PL/SQL
- Data Modeling
- Database Performance Tuning
- Bash
- ELT
- Azure Synapse
- Microsoft Fabric
- Talend
- Azure
- Oracle OCI
- Database DevOps
- FinTech
- Schema Design
- Normalization
- Relational Databases
- Cloud Migration
- Database Modernization
- Developer DBA
- Data Engineering