Lead Admin-DBA3 Days OfficeDublin2-3 Weeks' Notice prefferedDuration :1 YearMandatory Skills: Oracle Database.Experience: 5-8 YearsRole & ResponsibilitiesHandled large database estates and managed TB size of databasesInstallation and administration of multiple versions of databases on multiple Unix platforms and Windows serversDesign and implement the high availability solutions (RAC, Golden Gate and Dataguard)Install, configure and manage ASM instances in oraclePlan and execute major migrations and upgradesDefine and configure the disk and diskgroups in ASM and troubleshootManage and administer the databases on Exadata machinePlan the database upgrade, migration and patchingPlan and implement the backup/recovery on need basisHardware tech refresh (host to host database move)Coordinate and work with database vendors for resolution on major incidentsDatabase refresh, re-org, backup using RMAN and 3rd party toolsInstall and configure grid control database monitoring toolsInstall, Administer, manage and troubleshoot Oracle grid controlDefine performance benchmarks and metricsPeriodic database instance performance review and tuning recommendationProactive database analysis and suggestion to application team / businessWrite and troubleshoot shell scripting, SQL and PL/SQL scriptsPrimarily role is supporting the production and non-prod database environmentsEnsure the reduction of repeated errors through implementation of necessary checkpointsContribute towards evaluation of tools, products and software selectionSLA tracking and reporting to Higher managementPrepare and Maintain Standard Operating Procedure for all activitiesProactive identification of risks and mitigation of the sameTechnical presentation on emerging technologies.Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager.Implement and Periodical check on AutomationImplement and Periodical check on DB SecurityIdentify, document and track Technology related risks and mitigation plan in the projectTechnical and Process guidance to L2 and L1 DBAProvide 24x7 and on call support for critical application databasesSkillsMust have / Nice to HaveTechnical Skills (Core & Top-Up)Strong database administrationDatabase upgrades on multiple versions and releasesHigh availability (RAC) setup and administrationDisaster recovery design, planning, setup and administer the Dataguard (standby)Install, configure, maintain and troubleshooting on Golden GateKnowledge on ExaDataOEM Configuration and managementAutomation through scriptingStrong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory viewsExperience on OS, Storage, Network and Virtualization activitiesCertification on Primary TechnologyHandled database estate of various technologiesProcess & ToolsService Request and Incident, Problem, Change managementsConfiguration, Capacity planning and Knowledge managementExperience on ITIL Tools like Remedy, Service Now or any other ticketing toolIdentify the service improvement planITIL Foundation certifiedBehavioral SkillStrong verbal and written communication skillsTeam management and motivationFlexibility, good attitudeManage the global infrastructure customer and projects