System Analyst, Oracle & SQL Developer

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

Job summary

A leading renewable energy company in Gatineau is seeking an experienced System Analyst-Oracle & SQL Developer to maintain and develop database code. The role requires strong analytical skills, communication, and at least 5 years in Oracle PL/SQL and SQL Server T-SQL. The ideal candidate will work on-site to support various data tasks and will enjoy competitive salary and benefits.

Benefits

Competitive salary

Health benefits program

Defined contribution pension plan

Access to modern gym and building amenities

Qualifications

• 5+ years of experience with Oracle PL/SQL and SQL Server T-SQL.
• Advanced knowledge in database coding (T-SQL & PL/SQL).
• Ability to work in a fast-paced environment.

Responsibilities

• Respond to production incidents and support requests.
• Write complex SQL code to query data and fix bugs.
• Design and deploy various data objects including tables and stored procedures.

Skills

Analytical skills

Communication skills

Time management

Collaboration

Education

University or College Degree in Computer Science / Technology or equivalent

Tools

Oracle PL/SQL

SQL Server T-SQL

C#

.NET

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.

J-18808-Ljbffr