DV Cleared Oracle PL/SQl Developers (Applicants must hold live DV Clea

We are looking for a DV Oracle Developer to work on a number of systems across a large Delivery Portfolio within a secure Government client. The role will be for a minimum of 3 months but there could be the potential for further work and follow on opportunities.

Essential Requirements

- 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 Vau
- 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;
- Datamodelling - 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 life cycle, provision of accurate effort estimates, undertaking work package ownership.

Desired Requirements

- 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
- Knowledge of advanced replication using Materialised Views, Streams and Advanced Queues.