Data Migration Specialist (Oracle, PostgreSQL, SQL)
YDC Pro
We are Hiring!!!
Data Migration Specialist
Hybrid – GTA West – Canada
Core Skills: Oracle, PostgreSQL, SQL, stored procedures, Java, and Python.
About YDC
Please email your word format resume to ***email_hidden***
YDC (YDCPro) is a North American based technology consulting and talent solutions firm with HQ in Toronto, Canada, helping organizations accelerate digital transformation. Since 2016, it has focused on artificial intelligence, data analytics, cloud computing, and application development, delivering tailored solutions that improve efficiency and business performance.
Job Summary
We are looking for a Data Migration Specialist to support the analysis, design, development, and execution of data migration activities from legacy/source systems into modern destination platforms. This role requires strong hands-on experience with Oracle and PostgreSQL, including the ability to read existing source data repositories, understand database schemas, analyze data relationships, and build reliable migration scripts and procedures.
Ideal Candidate Profile
The ideal candidate is a hands-on data migration engineer who can independently investigate a source system, understand how data is structured and used, and build reliable migration logic into a destination platform. They are strong in Oracle, PostgreSQL, SQL, stored procedures, Java, and Python. They can think like both a developer and a DBA, and they are comfortable using modern AI tools to improve productivity without blindly trusting generated results.
Key Responsibilities
- Work closely with engineering, product, and database teams to understand source and destination data models.
- Analyze legacy/source data repositories to identify database structures, table relationships, constraints, indexes, data quality issues, and migration dependencies.
- Design and implement data migration scripts, procedures, and tools to convert source data into the required destination format.
- Develop and maintain migration logic using SQL, PL/SQL, PostgreSQL functions/procedures, Java, and Python.
- Build repeatable and auditable migration processes, including extraction, transformation, loading, validation, rollback, and reconciliation.
- Perform data mapping between source and target systems, documenting transformation rules and assumptions.
- Optimize migration performance for large datasets using database tuning, indexing strategies, batching, and transaction management.
- Validate migrated data through reconciliation reports, automated checks, and exception handling.
- Troubleshoot data migration issues, including data integrity problems,
- schema mismatches, encoding issues, performance bottlenecks, and failed migration runs.
- Collaborate with application engineers to understand how source data is used by the application and how it should be represented in the target system.
- Use agentic AI tools such as Claude Code, Codex, GitHub Copilot, or similar tools to assist with code analysis, script generation, test creation, documentation, and migration acceleration.
- Follow secure coding, data privacy, and auditability practices when handling sensitive or production data.
Preferred Qualifications
Experience migrating data between Oracle and PostgreSQL.
Experience with large-scale or production-critical data migration projects.
Experience with legacy application modernization or database modernization initiatives.
Experience reading application source code to infer data usage, business rules, and hidden dependencies.
Experience with Git, CI/CD pipelines , automated testing, and deployment processes.
Experience using GenAI or agentic coding tools such as Claude Code, OpenAI Codex, GitHub Copilot, Cursor, or similar tools.
Experience creating automated data quality checks and migration reports.
Familiarity with containerized development environments, Linux scripting, and cloud/on-prem deployment environments.
GenAI / Agentic Tool Expectations
The candidate is not expected to be an AI researcher but should be comfortable using AI-assisted engineering tools as part of daily work.
- Use Claude Code, Codex, or similar tools to analyze database scripts, Java/Python code, and migration logic.
- Generate first drafts of migration scripts, SQL queries, validation scripts, and documentation.
- Use AI tools to accelerate source code exploration and identify where data structures are used.
- Review and validate AI-generated output carefully before using it in production migration work.
- Apply engineering judgment, testing, and database expertise to ensure correctness, security, and reliability. Reliability.
YDCPRO Ltd. Suite 2700/27th floor,
161 Bay Street TD Tower – Toronto – ON, M5J 2S1.
Website:
Vacancy posted 13 days ago
Similar jobs that could be interesting for youBased on the Data Migration Specialist (Oracle, PostgreSQL, SQL) in Oakville, ON vacancy
- ...successful candidate will have the capability and interest to grow with us. You will also be responsible for building SQL interfaces with 3rd party systems for data ETL. Most professional services team members also spend time supporting our Application Support team. The Euna...SuggestedFull timeSummer workWork at officeLocal areaFlexible hoursWeekend work3 days per week
$55k - $65k per year
...Logistics as we are launching a brand new automotive sequencing site in Mississauga/Oakville. We are looking for a driven Materials Specialist to join our DP World team. You will be responsible for overseeing and monitoring the movement of materials in the receiving department...SuggestedContract workInternshipLocal area$85k - $110k per year
...2026 About the Role We’re hiring a CRO Specialist to lead conversion performance across our... ...That means spotting opportunities in the data, forming hypotheses, launching tests, and... ...TikTok) • Comfort pulling your own data with SQL or similar tools What We Offer • $85,...SuggestedPermanent employmentFull timeWork at office$80k - $130k per year
...partners and experts in all aspects of human resources. As a Specialist, HR Business Partner, you will be integral to the Ford of Canada... ...action planning related to employee engagement and morale, including data analysis, insight identification, and plan development and...SuggestedWork at office- ...organizations WHY WE NEED YOU? GLAD YOU ASKED... At Pelmorex, we’re on a mission to transform weather and environmental data into decision-grade insights for businesses and consumers. Our B2B products help organizations make smarter, safer, and more profitable...SuggestedFull timeFlexible hoursWeekend work
$75k - $95k per year
...experience you won't find anywhere else. The Payroll & Benefits Specialist is responsible for full-cycle payroll administration, union... ..., and manual cheques. Review and audit time records, payroll data, and attendance for accuracy. Reconcile payroll accounts, resolve...Hourly pay$60k - $80k per year
...and Japan. About the Role We’re looking for a Paid Media Specialist to support our paid media team in the execution and day-to-day management... ...following the established testing plan • Pull performance data from ad platforms and analytics tools, organize it, and prepare...Full timeManual laborWork at officeTrial period$65k - $70k per year
...Admissions Operations & Data Coordinator Location: Oakville, Ontario (on-site) Type: Full-time Salary Range : $65,000.00 - $70,000.00 COME JOIN OUR TEAM: If you are passionate about data, systems, and delivering exceptional experiences, this is the opportunity...Full timeWork at officeLocal area- ...2025 and Canada’s Top Employers for Young People 2025. What will you do? We are seeking a highly experienced Synthesia AI Video Specialist for a 3-month contract to support the Siemens Academy team in Oakville. This role focuses on converting existing content into...Hourly payLong term contractContract workTemporary workWork at officeLocal areaRemote workFlexible hours
- ...campus strategy and represent Siemens as a brand ambassador at career fairs, events, and virtual engagements. Leverage recruitment data and insights to measure success, refine campus strategies, and continuously improve outcomes. Employer Branding Strengthen Siemens...Work at officeLocal areaRemote workFlexible hours
- ...Join SAGE Engineering Services Ltd. as a PROJECT SPECIALIST / PROJECT ENGINEER! Be part of projects that matter – supporting the design, qualification, and delivery of life-changing pharmaceutical advancements. Since 2000, SAGE has steadily grown to serve medium to large...Full timeFor contractorsWork at officeFlexible hours
- ...Bennington Financial Corp, powered by EQB, is a compelling place to build your next chapter! The Work The Lease Completion Specialist is responsible for processing the close out of mid-term and end-of-term leases for the Equirex and Bodkin portfolios. This role will...Long term contractFull time
- ...Inside Sales Specialist (National) Who We Are Essity is a global leader in health and hygiene with our corporate headquarters in Stockholm... ..., and sales results in CRM systems. Leverage CRM tools, data insights, and digital marketing leads to optimize outreach and decision...Live InWork at officeRemote work3 days per week
$78k per year
...evolving global market. In this position you will be reporting to the Continuous Improvement Manager. As the Continuous Improvement Specialist , you support the Oakville site through its Continuous Improvement journey. In this role, the CI Specialist will be the primary...Long term contractPermanent employmentTemporary workWorldwideRelocation package$22.21 per hour
...all while having fun! Acclaim Health announces the availability of three (3) Full Time (37.5 hours per week) Service Coordination Specialist –PSW position working in the Speers Road office in the Home Care team. This position requires the individual to work Monday to Friday...Hourly payFull timeWork at officeMonday to fridayShift work$17.6 per hour
Do you have strong attention to detail and enjoy data entry ? Are you ready to get back to working onsite and enjoy a fast paced environment? We are currently hiring a Data Administrator for an exciting on-going contract assignment. This company is known for being part...Weekly payFull timeContract workWork at officeLocal areaMonday to friday- ...our 100% virtual environment, you can achieve work-life balance while making a real impact. Your Role: As an Insurance Benefits Specialist, you'll play a key role in connecting clients with the benefits that secure their future. With our comprehensive training and support...Remote jobWeekly payFull timeContract workWork from home
- ...partnerships with major national retailers and digital commerce platforms. Position Scope: (20-Month Contract) The Quotations Specialist – Inside Sales creates the project pipeline nationally in the ongoing development of existing and prospective customers. Coordinates...Contract workFor contractorsWork at office
- ...Outbound call Specialist - Desjardins Agent Team Member Location: Oakville, ON Type: Full Time, Permanent Position Overview: A successful Desjardins Agent is seeking a qualified professional to join their winning team for the role of Agency outbound call specialist...Permanent employmentFull timeFor contractors
$23 per hour
...and career pursuits and creating opportunities for ongoing communication and relationship building. What you’ll do The Credit Risk Data Analyst Student reports to the Manager of Modeling & Segmentation Analytics within our Credit Risk Division. The mandate of the Credit...Hourly pay- Are you looking for a job where you can stay in good shape, work outdoors, and make a solid income this summer? This year, our team is growing as we take on a growing number of clients. Our hard-working and motivated team works on many different homes for a variety of clients...Full timeSummer work
$29 - $31 per hour
Randstad has partnered with a leading organization in the distribution industry, looking for a tech-savvy AR Specialist to join their team, located in Oakville. This role is specifically designed for a professional who excels in a high-volume environment and possesses strong...Hourly payContract workFlexible hours- ...Reboot Monkey is a global leader in IT solutions, specializing in data center management that simplifies your IT operations. We provide hosting space, future-proof upgrades, and 24/7 support through our smart or remote hands, ensuring seamless, secure, and sustainable service...Permanent employmentFull timeFreelanceRemote workFlexible hoursNight shift
- Merriam Music is a multi-location, family-owned business based in Oakville, Ontario. The business operates two primary sales divisions, one focused on music education, one on piano retail. In both categories, Merriam is considered a leader in terms of market share, marketing...Long term contractPart timeImmediate startFlexible hours
$80k - $120k per year
ABOUT THE POSITION At Merriam Music, we live and breathe the arts - but behind the curtain, we run one of the most successful sales operations of any small-to-medium business in Canada. Whether it's connecting someone with their dream piano or enrolling a family into a lifetime...Full timeSelf employmentRemote workWork from homeShift workWeekend workDay shiftAfternoon shift$25 per hour
...Appleby College currently has a challenging opportunity for a: Collections Specialist – Paid Internship sponsored by Young Canada Works Full-time contract: August 10, 2026 – February 5, 2027 Hours: 35 hours/week from 8:30 am – 3:30 pm, $25/hour WELCOME TO APPLEBY...Hourly payFull timeContract workInternshipLocal area- ...and Canada’s Top Employers for Young People 2025. What will you do? We are seeking a dynamic and technically proficient Sales Specialist to drive growth in our Digital Industries segment, with a focus on Motion Control . This role involves identifying customer needs...Hourly payLong term contractContract workWork at officeLocal areaRemote workFlexible hours
- ..., services, and user experiences. Role Overview We’re inviting individuals from all backgrounds, including those searching for data entry clerk roles, to express interest in joining upcoming consumer research studies. These may include online interviews, product evaluations...Part timeCasual workRemote workFlexible hours
$120k - $125k per year
...knack for translating complex financial data into actionable insights? Can you lead the... ...and play a crucial role in a major system migration? If so, this could be your next career... ...two direct reports, an Accounts Payable Specialist and an IT Finance Analyst, and will be a...Work at office- ...Experience 10–15+ years of experience as an Oracle DBA Strong expertise in: Oracle... ..., 12c, 19c) Oracle RAC & Exadata Data Guard and GoldenGate RMAN backup &... ...Hands-on experience with: Database migration and upgrades Performance tuning and SQL optimization ERP databases (Oracle...PostgreSQLOracle
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Migration Specialist (Oracle, PostgreSQL, SQL). Be the first to apply!
