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 - 70000 £ 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 employer: SmartSourcing Ltd
Contact Detail:
SmartSourcing Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle Database Administrator
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend relevant meetups or webinars, and don’t be shy about asking for introductions. You never know who might have the inside scoop on job openings.
✨Tip Number 2
Show off your skills! Create a portfolio or a personal website showcasing your database migration projects and any relevant documentation you've worked on. This can really set you apart from other candidates.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Practice common interview questions related to Oracle, T-SQL, and ETL processes, and be ready to discuss how you've tackled challenges in past projects.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit 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
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 responsibilities listed in the job description, 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 role. Mention specific experiences that relate to data extraction, transformation, and loading (ETL) processes, and how you've tackled similar challenges in the past.
Show Off Your Documentation Skills: Since strong documentation skills are key for this role, include examples of technical documentation you've created, like ERDs or process flow diagrams. We love seeing how you can communicate complex information clearly and effectively!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it gives you a chance to explore more about what we do at StudySmarter!
How to prepare for a job interview at SmartSourcing Ltd
✨Know Your Databases
Make sure you brush up on your Oracle and T-SQL knowledge. Be ready to discuss your experience with database migration projects, especially focusing on ETL processes. Highlight any specific challenges you've faced and how you overcame them.
✨Showcase Your Documentation Skills
Prepare examples of your technical documentation, like ERDs or process flow diagrams. Being able to explain how you create and maintain these documents will demonstrate your attention to detail and organisational skills, which are crucial for this role.
✨Communicate Effectively
Practice articulating your thoughts clearly, especially when discussing collaboration with vendors and stakeholders. Use examples from past experiences where you successfully managed communication and resolved issues during a migration project.
✨Be Ready for Problem-Solving Scenarios
Expect to be asked about specific technical challenges you've encountered in previous roles. Prepare to walk through your thought process and the steps you took to resolve those issues, showcasing your problem-solving skills and adaptability.