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 performanceResponsible for optimisation of in-application PL/SQL statements as necessary and establishing best practicesDevelops new database-centric functionality on existing software productsCreate technical and architectural documentation and create technical instructions throughout programme developmentProvide expertise in the full development lifecycle, from concept and design to testingAdvising on Oracle features and on best practice and optimal approach in the use of PL/SQLResponsible for the performance, integrity and security of a Re-architecture and refactoring of legacy systemsEnsures 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 themCreate shell scripts and perform timely backups of all key database systemsReports
Qualifications
BS/MS degree in Computer Science, Engineering or a related subject
Essential skills
Technical SkillsDesigning and building Oracle (19c) database schemas and ensuring their stability, reliability, and performanceOracle 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 TuningCreation 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 toolsOracle(19c) database design & implementation of logical and physical data modelBuild and maintenance of largescale databases in a development environmentExcel spreadsheets manipulation using only PL/SQL (read and write)Ability to manipulate binary files (BLOB) in PL/SQLProgrammatically 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 AjaxUnderstanding of Apex Themes, CSS, and UI customisationToolset ExperienceOracle 19cOracle ORDS Oracle APEX LinuxJiraConfluenceBI Publisher and reports Consultancy SkillsClient-facing skillsPeople 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 interventionsTeam 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 developmentActing as a senior responsible person and leading teams of specialists on complex software projectsPublic 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 challengesWe 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 coursesCompetitive 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.