Expleo

Senior Database Developer – Oracle Experience

Job Locations
IE-D-Dublin
Job area
IT & Digital
Employment type
Permanent or Fixed Term Contract
Visa sponsorship
None
Workplace
Hybrid

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.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share to social media

Can't find the job of your choice?
Upload your C.V. / Resume here for our recruiters to view.