Oracle DBA - 2113595

Company:  Diverse Lynx
Location: O'Fallon
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Location: O'Fallon, MO (Onsite)

Location: O'Fallon, MO

Job Role: Oracle DBA

Required Skills:

Handled large database estates and managed TB size of databases

Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers

Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)

Install, configure and manage ASM instances in oracle

Plan and execute major migrations and upgrades

Define and configure the disk and diskgroups in ASM and troubleshoot

Manage and administer the databases on Exadata machine

Plan the database upgrade, migration and patching

Plan and implement the backup/recovery on need basis

Hardware tech refresh (host to host database move)

Coordinate and work with database vendors for resolution on major incidents

Database refresh, re-org, backup using RMAN and 3rd party tools

Install and configure grid control database monitoring tools

Install, Administer, manage and troubleshoot Oracle grid control

Define performance benchmarks and metrics

Periodic database instance performance review and tuning recommendation

Proactive database analysis and suggestion to application team / business

Write and troubleshoot shell scripting, SQL and PL/SQL scripts

Primarily role is supporting the production and non-prod database environments

Ensure the reduction of repeated errors through implementation of necessary checkpoints

Contribute towards evaluation of tools, products and software selection

SLA tracking and reporting to Higher management

Prepare and Maintain Standard Operating Procedure for all activities

Proactive identification of risks and mitigation of the same

Technical 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 Automation

Implement and Periodical check on DB Security

Identify, document and track Technology related risks and mitigation plan in the project

Technical and Process guidance to L2 and L1 DBA

Provide 24x7 and on call support for critical application databases

Technical Skills

Strong database administration

Database upgrades on multiple versions and releases

High availability (RAC) setup and administration

Disaster recovery design, planning, setup and administer the Dataguard (standby)

Install, configure, maintain and troubleshooting on Golden Gate

Knowledge on ExaData

OEM Configuration and management

Automation through scripting

Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views

Experience on OS, Storage, Network and Virtualization activities

Certification on Primary Technology

Handled database estate of various technologies

Process & Tools

Service Request and Incident, Problem, Change managements

Configuration, Capacity planning and Knowledge management

Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool

Identify the service improvement plan

Secondary Skill

OS - Solaris/Linux/AIX/Client UNIX & Windows

Database - MySQL/MS SQL & Windows OS / Sybase /

DB2 / /MongoDB/SAP HANA

Sincerely Yours,

Shashi Bhushan Kumar

Diverse Lynx, LLC

300 Alexander Park Suite # 200

Princeton, NJ 08540

Tel: (phone number removed) Ext.344

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.

 

Apply Now
An error has occurred. This application may no longer respond until reloaded. Reload 🗙