Senior Database Developer (Oracle & Database Migration) [BHJOB13022_13516]

Ignite Technical; Burnaby; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

Join a forward-thinking company as an Oracle Database Developer, where you will play a vital role in maintaining and enhancing the database infrastructure. This exciting position offers the opportunity to work with cutting-edge technologies and contribute to the evolution of a cloud-native platform. Collaborate with a talented team to ensure high performance, scalability, and operational efficiency of mission-critical systems. If you are passionate about database technologies and eager to make a significant impact in a dynamic environment, this role is perfect for you.

Qualifications

• Expertise in SQL and database performance optimization.
• Deep understanding of data modeling and database architecture.

Responsibilities

• Maintain and enhance database systems supporting product lines.
• Optimize performance and ensure reliability across platforms.

Skills

Data Modeling

Database Architecture

SQL

Stored Procedures

Analytic Functions

Performance Optimization

Cloud Environments

Database Migration Strategies

Tools

Oracle

PostgreSQL

SQL Server

Linux

Python

Java

C/C++

Go

Job description

On behalf of our Utilities client based in Burnaby, Ignite Technical Resources is seeking an Oracle Database Developer to join our client's team on a permanent basis. It is a Hybrid model, with 2-3 days a week on-site at their Burnaby location.

Summary of the Role:

The client is looking for a Database Developer to support the database technologies embedded in their broad product line and to contribute to the evolution of the platform. This role will be critical in maintaining and enhancing current database infrastructure (Oracle, SQL Server, Postgres) and leading efforts to transition to a cloud-native architecture. You will work closely with our team in supporting data modeling while maintaining high performance, scalability, and operational efficiency within systems deployed both on-premises and in cloud environments.

Responsibilities:

1. Review, maintain, and enhance the current database systems which provide the foundations of multiple product lines.
2. Data model ownership to support product development teams in the development of new features and products.
3. Optimize database performance and ensure system reliability across platforms.
4. Ensure the ongoing scalability and performance of the underlying database systems.
5. Contribute to the development of a cloud-native platform, including the integration of multiple different back end technologies into a common platform.

Skills and Experience Required for the Role:

1. Deep understanding of data modeling, database architecture, and system resource/performance considerations.
2. Expertise in SQL, stored procedures, and analytic functions, preferably with Oracle and PostgreSQL with TimescaleDB.
3. Experience with database connection and data access libraries and tools in a Linux environment using Oracle/PostgreSQL in Python, Java, C/C++, and Go.
4. Proven track record of supporting mission-critical database systems in production environments.
5. Experience with cloud environments and database migration strategies.