Oracle to Db2 SQL Migration Developer

Computer Task Group, Inc•UNAVAILABLE, UNAVAILABLE

6h•Remote

About The Position

CTG is hiring an Oracle to Db2 SQL Migration Developer for a client. This remote position is expected to last five months. The developer will migrate Oracle SQL code to IBM Db2 SQL and ensure compatibility, functional equivalence, and accurate migration results. The role involves identifying differences in SQL syntax, functions, data types, and database behavior; validating data and application functionality; resolving conversion issues; and optimizing migrated code. The developer will document code changes, test procedures, results, and technical findings, and ensure database applications meet performance, security, and technical requirements. Candidates need hands-on SQL development experience with both Oracle and IBM Db2, including converting Oracle SQL to Db2 and validating migration results. A bachelor's degree in a related field or equivalent relevant professional experience is preferred. U.S. citizenship and residence in the United States are required. The expected base salary is $60.00 to $65.00 per hour, and a competitive benefit package is offered.

Requirements

At least 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.
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; candidates must reside in the United States.
Excellent verbal and written English communication skills and ability to interact professionally with a diverse group.

Nice To Haves

Previous DBA experience or related responsibilities involving database troubleshooting, performance tuning, SQL optimization, and data validation in Oracle and/or Db2 environments.
Bachelor's degree in Computer Science, Information Technology, or a related field; equivalent relevant professional experience is also accepted.

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.
Troubleshoot conversion issues and investigate data discrepancies.
Optimize migrated SQL code.
Document code changes, testing procedures, results, and technical findings.
Ensure database applications meet performance, security, and technical requirements.
Develop, test, and maintain relational database applications.