Database Analyst and IT System Administrator

2 weeks ago

Markham, Canada Bank of China(Canada) Full time

Overseeing database development and modification efforts.
- Designing and maintaining data systems and databases, includes fixing coding errors and other data-related problems.
- Mining and reorganizing data from primary and secondary sources in a functional manner.
- Maintaining data dictionary by revising and entering definitions.
- Using statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.
- Gathering, organizing and interpreting statistical data from the database to provide trends and prediction reports to Senior Management.
- Collecting and documenting user requirements; confirming project requirements by studying user requirements; Managing and resolving all customer queries; providing all data extraction techniques for various businesses.
- Analyzing results using statistical techniques and preparing ongoing reports.
- Designing and evaluating efficient backup recovery process for various databases.
- Protecting database by developing access system; specifying user level of access.
- Preparing reports, manuals and other documentation on the status, operation and maintenance of software.
- Application and server maintaining and supporting.
- Monitoring, troubleshooting and resolving system-related issues.
- Providing technical computer support and services to all staff as required in a timely manner.
- Perform other tasks as assigned.

**Requirements**:

- Bachelor's degree in Computer Science or relevant field.
- Prior experiences working with ETL and data migration are required.
- Must have strong Oracle PL/SQL programming skills.
- Strong knowledge of relational database design (Oracle, SQL Server, MySQL etc) and data management (e.g. permissions, recovery, security and monitoring).
- Technical expertise regarding data models, database design development, data mining.
- Experience with reporting packages and programming (Java, Python etc.)
- Ability to analyze existing tools and databases and provide software solution recommendations.
- Ability to understand front-end users’ requirements skills.
- Excellent verbal and written communication skills in English and Chinese.
- Excellent problem-solving, analytical and organizational skills.
- Proficient in Microsoft Office.
- Ability to work independently and as part of a team.

**Benefits**:

- Company events
- Dental care
- Extended health care
- On-site parking
- Paid time off
- Vision care

Schedule:

- Monday to Friday

Supplemental pay types:

- Overtime pay

**Experience**:

- ETL and data migration: 1 year (preferred)

**Language**:

- Mandarin (preferred)

  • Database analyst

    3 weeks ago

    Markham, Canada Innovyne Full time

    InnoVyne is a software consultancy that specializes in Integrated Performance Management that combines Sales Performance Management and Financial Planning, Analysis & Reporting into a unified view of the business. We partner with sales and financial organizations to address automation, efficiency and transparency challenges in their sales operations,...

  • Database analyst

    2 days ago

    Markham, Canada Innovyne Full time

    InnoVyne is a software consultancy that specializes in Integrated Performance Management that combines Sales Performance Management and Financial Planning, Analysis & Reporting into a unified view of the business. We partner with sales and financial organizations to address automation, efficiency and transparency challenges in their sales operations,...

  • Database analyst

    4 weeks ago

    Markham, Canada Innovyne Full time

    InnoVyne is a software consultancy that specializes in Integrated Performance Management that combines Sales Performance Management and Financial Planning, Analysis & Reporting into a unified view of the business. We partner with sales and financial organizations to address automation, efficiency and transparency challenges in their sales operations,...

  • Database analyst

    3 weeks ago

    Markham, Canada Innovyne Full time

    InnoVyne is a software consultancy that specializes in Integrated Performance Management that combines Sales Performance Management and Financial Planning, Analysis & Reporting into a unified view of the business. We partner with sales and financial organizations to address automation, efficiency and transparency challenges in their sales operations,...

  • Database Administrator

    4 weeks ago

    Markham, Canada Pet Valu Full time

    Location: Markham, Ontario **Job Description**: Job Overview A hands-on Database Administrator who thrives in a dynamic work environment. This role is responsible to provide 24/7 database support by working with other database service team members and cross-functional IT team members to ensure high security, high availability, high performance Pet Valu...

  • Database analyst

    4 weeks ago

    Markham, ON, Canada Innovyne Full time

    InnoVyne is a software consultancy that specializes in Integrated Performance Management that combines Sales Performance Management and Financial Planning, Analysis & Reporting into a unified view of the business. We partner with sales and financial organizations to address automation, efficiency and transparency challenges in their sales operations,...

  • Senior Database Administrator

    3 weeks ago

    Markham, Canada PET VALU Full time

    Description :Job Overview A hands-on Senior Database Administrator who thrives in a dynamic work environment. This role involves working with other database service team members, cross-functional IT and business team members to ensure high security, high availability, high performance Pet Valu databases, including but not limited to on-prime and cloud-based...

  • Database Administrator/Architect

    4 weeks ago

    Markham, Canada PeopleToGo Full time

    Job Title:         Database Administrator/Architect Location: Type:               Contract Our client is currently seeking an experienced Database Administrator/Architect to work out of their Toronto office.Role: As a member of the Enterprise Architecture team within Information Services, the Data Base Administrator/Architect is...

  • Database Services Manager

    3 weeks ago

    Markham, Canada PET VALU Full time

    Description :Job Overview A hands-on Manager Database Services who thrives in a dynamic work environment, this role involves leading a database service team, and working with cross-functional IT and business teams to ensure high security, high availability, high performance Pet Valu databases, including but not limited to on-prime and cloud-based SQL server,...

  • database analyst

    3 weeks ago

    Markham, Canada Starzlink Corporation Full time

    Education: College/CEGEPExperience: 7 months to less than 1 yearTasksOperate 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 and usage and...

  • database analyst

    3 weeks ago

    Markham, Canada Starzlink Corporation Full time

    Education: Expérience: EducationCollege/CEGEPTasksOperate 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 and usage and for the backup and...

  • Systems Analyst

    2 weeks ago

    Markham, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. (“Metergy”) As one of North America’s most experienced submetering providers, we’ve brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a...

  • Systems Analyst

    1 week ago

    Markham, Ontario, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. ("Metergy") As one of North America's most experienced submetering providers, we've brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a fleet of...

  • Systems Analyst

    2 weeks ago

    Markham, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. ("Metergy") As one of North America's most experienced submetering providers, we've brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a fleet of...

  • Systems Analyst

    2 weeks ago

    Markham, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. ("Metergy") As one of North America's most experienced submetering providers, we've brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a fleet of...

  • Systems Analyst

    2 weeks ago

    Markham, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. ("Metergy") As one of North America's most experienced submetering providers, we've brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a fleet of...

  • Systems Analyst

    2 weeks ago

    Markham, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. ("Metergy") As one of North America's most experienced submetering providers, we've brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a fleet of...

  • Manager, Database Operations

    6 days ago

    Markham, Canada BGIS Full time

    **Who We Are** BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over 320...

  • Routing Analyst

    6 days ago

    Markham, Canada Miller Waste System Full time

    MILLER WASTE SYSTEMS - Routing Analyst **Title**: Routing Analyst **Location**: Miller Waste Systems Inc. - Markham, Ontario **Reporting to**: Project Manager **Start Date**: ASAP **Description**: Miller Waste Systems Inc. has been in operation since 1961. Miller is a leader in waste management and diversion, providing governments and industries with a...

  • Systems Analyst

    3 weeks ago

    Markham, ON, Canada Metergy Solutions Inc Full time

    April 24, 2024 About Metergy Solutions Inc. (“Metergy”) As one of North America’s most experienced submetering providers, we’ve brought turnkey solutions to our clients for over 15 years. We help our customers effectively manage their utility consumption as we supply, install and remotely read electricity, water and thermal submeters across a...