At a Glance
- Tasks: Join a team to migrate critical databases using Oracle and SQL in an OpenVMS environment.
- Company: Work with a top-notch organization known for hiring the best talent.
- Benefits: Enjoy remote work flexibility and competitive daily rates of £400 - £450.
- Why this job: Make a real impact on a major migration project while enhancing your skills in a fast-paced Agile environment.
- Qualifications: Extensive experience with Oracle 10gR2, SQL, Pro*COBOL, and OpenVMS architecture is essential.
- Other info: This role is perfect for those passionate about database upgrades and security in tech.
The predicted salary is between 80000 - 120000 £ per year.
Job – Oracle / SQL Consultant on OpenVMS | Linux Recruit
Oracle / SQL Consultant on OpenVMS
-
Specialism
Linux Engineering
-
Job type
Contract
-
Location
UK Remote
-
Rate
£400 – £450 per day
This is a great opportunity to come in and make a real difference to a major organisation, using your experience with Oracle 10gR2, SQL, stored procedures, working with SQL Embedded in Pro*COBOL code in an OpenVMS Environment. You\’ll be joining the team to work on a mission critical migration project.
To take this one you\’ll need to have extensive experience of database upgrades, and OpenVMS architecture migrations, such as VAX to Alpha to Itanium is an advantage.
The client\’s customer\’s solution uses the Oracle database and OpenVMS. The current versions of OpenVMS, Oracle and Oracle forms are out of date, as a result, a major project is underway to migrate the solution to OpenVMS on X86 with the database re-hosted on Linux. The experience required to thrive in this role includes being experienced in working on an OpenVMS development environment, both with Pro*COBOL and Oracle.
Your main tasks as the Oracle/SQL/Pro*Cobol Consultant will be:
- Update Pro*Cobol/SQL/DCL code to support connecting to databases on a remote machine.
- Make code changes necessary to support the application running on OpenVMS X86 using a new Cobol pre-compiler.
- Code changes to support moving from the rule based to cost-based optimizer.
- Work with the VMS architecture and quality assurance functions to ensure the security, privacy and integrity of our customer\’s data and solutions, ensuring relevant accreditations are achieved.
Key Skills & Experience:
- Strong understanding of Oracle 10gR2 on OpenVMS.
- Understanding of working with Embedded SQL in Pro*COBOL code.
- Hands-on experience with applications written in SQL/Pro*COBOL.
- Experienced in working on an OpenVMS development environment.
- Strong understanding of DCL.
- Demonstrable hands-on experience with applications written in SQL.
- Experienced working within Agile delivery teams within a fast-paced environment, including being an active contributor as part of an Agile development team.
- Good understanding of Service Operations & ITIL responsibilities as applied to operating within both agile and non-agile environments.
- Diligent and positive about supporting fellow Engineers to track support tickets, system monitoring, security & auditing.
This is a top-notch organisation who only hire the very best, so it\’s really one not to be missed. Apply now for the full details…
#J-18808-Ljbffr
Oracle / SQL Consultant on OpenVMS employer: LinuxRecruit
Contact Detail:
LinuxRecruit Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle / SQL Consultant on OpenVMS
✨Tip Number 1
Make sure to highlight your hands-on experience with Oracle 10gR2 and Pro*COBOL in your discussions. This role requires a deep understanding of these technologies, so be prepared to discuss specific projects where you've utilized them.
✨Tip Number 2
Familiarize yourself with the migration processes from VAX to Alpha to Itanium within OpenVMS environments. Being able to speak knowledgeably about these migrations will set you apart as a candidate who understands the complexities involved.
✨Tip Number 3
Demonstrate your experience working in Agile teams. Share examples of how you've contributed to team success in fast-paced environments, as this is crucial for the role and shows that you can adapt quickly.
✨Tip Number 4
Be ready to discuss your understanding of DCL and its application in OpenVMS. This knowledge is essential for the role, and showcasing your expertise will help you stand out during the selection process.
We think you need these skills to ace Oracle / SQL Consultant on OpenVMS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle 10gR2, SQL, and Pro*COBOL. Emphasize any previous work on OpenVMS environments and database upgrades to align with the job requirements.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the migration project and detail how your skills in SQL and OpenVMS can contribute to the team's success. Mention specific projects or experiences that demonstrate your expertise.
Showcase Agile Experience: Since the role involves working within Agile delivery teams, be sure to mention any relevant Agile methodologies you have experience with. Highlight your contributions to past projects and how you collaborated with team members.
Proofread Your Application: Before submitting, carefully proofread your application materials. Check for any spelling or grammatical errors, and ensure that all technical terms are used correctly to present yourself as a detail-oriented candidate.
How to prepare for a job interview at LinuxRecruit
✨Showcase Your Technical Expertise
Be prepared to discuss your hands-on experience with Oracle 10gR2 and Pro*COBOL. Highlight specific projects where you've successfully implemented database upgrades or worked on OpenVMS architecture migrations.
✨Demonstrate Problem-Solving Skills
Expect questions that assess your ability to troubleshoot and resolve issues in a fast-paced environment. Share examples of how you've tackled challenges related to SQL embedded in Pro*COBOL code or DCL scripting.
✨Familiarize Yourself with Agile Methodologies
Since the role involves working within Agile delivery teams, be ready to discuss your experience in Agile environments. Talk about your contributions to team dynamics and how you handle support tickets and system monitoring.
✨Understand Security and Compliance
Given the importance of data security and integrity, prepare to discuss your knowledge of ITIL responsibilities and how you've ensured compliance in previous roles. This will demonstrate your diligence and commitment to quality assurance.