ALS Limited Logo

ALS Limited

Database Developer (Oracle PL/SQL)

Posted 21 Days Ago
Be an Early Applicant
In-Office
North Vancouver, BC, CAN
Mid level
In-Office
North Vancouver, BC, CAN
Mid level
Develop and maintain Oracle SQL and PL/SQL database applications, including queries, packages, procedures, functions, triggers, integrations, and data workflows. Optimize database performance, troubleshoot application and data issues, ensure transaction reliability, and collaborate with developers, analysts, and stakeholders. The role also involves testing, documentation, code reviews, version control, automated deployments, CI/CD, and database change management.
The summary above was generated by AI

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 with 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 determined 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 are 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 have a safe, flexible and rewarding career that makes a positive impact on our people, the planet and our communities.

Everyone Matters

ALS is proud to be an equal opportunity employer and is committed to fostering an inclusive work environment where the strengths and perspectives of each employee are both recognised and valued.

Qualified candidates will be considered without regard to race, colour, religion, national origin, military or veteran status, gender, age, disabilities, sexual orientation, gender identity, pregnancy and pregnancy-related conditions, genetic information and any other characteristics protected by the law. We invite resumes from all interested parties, including women, First Nations, Metis and Inuit persons, members of minority groups, and persons living with disabilities.  

ALS also welcomes applications from people with all levels of ability. Reasonable adjustments to support candidates throughout the recruitment process are available upon request. 

Eligibility
To be eligible to work at ALS you must be a Citizen or Permanent Resident of the country you are applying for, or either hold or be able to obtain, a valid working visa.

How to apply
Please apply on-line and provide a resume & cover letter that best demonstrate your motivation and ability to meet the requirements of this role.

ALS Limited Burnaby, British Columbia, CAN Office

Burnaby, Canada

ALS Limited North Vancouver, British Columbia, CAN Office

North Vancouver, Canada

ALS Limited Vancouver, British Columbia, CAN Office

Vancouver, Canada

Similar Jobs

An Hour Ago
Hybrid
Vancouver, BC, CAN
Senior level
Senior level
Gaming • Information Technology • Mobile • Software • Esports
Develop and debug C++ gameplay audio systems for a AAA sports game, including dynamic crowd reactions, player commentary, and contextual sound effects. Collaborate with gameplay engineers, audio designers, and artists to integrate audio with behavior and animation systems. Build AI-powered analysis tools and workflows, contribute to a large performant codebase, participate in code reviews, and communicate technical concepts across disciplines.
Top Skills: C#C++PythonUnreal Engine
9 Hours Ago
Easy Apply
In-Office or Remote
Canada
Easy Apply
Mid level
Mid level
Cloud • Security • Software • Cybersecurity • Automation
Lead the SSCS Add-On engineering team to develop security capabilities, managing delivery, team growth, and quality in a collaborative environment.
Top Skills: Ci/CdDevsecopsSigstoreSlsa
11 Hours Ago
Hybrid
Vancouver, BC, CAN
Entry level
Entry level
Fintech • Financial Services
Conduct physical collateral and inventory inspections at dealerships and commercial businesses, reconcile records, investigate discrepancies, prepare audit reports, communicate risks, and support lending compliance. Manage extensive territory travel, customer inquiries, documentation issues, and relationship building. The role requires independent judgment, analytical skills, business-record knowledge, Microsoft Office proficiency, a valid driver’s license, reliable vehicle, and the ability to work in varied indoor and outdoor environments.
Top Skills: ExcelMS OfficeMicrosoft OutlookMicrosoft PowerpointMicrosoft Word

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account