Oracle DBA Hybrid working SC Clearance
Oracle DBA - Database Consolidation Specialist - Hybrid - 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 HPUX 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.
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 HPUX 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.
SmartSourcing are a Disability Confident Employer and we promote, celebrate and value diversity, we are committed to promoting equality and inclusion for all.