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 :
- Review, maintain, and enhance the current database systems which provide the foundations of multiple product lines.
- Data model ownership to support product development teams in the development of new features and products.
- Optimize database performance and ensure system reliability across platforms.
- Ensure the ongoing scalability and performance of the underlying database systems.
- 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 :
Deep understanding of data modeling, database architecture, and system resource / performance considerations.Expertise in SQL, stored procedures, and analytic functions, preferably with Oracle and PostgreSQL with TimescaleDB.Experience with database connection and data access libraries and tools in a Linux environment using Oracle / PostgreSQL in Python, Java, C / C++, and Go.Proven track record of supporting mission-critical database systems in production environments.Experience with cloud environments and database migration strategies.