Senior Database Systems Developer

Overview

We are looking for a Senior Database Systems Developer to play a lead role in software design, architecture, requirements analysis, and software development to deliver support and maintenance of existing applications as well as development of new applications.

Responsibilities

• Responsible for designing databases and ensuring their stability, reliability, and performance
• Responsible for optimisation of in-application PL/SQL statements as necessary and establishing best practices
• Develops new database-centric functionality on existing software products
• Create technical and architectural documentation and create technical instructions throughout programme development
• Provide expertise in the full development lifecycle, from concept and design to testing
• Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL
• Responsible for the performance, integrity and security of a Re-architecture and refactoring of legacy systems
• Ensures that data remains consistent across the database, is clearly defined, users can access data concurrently, in a form that suits their needs and that there is provision for data security and recovery control (all data is retrievable in an emergency)
• Design schemes, tables, and servers and set permissions for users to access them
• Create shell scripts and perform timely backups of all key database systems
• Reports

Qualifications

• BS/MS degree in Computer Science, Engineering or a related subject

Essential skills

• Technical Skills

  • Designing and building Oracle (19c) 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
  • 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
  • Oracle(19c) database design & implementation of logical and physical data model
  • Build and maintenance of largescale databases in a development environment
  • 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 customisation
  • Toolset Experience
  • Oracle 19c
  • Oracle ORDS
  • Oracle APEX
  • Linux
  • Jira
  • Confluence
  • BI Publisher and reports

   

  Consultancy Skills

  • Client-facing skills
  • People management skills - introducing and building ways in which people can learn from each other, encouraging mentoring and the transfer of knowledge by designing and delivering learning interventions
  • Team work and emotional intelligence
  • Good self-management – continuous performance is both an objective and a mind-set
  • Has an innovative approach – a bold thinker and doer, matching creativity with vigilance
  • High value on openness and transparency

Experience

• 7+ years of experience in application development
• Acting as a senior responsible person and leading teams of specialists on complex software projects
• 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