Senior Database Systems Developer

<h2>Overview</h2> <p>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.</p> <h2>Responsibilities</h2> <ul> <li>Responsible for designing databases and ensuring their stability, reliability, and performance</li> <li>Responsible for optimisation of in-application PL/SQL statements as necessary and establishing best practices</li> <li>Develops new database-centric functionality on existing software products</li> <li>Create technical and architectural documentation and create technical instructions throughout programme development</li> <li>Provide expertise in the full development lifecycle, from concept and design to testing</li> <li>Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL</li> <li>Responsible for the performance, integrity and security of a Re-architecture and refactoring of legacy systems</li> <li>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)</li> <li>Design schemes, tables, and servers and set permissions for users to access them</li> <li>Create shell scripts and perform timely backups of all key database systems</li> <li>Reports</li> </ul> <h2>Qualifications</h2> <ul> <li>BS/MS degree in Computer Science, Engineering or a related subject</li> </ul> <h2>Essential skills</h2> <ul> <li><p><strong>Technical Skills</strong></p> <ul> <li>Designing and building Oracle (19c) database schemas and ensuring their stability, reliability, and performance</li> </ul> <ul> <li>Oracle PL/SQL coding including but not limited to:</li> <ul> <li>Oracle Built-in Packages/Bulk Collect/lnsert/Array Processing/ Ref Cursors </li> <li>Dynamic SQL —literal and bind variables </li> <li>Application Tuning</li> <li>Creation of scripts to generate views, procedures, functions, triggers, indexes, constraints and packages </li> <li>Data Definition and Transaction Control Language, SQL tuning and Oracle query optimisation using cost-based optimiser and other query optimisation tools</li> </ul> <li>Oracle(19c) database design &amp; implementation of logical and physical data model</li> <li>Build and maintenance of largescale databases in a development environment</li> <li>Excel spreadsheets manipulation using only PL/SQL (read and write)</li> <li>Ability to manipulate binary files (BLOB) in PL/SQL</li> <li>Programmatically read and write Json and XML using only custom PL/SQL (and explicitly not using the built-in Oracle packages/objects)</li> <li>Knowledge of JavaScript, application processes and Ajax</li> <li>Understanding of Apex Themes, CSS, and UI customisation</li> <li>Toolset Experience</li> <ul> <li>Oracle 19c</li> <li>Oracle ORDS </li> <li>Oracle APEX </li> <li>Linux</li> <li>Jira</li> <li>Confluence</li> <li>BI Publisher and reports</li> </ul> </ul><p><strong> </strong></p><p><strong>Consultancy Skills</strong></p> <ul> <li>Client-facing skills</li> <li>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</li> <li>Team work and emotional intelligence </li> <li>Good self-management – continuous performance is both an objective and a mind-set </li> <li>Has an innovative approach – a bold thinker and doer, matching creativity with vigilance </li> <li>High value on openness and transparency</li> </ul></li> </ul> <h2>Experience</h2> <ul> <li>7+ years of experience in application development</li> <li>Acting as a senior responsible person and leading teams of specialists on complex software projects</li> <li>Public sector experience preferred</li> </ul> <h2>Benefits</h2> <p>At Expleo, we are committed to providing a competitive salary and substantial benefits offering with unique wellbeing, financial and employee recognition programmes.</p> <p>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. </p> <p>By providing significant learning and development opportunities, we encourage individual growth and success throughout your career with us.</p> <p> </p> <ul> <li>Collaborative working environment – we stand shoulder to shoulder with our clients and our peers through good times and challenges</li> <li>We empower all passionate technology loving professionals by allowing them to expand their skills and take part in inspiring projects </li> <li>Expleo Academy - enables you to acquire and develop the right skills by delivering a suite of accredited training courses</li> <li>Competitive company benefits such as medical