Jobs
>
Toronto

    Database Analyst - Toronto, Canada - Akkodis

    Akkodis
    Akkodis Toronto, Canada

    1 week ago

    Default job background
    Accounting / Finance
    Description

    Sr NoSQL Database Analyst

    About the Role

    The candidate will be a member of a team within Data Management Services (DMS) called Alternative Database Technologies. Alternative Database Technologies is responsible for database infrastructure architecture and operation support to teams using various cloud based and on-premise database platforms. The successful candidate will have a passion for database related technologies and will need to be able to pick up, understand and become proficient in a wide range of software products in a short period of time. This is an opportunity for someone who is an expert in MongoDB to also work with multiple database platforms and architectures; NoSQL and SQL, OLTP, and OLAP. A minimum 5 year of experience in Information Technology is required as well as experience in non-relational database technologies or AWS database services, such as MongoDB, Redshift, DynamoDB, DocumentDB and Time series.

    This role requires security clearance which can only be obtain with a minimum five consecutive years of residency in Canada.

    What will you do?


    • Key Responsibilities include Provision MongoDB instances; Ensure performance, security, and availability of databases; Configure encryption at rest and in transit; Prepare documentations and specifications; Handle common database procedures, such as upgrade, backup, recovery, migration, etc.; Collaborate with other team members and stakeholders; Perform upgrades to MongoDB environments; Automate repeatable installation and maintenance tasks.


    • Manage medium to large size infrastructure projects, such as MongoDB7.0 upgrade, MongoDB Atlas migration or etc.


    • Participate in projects throughout the entire project lifecycle, and define, manage, and track project deliverables using defined technologies.


    • Maintain up-to-date documentation and procedures for MongoDB and other supported database platforms.


    • Keep up to date on current and upcoming technology innovations for use within Sunlife.


    • Sound knowledge of DevSecOps and database automation and scripting (e.g. AWS CDK, Github Action, Ansible, shell scripting, python, SQL).


    • Support project development following documented standards, policies, and procedures (Change Management Process).


    • Work closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services.


    • Define, document and implement consistent standards and procedures.


    • Evaluate functionality and features within related database products.


    • Contribute ideas for best practice improvements, process improvement, and innovative solutions.

    What experience and skills should you have?


    • University degree in Computer Science or related information technology degree/diploma.


    • 5+ years advanced administration experience in MongoDB.


    • 5+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.).


    • In depth Analytical and problem-solving skills.


    • Understanding of the MongoDB query and command functionality, e.g. CRUD operations, Aggregation framework, etc.


    • Experience/familiarity with the operations and maintenance of production database systems.


    • Understanding of schema design (relational and MongoDB), index design, operation optimization, query (or explain) plans.


    • Experience with identifying and correcting slow operations, using log analysis (experience using mtools a plus).


    • Understanding of interpreting Ops manager / Cloud Manager operation metrics.


    • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.


    • Expertise in snapshot, import/export, db optimization with the help of explain plan.


    • Expert of Object oriented programming in order to write robust and re-usable code.


    • Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.


    • Expert of writing shell scripting, Perl script for Linux/Unix.


    • Ability to lead technical discussions and self manage workloads


    • Excellent interpersonal, communication skills, organizational skills with the ability to multitask.

    What would you be nice to have:


    • A certification of MongoDB certified DBA or developer.


    • Knowledge or experience of Mongo Atlas or MongoDB Ops Manager.


    • A developer background or experience working with development teams.


    • Experiences in any of the NoSQL (DynamoDB, Neptune or other), Redshift, MySQL, Oracle, Sybase or SQL Server.


    • Understanding or experience working with Cloudwatch, Cloudtrail, AWS Config, AWS Backup and/or AWS DMS.


    • Cloudformation, Glue and/or Lambda scripting experience.


    • Python scripting.


    • Understanding or experience with DevOps or Agile methodologies.


    • Experience with Security Architecture(s).


    • Knowledge of database backup and recovery strategies (including DR strategies).


    • Experience working in the AWS cloud environment is a nice to have.

  • R.E. ROYAL TRADING INC.

    database analyst

    5 days ago

    R.E. ROYAL TRADING INC. Vaughan, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Operate database management systems to analyze data · Collect and document user's requirements · Work conditions and physical capabilities · Fast-paced environment · Work under pressure ...

  • Secure Digital Markets

    Database Analyst

    4 days ago

    Secure Digital Markets Toronto, Canada

    Salary: · **What We Offer** · At Secure Digital Markets (SDM), you can build a career out of making things happen Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada' ...

  • Secure Digital Markets

    Database Analyst

    1 day ago

    Secure Digital Markets Toronto, Canada

    **What We Offer** · At Secure Digital Markets (SDM), you can build a career out of making things happen Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada's largest ...

  • Dawn InfoTek Inc.

    Database Analyst

    1 week ago

    Dawn InfoTek Inc. Toronto, Canada

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. · We a ...

  • Unisystech Consulting inc.

    Database Analyst

    1 week ago

    Unisystech Consulting inc. Toronto, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 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 ma ...

  • ShyftLabs

    Database Analyst

    7 hours ago

    ShyftLabs Toronto, Canada

    Education: Master's degree · - Experience: 3 years to less than 5 years · - or equivalent experience · **Screening questions**: · - Are you available for the advertised start date? · - Are you willing to relocate for this position? · - Do you have previous experience in this fiel ...

  • CanPacific College of Business & English

    Database Analyst

    6 days ago

    CanPacific College of Business & English Toronto, Canada

    Education: Bachelor's degree · - Experience: 7 months to less than 1 year · - or equivalent experience · **Work setting**: · - School or educational institution/establishment · **Tasks**: · - Design, construct, modify, implement and test data models and database management system ...

  • Flyinger Solutions Ltd.

    Database Analyst

    1 week ago

    Flyinger Solutions Ltd. Toronto, Canada

    Education: Bachelor's degree · - 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 m ...

  • Property Realty Inc.

    Database Analyst

    3 days ago

    Property Realty Inc. Toronto, Canada

    Education: College/CEGEP · - Experience: 2 years to less than 3 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 · - Opera ...

  • VRIZE CANADA INC.

    Database Analyst

    6 days ago

    VRIZE CANADA INC. Toronto, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 35 hours per week · - Education: Bachelor's degree · - Experience: 3 years to less than 5 years · **Work setting**: · - Consulting firm · **Tasks**: · - Collect and document user's requirements · - Design and develop data ...

  • Ronald McDonald House Charities Toronto

    Donor Database Analyst

    1 day ago

    Ronald McDonald House Charities Toronto Toronto, Canada

    **Donor Database Analyst** · **Full Time, Permanent** · Toronto, Ontario (240 McCaul Street) · **The Organization** · Since 1981, Ronald McDonald House Charities (RMHC) Toronto has served as a place to call home for families with seriously ill children undergoing treatment. RMHC ...

  • Nuclear Waste Management Organization (NWMO)

    Geoscience Database Analyst

    6 days ago

    Nuclear Waste Management Organization (NWMO) Toronto, Canada

    **Location** · Toronto · **Employment Category** · Fixed Term · **Department** · Geoscience · **Job Reference** · 10208 · The Nuclear Waste Management Organization (NWMO) is a not-for-profit organization tasked with the safe, long-term management of Canada's used nuclear fuel ins ...

  • Ontario Energy Board

    Analyst, Reporting and Database

    1 week ago

    Ontario Energy Board Toronto, Canada

    Overview: · This Division is responsible for all aspects of corporate financial management and reporting, information technology strategies and plans as well as other organizational service functions including procurement, risk management, internal audit, emergency/contingency pl ...

  • Delbridge Solutions Inc.

    Database Analyst

    1 week ago

    Delbridge Solutions Inc. Concord, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 30 hours per week · - Education: College/CEGEP · - Experience: 1 year to less than 2 years · **Work setting**: · - Consulting firm · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and ...

  • Finartech Inc.

    Database Analyst

    5 days ago

    Finartech Inc. Concord, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 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 ma ...

  • Green Bee 3

    Database Analyst

    6 days ago

    Green Bee 3 Vaughan, Canada

    **Database Analyst** · Green Bee 3 Concord, ON · Green Bee 3 has pioneered IT services in the GTA for over 25 years, consistently delivering business value with the latest technology. · **OUR MISSION** · Building on our technologies and competencies creating value for our custome ...

  • Canlan Sports

    Database Analyst

    1 week ago

    Canlan Sports North York, Canada

    Canlan Sports is the largest private sector owner and operator of recreational sports complexes in North America. The company's success in the recreation-entertainment & hospitality industry is attributed to a combination of innovative programming, service delivery leadership and ...

  • STLTH

    Analyst, Database

    2 days ago

    STLTH Scarborough, Canada

    Education: College/CEGEP · - Experience: 1 year to less than 2 years · - or equivalent experience · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database ...

  • WS & Company Ltd.

    Database Analyst

    7 hours ago

    WS & Company Ltd. Scarborough, Canada

    Education: College/CEGEP · - Experience: 7 months to less than 1 year · - or equivalent experience · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management syste ...

  • STLTH

    Analyst, Database

    1 week ago

    STLTH Scarborough, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · - or equivalent experience · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and datab ...