Oracle Developer

BAE Systems Applied Intelligence
United Kingdom
11 Nov 2017
17 Nov 2017
Contract Type
Full Time
The Applied Intelligence division of BAE Systems delivers solutionswhich protect and enhance the connected world. Everything we do createsa safer future. We want to solve problems for our customers and by bringing togethergreat minds, we can work together to make the world a safer place.Job summaryThis Oracle Developer will work across multiple projects within adelivery centre in a secure Government client. This role is based onclient site and London. Security Clearance is required for this vacancy.If you are not Security Cleared presently you must be willing and ableto qualify for the processKey Responsibilities 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. #AI-DICE#LI-LL1 Security Clearance is required for this vacancy. If you are notcurrently Security Cleared, you will need to be eligible for this andwilling to go through the process. For more guidance on NationalSecurity Vetting please click here. About BAE Systems Applied Intelligence: We help nations, governments and businesses around the world defendthemselves against cyber crime, reduce their risk in the connectedworld, comply with regulation, and transform their operations. We dothis using our unique set of solutions, systems, experience andprocesses. Our success is down to our people. The changing nature of our businessmeans that we're constantly looking for the brightest talent to help usfulfil our ambitions. As an experienced professional, we'll entrust youwith responsibility; this means that you'll have client contact, varietyand support from day one. We'll encourage and support you to develop your skills and reward youas you grow. Whatever your area of expertise, you'll be much more thanjust a job title; you'll be an integral part of the business where yourindividual contribution makes a difference every day. Great mindsdeserve great rewards, so we also offer a very competitive salary andbenefits package. Diversity and inclusion are integral to the success of BAE SystemsApplied Intelligence. Staying competitive in today's global marketplacerequires an organisational culture where employees with varyingperspectives, skills, life experiences and backgrounds - the best andbrightest minds - can work together to achieve excellence and realiseindividual and organisational potential. We also welcome discussionsabout flexible working. Division Overview: UK Services UK Services delivers IT Services and Consultancy to AppliedIntelligence clients based primarily in the UK. We divide our clientsinto 3 market segments; National Security, Government and EnterpriseServices. We differentiate ourselves through recognised expertise inData, Security, Digital Media and Business Solutions. Help us secure a connected world by being an unseen hero. Apply now andbe inspired. - provided by Dice ORACLE, ORACLE APPLICATION SERVER, ORACLE DATABASE, ORACLE ENTERPRISE MANAGER, ORACLE RAC, ORACLE RMAN