Description
Professional Summary: * Total 11 years of experience as Oracle Database Administrator and experience on UNIX (Solaris, HP-UX, AIX), Linux, PL/SQL, Sql etc. * One year experience in handling Oracle EBS (Patching, cloning, troubling EBS performance issues). * Oracle Certified (10g) Database Administrator * Hands on experience of 9i/10g/11g/12c RAC implementation, maintenance and support, Oracle Data guard (10g/11g/12c) both logical & Physical Standby experience on Unix & Windows XP/NT servers. * Expertise in OEM 12c Cloud control and 10g Grid Control. * Extensive experience with Oracle Database Migration/Upgrade from 9i to 10g and from 10g to 11g. * Extensive experience of PSU patching and bug fixes on the top of Oracle RAC/Non-RAC Production/Non-Production databases. * Currently managing 200+ Oracle Production Support Databases with the total size of 15.0+ TB and 900 Oracle Instances on Dev/Test and Production Environment. * Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g), 11g/10g/12c Data pump (expdp, impdp) and 9i Export Import (exp, imp), hot/cold backups. * Good hands on experience in Shell scripting. * Database replication using Golden Gate and administration. * Experience as On-Call 24x7 production DBA support, development DBA. * Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments. * Strong experience in tuning database performance from system as well as query tuning perspective. Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning. Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, PL/SQL. * Working experience with Very-Large databases (VLDB), data migration. * Expertise in Managing Large Scale Projects. Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC * Developing and Implementing Disaster Recovery (DR) Plan. * Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose. * Daily Health Check Up of the Database. * Database cloning from Production to Test and Development environments. * Configured and maintained huge OLTP databases. * Monitoring Table spaces and extent Growth. * Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly. * Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP. * Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports. * Experience in Identifying performance bottlenecks on high volume transaction systems. * Analyze SQL statements, reorganize database objects and design indexes to improve response of queries. * Job scheduling using crontab. * Implemented RMAN Backups, Creation of catalog database. * Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption). * Performed full and incremental backups using RMAN * Ensure high availability of Databases at all time. * Support migration and loading of data into oracle database using SQL*Loader. * Performed and scheduled re-orgs. * Provided support on performance issues during project development resulting in improved response times and reduced contention. * Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration. * Implemented database auditing, data security and Remediate high-risk violation in production environment. * Developed PL/SQL programs (Functions, Procedures, Packages and Triggers). * Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management * Created Users, Roles and Managing Security & Concurrent Managers administration. * Writing UNIX shell scripts for backup and recovery, Import and export procedures. Environment: Oracle DB 10G/11GR2, GolenGate, Data Guard, Data Domain, Redhat Linux, HP-UX, Netbackup, Shell (sh, ksh, bash, perl, python), OMS, OEM.
Accomplishments
Highlights:
Keywords
