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