Senior Database Engineer & ELT Specialist

Elastify; Canada; On-site; CAD 95,000 - 130,000; Full time

Job summary

Elastify is seeking a Senior Data Engineer / Developer DBA to join our technology team in Canada. This 80% database development and 20% data engineering role focuses on Oracle, SQL/PLSQL, data modeling, and performance optimization in a fast-paced environment.

You will act as a Database SME across multiple projects, contributing to design, development, optimization, and full implementation while managing multiple priorities and delivering high-quality solutions.

Qualifications

• 8-12 years of experience in database development, Developer DBA, or data engineering roles.
• Strong hands-on experience with Oracle 19c/23ai and 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.

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.

Skills

Oracle

SQL/PLSQL

Data modeling

Database performance tuning

Bash scripting

ELT pipelines

Problem solving

Tools

Talend

Azure Synapse

Microsoft Fabric

Exadata Cloud at Customer

Oracle OCI

Job description

Elastify is seeking a Senior Data Engineer / Developer DBA to join our technology team in Canada. This 80% database development and 20% data engineering role focuses on Oracle, SQL/PLSQL, data modeling, and performance optimization in a fast-paced environment.

You will act as a Database SME across multiple projects, contributing to design, development, optimization, and full implementation while managing multiple priorities and delivering high-quality solutions.