System Analyst, Oracle & SQL Developer

About Us

Brookfield Renewable is one of the core businesses under Brookfield Corporation (Brookfield) one of the worlds leading alternative asset managers. Brookfield Renewable is one of the worlds largest owners operators and developers of renewable power with $102 billion of power assets under management. Our portfolio of hydropower wind utility-scale solar distributed generation and storage assets extends across North America South America Europe India and China totaling almost 33000 megawatts of capacity and over 7000 generating facilities globally.

Come Join Us

At Brookfield Renewable we attract and retain high-performing individuals who are interested in making an impact driving meaningful change and being part of a fast-paced and collaborative environment. Join a purpose driven winning team committed to results in an inclusive and high-performing culture. Together we contribute to the success of one of the fastest growing and largest publicly traded pure play renewable power platforms in the world while supporting decarbonization and greater energy sustainability to facilitate the global transition to a net-zero.

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 - must be able to undertake and manage multiple tasks at the same time and work 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 (5years) with Oracle PL/SQL and SQL Server T-SQL
• Advanced knowledge 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 the principles of database design
• C# development experience are considered a valuable asset
• ETL is an asset
• UI / UX experience is an asset.

Note: Offices continue to be central to collaboration and Brookfields 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.

• We work to recognize you in meaningful personalized ways including a competitive salary bonus structure a health benefits program and defined contribution pension plan.
• Our spaces are open dynamic and collaborative giving you access to different businesses and teams. For your wellbeing our building is equipped with a modern gym bike storage and healthy snacks and drinks.
• We cultivate a culture where we invest 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.

Required Experience:

IC