OverviewWe 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.ResponsibilitiesResponsible for designing databases and ensuring their stability, reliability, and performanceResponsible for optimization 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 controlDesign schemes, tables, and servers and set permissions for users to access themCreate shell scripts and perform timely backups of all key database systemsReportsQualificationsBS/MS degree in Computer Science, Engineering or a related subjectEssential SkillsTechnical 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/Insert/Array Processing/Ref CursorsDynamic SQL —literal and bind variablesApplication TuningCreation of scripts to generate views, procedures, functions, triggers, indexes, constraints, and packagesData Definition and Transaction Control Language, SQL tuning and Oracle query optimization using cost-based optimizer and other query optimization toolsOracle (19c) database design & implementation of logical and physical data modelBuild and maintenance of large-scale 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/SQLKnowledge of JavaScript, application processes and AjaxUnderstanding of Apex Themes, CSS, and UI customizationToolset ExperienceOracle 19cOracle ORDSOracle APEXLinuxJiraConfluenceBI Publisher and reportsConsultancy SkillsClient-facing skillsPeople management skillsTeamwork and emotional intelligenceGood self-managementInnovative approachHigh value on openness and transparencyExperience7+ years of experience in application developmentActing as a senior responsible person and leading teams of specialists on complex software projectsPublic sector experience preferredBenefitsAt 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 environmentEmpowerment of technology-loving professionalsExpleo Academy for skill developmentCompetitive company benefitsTeam-oriented culture“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.
#J-18808-Ljbffr