Database Developer (Oracle PL/SQL)

ALS Chemex de Mexico

North Vancouver

Sur place

CAD 126 000 - 154 000

Plein temps

14 jours+

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Avantages offerts par ce poste

Extended medical
Dental coverage
Vision coverage
Retirement plan with company match
Education assistance

Résumé du poste

ALS is seeking a Database Developer to join our software and technology team. You will design, develop, and maintain Oracle SQL and PL/SQL objects, ensuring reliable data exchange across systems and applications.

You will optimize queries, troubleshoot complex data issues, and collaborate with developers and stakeholders to deliver scalable database solutions. This hands-on role focuses on data integrity, performance, and robust data processing workflows.

Qualifications

  • 3 to 5 or more years of professional experience in database development or a closely related software development role.
  • Oracle certification in SQL, PL/SQL or database development.
  • Strong hands on experience with Oracle SQL and PL/SQL, including the development and maintenance of complex queries, stored procedures, functions and packages.
  • Solid understanding of relational databases, data modelling concepts, transactions, indexing and query optimization.
  • Experience integrating databases with applications, APIs, services or other data systems.

Responsabilités

  • Design, develop, test and maintain Oracle SQL queries, PL/SQL packages, stored procedures, functions, triggers and other database objects.
  • Build and enhance database driven application functionality, business logic and data processing workflows.
  • Develop and maintain database integrations with internal applications, external systems and services, ensuring reliable and accurate data exchange.
  • Analyze queries and execution plans, identify bottlenecks, and improve performance, scalability and maintainability of database solutions.
  • Investigate application and data related issues, identify root causes, and implement effective fixes and preventative improvements.
  • Implement appropriate validation, error handling and transaction management to ensure data consistency and reliability.
  • Work with developers, analysts and business stakeholders to understand requirements, evaluate solutions and deliver enhancements that meet business needs.
  • Participate in code reviews, testing, documentation, version control and release processes to maintain high quality, maintainable code.

Connaissances

Oracle SQL
PL/SQL
Database development
Performance tuning
Data integration
Problem solving

Formation

Oracle certification

Description du poste

At ALS, we encourage you to dream big.

When you join us, you'll be part of a global team harnessing the power of scientific testing and data-driven insights to build a healthier future.

About the Position:

We're looking for a Database Developer with strong Oracle SQL and PL/SQL development skills to join our software and technology team. In this role, you will develop, enhance and maintain database driven applications and integrations that support our business systems and operational processes.

You will work alongside software developers and business stakeholders to translate requirements into reliable technical solutions, troubleshoot complex issues, improve database performance and support the ongoing evolution of our applications. This is an opportunity for a hands on developer who enjoys solving problems, working with complex data and building practical solutions that connect databases, applications and business processes.

Specific Responsibilities:
  • Design, develop, test and maintain Oracle SQL queries, PL/SQL packages, stored procedures, functions, triggers and other database objects.
  • Build and enhance database driven application functionality, business logic and data processing workflows.
  • Develop and maintain database integrations with internal applications, external systems and services, ensuring reliable and accurate data exchange.
  • Analyze queries and execution plans, identify bottlenecks, and improve the performance, scalability and maintainability of database solutions.
  • Investigate application and data related issues, identify root causes, and implement effective fixes and preventative improvements.
  • Implement appropriate validation, error handling and transaction management to ensure data consistency and reliability.
  • Work with developers, analysts and business stakeholders to understand requirements, evaluate solutions and deliver enhancements that meet business needs.
  • Participate in code reviews, testing, documentation, version control and release processes to maintain high quality, maintainable code.
Required Knowledge, Skills & Abilities:
  • 3 to 5 or more years of professional experience in database development or a closely related software development role.
  • Oracle certification in SQL, PL/SQL or database development.
  • Strong hands on experience with Oracle SQL and PL/SQL, including the development and maintenance of complex queries, stored procedures, functions and packages.
  • Solid understanding of relational databases, data modelling concepts, transactions, indexing and query optimization.
  • Experience developing and maintaining application functionality that interacts with relational databases.
  • Experience integrating databases with applications, APIs, services or other data systems.
  • Demonstrated ability to troubleshoot complex technical issues and develop effective, maintainable solutions.
  • Familiarity of software development fundamentals, including source control, testing, debugging and technical documentation.
  • Strong analytical and problem solving skills, with the ability to manage priorities and work collaboratively.
  • Effective written and verbal communication skills.
Required Qualifications:
  • Scripting or automation using Python, PowerShell or similar languages.
  • Automated deployments, CI/CD pipelines or database change management.
  • Supporting enterprise business applications or data intensive operational systems.
Our benefits includes:
  • An estimated annual salary ranging from $90,000 - $110,000 at the time of posting. Individual compensation is determ by factors such as job‑related skills, relevant experience, education and/or training.
  • Structured wage increases.
  • Comprehensive benefit package specific to your work status (including extended medical, dental , and vision coverage, access to company perks, life and disability insurance, retirement plan with company match, employee assistance and wellness programs).
  • Additional vacation days for years of service.
  • Business support for education or training after 9 months with the company.
  • Learning & development opportunities (unlimited access to e‑learnings and more).
Working at ALS

The ALS team is a diverse and dedicated community united by our passion to make a difference in the world.

Our values is important to us, and shape how we work, how we treat each other and how we recognise excellence.

At ALS, you'll be supported to develop new skills and reach your full potential. We invest in our people with programs and opportunities that help you build a diverse career with us.

We want everyone to be safe, flexible and rewarding career that makes a positive impact on our people, the planet and our communities.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Database Developer (Oracle PL/SQL)
Database Developer (Oracle PL/SQL)

ALS Global • North Vancouver

Sur place
CAD 90 000 - 110 000
Salary range: $90,000-$110,000 CAD
Structured wage increases
Comprehensive benefits package (health
+2
Database Developer (Oracle PL/SQL)
Database Developer (Oracle PL/SQL)

ALS Global • Vancouver

Sur place
CAD 90 000 - 110 000
Extended medical coverage
Dental and vision coverage
Retirement plan with company match
+1
Mining Process Engineer
Mining Process Engineer

ALS Canada Ltd. • North Vancouver

Sur place
CAD 115 000 - 135 000
Extended medical, dental and vision
Company retirement plan with match
Learning & development opportunities
+1
Bilingual HR Advisor
Bilingual HR Advisor

ALS Global • Greater Sudbury

Sur place
CAD 70 000 - 85 000
Benefits package
Additional vacation days
Education support
+1
Office Assistant
Office Assistant

ALS Global • Kamloops

Sur place
CAD 28 000 - 40 000
Extended medical, dental, vision
Retirement plan with company match
Education or training support after 9+
+1
HR Advisor
HR Advisor

ALS Global • North Vancouver

Sur place
CAD 70 000 - 85 000
Competitive salary range
Bilingual HR Advisor
Bilingual HR Advisor

ALS Canada Ltd. • Northeastern Ontario

Sur place
CAD 70 000 - 85 000
Extended medical
Dental and vision coverage
Retirement plan with company match
+2
Business Development Manager - North America
Business Development Manager - North America

ALS Canada Ltd. • North Vancouver

Sur place
CAD 130 000 - 150 000
Comprehensive benefit package specific
Office Assistant
Office Assistant

ALS Canada Ltd. • Kamloops

Sur place
CAD 28 000 - 40 000
Extended medical
Dental coverage
Vision coverage
+3
Work Order Entry Clerk
Work Order Entry Clerk

ALS Global • Timmins

Sur place
CAD 38 000 - 48 000