|Database Administrator – Aldershot – 12 months
Database Administrator sought for a long term contract with a leading technology and communications client in Aldershot.
* Installing and configuring new instances of DBMS server software and related products - (Windows, Linux, Solaris, etc). * Installing and configuration of RAC database with Grid Infrastructure. * Configuration and management of database vault and database wallet with TDE usage for tablespace. * Database design, table design and data modeling user management schema creation, grant and connection details etc. * TNS / database listener management for connectivity with different servers and database users. * Physical backup and restore with Rman and with any tool like TSM or networker etc. * Database logical backup and recovery like exp/imp and expdp/impdp. * Performance and tuning of complex queries of used by users. * Support Oracle databases * Take care of the Database design and implementation. * Setup and maintain documentation and standards including providing consulting expertise on detailed Installation Instructions and Managed Service Guides * General technical troubleshooting and giving technical expert consultation * For complex issues work with the vendors / 3rd party providers to ensure issues are fixed on a time-bound manner * Maintain databases including carrying out support / administrative tasks such as DB installation, DB patching, database backup, Oracle DB tuning, RAC setup, partitioning, database upgrades.
Required Skills and Experience
* Familiarity with the main data manipulation languages and the principles of database design * Experience in installing and administering Oracle 8i, 9i, 10g,11g (12C will be added advantage). * Knowledge of ASM storage and management. * Knowledge of PSU installation and database patch apply. * Management of database objects like table, index, view, materialized view, synonym etc. * Working experience in Stored Procedures, function, Package, Trigger, Views, and Collections in PL/SQL. * Experience working with customers across teams. * Oracle DBA experience in supporting application development. * Hands-on SQL and PL/SQL coding skills * Database migration from same platform across the platform with different versions of the database. * Database upgrade from old version to new version * Knowledge of GUI tools for database management (OEM) and knowledge of any incident management tool
Capita IT Resourcing is acting as an Employment Business in relation to this vacancy