Database and Modelling Lead

6 months ago

Toronto, Canada TRC Companies, Inc. Full time

About Us:
Groundbreaker. Game changer. Pioneer.

TRC has long set the bar for clients who require more than just engineering, combining science with the latest technology to devise innovative solutions that stand the test of time. From pipelines to power plants, roadways to reservoirs, schoolyards to security solutions, clients look to TRC for breakthrough thinking backed by the innovative follow-through of an industry leader.

TRC's professionals work with a broad range of commercial, industrial and government clients and the communities they serve. We deliver breakthrough solutions that address local needs - so our clients can better succeed in an ever-changing world.

Working at TRC means tackling interesting, meaningful projects. We pride ourselves on our collaborative spirit, entrepreneurial zeal and agile corporate structure. We recognize that the expertise of our staff is our strongest asset, so we generously reward employees for successful performance and invest in their careers through training and the development of new skills and certifications.

Overview:
We are looking for a knowledgeable IT/OT Consultant to help our Utilities customer to convert, migrate, integrate, validate, and maintain the full database for their Transmission and Distribution control systems (SCADA/EMS/GMS/DMS/OMS). You’ll take the hassle out of providing strategic advice, solving technical problems, driving technical team and provide training to users to maximize the value of technology in business.

An IT/OT consultant must be knowledgeable and customer-oriented. Communication is everything for a consultant so we expect you to amaze us with your presentation skills. We’re further looking for superior technical expertise on SCADA, EMS, DMS, OMS, GIS and a problem-solving aptitude.

The Database and Modeling Lead will play a pivotal role in ensuring the successful delivery of the full database for the new system SCADA/EMS/GMS.

**Responsibilities**:

- Overseeing the full cycle of the database conversion activity from the legacy system to the new system
- Reviewing/defining the strategy to come-up with a fully working database for the new system
- Reviewing/defining/optimizing the process to make it robust, easily repeatable, and controllable.
- Reviewing/defining/managing the implementation of the tools necessary to export/import/consolidate/convert/validate the Database
- Managing the delivery of the services performed by the technology vendor.
- Define the database deployment process that fulfills Continuous Integration / Continuous Deployment principles
- Assist the customer leadership team with the management of SME’s performing the work.
- Support the Customer’s SMEs and Vendor’s SME in solving technical problems
- Advise the customer around any action to take to ensure that the data is maintainable across all sub-systems, and that it fulfills all functional and non-functional requirements
- Establishing Quality controls and KPIs to measure the progress of the full DB Delivery
- Working with the project manager providing clear and accurate project reporting
- Acting as a champion to foster a positive project work environment; and successfully lead the database track to accomplish all the project objectives
- Maintain practices and procedures that support enterprise service management, governance, and regulatory processes
- Collaborate with various departments and teams including Test, Operations, and IT

Qualifications:

- Requires a minimum of 10 years of experience related to Energy Management Systems/SCADA, data modeling, and operational support of real-time control systems
- Experienced in the implementation and maintenance of large-scale SCADA/EMS systems running on a major vendor platform
- Experience in converting legacy SCADA/EMS system databases to a new technology platform in an electric utility company
- Expert with at least one vendor platform database (OSI, GE, Schneider, Siemens, ABB )
- Strong organizational and time management skills to effectively manage multiple priorities and competing demands with tight timelines
- Strong verbal and written communication skills including the ability to clearly present information to various audiences in both formal and informal settings
- Strong customer service focus with the proven ability to develop and maintain effective relationships with team members and internal and external stakeholders which includes excellent communication, interpersonal and problem-solving skills
- Ability to deploy a structured approach to problem solving and work practices
- Familiarity with systems development methodologies, requirements analysis, system design and testing methods
- Requires a bachelor’s degree in IT, Engineering, Computer Science, related discipline, or equivalent experience

EEO Statement:
TRC is an equal opportunity employer: disability/veteran. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Salary Rang

  • Data Modeler

    6 months ago

    Toronto, Canada Tata Consultancy Services Full time

    **About TCS** TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and...

  • Data Modeler

    1 month ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Astra North Infoteck Inc.Job DescriptionData Modelera. Our ideal candidate will have expertise in Database Design and Oracle Exadata, with a strong grasp of complex SQL and PL/SQL, as well as DDL concepts.b. At Astra North Infoteck Inc., we seek a talented Database Design professional with experience in Oracle Exadata and complex SQL and PL/SQL, including...

  • Database Expert

    4 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job Title: Database ExpertWe are seeking a highly skilled Database Expert to join our team at iTek Innovative Solutions Inc.Company OverviewiTek Innovative Solutions Inc. is a leading provider of innovative solutions, and we are committed to excellence in all that we do.Job DescriptionThe successful candidate will be responsible for collecting data to...

  • Data Modeler

    6 months ago

    Toronto, Canada spruceinfotech Full time

    **Company Description** Spruce InfoTech is a leading information technology firm that provides varied services to help clients change manage and transform their businesses by means of high quality, innovative and cost effective solutions. We provide services to different companies from small scale level to even fortune 500 organizations and guide them in the...

  • Database Analyst

    6 months ago

    Toronto, Canada Peak Power Inc. Full time

    Education: Secondary (high) school graduation certificate - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data...

  • Database Architect

    18 hours ago

    Toronto, Canada Iris Software Inc. Full time

    About the RoleWe are seeking a highly skilled Database Architect to lead our Data Transformation Platform team at Iris Software Inc.Job OverviewThe successful candidate will have extensive experience in database development, with expertise in SQL tuning, database performance tuning, and best practices. Proficiency in multiple databases including SQL Server,...

  • Data Modeler

    2 weeks ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • Data Modeler

    2 weeks ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview: Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • Data Modeler

    2 weeks ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • Data Modeling Expert

    7 days ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the RoleWe are seeking a highly skilled Data Modeling Expert to join our team at Tata Consultancy Services. As a key member of our data modeling team, you will play a crucial role in designing and implementing effective data models that drive business growth and innovation.Key Responsibilities:Collaborate with business stakeholders, data owners, and...

  • Data Modeler

    4 weeks ago

    Toronto, Canada Botsford Associates Full time

    Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing) systems,...

  • Data Modeler

    2 weeks ago

    Toronto, Canada Atlantis IT group Full time

    **Role name: Data Modeller** **Location: Toronto, ON | Hybrid** **Durtion: 12 months of long term contract position** Role Description: a. Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL.b. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL Competencies: Data Concepts & Data Modelling Experience (Years):...

  • Data Modeler

    2 months ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the Role:Tata Consultancy Services is seeking a skilled Data Modeler to join our team. As a Data Modeler, you will be responsible for working with key business representatives, data owners, end users, application designers, and data architects to model current and new data.Key Responsibilities:- Design and implement effective data models using data...

  • Database Architect Lead for Ontario Public Service

    5 days ago

    Toronto, Ontario, Canada Ontario Public Service Full time

    **Job Overview**We are seeking a highly skilled Database Architect Lead to join our team at the Ontario Public Service. As a key member of our Operations, Maintenance & Support Branch (OMSB), you will lead a dynamic team to design, implement, and maintain Oracle databases in the Azure cloud.**About the Role**In this role, you will be responsible for...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    Job SummaryKDigitalLabs INC is seeking a skilled Database Systems Specialist to join our team. This role involves designing, developing, and implementing database management systems to analyze data.About the RoleWe are looking for an experienced professional with expertise in data administration policy, standards, and models. The successful candidate will...

  • Database Administrator

    6 months ago

    Toronto, Canada KDigitalLabs INC Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration...

  • Data Modeler

    3 weeks ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the Role:Data Modeler is a key position in Tata Consultancy Services, where you will work closely with business representatives, data owners, end users, application designers, and data architects to model current and new data.The ideal candidate will have expertise in data modeling techniques and methodologies, as well as strong experience in database...

  • Technical Lead

    1 day ago

    Toronto, Ontario, Ontario, Canada Iris Software Inc. Full time

    Iris's direct client, one of the Top 5 Bank in Canada, is looking to hire a Technical Lead for a long term opportunity at Toronto, ON (Hybrid Position).Our Client is a Canadian multinational financial services company and the largest bank in Canada by market capitalization. The bank serves over 17 million clients and has more than 89,000 employees...

  • Database Systems Engineer

    3 weeks ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    About the RoleKDigitalLabs INC is seeking an experienced Database Systems Engineer to join our team. As a key member of our technical staff, you will be responsible for designing and developing databases to meet the needs of our clients.ResponsibilitiesDesign and develop databases using industry-leading tools and technologiesCollaborate with cross-functional...

  • Database System Architect

    4 weeks ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    Job DescriptionWe are seeking a skilled Database System Architect to join our team at KDigitalLabs INC. In this role, you will be responsible for designing and developing database systems that meet the needs of our clients.About the JobThis is a permanent position with a salary range of $60,000 - $80,000 per year, depending on experience.Key...