Diverse Lynx
Lead Oracle DBA
Diverse Lynx, O Fallon, Missouri, United States, 63366
Lead Oracle DBA
Location: O'Fallon, MO (Onsite)
FulltimeNeed Lead exp 4years with total 9+Years expTech Expertise:RAC ClustersGolden GateData GuardRequired Skills:
Handled 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 databases
Technical Skills
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 & Tools
Service 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 planSecondary Skill
OS - Solaris/Linux/AIX/Client UNIX & WindowsDatabase - MySQL/MS SQL & Windows OS / Sybase /DB2 / PostgreSQL/MongoDB/SAP HANA
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location: O'Fallon, MO (Onsite)
FulltimeNeed Lead exp 4years with total 9+Years expTech Expertise:RAC ClustersGolden GateData GuardRequired Skills:
Handled 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 databases
Technical Skills
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 & Tools
Service 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 planSecondary Skill
OS - Solaris/Linux/AIX/Client UNIX & WindowsDatabase - MySQL/MS SQL & Windows OS / Sybase /DB2 / PostgreSQL/MongoDB/SAP HANA
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.