Database Administrator

London Hydro, Inc.; London; Hybrid; CAD 60,000 - 100,000

Job description

If you are a motivated and proactive database administrator with strong critical thinking and analytical skills, this is an opportunity to make a meaningful impact.

The Database Administrator at London Hydro will play a key role in managing and enhancing corporate databases, ensuring performance, security, and reliability. This role requires expertise in database management, cloud-based solutions, and disaster recovery planning to support business operations.

The successful candidate will oversee database optimization, troubleshoot critical issues, and implement best practices for security and performance. Reporting to the Director of Information Systems, you will be instrumental in maintaining robust data infrastructure and supporting cross-functional teams with technical solutions.

WHAT YOU WILL DO

Database Management and Optimization

1. Install, configure, and maintain database management systems (DBMS) such as Oracle, HANA DB to ensure optimal functionality.
2. Set up and administer test databases for application testing, system support, and upgrades.
3. Support the design and implementation of database structures and architectures, including schemas, tables, indexes, and stored procedures.
4. Manage regular upgrades and oversee day-to-day database operations, maintaining data integrity and system efficiency.
5. Monitor and optimize database performance, tuning queries and configurations to improve response times and resource utilization.
6. Monitor and optimize the performance of cloud-based databases (such as AWS, Google Cloud platform) to ensure that they meet the organization’s requirements.
7. Troubleshoot and resolve database issues promptly, ensuring minimal disruption to operations.
8. Perform administrative functions for the various applications that use the databases (such as SAP HANA cockpit, Oracle Enterprise Manager), and hazards.
9. Support vendors and consultants during the installation of new applications and hardware.
10. Collaborate with cross-functional teams to gather and analyze requirements, providing technical solutions that meet business needs.

Data Security, Backup, and Disaster Recovery

1. Ensure database security by implementing access controls, encryption, and auditing measures, in consultation with the Senior DBA.
2. Develop, implement, and continuously maintain comprehensive backup and recovery procedures for all databases, ensuring high availability, robust backup solutions, and an effective Disaster Recovery Plan to safeguard data integrity and minimize downtime, in consultation with the Senior DBA.

Safety and Others

1. Adhere to all Occupational Health & Safety Act rules and regulations, the IHSA’s EUS rulebook, and London Hydro work practices. Report all injuries and near misses immediately. Perform all activities in a manner that protects the health and safety of yourself and others. Wear personal protective equipment as required. Understand and comply with London Hydro Health and Safety policies.
2. Perform other duties related to the above job purpose.

WHAT YOU WILL BRING

1. Bachelor’s degree in computer science, Software Engineering, or a related field from a recognized university, preferred.
2. Database management certifications would be an asset (Oracle Database Administration Certified Professional, Oracle Data Guard Administrator, or SAP Certified Associate - Database Administrator)
3. More than 5 years of hands-on experience with database management, utilization, and operating systems.
4. In-depth knowledge of SQL, PL/SQL, MySQL and SQL Script.
5. 3-5 years of experience of OEM.
6. Experienced with CommVault backup application.
7. Extensive knowledge of Oracle, SAP HANA dB.
8. Experience with table management techniques such as table partition, load/unload table into memory, and Native Storage Extension for enhanced performance.
9. Familiarity with NoSQL databases (e.g., MongoDB) and big data platforms is considered an asset.
10. Knowledge of database monitoring and performance tuning techniques.
11. Experience with SAP BODS is considered an asset.
12. Familiarity with database security practices (e.g., encryption, access control, auditing).
13. Strong analytical, problem-solving, and troubleshooting skills.
14. The position necessitates a high degree of confidentiality.
15. Excellent written and verbal communication skills.
16. Flexibility to adapt to changing project requirements and priorities.

WHY JOIN OUR TEAM

1. London Hydro has been recognized by Canada’s Top 100 Employers as one of Southwestern Ontario’s Top Employers for 2025. This recognition is a testament to our unwavering commitment to excellence and our dedication to fostering an environment where every team member can thrive.
2. Benefits and Compensation Package:
3. Competitive Vacation Entitlements
4. Recognition & Social Programs
5. Wellness and Family Assistance Program
6. On-site Cafeteria & Free Fitness Centre
7. Corporate Cellphone
8. Hybrid Work Arrangement
9. Positive, Collaborative, and Safety-Focused Culture
10. Want to learn more about what makes London Hydro a great place to work? Watch our short video or visit our website at www.londonhydro.com.

SOUNDS LIKE A GOOD FIT? HOW TO APPLY

We invite you to submit your cover letter and resume as a single document (in .pdf or .docx format only), saving the file as your last name and first name with no spaces (i.e., LastnameFirstname) to: Human Resources Department, London Hydro Inc., P.O. Box 2700, London, ON N6A 4H6. Fax: [phone]. E-mail (Database Administrator in the subject line and ensure that you attach your resume): [e-mail].

Deadline to Apply: April 4, 2025

While we appreciate all applications received, only those invited for an interview will be acknowledged. In accordance with Canadian immigration requirements, this advertisement is directed to applicants who are authorized to work in Canada. The successful candidate will be required to complete a Criminal Record and education check prior to the commencement of employment.

London Hydro is committed to fostering a corporate culture and climate that values and supports a diverse, equitable and inclusive organization. London Hydro is an equal-opportunity employer. Accommodation is available under the Human Rights Code and the Accessibility for Ontarians with Disabilities Act. Any personal information submitted will be managed in accordance with the requirements of the Municipal Freedom of Information and Protection of Privacy Act and will be used only to determine eligibility for employment. We recognize the importance of work-life balance. Currently, we offer a hybrid work arrangement (In-Office and Remote) in accordance with London Hydro policy. Please note remote work is not guaranteed in the future and is subject to change.