PROFESSIONAL SUMMARY:

• I have over 5 years of experience on Database upgrades and patches, database migration, backup and recovery, performance tuning, Data Guard and security administration as an Oracle Database Administrator. I have experience in database versions 10g, 11g, and 12c.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience with RAC Cluster ware configuration and patching, RAC Backup and Recovery.
• Experience in Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load Balancing and designing failover systems on UNIX platforms.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance Monitoring/tuning/troubleshooting.
• Oracle Database performance - tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Experience in cloning/replicating Production database using RMAN.
• Performed Tablespace point in time recovery (TSPITR) using RMAN
• Good in using Flashback technology to provide faster recovery of database.
• Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.
• Performance Tuning of Oracle database using OEM GC, Cost optimizer, SQL analyzer, Performance Manager, Stats pack, AWR, ADDM, ASH, RDA, Explain plan TKPROF, SQL TRACE and Oradebug.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Developing shell scripts and SQL scripts to carry out routine checks on databases.
• Implemented proactive monitoring scripts for production databases.
• Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
• Utilized SQL Loader to migrate or load data to Oracle.
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Very good with Database Cloning, Migration, and Patching of Oracle Databases.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Experienced in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Good knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management).

TECHNICAL SUMMARY:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL SUMMARY:

Confidential, Pittsburgh, PA

Oracle Database Administrator

Responsibilities:

• Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Upgraded Oracle 10g database version to 11g.
• Upgraded Oracle 11g database version to 12c version
• Provided database related services to their development & QA environments.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
• Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC
• Configured Offline and Online Disaster recovery sites to maximized the database availability
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH),
• Import/Export Server Manager. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Streams to capture propagate, apply changes in multiple databases.  
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN. 
• Configured, administered, and monitored a Streams environment using various tools like OEM console. 
• Installation, maintenance and tuning of 11g RAC databases including ASM and CRS. 
• Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection . 
• Data Migration as part of enterprise data warehouse project. 
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Schaumburg, IL

Oracle Database Administrator

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Performed disk and disk group management in ASM while installing 11gR2 RAC.
• Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).
• Ensured that oracle database systems operate securely and efficiently.
• Managing databases from planning and testing stages through implementation and support.
• Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Failover tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Extensively used AWR and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Environment: Oracle 10.1.0.4/10.2.0.4/11 gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, TOAD.