Oracle Database Administrator

Oracle DBA - Database Consolidation Specialist – Remote – 6 months – SC Clearance

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.