SUMMARY:

• Over 10+ years experience in the Information Technology field, with comprehensive hands - on expertise in development, production database administration and database application development. Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams. With experience in both Finance and Healthcare across a wide variety of systems and companies from large to small.
• Experience as Oracle DBA (12c/11g/ 10g/9i/8i) on different Sun Solaris, Linux, AIX, and Windows environment.
• Experience in full life cycle of database administration. Worked both as a development and a 24x7 Production Support DBA.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 10g,11g and 12c.
• Extensive hands-on and managerial experience in the design, construction and deployment of data warehouse systems.
• Experience in configuring Automatic Storage Management (ASM) to administer the oracle related files.
• Worked on data warehouse tools. Involved in defining staging area Metadata, Data Mart, defining & populating the Enterprise Model warehouse, Incremental Data loading
• Extensive experience in installing, upgrading and applying patches to various versions of oracle (12c/11g/10g/9i/8i). Duties included raising Oracle SR support to deal with bugs and issues associated.
• Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
• Installed and configured Oracle 12c (12.1.0.2) RACDatabase on HP-UX and Linux advance Server on Development, Test and Production boxes.
• Involved in disaster recovery planning, detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
• Experience in performingHot and cold backups with and without RMAN.Automated RMAN scripts using cronjob to perform daily backups.
• Expertise in database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Experience in Performance Tuning (I/O, Memory & SQL/PLSQL Tuning) using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Over 5 years of experience working with Oracle Golden gate for performing database upgrades, Cross platform migrations and Replications.
• Monitoring and Management of various Database Components (Logical & Physical) like Tablespaces and Segments for space management.
• Experienced in troubleshooting traditional export/import and datapump export/import.
• Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
• Creating high level and detail design for applications. Creating and execution of test cases/test plans. Executing test cases and test scripts for data validations.
• Experience in Operational data store, data cleansing, backup and restoration strategies.
• Highly motivated individual and good team player.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

HP: UX 10.x, 11.x, Sun Solaris 8, 9, 10,11 AIX 5.2,6.1, RHEL 6.x,7.xand Windows 95/98/NT/2000/XP

Database: ORACLE 8i/9i/10g/11g/12c,SQL Server (2008,2005,2003)

HighAvailability: RAC (9i/10g/11g/12c), Data Guard (Physical and logical standby setup), Goldengate 10g/11g/12c

Tools: OEM (Oracle Enterprise Manager), RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus, TOAD, Data Guard, Putty, Statspack, Opatch, Winscp3, Virtual Network Computing with PC Anywhere and VNC.

Languages: SQL, PL/SQL, C, shell scripting, Html, Java, and JSP

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. Oracle DBA

Responsibilities:

• Worked as an Oracle Production DBA (11g/12c) on Supercluster(T5-8/M-6/M-7) on Solaris 10/11.
• Installed and administered Oracle Real Application clusters (RAC 11g) on a 4 node T5-8 Supercluster and Automatic Storage Management (A.S.M).
• Installed and configured agents on 12c O.E.M on a Supercluster T5-8.
• Maintained and Migrated databases upto10TB .
• Implement IT Control Policies in planning, designing, developing, and testing of applications(APEX/COGNOS/JDE).
• Create and Implemented Data warehouse 11G Databases for Projects working with Tableau Application.
• Performed Tuning, coding and Monitored OEM.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Involved in Oracle partitioned tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Tune the application queries and identify the resource, database and design issues. Modify and implement new changes without affecting the functionality of applications and end-users for reporting server.
• Involved in the Migration of database from 11.2.0.4 to 12.1.0.2.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Knowledge on stand-alone database using Oracle Data Guard feature for High availability configuration.
• Database administration activities including Tablespaces allocation, user enrollments and database re-organization.
• Extensively worked on identifying high load sql statements and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Ensuring that adequate recovery procedures are in place, based on: Database backups being done and verified.
• Effectively manage issue identification and resolution process.

Environment: Oracle 12c/11g/10g,SqlServer2005,2008, Solaris 10/11, GG 11/12, MS Windows, RMAN, OEM 12c

Confidential, Irvine CA

Sr. Oracle DBA

Responsibilities:

• Worked as an Oracle Production DBA (10g/11gR2) on Supercluster T4-4/T5-8.
• Installed and administered Oracle Real Application clusters (RAC 10g) on a 2 node Linux cluster using Oracle Cluster File System (O.C.F.S) .
• Configured 11g two node RAC on new supercluster T5-8 as required by the project specification to support COGNOS and other business applications.
• Migrated Non ASM databases to ASM.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Worked with architect, application and infrastructure teams on implementing customer-servicing application releases and infrastructure projects
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Involved in Oracle partitioned tables and Worked with Oracle AMR Support Team to apply patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Involved in the Migration of database from 10.2.0.3 to 12.1.0.2.
• Implemented High availability using Golden Gate Replication.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Knowledge on stand-alone database using Oracle Data Guard feature for High availability configuration.
• Implemented Oracle Enterprise Manager Grid Control and configured agents.
• General DBA tasks including physical/logical design creation of tablespaces, monitoring space usage, capacity planning, checking fragmentation, reorganization
• Extensively worked on identifying high load sql statements and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Ensuring that adequate recovery procedures are in place, based on: Database backups being done and verified.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Environment: Oracle 12C/11g/10g,SqlServer2005,2008 Solaris 11,RHEL 7, AIX 6.1, RMAN,OEM 11g/12c/13c,GG 11/12.1/12.2

Confidential, OH

Oracle DBA Manager

Responsibilities:

• Worked as an Oracle DBA(9i/10g/11g) on Linux,AIX and Windows servers.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance and managing data lifecycles.
• Involved in extracting data from source & interface systems data warehouse system (ETLprocess) using DTS & SQL Loader.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack. Installed and configured OEM GC and intensively used for Diagnostic & tuning activities.
• Maintained Production databases upto 10TB.
• Configured RAC on oracle 11g R2.Migrated the Production & Non-Prod Database from Oracle 10 g Using Goldengate.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Maintain the scheduling, distribution, and refresh for reports, views, and OLAP Performance tuning and support of application servers Defining and managing database connectivity to multiple sources and target databases.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Handled large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) Grid control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Performed migration of databases, schemas, objects and data from 9i to 10g databases and single node to cluster databases using traditional export and Datapump.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 11g/10g/9i,SqlServer2005,2008 HP-Unix 11i v3, Solaris 10,RHEL 5, AIX 5.2, MS Windows,RMAN, OEM

Confidential, OH

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA(9i/10g/11gR2) on Linux, Sun Solaris and AIX servers.
• Installed and administered Oracle Real Application clusters (RAC 11gR2) on a 3 node Linux cluster using VERITAS Cluster File System (V.C.F.S).
• Responsible for Installing, upgrading, Implementing and supporting oracle 10g R1/R2 and 11g R1/R2 databases.
• Involved in Installing and maintaining of Sun Solaris (SVE) Active/Passive Cluster on Oracle 11gR2.
• Involved in administration of over 150 Oracle 11g R1/10g R2 instances.
• Developing PL/SQL code, day to day DBA activity including the monitor and allocate storage space for data, Creation of the different databases environments for development, Testing & productions & Audit database usage, Tune the database.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.
• Experienced with cross site (active-active) data replication using Golden gate.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Maintained Production, Development,Quality assurance database (QA) and Test databases.
• Core DBA maintenance for DB’s upto 7T.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Assisted in implementing Oracle Financial Services Analytical Applications Infrastructure (OFSAAI - Reveleus& Basel products.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Worked on troubleshooting issues with full export and import.
• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Extensively worked in the performance tuning of the programs.
• Tuning SQL statements using Explain Plan and STATSPACK. Optimized SQL statements for maximum performance by using TKPROF and EXPLAIN PLAN
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Identified heavy resource consuming transactions/jobs to all request, developers to tune the components OEM Automatic Workload Repository Snapshots.

Environment: Oracle 11g/10g/9i, HP-Unix 11i v3, Solaris 10,RHEL 5, AIX 5.2, RMAN, OEM.

Confidential, LA

On Campus Intern

Responsibilities:

• Participated with groups of business students to create, organize, and implement business and marketing strategies to boost sales of Confidential sports team merchandise online 15%.
• Attended brainstorming sessions with top brand representatives and focus groups to learn more about CSU products and consumers.
• Monitored revenue and reported to CSU merchandise managers; organized data and created graphs using Microsoft Excel.
• Created monthly presentations using Microsoft PowerPoint for account managers to illustrate the progress and effectiveness or our business/marketing strategies.
• Completed the On Campus training in pl/sql and Certified in Oracle 11g DB program.
• Migrated 22 databases to new environment with in estimated downtime.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Worked on troubleshooting issues with full export and import.
• Installed and administered Oracle Real Application clusters (RAC 10gR2) on a 4 node Linux cluster using Oracle Cluster File System (O.C.F.S) and Automatic Storage Management (A.S.M).
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems.
• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Tuned oracle databases and applications using Tuning Tools like OEM GC, Cost optimizer, SQL analyzer,AWR, ADDM, ASH, Explain plan and SQL TRACE.