SUMMARY:

• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Worked on Deploying and Administering ADF applications.
• 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.
• Extensively 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 Fusion Middleware components from Weblogic server, Oracle identity manager including OID and OAM integration for Single-Sign-on (SSO).
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Experienced in using features like RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Highly experienced in Oracle Automatic Storage Management (ASM) required to fulfill the storage needs.
• 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.
• 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.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Tunning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

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

Tools: and Utilites: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer.

RDBMS: Oracle 9i, 10g, 11g

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

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Security Administrator

Responsibilities:

• Configured and administered oracle snapshot and Active data guard physical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Install and configure oracle Fusion Middleware components including weblogic server, BI Publisher, Forms and Reports instances on RedHat Linux 6.
• Configure and administer oracle Identity manager (IDM), including OID and OAM and integration of both for Single-sign-on (SSO) and more robust user security.
• Performed database upgrades from 11g to 12c using DBA and data pump
• Experience in installing, administrating and troubleshooting Oracle Forms and Reports, Oracle Identity Management.
• Evaluate, install deploy and administer ADF applications including security patches and other changes across environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Configured and managed Oracle Transparent Data Encryption (TDE) for data security on 11g and 12c databases.
• Installed and used Oracle Enterprise Manager (OEM) 12c and later 13c Cloud control for monitoring and reporting on all databases in the environment.
• Perform monthly review of databases monthly audit report.
• Managed Oracle Bi Publisher for reporting, at application and Middleware levels.
• 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.
• Knowledgeable in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Confidential, PA

Oracle Database Administrator-Lead Consultant

Responsibilities:

• Successfully implemented Disaster Recovery solutions for different oracle database environment using RMAN, COMMVAULT, and User managed systems
• 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 switchovers on primary and standby databases as a part of planned maintenance activities.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Used RMAN CATALOG to recover databases from different critical systems in a timely fashion based on SLA
• 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.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting Oracle 11g, 10g RAC to single instance databases to databases for disaster recovery solutions
• Installed ASM environment and migrated databases from NON-ASM to ASM and vice versa. Administer NOsql databases
• Used PUTTY for database management.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, COMMVAULT, SQL* Plus, PUTTY.

Confidential, MN

Oracle Production Support Database Administrator

Responsibilities:

• Installation and configuration of Oracle database 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000
• Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database
• Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks
• Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks
• Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks

Environment: HP-UX, Windows, Oracle 8i, 10g, SQL, PL/SQL, SQL plus, TOAD

Confidential, Deerfield, IL

Oracle Database Administrator

Responsibilities:

• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
• Administered (10g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Supported off-hour on call support for database related issues.
• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• 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.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

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