Senior Oracle DBA | Capgemini

Design develop implement and maintain our core Oracle database Ensure DB availability Proactively manage and maintain security standards and controls Actively seek to optimize and simplify our architecture Take ownership of performance and capacity monitoring aspects of the DB Execution of data migration jobs and scripts as required Assist the infrastructure team in sizing hardware used for the DB Support and collaborate with product developers Understanding and expert knowledge in OEM working of ILOM ODA BASE Query tuning for optimal performance Troubleshooting knowledge on query for degraded performance Ability to provide recommendations to Client for faster execution of queries SPs Contribute to the creation and maintenance of disaster recovery plans Create a reliable backup strategy Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality Determine and document DB policies procedures and standards Performance testing and evaluation to ensure data security privacy and integrity Identification of bottle necks and deadlock issues Ensure SLA s operational KPI s are met working as necessary with internal and external support functions when major incidents occur Competencies Ideally Oracle Certified DB Professional OCP with more than 5 years experience with Oracle preferably in a lead role Experience should include DB design modelling and normalization capacity planning performance tuning storage management backup and recovery managing schemas report generation and DB clustering technologies Operating system experience in Linux Oracle management tools Data Guard RMAN Data pump Partitioning Architecture design principles Good problem solver focused and dedicated developer with ability to work on your own as well as with a team Hands on experience with DB standards and end user applications translating capacity requirements into infrastructure deployment technology Strong practical experience of ORACLE in a production RAC ASM Latest environments Must be a self starter with a strong attention to detail Experience with an Organisation with a key reliance on 24x7 reliability on its database Hands on experience in Performance tuning Backup and recovery Having Development experience together with CORE DBA will be added advantage Expert in database PSU and CPU patching and planning Ready to work in 24 7 shifts and on call Good communication skill