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 optimization 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
* 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 optimization using cost-based optimizer and other query optimization 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
o Knowledge of JavaScript, application processes and Ajax
o Understanding of Apex Themes, CSS, and UI customization
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
o Teamwork and emotional intelligence
o Good self-management
o Innovative approach
o 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
* Empowerment of technology-loving professionals
* Expleo Academy for skill development
* Competitive company benefits
* Team-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