Oracle DBA - Database Consolidation Specialist – Hybrid – 6 months – SC Clearance
2 days per week on site in thre Midlands and / or London
Responsibilities:
* Support the consolidation by migrating data and functionality from mainly Oracle legacy systems, including Product Management Databases, CRM systems, and Geneva/Netcracker billing platforms, to the new centralised platform.
* Perform data extraction, transformation, and loading (ETL), data mapping, validation, and testing to ensure accuracy and integrity of migrated data.
* Collaborate with the new vendor to align migration processes, troubleshoot integration issues, and ensure system compatibility.
* Work closely with internal technical teams, business stakeholders, and current system users to gather requirements, address concerns, and provide updates on migration progress.
* Optimize Oracle, T-SQL, and other database platforms, resolve technical challenges, and provide post-migration support, including documentation and issue resolution.
Skills/Qualifications:
* Proven experience in database migration projects
* Strong expertise in Oracle, T-SQL, ETL processes, and HP-UX or other legacy Unix/Linux/Windows system administration in a mixed database environment.
* Strong documentation skills, including the ability to create and maintain technical documentation such as ERD (Entity Relationship Diagrams), process flow diagrams, and data mapping documentation.
* Excellent communication and stakeholder management skills to effectively collaborate with vendors, technical teams, business users, and current system stakeholders.
* Strong problem-solving, data mapping, and database performance optimization skills.
* Experience with data validation and ensuring compliance with business requirements.
* Security Clearance (SC): The candidate must either hold valid SC clearance or be eligible to obtain it prior to starting