Oracle DBA / Developer

Tender description

Who Speclialist Work With Specialist will be part of data architecture team working closely with the Enterprise Data Architect. Specialist will be required to work with multiple development teams and existing vendor to understand legacy and new data structures. What Specialists Work On Specialist required to work in the data migration team to identify source data requirements, assess data quality, map and specify the required transformations from the source to the target data, validate and perform trial data migration in production, cleanse data, and conduct a post implementation review of the data migration. Where the Work Takes Place Westminster,Victoria Early Market Engagement Working Arrangements We expect the specialist to work collaboratively with project teams that are transforming Her Majesty’s Passport Office business/processes/applications. Work is based in London and will involve being on site 5 days per week. There may be an occasional need to attend our other offices in Central London (Petty France). No travel expenses will be paid for this purpose. Expenses for any exceptional travel authorised outside of Central London will fall under the Standard Government Terms and Conditions for Expenses as covered in the DOS Contract. Service design and development must align with HM Passport Office strategic technical architecture and technologies. Work Location Westminster,Victoria Security Clearance DV (Developed Vetting) clearance is required Additional T&Cs Breakpoints to assess progress and quality will be set by mutual agreement. Skills & Experience Demonstrable experience of successfully designing and implementing data migration, data transformation, data quality, modelling, testing and post production reviews from Oracle to a Big Data or another relational database. Have demonstrable experience of successfully implement Oracle Advance Security and manage personal and/or sensitive information with appropriate controls and protection. Demonstrable experience of Backup and Recovery techniques& using Oracle Administration& Oracle RMAN, Oracle Flashback and other methods, including Patching & upgrades (whilst minimising or eliminating the impact dependent services) Have demonstrable experience of High Availability components; Oracle Clusterware, Oracle RAC, Oracle Data Guard Have demonstrable experience of PL/SQL and Advanced Queues. Nice to Haves Have demonstrable experience of successfully and collaboratively working, coaching and sharing knowledge with Public Sector client teams. Have demonstrable experience of Her Majesty's Passport Office business processes and data stores. Have demonstrable experience of mapping source and target data models, identify gaps, data cleansing, schema modelling (Relational/XML/JSON). Have existing, valid DV Clearance No. of Specialists to Evaluate 3 Cultural Fit Criteria Be transparent and collaborative when making decisions. Take responsibility for their work. Can work with clients with low technical expertise. Able to work within Her Majesty’s Passport Office design, delivery and governance framework. Assessment Method Evaluation Weighting Technical competence 60% Cultural fit 15% Price 25% Questions from Suppliers Budget range