SUMMARY

• Around 10 years of experience as an Oracle Database Administrator, providing 24/7 support of development and production 12c/11g/10g/9i/8i databases on Various Platforms.
• Expertise in Linux, HP - UX, SUN SOLARIS, AIX, and Windows environments.
• Experienced in cross platform migrations from Windows to Linux, Solaris to Linux.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, script development and documentation.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), monitoring (alert log, memory, disk me/O, CPU, database network connectivity).
• Experienced in migrating across every platform, and have worked on RAC nodes up to 24 node clusters -- Installed 12c Enterprise Manager, 12c Database, and migrated to 12c RAC Cloud.
• Virtualization Expert -- VMWARE, Oracle VM.
• Experienced in maintaining Oracle replication between source and target Oracle databases.
• Laid hands on new tools and experienced features like Data Replay, LogMiner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 12c.
• Provided support for identifying and troubleshooting performace issues for SAP applications on Oracle 11g.
• Manage large complex Oracle RAC clusters wif applications.
• Experienced in setting up/Installation and configuration of release 11g R2 RAC wif ASM and Raw Devices and 11g CRS. Experienced in configuring & Managing the ASM.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experienced in dealing wif ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Performed backups and tested crash recoveries using Cold, Hot backups and RMAN and also tested various recovery procedures.
• Installation, configuration and deployment of VMware products such as VMware Workstation, VMware converter, VMware View, VCB and morein virtual environment
• Experience inwif Virtualizationtechnologies like installing, configuring,VMware vSphere. Creation, management, administration and maintenance of virtual servers and clients.
• Testing database failover wif virtual networks
• Eperienced in using Toad Data Modeler and Erwin.
• Experienced in normalizing tables for reducing redundancy.
• Experienced in Physical and Logical database Design.
• Experience in using GlodenGate to support data replication in the Oracle database environment.
• Experience in installing and configuring GlodenGate 9.5.
• Experience in using GlodenGate in moving large volumes of transactional data, wif minimal impact to online systems.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers wif EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQLTRACE utilities.
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Experienced in using 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations & benchmarking using load-testing tools.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Scheduling of jobs using Crontab.
• Experience in Database Security and Auditing.
• Expertise in RMAN for recovery and cloning.
• Experience in shell scripting for various CRON jobs to be run.
• Experience in Migration of Database from 9i to 10g, 10g to 11g and 11g to 12c.
• Performing Database Cloning in Oracle 9i, 10g, 11g & 12c using RMAN.
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 to MS SQL Server 2005.
• Worked in OLTO & OLAP environment that includes production (24/7), QA and development database in SQL Server.
• Good Experience wif SQL Server 2005 online Indexing and Recoveries features.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2000.
• Experience in upgrading SQL Server from .
• Having Knowledge on administration of Confidential Symmetrix and Clariion Hardware.
• Having Knowledge on SRDF.
• Knowledge in Zoning, mapping and masking.
• Experience in Storage provisioning.
• On call 24x7 Production Support. Worked beyond regular hours.

TECHNICAL SKILLS

Hardware: Pentium, PC AT-486, IBM, Dell and Apple Mac.

Operating System: MS-DOS, MS Windows 95/98/2000/2003/ ME/NT/XP/Vista, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.xProgramming Languages C/C++, Java (J2EE), SQL, PL/SQL, Delphi, Unix Shell Scripting

RDBMS: Oracle 8i,Oracle 9i,Oracle10g, Oracle 11g, Oracle 12c, Exadata,MS Access,MySQL,DB2

Tools: Oracle Grid, OVM, VMWARE, RMAN, OEM,GlodenGate SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOAD,VB

Web Related and Other Tools: Dreamweaver MX, MS FrontPage, Flash, Flex Builder, Adobe Photoshop CS3.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Data Modeling Tools: Erwin 4.0, Sybase Power Developer

PROFESSIONAL EXPERIENCE

Confidential, LOS ANGELES-CA

Sr Oracle DBA

Responsibilities:

• Worked as a Core DBA/ Exadata DBA at Confidential as migration specialist on Oracle 12cR1, 11gR2, Exadata X2, X3 & X6,, OEM 13c, RAC, Data Guard, Linux.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack
• Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines
• Managing database on 12c RAC and 11g R2 RAC
• Created OEDA requirement document for Oracle to setup the new Exadata X6 machines
• Worked wif network and linux teams to configure the network on the Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1
• Configured and modified Exadata x6 machines as per Confidential requirement and specifications after Oracle handed over the standard Exadata machines.
• Installation of OJVM patch on 11gR2 databases on Exadata X2 and X3 environments before migrating it to Exadata X6 machines to match wif Bundle patch version.
• Worked wif Storage team in configuring Netbackup and Datadomain on Exadata X6 machines.
• Upgrading oracle databases from 11g to 12c and implementing 12c databases for QA/test/dev environments, and applying one off patches and patch set updates as per Oracle upgrade matrix.
• Developing active standby and snapshot standby databases for 12c test database environments through the application of Data guard broker.
• Installation of GlodenGate on 11g databases including implementation of OEM 11g Repository database, OEM 12c Agent and configuring GlodenGate plug-ins and upgraded GlodenGate in Oracle database for real-time data integration.
• Performing GlodenGate replication monitoring, tuning, and capacity planning through managing the trail files, pump process and supplemental logging.
• MySQL Enterprise Monitor agent 3.0.24 installation on RHEL Servers.
• Installation of necessary components and configured MySQL database 5.6.
• Configured Master-Slave in MySQL and Enabled Replication between Master and Slave database.
• Performed database migration from db2 to Oracle database.
• Performed migration of database using replication of Oracle database 11.2.0.4 (OLTP) to AWS RDS sql server wif GlodenGate cerated trail files that has changed database from source database and then pushed these files to target database.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Working on setting up agents on Exadata x6 machines for monitoring.
• Installation and configuration of Oracle databases (single instance) and installation and configuration of RAC instances in oracle 10g and 11g and Converting single instance databases to RAC databases.
• Installation and configured Glodengate v. 11.2.1.0.1 on 4 node RAC Enterprise DB clusters and administering RAC one node databases on 4 node Development RAC running 11.2.0.3.
• Dealing wif Proactive and Reactive Tuning techniques including SQL load balancing and assistance using Query Optimizers and Tuning Advisor.
• Utilizing RMAN recover table functionality and creating proof of concepts for the pre-prod environment and active database cloning through RMAN.
• Deployed shell scripts using K-shell and scheduled CRON jobs for database regular tasks and opening, serving and managing tickets wif Oracle Support Center (Metalink).
• Deploying and configuring 3 node RAC instances in 11g and refreshes from Non-RAC to RAC environments including Faster Application Notification (FAN) and Load Balancing Advisory.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Providing 24x7 Support of Critical Databases and enhancing the Database Monitoring process and troubleshooting issues during upgrade, applying patches to fix issues.

Confidential, St Louis-MO

Senior Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11.2.0.4 databases on Linux and also migrated Oracle databases from Solaris to Linux.
• Worked wif Infrastructure and Operation Database Engineering Team.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using DG Broker for RAC one Node Databases.
• Configured and installed RAC 4 Node Production Databases wif Automatic Storage Management (ASM).
• Provided 24/7 on-call support for OLTP production databases to ensure support for critical issues.
• Installed Oracle Glodengate for database replication.
• Duplicated all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC Hybrid Columnar Compression techniques.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata wif Oracle Dataguard and Oracle GlodenGate.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.
• Upgraded and migrated the database to different version depending on Business requirements.
• Configured RAC 11gR2 Data Guard Standby Databases using Data Guard Broker.
• Configured OEM 13c cloud control for monitoring on differnet servers using OEM agent deployment.
• Installation of Oracle 12c on Red Hat Linux, Solaris and HP-UX.
• Installed and Configured database alerts in 13c OEM.
• Installed and configured Oracle Virtual Machine (OVM).
• Configured OVM manager for monitoring the OVM.
• Linux and Solaris OVM configuration and integration wif 12c grid control.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Installation of OVM and VMWare, RHEL 5.6 x64, Oracle 11.2.0.1 and 11.2.0.3 on Virtualized RHEL 5.6.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names and also experienced in silent installations & configurations.
• Configured and Implemented Oracle 11g Database Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Implemented Gloden Gate for Standby Configuration and developed procedures for Replication.
• Performed data replication, transformation and delivery of database transactions using Gloden Gate replication tool. Supported a large number of Development Databases.
• Develop custom utilities to automate manually intensive tasks including mass schema changes, departitioning tables and rewinding/restarting Gloden Gate to recover from trail file corruption.
• Extensively used AWR, ADDM for database performance statistics.
• Extensively worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events wifin managed databases.
• Implemented streams and Logical standby replication
• Managed Oracle Grid control 11.1.0.1 and configured Data Guard for OMR in Linux environment.
• Involved in doing Data Modeling and designing data warehousing boundaries and parameters, Data Transformation.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views,AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces at performance standpoint.
• Performance tuning - Tune SQL statements, me/O, Memory, latches etc. Worked extensively on SQL Profiler, Explain Plan and Stats Pack for tuning top wait events, high cost SQL’s.
• Database structure changes, table/index sizing, SGA sizing, SQL, me/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Performed system enhancements, including SGA, memory tuning and SQL Tuning, hardware and software modifications.
• Performed various RMAN strategies like RMAN Backup, RMAN Restore and RMAN Recovery etc
• Configured and Performed Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Excellent experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable table spaces.

Confidential, Boston, MA

Senior Oracle DBA Lead

Responsibilities:

• Installation and Creation of Oracle 10g, 11g and 12c RAC databases for Testing, Development and Production.
• Managed an Oracle 12c RAC system.
• Responsible for Oracle DBA and Applications DBA tasks involved in Oracle 11g implementation on Redhat Linux and Oracle Solaris 10.
• Installed and Configured of RedHat Enterprise Linux on Oracle Virtual Machine (OVM).
• Installed and Configured of Oracle 11g/12c on Linux on Oracle Virtual Machine (OVM). configuration and deployment of VMware products such as VMware Workstation, VMware converter, VMware View, VCB and morein virtual environment.
• Configured Oracle Application Server on Linux on Oracle Virtual Machine (OVM).
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in the process of tuning and refining various queries of various applications.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Converted a single instance database to Oracle RAC 10g.
• Configured the Public Network/Private Interconnect for Oracle 10g RAC.
• Involved in RAC administration including 10g database cloning, tuning, patching and monitoring concurrent management processing etc.
• Involved in 24x7 on-call support for 800GB 2 Node Production RAC database.
• Refresh/Cloning of application from production environment to test environment and application of patches.
• Setup RMAN catalog for all the Oracle databases.
• Performing Backup/Recovery of Oracle databases using RMAN.
• Developing and Implementing Disaster Recovery (DR) plan.
• Experience in monitoring and tuning system resources associated wif the database performance, hit ratios, me/O, lock and latch contention.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata wif Oracle Dataguard and Oracle GlodenGate.
• 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.
• Create table spaces, tables and indexes, sizing the system table space, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Restoration and Recovery from backup.
• Monitor CPU usage, me/O contention, memory paging and identify the resource and performance bottleneck.
• Write various SQL scripts to monitor table space and extent growth.
• Knowledge in writing Shell Scripts for automating backups and restoration.
• Partitioned large tables to increase performance.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Performance tuning involving Memory, Disk me/O tuning and SQL tuning.
• Diagnose and troubleshoot database problems and failures.
• 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.
• Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
• Performed Installation of SQL Enterprise bit version on windows 2003 servers on Enterprise systems of clustered and standalone HP servers in Enterprise Data Centers.
• Performing SQL*Loader jobs for loading data from text files.
• Installed and configured SQL Server Cluster server in SQL Server 2005 using HP servers for HP Customers.
• Migrated DTS Packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Handling day-to-day activities.
• Installation of Oracle 12c on Red Hat Linux, Solaris and HP-UX.

Environment: Oracle 12c, 11g, 10g RAC, 9.2.x, Red Hat Linux 4/5, HP-UX 11, Sun Solaris 10, OVM, Shell Scripts, SQL Server 2000, SQL Server 2005, Windows 2000/2003 Servers, Oracle PL/SQL, My SQL, PL/SQL Developer Tool.

Confidential, San Jose, CA

Senior Oracle DBA

Responsibilities:

• Involved in administration of over 150 Oracle Instances.
• Installation and Creation of Oracle 9i, 10g and 11g databases for Testing, Development and Production.
• Worked as a member of TCS's core infrastructure team as Oracle Engineer/DBA at CNA Insurance on Oracle 12c,11g R2,10g, Exadata 5, OVM, OEM 12c, RAC, Data Guard, Gloden Gate, Linux, Aix, Solaris, HP/UX.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Provided 24x7 Database Administration and support.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Worked wif application teams in preparing database design using Toad Data Modeler.
• Installed and Configuration of RedHat Enterprise Linux on Oracle Virtual Machine (OVM).
• Installed of Oracle Application Server on Linux on Oracle Virtual Machine (OVM).
• Worked on creating relationships between the tables.
• Worked wif application teams in preparing database design using Toad Data Modeler.
• Worked on creating relationships between the tables.
• Provide user account administration, optimizing SQL queries; optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL.
• Backup and Recovery via RMAN scripts and troubleshooting.
• The size of the production databases ranges from 1TB to 6TB.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Responsible for installing and configuring GlodenGate 9.5 on OracleServers
• Responsible for upgrading GlodenGate 9.5 to GlodenGate 10.0
• Handle service requests from the business using CIT Helpdesk Service Management.
• Database Administration on application side, Web Server/Messenger Express Server Administration.
• Managed an Oracle 9i RAC system.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Installation of Oracle 10g on HP-UX and AIX.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM (Automatic Storage Management).
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Environment: Oracle 11g, Oracle 10g RAC, Oracle 9i, HP-UX 10.x, AIX, RHEL,, TOAD, OEM, OVM, STATSPACK, TKPROF, SQL, Erwin 4.0

Confidential

Junior Oracle DBA

Responsibilities:

• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for installing, upgrading and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database backup and recovery, monitoring and optimizing database performance.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Installed and configured SQL Server 2000 in Windows environment.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Creating primary database storage structures (table spaces, rollback segments etc.).
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and implementing sound Backup and Recovery Strategy.
• Establish and document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Developed hot, cold and logical backup scripts to automate backup procedures.
• Prepare the documentation of the process and knowledge transfer about the project to the new team members.
• Planning for storage space requirements and placing them for optimum me/O performance.
• Partitioning tables by determining suitable methodology to improve the performance and manageability.
• Cloned Production and Test environments to create Patch Test, Development and QA environments.
• Monitoring the database storage and day-to-day activities.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Participated in Disaster Recovery drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting wif Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Metalink.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.

Environment: Oracle 9i, Oracle 10g Sun Solaris, HP-UX, SQL Server 2000, Windows NT/2000, PERL