Oracle DB administration

Position:  Oracle DB administration

Work Location: Trivandrum / Bangalore

 Duration:  6 – 12 Months Contract to Hire

Experience: 5+ Years

 Job Description:

Evaluate the Database Server Hardware

Please, Install and create the Oracle Database Software

Back Up the Database

Implement the Database Design

Back Up the Fully Functional Database & Tune Database Performance

Manage Oracle Exadata environment, coordinate with 3rd party support, coordinate with application owners on patching activities, cohesively and collaboratively work with peers

Strong knowledge of Installation, configuring and maintaining of Oracle GRID infrastructure and applying of Oracle Quarterly patches

Administering Clusterware, RDBMS, ASM, and OEM patching, installation, and configuration

Deploying and maintaining high availability and failover technologies including Data Guard, Disaster Recovery, and RAC

Handling physical backups and recovery through RMAN, including duplication, refresh, and cloning in Standalone, RAC, and Data Guard environment

Experience with Golden Gate CDC for data replication across datacenters to ensure real-time data availability

Identifying poor SQL statements using AWR, ADDM, SQL Trace, OEM Grid Monitoring, customized scripts, and analyzing details using EXPLAIN PLAN, STATSPACK, and TKPROF

Tuning performance using SQL tuning Advisor, SQL access Advisor, creating hints, SQL baselines, new indexes, and SQL profiles

Developing automation scripts through shell, PL/SQL, and automation software to enhance stability and speed of task implementation, development, and support

Defining, implementing, and enforcing database security standards in compliance with company policies and compliance frameworks including SOX and PCI.

Thanks & Regards

Lavanya

lavanya@burgeonits.net

+91- 9390112851

Scroll to Top