Database Developer (Oracle PL/SQL)
ALS Global1 day ago
North Vancouver, CanadaMid Level / Senior
Base Salary
$90k - $110k/yr
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 integrations between databases, internal applications, external systems, and services.
- Analyze queries and execution plans, identify bottlenecks, and improve database performance, scalability, and maintainability.
- Investigate application and data-related issues, identify root causes, and implement effective fixes and preventative improvements.
- Implement validation, error handling, and transaction management to ensure data consistency and reliability.
- Collaborate with developers, analysts, and business stakeholders to understand requirements and deliver enhancements.
- Participate in code reviews, testing, documentation, version control, and release processes.
Requirements
- 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 complex queries, stored procedures, functions, and packages.
- Understanding of relational databases, data modeling concepts, transactions, indexing, and query optimization.
- Experience developing application functionality that interacts with relational databases.
- Experience integrating databases with applications, APIs, services, or other data systems.
- Ability to troubleshoot complex technical issues and develop effective, maintainable solutions.
- Familiarity with source control, testing, debugging, and technical documentation.
- Experience with scripting or automation using Python, PowerShell, or similar languages.
- Experience with automated deployments, CI/CD pipelines, or database change management.
- Experience supporting enterprise business applications or data-intensive operational systems.
- Strong analytical, problem-solving, prioritization, collaboration, written communication, and verbal communication skills.
Benefits
- Estimated annual salary of $90,000-$110,000 at the time of posting.
- Structured wage increases.
- Comprehensive benefits including extended medical, dental, and vision coverage, company perks, life and disability insurance, retirement plan with company match, employee assistance, and wellness programs.
- Additional vacation days based on years of service.
- Business support for education or training after 9 months with the company.
- Learning and development opportunities, including unlimited access to e-learning.
- Equal opportunity and inclusive workplace commitments, with reasonable adjustments available during recruitment.
- Employment eligibility requires citizenship or permanent residency in the country of application, or holding or being able to obtain a valid working visa.
About ALS Global
ALS Global provides analytical testing, inspection, and certification services for environmental, water, food & beverage, pharmaceutical, and personal care markets. It operates a global network of laboratories selling fee-for-service testing and equipment reliability programs to corporate and public-sector clients. ALS is a public company headquartered in Bowen Hills, Queensland, and is listed on the Australian Securities Exchange (ASX).