At a Glance
- Tasks: Migrate data from legacy Oracle systems to a new centralised platform.
- Company: Join a forward-thinking tech company focused on database innovation.
- Benefits: Remote work, competitive salary, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on problem-solving and stakeholder engagement.
- Why this job: Be part of a crucial project that shapes the future of data management.
- Qualifications: Experience in database migration and strong skills in Oracle and T-SQL.
The predicted salary is between 50000 - 65000 £ per year.
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.
Oracle Database Administrator in London employer: SmartSourcing Ltd
Contact Detail:
SmartSourcing Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle Database Administrator in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with Oracle databases. A friendly chat can lead to insider info about job openings or even referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your database migration projects and any relevant documentation you've worked on. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios. Be ready to discuss how you've tackled challenges in past migrations, as well as your approach to data validation and performance optimisation.
✨Tip Number 4
Don't forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Oracle Database Administrator in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with database migration projects and your expertise in Oracle and T-SQL. We want to see how your skills align with the role, so don’t be shy about showcasing relevant achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the Oracle DBA position. Mention your experience with ETL processes and your ability to collaborate with technical teams and stakeholders.
Show Off Your Documentation Skills: Since strong documentation skills are key for this role, include examples of your technical documentation work. Whether it’s ERDs or process flow diagrams, we want to see how you can keep things organised and clear!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts and you’ll be set!
How to prepare for a job interview at SmartSourcing Ltd
✨Know Your Databases Inside Out
Make sure you brush up on your Oracle and T-SQL skills before the interview. Be ready to discuss your experience with database migration projects, especially focusing on ETL processes. Having specific examples of past projects will show that you know your stuff!
✨Show Off Your Documentation Skills
Since strong documentation skills are a must for this role, prepare to talk about how you've created and maintained technical documentation in the past. Bring along samples of ERDs or process flow diagrams if possible, as this will demonstrate your ability to communicate complex information clearly.
✨Communicate Like a Pro
This job requires excellent communication and stakeholder management skills. Practice explaining technical concepts in simple terms, as you'll need to collaborate with various teams. Think of examples where you've successfully managed stakeholder expectations or resolved conflicts.
✨Prepare for Problem-Solving Questions
Expect to face questions that test your problem-solving abilities. Think of scenarios where you've optimised database performance or tackled integration issues. Be ready to walk through your thought process and the steps you took to resolve challenges.