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
+91- 9390112851