Senior Database Developer – Oracle Experience

Overview
We're looking for a Senior Database Developer to play a key role in delivering robust, citizen-focused software solutions for government clients.
With over 7 years of experience developing enterprise applications using Oracle, you'll bring deep technical expertise and a collaborative mindset to support and mentor your team.
This is a great opportunity to shape the data backbone of critical public services—ensuring performance, reliability, and scalability at every level.
Responsibilities
Development and maintenance of views, code, stored procedures, triggers, packages
Developing customised reports and system generated documents.
Coding in adherence to the Department and Oracle standards.
Performing preventative maintenance activities.
Preparation and maintenance of technical documentation.
Managing project source code and documentation.
Effort estimation & quality control of code and other deliverables.
Version control of application code.
Database tuning and performance monitoring
Troubleshooting and resolving complex database problems.
Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL.
Conducting developer code reviews.
Provision of mentoring and skills transfer to colleague as and when required.
Management of DBA routine tasks e.g. roles, privileges, synonyms, schemas, objects, tablespaces across multiple environments.
Writing database deployment scripts in compliance with release management standards.
Development on multiple concurrent projects to strict deadlines.
Data modelling and database design.
Issue analysis, diagnosis and resolution.
Writing complex PL/SQL for Oracle 19c Databases
Qualifications
BS/MS degree in Computer Science, Engineering or a related subject
Essential skills
Technical Skills:
Designing and building Oracle database schemas and ensuring their stability, reliability, and performance.
Oracle PL/SQL coding including but not limited to:
Oracle Built-in Packages/Bulk Collect/lnsert/Array Processing/ Ref Cursors o Dynamic SQL —literal and bind variables
Application Tuning
Creation of scripts to generate views, procedures, functions, triggers, indexes, constraints and packages
Data Definition and Transaction Control Language, SQL tuning and Oracle query optimisation using cost based optimiser and other query optimisation tools
Demonstrate experience in administering a Jenkins instance in order to build windows executables.
Oracle database design & implementation of logical and physical data model.
Build and maintenance of largescale databases in a development environment.
Other technical skill requirements include:
Understand Excel spreadsheets manipulation using only PL/SQL (read and write)
Ability to manipulate binary files (BLOB) in PL/SQL
Programmatically read and write Json and XML using only custom PL/SQL (and explicitly not using the built-in Oracle packages/objects)
Knowledge of JavaScript, application processes and Ajax
Understanding of APEX Themes, CSS, and UI customization
Toolset Experience
Oracle
Oracle ORDS
Developing Oracle APEX reports
Linux
Jira
Confluence
Consultancy Skills:
Strong client-facing skills, with the ability to build trust and communicate effectively
Ability to lead and mentor, fostering a culture of learning and knowledge sharing
Collaborative team player
Self-driven and disciplined
Experience
7+ years of experience in application development
Public sector experience preferred
Benefits
At Expleo, we are committed to providing a competitive salary and substantial benefits offering with unique wellbeing, financial and employee recognition programmes.
We pride ourselves on our diverse and inclusive culture and offer a variety of family friendly policies and enhanced leave to help you achieve a healthy work life balance.
By providing significant learning and development opportunities, we encourage individual growth and success throughout your career with us.
Collaborative working environment – we stand shoulder to shoulder with our clients and our peers through good times and challenges
We empower all passionate technology loving professionals by allowing them to expand their skills and take part in inspiring projects
Expleo Academy - enables you to acquire and develop the right skills by delivering a suite of accredited training courses
Competitive company benefits such as medical and dental insurance, pension, life assurance, employee wellbeing programme, sports and social events, birthday hampers and much more
Always working as one team, our people are not afraid to think big and question the status quo.
"We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age".
At Expleo, we understand that many people experience impostor syndrome throughout their lifetime, please do not let this discourage you from applying for this role.
Our Talent Acquisition Team welcomes all CV's and will consider your application in line with the values, requirements and role competencies.
#J-18808-Ljbffr