SUMMARY

• Oracle Certified Professional with 14 plus years of experience in Database Installation, Administration, Configuration, Production support, Performance tuning, Backup and Recovery, Space Management, Database Security, Migration, schema maintenance in various platforms include UNIX, LINUX and HP - UX etc. Versions include 9i,10g,11g and 12c.
• Area of Expertise mainly includes Database support & maintenance, installation, configuration, administration, security management, memory management, backup, recovery, cloning, Golden Gate, up-gradation in RAC and Non RAC environments.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Proactive O/S, Applications & Database Maintenance & Monitoring.
• Expertise in Database Backup & Recovery strategies.
• Plan, test & implement the database Backup & Recovery strategy depending on the database size. Checking the daily, weekly, monthly backup status
• Expertise in Oracle Database Migration Activities (Across platform as well as same platform).
• Database Up gradation from oracle 10g, 11g R1 to Oracle 11g R2/12C using DBCA and Manual method.
• Database Refresh from PROD to DEV/QA/TEST servers using RMAN (Duplicate and Active Duplicate) and cloning.
• Applied CPU, PSU patches and regular bug patches with Opatch utility as per the business requirement.
• Implementing DR TESTING exercises for client requirement to maintain high availability for 10g/11g.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups and Created UNIX Shell scripts to automate database operation.
• Expertise at database administration activities such as monitoring database instances activity for blockers, waiting sessions, locks, dead locks, services start-up problems, Cluster management, connectivity problems, and max session reached errors etc.…
• Implementation of golden gate and replication using unidirectional method.
• Proficient in scheduling jobs, patches, alerting for databases, hosts and also database administration through OEM grid control.
• Maintaining the Technical document, Patch log and Activity log
• Creating and Managing Users, Responsibilities and Request Groups
• Planning for storage spaces requirements and placing them for optimum I/O performance.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g and 12c

O/S: RH Linux, IBM AIX 5.1, 5.2,6.0, Sun Solaris, HP-UX 10.x, 11.x & Windows 2003

Tools: Golden Gate, TOAD, DBverify, RMAN, Export & Import, Data Pump, AWR, ADDR, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, ASH,SQL Advisor and SQL*Loader.

High-Availability: Oracle 10g RAC / Oracle 11g RAC and Data Guard / Active Data Guard, Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, Reading, PA

Lead Oracle DBA

Responsibilities:

• Manage and support over 100+ databases, which includes Production and RAC (Real Application Cluster) databases.
• Setup, configuration and installation of the RAC environment and ASM.
• Applied latest releases of the RDBMS BP patches from Oracle to the Production and test instances to resolve technical challenges & issues.
• Restore and recover successfully production databases in RAC and ASM environment using RMAN.
• Convert successfully oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.
• Plan and perform recovery for Disaster Recovery Drill.
• Creating ASM Disk & Disk groups and Maintaining Oracle ASM instance.
• Adding nodes to existing RAC environment using RCONFIG.
• Cloned/Duplicated databases using RMAN backups whenever required by business.
• Done the database/schema refreshes from production databases to test/development servers.
• Manage Offshore and Onsite DBA Services including management of client work activities, understanding overall client and business deliverables.
• Prepare and Review Process documents for process improvements including ensure compliance with all laid down processes and procedures by all team members.
• Involved the database Capacity Planning for the future business growth requirement and suggest the input value to customer.
• Configured Data Guard (Physical Standby database) for the production database and tested for Switchover, Fail over, Activating the Standby to Primary Database.
• Monitoring of cluster resources on RAC environment with cluster server manager.
• Participation in Change review board meetings and coordinating with application support team and execution of change requests as per schedules.
• Documentation and maintain database, Fix the issues and provide root cause analysis.
• Migrating database using various tools such as EXPORT/IMPORT, RMAN and DATAPUMP.
• Golden Gate setup to achieve Unidirectional replication

Environment: ORACLE 10g/11g, Oracle 11g RAC, ASM, Red Hat LINUX, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Shell Scripting.

Confidential

Sr. Oracle DBA

Responsibilities:

• Manage and support 45+ Oracle databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation of Oracle binaries and Up gradation of Oracle databases from 11gR1 to 11gR2.
• Troubleshooting RAC startups, crashes, node evictions, reboots, corruptions, failover & failback of VIP.
• Synchronizing Standby databases with Production databases.
• Implemented DR TESTING exercises/snapshot standby feature for client requirement to maintain high availability.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backup.
• Database clone from PROD/DR to DEV/QA/TEST servers using RMAN (backup/restore and Duplicate/Active Duplicate).
• Extensive experience in Data Center Configuration and Migration from Linux to AIX.
• Migrating single instance database to RAC environment using rconfig utility.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups
• Applied CPU, PSU (+OJVM) patches and regular bug patches with Opatch utility as per the business requirement.
• Identifying fragmented tables and re-organizing tables and rebuilding indexes.
• Performed Data Centre Migrations from Linux to AIX.
• Performance tuning Using TKPROF, EXPLAIN PLAN, Automatic SQL Tuning, AWR and ADDM reports for the Better performance.
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose
• Provide support to Development Team with their SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.

Environment: ORACLE 9i/11g, Oracle 11g RAC, ASM, Oracle Solaris 10, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Shell Scripting.

Confidential, NA

Oracle Consultant

Responsibilities:

• Working 24*7 along with DBA team to maintain & support more than 1000 Oracle Database in Production (RAC & NON RAAC), Test and Development Environment.
• Perform day-to-day operations like troubleshooting client connectivity, user/application errors, monitoring database growth, review of alert, listener, alert log on time base for ORA errors and other logs, monitoring scheduled jobs that include statistics gathering, backups, snapshot refreshes etc.
• Responsible for, both manage and support all Production, Development and Staging instances of Oracle 9i.
• Generating Reports, Monitor Disk Usage and up-keep of the systems for the continuous production environment.
• Created several databases manually and also by using DBCA tool for supporting Production/QA/Test and Development environments.
• Tuning of the SQL Queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Monitoring and checking the RMAN hot backup and Logical backup (Export /Import), both scheduled in cron job.
• Installation & configuration of ORACLE Database Vault.
• Creating the partitioned table using Range, hash, list partitioning.
• Managing RAC Environment efficiently.
• Working on database application and performance tuning.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges), Oracle Configuration Management Pack.
• Troubleshooting database problems faced by the application developers/users.
• Managed appropriate use of free space within table spaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Creating technical documentation and imparting knowledge sharing within the team.

Environment: Oracle 9i RAC on Sun Solaris, Oracle Partitioning, RMAN, TKProf, Explain Plan.