Enterprise Database Administrator

3 weeks ago


Vaughan, Canada Alectra Utilities Full time

The Opportunity
- Job Posting Number:
**_2023-054_**
- Position:_

**_Enterprise Database Administrator_**
- Location:_

**_Vaughan (Cityview) (Hybrid: Remote/In-office)_**

**_Reports to:_**

**_Manager, IT Operations_**
- Business Unit:_

**_Digital Innovation & Information Technology_**
- Division:_

**_IT Operations_**
- Hours per Week:_

**_35_**
- Rate of Pay:_
- Number of Openings:_

**_1_**
- Union:_

**_No_**
- Open:_

**_February 21, 2023_**
- Close:_

**_March 6, 2023_**
- Alectra is committed to putting our people first in providing a positive employee experience and a safe work environment. Our Hybrid Workplace policy allows for an effective balance for employees with the opportunity to work in a hybrid environment; a combination of Remote / In-office work based on operational requirements._

**Position Purpose**:
**Responsibilities**:

- Develops and enforces data base standards, policies and procedures
- Collaborate with cross-functional teams to understand business requirements and translate them into logical and physical data models
- Provides technical expertise in the planning, design and implementation of projects and key initiatives
- Extract, load and merge data from multiple sources
- Monitor databases and server health, growth, and proactively manage enterprise data systems toward 100% uptime
- Develop of strategic performance dashboards and reports using SSIS, SSRS and SSAS.
- Document all operational processes and procedures to optimize support and management of deployed systems
- Collaborate with cross-functional teams to understand business requirements and translate them into logical and physical data models
- Proactively monitor vendor end of support/life for implemented databases, develop plans for database upgrades and/or replacements, and execute database upgrades/replacements with the broader IT team
- Ensures compliance to legislative, regulatory and Health & Safety policies, procedures and standards
- Performs other duties as assigned
- Follows all established procedures, including on call support, as required Use backup and recovery best practices to ensure systems are protected from data loss in compliance with established business continuity and DR practices
- Administer SQL database user access, roles and permissions

**Education & Specialized Knowledge**:

- University degree in computer science or related field
- Microsoft Certified Solutions Associate (MSCA) SQL 2016
- Microsoft Certified Solutions Expert (MCSE) Data Platform or Business Intelligence would be an asset
- Must hold and maintain a valid class “G” driver’s license
- _Advanced technical knowledge with MS-SQL Server 2016 or higher._
- _Advance technical knowledge of MS-SQL Server Business Intelligence tools_
- Knowledge of SSIS, SSMS, and SSRS would be an asset
- Knowledge of Oracle Database technologies would be an asset
- Experience with MS-SQL virtualization and Azure cloud database technologies

**Experience**:

- 5 or more years’ experience in database development and support in Microsoft enterprise SQL environment
- Production environment experience in data extraction, transformation and loading, exporting and importing data, data conversion and migration, creating database objects, performance tuning, analyzing SQL code, debugging performance problems
- Experience in a unionized utility environment an asset

**Skills/Abilities/Competencies**:

- Solid problem-solving and analytical skills with excellent attention to detail and the ability to provide practical and/or innovative solutions to complex technical issues
- Strong written and presentation skills, with the ability to explain technical information in an organized and concise way
- Ability to plan, prioritize and execute multiple projects and initiatives within established timelines
- Ability to build and maintain collaborative working relationships with internal and external stakeholders

How to Apply

If you would like to be considered for this position and meet the qualifications, please submit your resume by clicking on the button below.

You can also submit a resume for us to keep on file and review as new opportunities arise that might be the right fit for your skills and experience.

We thank all applicants for their interest in a career with Alectra. Only those selected for an interview will be contacted.



  • Vaughan, Canada GFL Environmental Inc. Full time

    GFL Environmental is looking for a Database Administrator to join our team in Vaughan, ON. The Database Administrator will support MS SQL database management activities including improving database quality and scripts. Developing and deploying DB scripts for data quality, stability, and security systems to support maintenance activities that meet or exceed...


  • Vaughan, Canada CAA Club Group Full time

    Position Details What you will do: Interact with Data Centre Operations/Systems Administration/ Application Support teams to ensure the proper design and deployment of databases. Assess and develop long-term strategic goals for production databases in conjunction with stakeholders Conduct research and make recommendations on database...

  • Database Analyst

    1 month ago


    Vaughan, Canada AG IT Consulting Full time

    One (1) Full-time permanent position in AG IT Consulting located at 9131 Keele Street Suit-A4, Vaughan (Concord), ON L4K 0G7. (Remote is also available) Job title - Database Analyst JOB RESPONSIBILITIES: - Collect and document user's requirements - Develop and maintain computer databases - Design and develop database - Design, construct, modify, implement...

  • database analyst

    1 month ago


    Vaughan, Canada AG IT Consulting Full time

    Education: Expérience: EducationCollege/CEGEPWork settingConsulting firmTasksDevelop and maintain computer databasesDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data...

  • database analyst

    1 month ago


    Vaughan, Canada AG IT Consulting Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsWork settingConsulting firmTasksDevelop and maintain computer databasesDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration...

  • analyst, database

    4 weeks ago


    Vaughan, Canada CUSTOMIZED 4 U INC. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for...

  • database analyst

    2 weeks ago


    Vaughan, Canada Conquer Infotech Inc. Full time

    Education: Expérience: EducationCollege/CEGEPTasksCollect data to identify areas for improvement within an organization's IT infrastructureDevelop and implement a strategic blueprint to follow when deploying databases within their organizationDevelop and maintain computer databasesDocument reporting needs, queries, logic, results and recommendations to...

  • database analyst

    7 days ago


    Vaughan, Canada Conquer Infotech Inc. Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsTasksCollect data to identify areas for improvement within an organization's IT infrastructureDevelop and implement a strategic blueprint to follow when deploying databases within their organizationDevelop and maintain computer databasesDocument reporting needs, queries, logic, results and...

  • analyst, database

    1 month ago


    Vaughan, Canada CUSTOMIZED 4 U INC. Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access...


  • Vaughan, Canada Mackenzie Health Full time

    Job Description Student – Enterprise Analytics Temporary Full Time (Approximately 4 months) (2) The Enterprise Data Office team is looking to hire a student to help with optimizing Enterprise Analytics workflows, including data & analytics governance artifact development and batch interface scripting. Students may be asked to support a...


  • Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...


  • Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...


  • Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...


  • Vaughan, Canada Weston Consulting Full time

    Over the last 40 years, Weston Consulting has become a leader in land use planning and urban design, serving the public and private sectors across Ontario. Due to our ongoing contribution to the built environment and our commitment to our clients, we are looking to grow our team through the addition of an Office Administrative Assistant. Core Values -...

  • EHS Administrator

    1 month ago


    Vaughan, Canada GFL Environmental Inc. Full time

    GFL Environmental is looking for a EHS Administrator to join our Waste Processing operations based out of the Toronto area! The Health, Safety & Compliance Administrator will perform health, safety, and compliance functions as assigned by management, such as manage corporate safety databases and safety communication. In this role, you will be responsible for...


  • Vaughan, Canada Maple Drywall Inc Full time

    **Job Summary**: We are currently seeking a dynamic individual for the role of Administrative/ Project Coordinator. The individual will report directly to the Director of the high-rise department. The Administrator is responsible for the organization and preparation of purchase orders, reviewing contracts, liaising between clients, foremen and internal...


  • Vaughan, Canada Hydro One Networks Inc Full time

    Job Function : Perform various office administrative duties and departmental records maintenance. Produce/process correspondence, databases and spreadsheets and other documents. Job Description: Support development and administration of various customer contracts/service agreements, including tracking of progress and updating/verification of...


  • Vaughan, Canada CAA Club Group Full time

    Position Details What You Will Do Meet with decision makers, systems owners and business users to define business and operations requirements and systems goals, and identify and resolve systems issues Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow Review...


  • Vaughan, Canada Ambient Mechanical Ltd Full time

    Servicing the GTA since 1982, we've grown from a family-run business into a team of over 100 certified HVAC and controls technicians, pipefitters, electricians, salespeople, in-house design engineers, and customer service representatives. Ambient Mechanical is committed to providing exceptional heating and cooling, ventilation, preventative HVAC maintenance,...


  • Vaughan, Canada GG FREIGHT SERVICES INC. Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsTasksDetermine and establish office procedures and routinesManage contractsAnswer telephone and relay telephone calls and messagesAnswer electronic enquiriesCompile data, statistics and other informationAdvise senior managementOversee payroll administrationArrange travel, related itineraries and...