System Analyst, Oracle & SQL Developer

Brookfield Renewable Partners L.P.; Gatineau; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading renewable energy provider in Gatineau is seeking a System Analyst-Oracle & SQL Developer to enhance their database capabilities. The role involves maintaining and deploying database code, responding to incidents, and working collaboratively with teams. Applicants should have significant experience with Oracle PL/SQL and SQL Server T-SQL. This on-site position emphasizes a strong commitment to diversity and employee growth.

Benefits

Competitive salary

Health benefits program

Defined contribution pension plan

Access to gym and healthy snacks

Qualifications

• 5+ years of experience with Oracle PL/SQL and SQL Server T-SQL.
• Ability to work under tight deadlines and handle multiple tasks.
• Familiarity with data manipulation languages and database design principles.

Responsibilities

• Maintain, develop, and deploy database code and objects.
• Respond to production incidents and support requests.
• Design and deploy data objects including tables and stored procedures.

Skills

Analytical skills

Critical thinking

Communication skills

Time management

Collaboration

Education

University or College Degree in Computer Science/Technology

Tools

Oracle PL/SQL

SQL Server T-SQL

C#

.NET development

Job description

National Capital Region
National Capital Region
41 Rue Victoria
Gatineau, QC J8X 2A1, CAN

Brookfield Renewable is one of the core businesses under Brookfield Corporation ("Brookfield"). Brookfield Renewable is one of the world’s largest owners, operators, and developers of renewable power, with $102 billion of power assets under management. Our portfolio spans hydropower, wind, utility-scale solar, distributed generation, and storage assets across North America, South America, Europe, India, and China, totaling almost 33,000 megawatts of capacity and over 7,000 generating facilities globally.

About the Role

Reporting to the Technology Services Manager, the System Analyst-Oracle & SQL Developer will be a member of the Technology Services team. The System Analyst-Oracle & SQL Developer will be responsible for maintaining, developing, and deploying database code and objects on Oracle and SQL Server platforms.

Key Responsibilities

• Respond to production incidents and support requests.
• Write complex SQL code to query data, fix bugs and implement enhancements.
• Design and deploy various data objects including tables, views, indexes, stored procedures (T-SQL and PL/SQL).
• Plan and coordinate data migrations between systems.
• Diagnose and resolve access and performance issues.
• Create and maintain technical documentation.
• Work within the support process standards (and improve when required).
• Provide periodic on-call support (24/7).
• SOX evidence reporting for databases.

Knowledge and Experience Required

• Strong analytical skills and critical thinking.
• Ability to work in a fast-paced environment.
• Strong planning, prioritizing and time management skills; able to undertake and manage multiple tasks under tight deadlines and operational pressures.
• Ability to collaborate professionally with other teams.
• Excellent communication skills (verbal and written).
• University or College Degree in Computer Science/Technology or equivalent.
• Advanced knowledge in database coding (T-SQL & PL/SQL).
• Demonstrated technical skills (5+ years) with Oracle PL/SQL and SQL Server T-SQL.
• Advanced knowledge and experience in root cause analysis and providing workarounds and solutions for DB code.
• Good working knowledge of formal change-management processes.
• Familiarity with the main data manipulation languages and principles of database design.
• C# and .NET development experience is a valuable asset.
• ETL is an asset.
• UI/UX experience is an asset.

Note: Offices continue to be central to collaboration and Brookfield’s identity. This position requires the employee to be on-site for a minimum of 4 days to perform most effectively.

Working here, you will enjoy

At Brookfield, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential.

• Competitive salary, bonus structure, health benefits program, and defined contribution pension plan.
• Open, dynamic, and collaborative spaces with access to different businesses and teams; building amenities include a modern gym, bike storage, and healthy snacks and drinks for wellbeing.
• Culture that invests in your growth and development.

Diversity & Inclusion

Brookfield Renewable embraces and promotes the principles of diversity, equity, and inclusion. We welcome and encourage applications from all qualified candidates, including women, Indigenous peoples and other persons of all races, ethnic origins, religions, abilities, sexual orientations, and gender identities and expressions. We also provide accommodation during all parts of the hiring process, upon request. If contacted to proceed to the recruitment process, please advise us if you require any accommodation.