Elexicon Energy Inc.

Database Specialist (6 Month contract)

LocationAjax, ON
Job Typefull_time

About This Job

Elexicon Energy is the fourth-largest municipally owned electricity distributor in Ontario. Our mission is to provide our customers with reliable, affordable energy services and to continuously improve to meet their needs, while ensuring the needs of our shareholders are met through sustainable growth.

WHY JOIN OUR TEAM?

At Elexicon Energy we believe in living and leading our values through our daily actions. Our people are passionate about what they do and are engaged in day-to-day operations, projects and initiatives to support Our Why of empowering the communities we serve and helping customers create the possibilities that energize their future. This is an exciting time to join our growing team as we develop the strategies and plans to support a new brand and vision for customer centricity and operational excellence!

Reporting to the Manager, Technology Project Delivery & Governance, the Database Specialist plays a critical role in supporting the reliability, performance, and security of Operational Technology (OT) applications through effective database management. This role is responsible for developing and maintaining integrations between OT systems and enterprise applications, managing SQL Server and Oracle database environments, and ensuring the cyber security compliance of all implementations. The ideal candidate will be a self-starter with strong problem-solving skills and a passion for continuous learning, capable of working independently while collaborating closely with IT, engineering, and operations teams.

Duties And Responsibilities

Gather and comprehend project requirements from both functional and technical perspectives, and collaborate with stakeholders including the IT infrastructure team, external vendors, and internal SMEs from other all lines of business.
Support end-users of both third party and in-house developed applications
Document technical procedures and workflows for OT applications, integrations and database management activities.
Develop and maintain stored procedures, triggers, and database scripts for both SQL and Oracle databases to support business data flows.
Develop and support approved ad-hoc reporting and data extraction requests from lines of business to drive informed decision-making.
Develop operational and project dashboards using Power BI (or other applications)
Document technical procedures and workflows for OT applications, integrations and database management activities.
Develop and maintain custom applications as part of a team using Oracle PL/SQL, SQL, SSRS, MySQL and various other programming and scripting languages as required.
Analyze, comprehend, and support legacy system integrations.
Ensure cyber security compliance in the implementation, integration, and support of OT systems.
Keep skills current and independently acquire new skills by leveraging online resources.


Key Skills & Qualifications

Oracle 19C database experience/XQuery Packages/Procedures/Triggers/Queries
Microsoft SQL Server experience/MySQL/SSRS
Proficiency in SQL and PL/SQL.
Strong understanding of APIs (REST/SOAP), messaging systems, and data transformation (XML, JSON).
Experience with data analytics and visualization using tools such as excel, PowerBI etc.
Excellent written and verbal communication skills to effectively communicate with technical and non-technical stakeholders.
Positive attitude and very strong work ethic.
Ability to learn and adapt very quickly.
Ability to work independently or in a small team environment.
Excellent organization skills and the ability to handle and prioritize multiple projects at once.


Minimum Requirements

Computer Science degree, Engineering degree, or equivalent combination of education and experience.
1-3 years (including co-op/internships) of relevant experience with systems integration, data analytics, report and dashboard creating, database development (SQL and Oracle), and application support.
Understanding of cyber security principles and best practices relating to OT system integrations.

Our Commitment To Diversity, Equity, Inclusion And Belonging

Elexicon Energy embraces and celebrates our collective diversity. We are committed to fostering an inclusive, diverse and equitable workplace built on respect, support and collaboration.

Elexicon Energy is an equal opportunity employer. We value an inclusive and supportive workplace which truly reflects the diversity of the communities we serve. We welcome all individuals to apply and do not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, disability, age, Indigenous/Métis status, or other legally protected status.

In accordance with the Ontario Human Rights Code and Accessibility for Ontarians with Disabilities Act, 2005, accommodation is available upon request at any point during the recruitment process. If you require accommodation please email us at HR@elexiconenergy.com and we will work to meet your needs.

We thank all applicants; however, only those to be considered will be contacted.

Similar Jobs

company-logo

Database Specialist (6 Month contract)

Elexicon Energy
Job Typetemporary
 
Ajax, ON
6 days ago
company-logo

Database Specialist (6 Month contract)

Elexicon Energy Inc.
Job Typefull_time
 
Ajax, ON
6 days ago
company-logo

Data Science Developer (12-month contract)

ARC Resources Ltd.
Job Typecontract
 
Calgary, AB
21 days ago
company-logo

Contract Specialist (18-month temporary)

Canadian Natural Resources Limited (CNRL)
Job Typefull_time
 
Calgary, AB
19 days ago
company-logo

Contract Specialist (18-month temporary)

Canadian Natural
Job TypeFull-time
 
Calgary, AB
19 days ago
company-logo

Project Engineer (6-month contract)

Woodfibre Management Ltd
Job TypeContract
 
Houston
7 days ago
company-logo

Database Management Specialist

ACRT
Job Typefull_time
 
Denver, CO
14 days ago
company-logo

Contract Specialist

Entergy
Job Typecontract
 
New Orleans, LA
6 days ago
company-logo

Instrumentation Specialist - 12 Month Contract

Tacora Resources Inc.
Job TypeContract, Fixed term contract
 
Wabush, NL
7 days ago
company-logo

Contract Specialist

Aiken Electric Cooperative, Inc.
Job Typefull_time
 
Aiken, SC
14 days ago
company-logo

Contracts Specialist

Canadian Natural Resources Limited (CNRL)
Job Typefull_time
 
Calgary, AB
19 days ago
company-logo

Contracts Specialist

Canadian Natural
Job TypeFull-time
 
Calgary, AB
20 days ago
company-logo

Contracts Specialist

Metergy Solutions
 
Markham, ON
22 days ago
company-logo

Contracts Specialist

Babcock Power Inc.
Job TypeFull-time
Salary
$60000 - $71000
Duncan, SC
29 days ago
company-logo

Contract Specialist

Transcanada Turbines
Job TypeFull-time
 
Airdrie, AB
29 days ago
company-logo

Contracts Specialist

Barrick Mining Corporation
Job Typefull_time
 
Marathon, ON
30 days ago
company-logo

Contracts Specialist

Barrick Gold Corporation
Job TypeFull-time
 
Marathon, ON
30 days ago
company-logo

Data Analyst (contract)

Xcel Energy
Job Typecontract
 
Minneapolis–Saint Paul, WI
26 days ago
company-logo

Contract & Procurement Specialist

Porcupine Engineering Services Inc
Job Typecontract
 
Ottawa, ON
12 days ago
company-logo

Specialist, Contract Compliance

Venture Global LNG
Job TypeContract
 
Houston, TX
27 days ago

Trending Jobs

company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, TX
about 2 months ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, NM
26 days ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, TX
2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, TX
about 1 month ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, LA
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, TX
3 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, TX
over 1 year ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, OK
3 months ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, TX
3 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, PA
5 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, TX
2 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Midland, TX
4 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, PA
5 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, TX
6 months ago
company-logo

Civil/Structural Designer

Dudley Staffing
Job TypeFull-time
Salary
$30 - $60
Canonsburg, PA
5 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Cheyenne, WY
4 months ago
company-logo

E & I - Office/Field Administration

Surepoint Group
Job Typefull_time
 
Grande Prairie, AB
29 days ago
company-logo

Mechanical/Piping Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Senior Division Order Analyst

Formentera
Job TypeFull-time
Salary
$110000 - $130000
Austin, TX
about 1 year ago

Notice: The inclusion of job postings or company information on our platform does not imply endorsement, partnership, or affiliation. Listings may include publicly available roles from various sources, and companies shown may not have a direct relationship with Energy Hire.