Overview
We are looking for a Database Systems Developer to play a lead role in software design, architecture, requirements analysis, and software development to deliver support and maintenance (Tuning and optimization) of existing applications as well as development of new applications.
Responsibilities
* Responsible for designing databases and applications and ensuring their optimum 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
o Designing and building Oracle (19c) database schemas and ensuring their stability, reliability, and performance
o Oracle PL/SQL coding including but not limited to:
+ Oracle Built-in Packages/Bulk Collect/Insert/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
o Oracle (19c) database design & implementation of logical and physical data model
o Build and maintenance of large-scale databases in a development environment
o Excel spreadsheets manipulation using only PL/SQL (read and write)
o Ability to manipulate binary files (BLOB) in PL/SQL
o Programmatically read and write Json and XML using only custom PL/SQL (and explicitly not using the built-in Oracle packages/objects)
o Knowledge of JavaScript, application processes and Ajax
o Understanding of Apex Themes, CSS, and UI customisation
o Toolset Experience
+ Oracle 19c
+ Oracle ORDS
+ Oracle APEX
+ Linux
+ Jira
+ Confluence
+ BI Publisher and reports
* Consultancy Skills
o Client-facing skills
o 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
o Team work and emotional intelligence
o Good self-management – continuous performance is both an objective and a mind-set
o Has an innovative approach – a bold thinker and doer, matching creativity with vigilance
o High value on openness and transparency
Experience
* 4+ years of experience
* 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 CVs and will consider your application in line with the values, requirements and role competencies.
#J-18808-Ljbffr