Data Migration & Oracle Application Specialist

Listing reference: adapt_000295 Listing status: Online Apply by: 3 September 2026

Position summary

Industry: Education & Training Job category: IT and Telecommunications Location: Midrand Contract: Permanent EE position: Yes

About our company

Adapt IT (Pty) Ltd is a subsidiary of Adapt IT Holdings Proprietary Limited and a market leader in developing specialised vertical market software and digitally-led business solutions that assist clients across targeted industries to Achieve More by improving their customer experience, core business operations, business administration and enterprise resource planning.

Introduction

The Data Migration & Oracle Application Specialist is responsible for planning, managing, and executing complex data migration, data archiving, and Oracle database initiatives within the ITS ERP environment. The role focuses on ensuring data integrity, security, operational continuity, and successful knowledge transfer while supporting enterprise-scale Oracle applications.

Job description

Key Responsibilities

• Analyse Oracle databases, schemas, storage, and data dependencies.
• Plan and execute end-to-end data migration projects, including data extraction, transformation, loading (ETL), validation, reconciliation, cutover, and rollback.
• Develop and optimise Oracle SQL and PL/SQL scripts, packages, procedures, and migration utilities.
• Design and implement secure data archiving and information lifecycle management solutions.
• Ensure data quality through reconciliation, validation, governance, and compliance with POPIA and change management processes.
• Provide specialist Oracle database and ITS ERP application support across Student, Finance, HR, Payroll, and related modules.
• Produce technical documentation, migration playbooks, and standards while mentoring team members and transferring critical knowledge.

Minimum requirements

Qualifications & Experience

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field (or relevant diploma with significant experience).
• Minimum 8 years' experience with Oracle-based enterprise applications.
• At least 5 years' experience in enterprise data migration, database support, conversion, or archiving.
• Extensive experience with Oracle SQL and PL/SQL in high-volume production environments.
• Experience planning and executing enterprise data migration projects.
• Experience analysing Oracle storage, schemas, and data growth.
• Experience with ITS ERP, ITS Integrator, HR/Payroll, Student, or Finance systems is advantageous.
• Oracle certifications are beneficial.

Technical Skills Required

• Expert Oracle SQL and PL/SQL development.
• Strong understanding of Oracle databases, schemas, tablespaces, indexes, constraints, users, roles, and database administration concepts.
• Enterprise data migration, ETL/ELT, data cleansing, transformation, reconciliation, and batch processing.
• Data archiving, backup, recovery, and information lifecycle management.
• Unix/Linux command-line and scripting.
• Experience with reporting and integration technologies such as Jaspersoft, REST services, and ORDS.
• Knowledge of relational databases, CI/CD, source control, testing, and release management.

Behavioural Competencies

• Strong analytical and problem-solving skills.
• High attention to detail and risk management.
• Excellent communication and stakeholder management.
• Ability to collaborate across technical and business teams.
• Mentoring, knowledge sharing, and documentation skills.
• High integrity when handling confidential data.

Success Measures

Success in the role is measured by:

• Accurate and complete data migrations.
• Controlled and successful migration cutovers.
• Preservation of data integrity and business continuity.
• Effective data archiving and reduced production database growth.
• High-quality, secure Oracle development.
• Strong documentation, knowledge transfer, and stakeholder confidence.