EXPERIENCE SUMMARY:

A highly result oriented skilled Oracle DBA certified Professional with extensive experience in Database Administration on production databases, good team player, organization with excellent communication skills. Highly skilled in the major Oracle database versions 12c, 11g, 10g 9i , Oracle Exadata database machine, Oracle GoldenGate and a wide range of operating systems UNIX IBM AIX / HP-UX / Oracle Solaris /Linux, Exadata and Windows platform.

KEY STRENGTHS:

• Oracle 10g Certified DBA Professional with more than 13 years of experience in 12c/11g/10g/9i Oracle Database upgrade, database cloning, patching, installations building new data servers, DB migration, administration, performance tuning, backup recovery, data guard.
• More than 15 years experiences in Unix-like system administration including IBM AIX / HP-UX / Linux . Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl.
• 6 years' in-depth knowledge and solid hands-on experiences of installation, configuration, trouble-shooting and performance tuning in Oracle 10g/11g R2 RAC Real Application Cluster , ASM Automatic Storage Management , Data Guard physical standby database , Oracle Golden Gate replicate software, Oracle Enterprise Manager.
• More than 5 years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate OGG in Oracle to Oracle homogeneous environments and heterogeneous environments including Oracle to Oracle and MS SQL Server to Oracle .
• First hands experiences in setting up Oracle Goldengate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.
• Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Deep understanding Oracle Goldengate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicat.
• Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM Oracle Enterprise Manager 12c.
• Three years first-hand administrative experiences in Oracle Exadata database full rack machine administration, migration, health check, resource management, patching/upgrade and SQL tuning.
• First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC Hybrid Columnar Compression , Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
• Proficient in Oracle database backup recovery strategies plan and implementation such as RMAN backup with/without catalog, cold and hot backup, full/incremental backup. Hands on experience in disaster recovery.
• Solid hands-on experiences in developing complex database objects like Stored Procedures, Functions, Package and Triggers using SQL and PL/SQL.
• Performance tuning, capacity planning, hot standby databases, database cloning, refresh, and patch.
• 24x7 on call technical support in monitoring, managing and solving production database issues.
• Self-starter, highly motivated, technically sound, training and monitoring skills in driving development teams to successful resolution.

SKILLS PROFILE:

PROFESSIONAL EXPERIENCES

Confidential

Role Responsibility: Sr. Oracle DBA

• Oracle Database Administration 10gR2, 11gR2 and 12c on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control on both Exadata machine, Linux X64 server and IBM PowerPC p770, including very large databases more than 50 TB.
• Worked with a team for installation and maintenance of Oracle 11gR2 RAC, ASM database for high availability.
• Leading the Team of 5 DBAs and managed Databases in the range from 800GB to 50TB with more than 40 instances.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .
• Setup both the one-way and the active-active data replication system and design the conflict detection solutions.
• Effectively decrease Oracle Goldengate lag by using various technical methods such as database tuning, OGG parameter tuning, application large table re-design, Linux/Unix kernel performance tuning, etc.
• Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments from MS SQL Server to Oracle Exadata .
• Setup the OGG lag monitoring scripts and plug-in in OEM 12c.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 11g Real Application Cluster RAC / ASM on Redhat Enterprise Linux 5.x boxes.
• Upgrading and migrating the database to different version depending on Business requirements. For Example 10g R2 to 11gR1, 11gR2 to 10gR2 on different OS
• Applying CPU, PSU and other patches using opatch utility.
• Maintenance of production database and development database which includes table space management, user creation, and privileges, roles Tables, Indexes and Security of database etc.
• RMAN Backup and Recovery. Physical Hot Cold backups and logical backups using Export/Import. Extensively use of shell scripting.
• Implementing and maintaining database security create and maintain users, roles and assign privileges
• Tuning of Database Tuning of Shared Pool, Buffer Cache, Redo Buffers, and Rollback Segments .
• Managing Privileges, Roles, and Users, Setup Disaster Recovery solutions Dataguard , Tuning, Migration Services, Backup and Recovery with RMAN and Shell Scripts over highly volume Terabyte Databases.
• Installation and configuration of Oracle Server 11gR2 RAC with ASM on multi node systems, in different operating systems for OLTP environment on Very Large Databases VLDB .
• Design and implementation of Backup and Recovery strategies both cold and hot backups and performing periodical backup, restoration and recovery using RMAN full and incremental
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, AWR, ADDM, ASH, EXPLAIN PLAN, STATSPACK, Data Pump, FLASHBACK and RMAN.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Weekly meetings with the team to discuss on-going issues. Plus handling customer escalations.
• Worked on Sev1, Sev2 Issues and also providing 24 7 On-Call Support and provided on-call and day-to-day support.
• Has the ability to work in a fast paced environment, Good team player and can work independently.

Confidential

Role Responsibility: Sr. Oracle DBA on Exadata Platform Consultant

• Management of table spaces such as dropping/creation and modification of storage parameters for disk optimization, coalescing table spaces regularly in case of fragmentation and analyze the statistics periodically and taking remedial action.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments. Monitoring the data fragmentation on data files performed the periodic export and import to avoid fragmentation. Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Maintaining the database security by granting of roles and privileges to the users. Monitor database performances and maintained daily backup, recovery, tuning of the database, tracking assigned projects and resolving or escalating issues to appropriate management levels.
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases.
• Extensive Performance Tuning, Memory SGA Tuning, Instance Tuning and evaluating system performance.
• Expertise in cloning schemas, objects and data on new server using exports from 9i database and imported to 10g using Oracle data pumps.
• Expertise in Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN and customized shell scripts.
• Experienced in working on high profile, externally facing, revenue generating, large-scale projects.
• Setting up logical / physical backups for these databases. Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Supported Oracle Development, test, and Production databases.
• Strong skills in Recovery Manager RMAN , Unix Shell Script for backup to disk/tapes, recovery, export/import, daily maintenance Crontab .
• Successfully implemented bi-directional replication using Oracle Streams and worked on minimizing the conflict resolution.
• Created implemented export import and backup shell scripts as per specifications.
• Cloned production database to refresh development, test databases on a periodic basis.
• Performed day-to-day activities, Such as daily health checkup of the database server using alert log, Statspack, AWR, ADDM, TKPROF, Explain plan.
• Proficient in troubleshooting and rising tar with Oracle Metalink for various database issues, upgrades, patches and performance issues.
• Performance tuning such as shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.
• Proficient in UNIX shell scripting in korn shell to be controlled from Crontab. roficient in using export/import for schema, table and database refresh.
• Proficient in raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.
• Installation, maintenance and tuning of Oracle 10g RAC/Standalone databases including ASM and CRS.
• Involved in Design, implementation and generating documentation of Oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Involved in Set up, configuration and maintenance of oracle data guard primary and standby databases to ensure disaster recovery, high availability and data protection.
• Involved in a major tuning project which involved creation of aggregate tables, hash and range partition tables for very large tables, materialized views and snapshots to store derived data, fully indexed tables for look-up tables
• Installation, maintenance and tuning of Oracle 10g RAC/Standalone databases including ASM and CRS.
• Involved in troubleshooting the issues on Cluster software configuration across the nodes like session and Data base configuration issues.
• Involved in Installation of 11g RAC on 2 node cluster and migration of Non RAC to Stand Alone Databa-set
• Disaster recovery management defined and implemented Production DR Databases, administration for log-shipping/stand-by database systems.
• Designed, Architect Managed Logical structures like Tables, indexes, clusters, Database links, Snapshots physical structures like db files, log files.
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL trace and query optimization using cost-based optimizer.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• For performance enhancement implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Responsible for online and offline backups and recoveries of the oracle database.
• Strong skills in Recovery Manager RMAN , Unix Shell Script for backup to disk/tapes, recovery, export/import, daily maintenance Crontab .

Confidential

Role Responsibility: Oracle DBA Consultant

• Responsible for 47 production and 64 non-production instances on various Linux and IBM AIX platforms located in different data centers in the U.S.
• Worked in a Team, handling more than 15 clients for Production support working in day to day maintenance of development and QA databases.
• Excellent knowledge of oracle 9i, 10g 11g architecture and administration, good understanding of new features.
• Performed installation, configuration, maintenance, and upgrades of Oracle development, QA, and production databases, including installation and upgrades for client/server software.
• Install, upgrade and maintain database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.
• Installation Creation of Oracle Database 9i/10g/11g on IBM AIX and Redhat Linux.
• Oracle Production database upgrade from Oracle 10g Database 4 node RAC database to 11g
• Implementing the incremental, cumulative incremental and full RMAN backup for each database to have space management and effective recovery.
• I worked closely and established good relationships with developers, SA's for discussing infrastructure support, recommendations and implementation to resolve development production issues
• Managing table spaces, adding data files, resizing data files, reorganizing table spaces to claim the space and to improve the performance.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed table spaces, Database Sizing, Rollback table space, Transaction Management, Security Administration
• Performed daily alert log files, trace files check, and general data consistency data integrity check.
• Tuning of Database Tuning of Shared Pool, Buffer Cache, Redo Buffers, and Rollback Segments
• Leading Oracle DBA Team for maintenance and Operational Support of Oracle Databases.
• Troubleshooting Diagnosis Oracle ASM databases and application Issues. Configure Database for Optimum performance on Sun Solaris.
• Cloning Oracle database through RMAN Duplicates. Maintaining the Oracle Backup and recoveries through RMAN.
• Day to Day Management of the performance of database to ensure they are operating effectively and make changes to environment as business needs.
• Refreshing /Cloning the database and application on demand or as per change request.
• Tuning of Oracle Database for locking, Wait Events using statspack, AWR, ADDR reports .
• Develop UNIX shell script to automate morning health checks.
• Hands-on experience in maintaining/modifying/adding cron-jobs and database jobs shell scripting in csh and ksh
• Raise and follow up Metalink Technical Assistance Request for resolving Severity 1 issue
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Providing 24 7 basis with on call weekend support.

Confidential

Role Responsibility: Java and Oracle PL/SQL Developer

• Build user interface using JSP and Java Script and dveloped EJB beans to create the business logic.
• Understanding business requirements. Involved in the SDLC process. Involved in writing Technical Design Document and Solution Specification and creating class diagrams. Used Spring Framework to build various modules of the system.
• Development of the persistence layer of the application object structure using Hibernate.
• Understanding of business requirements Involved in all the modules of the application. Prepared Technical Design Document to understand the flow of the application. Participated in the analysis, design and the development of different modules for the integration with the application.
• Involved in a team of designed and developers to design and implement the core modules. All Modules in the application are based on MVC architecture and J2EE technologies. Used design patterns to delegate requests to appropriate session EJB.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Loaded source data files with SQL Loader and imp/exp utilities.
• Created Oracle database objects tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views , PL/SQL Procedures/Functions/Packages, SQL and Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and reports needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Designed Test Plan and Test Cases according to Functional Requirements and design specifications of the application and executed them with testers. Implemented Unit Testing Stored Procedures, Functions, Packages and Triggers.
• Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Created PL/SQL packages, stand alone procedures, and stand alone functions. Wrote complex SQL queries with sub-queries, analytical functions and inline views
• Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.