This Oracle Developer will work across multiple projects within a delivery centre in a secure Government client. This role is based on client site and London. Security Clearance is required for this vacancy. If you are not Security Cleared presently you must be willing and able to qualify for the process
- Oracle SQL – strong SQL language skills for complex querying, analytical functionality, and physical data model implementation in support of application development and ad hoc business queries;
- Oracle PL/SQL – for ETL and data access component development;
- Database schema design – in depth understanding of relational paradigm, principles of normalisation, application persistence layer design patterns;
- Performance tuning – SQL query and PL/SQL optimisation, explain plan interpretation, ‘tkprof’, Oracle Enterprise Manager (SQL Tuning Advisor, SQL Access Advisor, AWR/ASH reports), access structures (indexes, clustering, materialised views, partitioning);
- Oracle Security – account administration/privileges, user authentication/authorisation best practices, knowledge of Oracle Label Security (OLS), fine grained access control (VPD), Oracle Database Vault;
- Data loading and transformation utilities - SQL*Loader, Data Pump, External tables, Imp/Exp;
- Object Orientated Design and Development concepts as they relate to the application-database interface – Oracle Data Provider for .NET, OCI, JPA, ORM technologies;
- Data modelling – experience of domain, logical, physical data models using CASE modelling tools (Enterprise Architect), production of Entity-Relationship Diagrams in UML;
- Scripting - Shell / bash / batch scripting;
- OLTP large data processing, and high performance web applications;
- Oracle RAC development – cluster-aware solutions, high availability, failure resilience and production application supportability;
- Multi-environment delivery – environment-agnostic build scripting, execution of implementation and regression plans, documenting release procedures and walkthrough guides;
- Configuration Management tools and techniques – use of code repositories (SVN, Mercurial, SourceSafe), code branching, build/patching procedures, issue tracking/defect management;
- Test practices – effective use of unit / system / performance test and test automation methods;
- Quality assurance – peer code review, design pattern assurance, coding standards, best practice references, establishment of quality metrics;
- Software methods – Agile and RUP delivery methods, comprehensive understanding of software development lifecycle, provision of accurate effort estimates, undertaking work package ownership.
Mandatory skills and experience
- Data Warehousing - dimensional modelling, analytics, Business Intelligence concepts;
- Data Quality – profiling, cleansing, enrichment, data quality audit, standardisation, transformation, matching;
- XML/HTML – W3C’s XML schema, XSD, XSLT, XPath standards;
- Object Oriented languages – Java, C# .NET;
- Oracle Fusion Middleware – Weblogic and Oracle Application Server (OAS), Business Process Orchestration (BPEL/BPM);
- Oracle Internet Directory (OID) / LDAP / Single Sign On;
- Oracle Administration:
- Knowledge of Backup and Recovery techniques and using Oracle RMAN, Oracle Flashback and other methods;
- Installation and use of High Availability components; Oracle Clusterware, Oracle RAC, Oracle Data Guard;
- Installation and use of Oracle ASM (as well as traditional file system storage);
- Oracle GRID Control (or other approaches / methods of pro-actively monitoring critical database systems).
- Patching & upgrades (whilst minimising or eliminating the impact to Live services);
- Knowledge of advanced replication using Materialised Views, Streams and Advanced Queues.
Security Clearance is required for this vacancy. If you are not currently Security Cleared, you will need to be eligible for this and willing to go through the process. For more guidance on National Security Vetting please click here.
About BAE Systems Applied Intelligence:
We help nations, governments and businesses around the world defend themselves against cyber crime, reduce their risk in the connected world, comply with regulation, and transform their operations. We do this using our unique set of solutions, systems, experience and processes.
Our success is down to our people. The changing nature of our business means that we’re constantly looking for the brightest talent to help us fulfil our ambitions. As an experienced professional, we’ll entrust you with responsibility; this means that you’ll have client contact, variety and support from day one.
We'll encourage and support you to develop your skills and reward you as you grow. Whatever your area of expertise, you'll be much more than just a job title; you'll be an integral part of the business where your individual contribution makes a difference every day. Great minds deserve great rewards, so we also offer a very competitive salary and benefits package.
Diversity and inclusion are integral to the success of BAE Systems Applied Intelligence. Staying competitive in today’s global marketplace requires an organisational culture where employees with varying perspectives, skills, life experiences and backgrounds – the best and brightest minds – can work together to achieve excellence and realise individual and organisational potential. We also welcome discussions about flexible working.
Division Overview: UK Services
UK Services delivers IT Services and Consultancy to Applied Intelligence clients based primarily in the UK. We divide our clients into 3 market segments; National Security, Government and Enterprise Services. We differentiate ourselves through recognised expertise in Data, Security, Digital Media and Business Solutions.