Oracle Developer

Pemberton Tech; Glasgow; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading financial institution in Glasgow is seeking a skilled software developer with expert Oracle PL/SQL programming abilities. This role involves designing and enhancing application features while collaborating with global teams in an Agile environment. The successful candidate will ensure high code quality and troubleshoot performance issues. The company offers a flexible and hybrid working setup to support work-life balance and personal commitments.

Qualifications

• Expert level Oracle PL/SQL programming skills.
• Intermediate level in Linux/Unix shell scripting.
• Experience with database profiling and performance tuning.

Responsibilities

• Design and improve technical features of applications.
• Liaise with teams for feature evaluation and issue escalation.
• Participate in Agile teams for global release preparations.

Skills

Oracle PL/SQL programming

Linux/Unix shell scripting

C programming

Pro*C programming

Tools

Autosys

SFTP

Solace

MQ

Oracle Forms

Job description

My client is one of the world’s largest and most respected financial institutions, with 329 years of success, quality and innovation behind us. We offer careers that provide endless opportunity – helping millions of individuals and businesses thrive, and creating financial and digital solutions that the world now takes for granted.

Working Flexibly

We’re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers’ and clients’ needs. Whether you have family commitments or you’re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life. If you would like some flexibility, then please discuss this with the hiring manager, and your request will be reviewed subject to business needs.

Hybrid Working

We are currently in the early stages of implementing a hybrid working environment, which means that many colleagues spend part of their working hours at home and part in the office, depending on the nature of the role they are in. We’re flexible on how this works and it may continue to change and evolve. Depending on your team, typically this means that colleagues spend a minimum of between 20% to 60% of their time in the office, which could be over a week, a month or a quarter. However, some colleagues may choose to spend more time in the office over a typical period than their role type requires. We also have a flexible working process where, subject to business needs, all colleagues globally are able to request work patterns to reflect their personal circumstances.

What will you be doing?

• Designing, developing and improving technical features of the application under project requirements and contributing to the technical architecture of existing, and new systems
• Liaising with other teams in evaluating new features and improvements and communicating with the global development team; escalating issues on time
• Working in Agile teams and taking part in technical preparations for global releases
• Ensuring consistent high code quality through unit and integration testing
• Working closely with QA, UAT and application support teams in getting the code tested, released and supported
• Troubleshooting performance and functional problems on development, testing and production environments
• Gathering development and testing estimates and including these in formal project plans
• Writing detailed integration requirements documents using the Confluence/Wiki based documentation approach aligned with an Agile / sprint-based development methodology

What we’re looking for:

• Expert level Oracle PL/SQL programming skills – knowledge of best practices and recent developments of Oracle database technologies
• Intermediate level Linux/Unix shell scripting
• Intermediate level C and Pro*C programming skills
• Intermediate level database profiling and performance tuning skills and experience

Skills that will help you in the role:

• Working knowledge of Autosys
• Knowledge of SFTP protocol and security key management concepts
• Extensive knowledge of messaging/middleware technologies (Solace, MQ)
• Basic knowledge of Oracle Forms/Report