Logo for CTG

Oracle to Db2 SQL Migration Developer

Role overview

Summary

This role focuses on migrating SQL code from Oracle to IBM Db2, ensuring that the new code maintains functional equivalence. You will work with CTG's clients to validate migration results and troubleshoot any issues that arise during the conversion process.

Qualifications

  • Strong proficiency in Oracle SQL, PL/SQL, and IBM Db2 SQL.
  • Minimum of 2 years of hands-on SQL development experience with both Oracle and IBM Db2.
  • Demonstrated experience converting Oracle SQL to Db2 SQL and validating migration results.
  • Excellent verbal and written English communication skills.
  • Preferred: Bachelor's degree in Computer Science, Information Technology, or a related field preferred, or equivalent relevant professional experience.

Responsibilities

  • Convert and migrate Oracle SQL code to IBM Db2 SQL, ensuring compatibility and functional equivalence.
  • Identify and resolve differences in SQL syntax, functions, data types, and database-specific behavior.
  • Develop and execute SQL queries to validate data accuracy, application functionality, and migration results.
  • Document code changes, testing procedures, results, and technical findings.

Key facts

  • Remote from: United States
  • Full time
  • Mid-level (2-5 years)
  • SQL Developer
  • $115K – $125K / year
  • English

Hard skills

Other skills

  • Troubleshooting (Problem Solving)
  • Analytical Thinking
  • Problem Solving
  • Detail Oriented

About the company

CTG logo

CTG

  • IT Services & Consulting
  • 5,001–10,000
CTG, a Cegeka company, is at the forefront of digital transformation, offering innovative IT solutions and services that accelerate your strategy and project momentum. We help you achieve your evolving digital aspirations and desired business and IT outcomes—improved business performance, data-driven decision making, continuous innovation, and reimagined customer experiences—with the agility and confidence needed to succeed. CTG’s comprehensive solutions help clients across all industries address the business, technology, and operational challenges that are escalating as the pace of change gets faster and the stakes get higher. Our solutions leverage the latest tools and methodologies to allow for greater technology and business flexibility. Contact us today at info@ctg.com to learn how CTG can help accelerate your digital transformation.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Description:

CTG is seeking to fill an Oracle to Db2 SQL Migration Developer position for our client.

Location: Remote
Duration: 5 months

Duties:

  • Convert and migrate Oracle SQL code to IBM Db2 SQL, ensuring compatibility and functional equivalence.

  • Identify and resolve differences in SQL syntax, functions, data types, and database-specific behavior.

  • Develop and execute SQL queries to validate data accuracy, application functionality, and migration results.

  • Troubleshoot conversion issues, investigate data discrepancies, and optimize migrated SQL code.

  • Document code changes, testing procedures, results, and technical findings.

  • Ensure database applications meet performance, security, and technical requirements.

Skills:

  • Strong proficiency in Oracle SQL, PL/SQL, and IBM Db2 SQL.

  • Knowledge of relational database concepts, data modeling, and SQL development.

  • Experience with SQL conversion, troubleshooting, testing, and data validation.

  • Familiarity with database application development across Linux, Unix, and Windows (LUW) environments.

  • Excellent technical documentation, analytical, and problem-solving skills.

  • Strong attention to detail and ability to work independently.

  • U.S. citizenship required; candidates must reside in the United States.

Experience:

  • Minimum of 2 years of hands-on SQL development experience with both Oracle and IBM Db2.

  • Demonstrated experience converting Oracle SQL to Db2 SQL and validating migration results.

  • Experience developing, testing, and maintaining relational database applications.

  • Preferred: Previous DBA experience or related responsibilities involving database troubleshooting, performance tuning, SQL optimization, and data validation in Oracle and/or Db2 environments.

Education:

  • Bachelor's degree in Computer Science, Information Technology, or a related field preferred, or equivalent relevant professional experience.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

To Apply:
To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!

The expected base salary for this position ranges from $60.00 to $65.00/hour. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered.

About Us:

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.

Related jobs

See all SQL Developer jobs

Other jobs at CTG