Oracle / SQL Consultant on OpenVMS

LinuxRecruit; Greater London; On-site; GBP 60,000 - 75,000; Full time

Job summary

A major organisation is seeking a skilled Database Migration Engineer to drive the migration of Oracle databases to an OpenVMS environment on X86. Candidates should have strong experience with Oracle 10gR2, Pro*COBOL, and Agile methodologies, ensuring application support and code updates during this critical project. If you're passionate about making a significant impact, apply now!

Qualifications

• Extensive experience with database upgrades.
• Experience in OpenVMS architecture migrations.
• Hands-on experience in an OpenVMS development environment.

Responsibilities

• Update Pro*Cobol/SQL/DCL code for remote database connections.
• Modify code for application compatibility on OpenVMS X86.
• Support migration from rule based to cost-based optimizer.
• Ensure data security and compliance with relevant accreditations.

Skills

Oracle 10gR2

Pro*COBOL

SQL

OpenVMS

Agile methodologies

DCL

Job description

Overview

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-host 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.

Responsibilities

• 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…