Reporting to the Manager, Infrastructure Operations, the Technical Consultant, implements processes, systems and projects that contribute to the efficient technical delivery of maintenance and improvement of Toronto Hydro's Database infrastructure.
The incumbent is expected to behave ethically and follow the established code of business conduct, policies and internal control procedures, laws and regulations governing Toronto Hydro.
KEY RESPONSIBILITIES:
- "Hands-on" database management, performance tuning, capacity planning, troubleshooting, monitoring, and Disaster Recovery of Oracle 12c & 19c
- Migrates and upgrades existing databases
- Troubleshoots (diagnose & resolve) production issues
- Installs and configures new databases
- Provides after hours database support (i.e. On-call support)
- Creates, maintains and tests disaster recovery plans
- Routinely applies latest security patches, completes health checks along with other preventative measures
- Documents Standard Operational Procedures (SOPs)
- Ensures compliance with all appropriate architecture and security standards
REQUIREMENTS:
-
Undergraduate degree or College diploma in Computer Science, Information Technology or related discipline.
-
Minimum seven (7) years progressive experience in Database Administration.
-
Mandatory experience with the following:
- Oracle database administration on Unix (AIX preferred)
- Performance tuning and debugging
- RMAN, Grid Control, and ASM
- Setting up and maintaining Physical/Logical DataGuard
- Monitoring and alerting tools such as OEM 19c
- Strong communication skills: Ability to verbally communicate technical information to a wide range of audiences, including technical staff and senior management; Technical writing skills for documenting operational support guides and Buildbooks
- Analyze and Solve Problems: Gathers relevant information systematically; considers a broad range of issues or factors; grasps complexities and perceives relationships among problems or issues
- Make Sound Decisions: Makes timely and sound decisions; makes decisions under conditions of uncertainty; evaluates short- and long-term consequences.
- Innovative: Generates and champions new ideas and initiatives; goes beyond the status quo; evaluates new or modified approaches and ideas with an open mind; brings perspectives and approaches together, combining them in creative ways.
- Manage Small upgrade Projects: Manages client expectations; keeps others informed about projects; performs impact analysis; adjusts plans to respond to changing business priorities; monitors projects and takes appropriate action when goals are not being met; follows up with clients to make sure that results meet or exceed expectations.
- Work Collaboratively: Willingly shares information; facilitates the discussion and resolution of different views; leverages areas of agreement to gain consensus; shares credit with others; promotes teamwork among groups; discourages "we vs. they" thinking; works for best solution rather than own solution; maintains optimism in complex or challenging situations; expresses disagreement tactfully and sensitively.
- Demonstrate Drive and Commitment: Strives to attain results; conveys a sense of urgency and drives issues to closure; persists despite obstacles and opposition; sets high standards of performance; pursues challenging goals and works hard to achieve them.
- Use Technical/Functional Expertise: Possesses up-to-date knowledge in the profession and industry; is regarded as an expert in the technical/functional area; accesses and uses other expert resources when appropriate.
Toronto Hydro Corporation
14 Carlton Street
Toronto
Ontario Canada
www.torontohydro.com/
