Oracle DBA Hybrid working SC Clearance
Posted Today by SmartSourcing Ltd
Negotiable
Undetermined
Hybrid
Midlands, UK
Summary: The Oracle DBA - Database Consolidation Specialist role involves supporting the migration of data and functionality from Oracle Legacy systems to a new centralized platform. The position requires collaboration with vendors and internal teams to ensure successful data migration, optimization of database performance, and adherence to security clearance requirements. The role is hybrid and requires strong technical and communication skills to manage stakeholder expectations and documentation.
Key Responsibilities:
- Support the consolidation by migrating data and functionality from Oracle Legacy systems to the new centralized 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.
Key Skills:
- 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, 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.
Salary (Rate): undetermined
City: Midlands
Country: UK
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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.
SmartSourcing are a Disability Confident Employer and we promote, celebrate and value diversity, we are committed to promoting equality and inclusion for all.