Data Base Developer Intern

2 weeks ago


Canada People Tech Group Inc Full time

Position Overview

We are seeking enthusiastic and motivated interns with experience in database concepts and cloud platforms. In this role, interns will receive training in advanced database tasks and cloud migration techniques, gaining valuable experience with tools like AWS SCT, DMS, and Ora2Pg. This is a unique opportunity to work in a fast-paced environment.

Responsibilities

  • Develop and enhance your skills in Oracle SQL and PL/SQL through real-world projects.
  • Engage in PostgreSQL database development, administration activities, including configurations, tuning, and performance monitoring.
  • Assist with day-to-day DBA tasks such as backups, recovery, and routine database maintenance.
  • Gain hands-on training in AWS Cloud Services, focusing on database and cloud migration aspects.
  • Work with AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) for database migration from Oracle to PostgreSQL.
  • Learn to utilize Ora2Pg or any other tools for migrating and converting Oracle databases to PostgreSQL.
  • Work in cloud migration and modernization projects, gaining exposure to advanced data transformation and modernization practices.
  • Collaborate on migration projects involving on-premises and cloud database systems, with exposure to CDC (Change Data Capture) and minimizing migration downtime.
  • Contribute to a dynamic team environment by demonstrating a proactive approach to problem-solving and learning.

Prerequisites

To qualify for this internship, candidates should meet the following criteria:

  • Proficient in writing and understanding Oracle SQL queries, procedures, and PL/SQL
  • Familiarity with cloud concepts and platforms (such as AWS, Azure, or GCP) and an understanding of basic cloud architecture and services
  • Solid understanding of database concepts, including relational databases, schema design, indexing, and data integrity
  • Strong verbal and written communication skills to convey ideas and work effectively within a team
  • Good analytical skills for data interpretation and problem analysis
  • Demonstrated capacity to approach challenges methodically and find innovative solutions
  • Basic understanding of the software development lifecycle and the general structure of the tech industry
  • Ability to quickly learn new tools, techniques, and concepts, especially in a high-paced, dynamic setting
  • Certification in any cloud technology is preferred


Learning Opportunities

  • Develop advanced SQL and PL/SQL skills, including building complex queries, administration, optimizing performance, and understanding query execution
  • Gain familiarity with PostgreSQL development, administration, performance tuning, and troubleshooting
  • Learn about core AWS services, with a focus on database migration and cloud-based data handling
  • Receive practical training on AWS SCT, AWS DMS, and Ora2Pg, essential for Oracle to PostgreSQL migration
  • Participate in end-to-end database migration projects, focusing on high availability, minimal downtime, and data integrity

Why Join Us?

  • A structured training program with comprehensive learning modules and resources designed to enhance your skills in SQL, PL/SQL, PostgreSQL, AWS, and database/cloud migration tools
  • Real-world projects that allow you to apply your learning and gain practical experience that enhances your technical skills
  • Mentorship from seasoned professionals who will guide your journey and provide valuable feedback for growth
  • Potential future employment based on performance and business needs, with opportunities for a career path in database and cloud technologies



  • Canada People Tech Group Inc Full time

    Position Overview We are seeking enthusiastic and motivated interns with experience in database concepts and cloud platforms. In this role, interns will receive training in advanced database tasks and cloud migration techniques, gaining valuable experience with tools like AWS SCT, DMS, and Ora2Pg. This is a unique opportunity to work in a fast-paced...


  • Canada, CA People Tech Group Inc Full time

    Position OverviewWe are seeking enthusiastic and motivated interns with experience in database concepts and cloud platforms. In this role, interns will receive training in advanced database tasks and cloud migration techniques, gaining valuable experience with tools like AWS SCT, DMS, and Ora2Pg. This is a unique opportunity to work in a fast-paced...


  • Canada People Tech Group Inc Full time

    At People Tech Group Inc, we are looking for a talented Data Structure Developer to join our team. The successful candidate will have the opportunity to work on developing skills needed to effectively solve problems and implement data structures.This role is perfect for beginners or those looking to solidify their understanding of the fundamentals. Our...

  • Ruby Developer

    7 days ago


    Canada Quantum Technology Recruiting Inc. Full time

    Ruby on Rails Developer Opportunity at Quantum Technology Recruiting Inc.We are seeking an experienced Ruby on Rails developer to join our dynamic team at Quantum Technology Recruiting Inc. The ideal candidate will have a strong background in Ruby on Rails development and experience with React and Go.About the Role:This is a 6-month contract position with...


  • Canada SP Data Digital Full time

    We are a forward-thinking organization at SP Data Digital, where innovation and entrepreneurial spirit thrive. Our team is comprised of dynamic individuals who challenge the status quo and drive results through creative problem-solving.We provide exceptional customer service to our partners, supporting some of the industry's leading companies in telecom,...


  • Canada Ionik Full time

    Job OverviewIonik, a leading technology company listed on the TSX Venture Exchange and OTCQX Best Market, offers a comprehensive suite of advertising, marketing, and monetization solutions for brands, advertisers, and publishers. Our cutting-edge digital technology businesses provide cross-platform, performance-driven advertising and data solutions to...


  • Canada Aylo Careers Full time

    Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet's safest and most popular platforms. With the support of an international team of dynamic and collaborative innovators, we are on a mission to enable safe user experiences and empower our communities by celebrating diversity, inclusion, and...

  • ERP Data Analyst

    6 months ago


    Canada WUSC EUMC Full time

    **POSITION TITLE** ERP Data Analyst **POSITION LOCATION** Ottawa preferred, Remote (Canada) available **REPORTS TO** Chief Financial Officer **CONTRACT TERM** Indeterminate **SALARY** 77k - 87k **APPLICATION DEADLINE** **LANGUAGE REQUIRED** Fluency in English is required, French an asset **Are you a data-oriented professional with ERP...


  • Canada Refonte Learning Full time

    Unlock Your Potential with Refonte Learning's AI and Data Science Study and Internship ProgramAre you a tech enthusiast looking to kickstart your career in AI and Data Science? Look no further than Refonte Learning's prestigious AI & Data Science Study and Internship Program. As an intern, you'll gain hands-on experience in the latest technologies: AI, Data...


  • Canada NTT DATA North America Full time

    SAP FI/CO Functional Lead with Data MigrationOur SAP Implementation FICO Functional Consultant will lead others through the implementation of SAP. Duties include but may not be limited to:Ability to lead business workshops for blueprinting activitiesAnalyzing legacy data, quality check of submitted load files, testing load quality, leading user testing and...


  • Canada NUMERATOR LIMITED Full time

    About the Role:As a key member of our team, you will play a vital part in driving decision-making and finding bigger opportunities at Numerator Limited. We are looking for an exceptional Data Engineer and Platform Developer to help us deliver data products, analytics, and models quickly and independently.We believe tomorrow's success starts with today's...


  • Canada NTT DATA North America Full time

    SAP FI/CO Functional Lead with Data MigrationOur SAP Implementation FICO Functional Consultant will lead others through the implementation of SAP. Duties include but may not be limited to:Ability to lead business workshops for blueprinting activitiesAnalyzing legacy data, quality check of submitted load files, testing load quality, leading user testing and...


  • Canada NTT DATA North America Full time

    SAP FI/CO Functional Lead with Data MigrationOur SAP Implementation FICO Functional Consultant will lead others through the implementation of SAP. Duties include but may not be limited to:Ability to lead business workshops for blueprinting activitiesAnalyzing legacy data, quality check of submitted load files, testing load quality, leading user testing and...


  • Canada, CA NTT DATA North America Full time

    SAP FI/CO Functional Lead with Data MigrationOur SAP Implementation FICO Functional Consultant will lead others through the implementation of SAP. Duties include but may not be limited to:Ability to lead business workshops for blueprinting activitiesAnalyzing legacy data, quality check of submitted load files, testing load quality, leading user testing and...


  • Canada NTT DATA North America Full time

    SAP FICO Functional Lead Role OverviewThis is an exciting opportunity to lead the implementation of SAP FI/CO in a prestigious organization. As an experienced SAP Finance Implementation specialist, you will be responsible for leading business workshops, analyzing legacy data, and ensuring the successful migration of financial data.Key...


  • Canada Tata Consultancy Services Full time

    About the RoleAs a Big Data Developer at Tata Consultancy Services, you will be responsible for designing high-quality deliverables that meet business requirements. You will work with a team to develop and maintain scalable, high-performance data transformation applications using Apache Spark framework.You will need to integrate code adhering to CI/CD...


  • Canada NTT DATA North America Full time

    At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company’s growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring, the best people and helping them grow both professionally and personally, we...


  • Canada NTT DATA North America Full time

    At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company’s growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring, the best people and helping them grow both professionally and personally, we...


  • Canada, CA Motion Recruitment Full time

    One of North America's leading financial technology firms is seeking a Data Migration Specialist to support a critical project ensuring seamless transitions for sellers across payment processing platforms. This role offers a 100% remote schedule, providing the flexibility to collaborate with cross-functional teams while driving impactful solutions for...


  • Canada ICON Full time

    ICON plc is a world-leading healthcare intelligence and clinical research organization. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotechnology, medical device and government and public health organizations. With our patients at the center of all that we do, we help to accelerate the development...