SUMMARY:

• Over 5 years of experience as an Oracle Database Administrator having hands and experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Managed 2TB Oracle 10g & 11g databases in Data warehousing environment.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Installation and configuration of oracle Golden Gate.
• Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experience in applying PSU patch on standalone as well as RAC databases.
• Experience in Golden Gate upgrade from 10.4 to 11.2.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for 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.
• Installed Oracle 11g with ASM and OCFS2 File systems.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• 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 Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Experienced in using 10g features like 10g 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.
• Experience in doing upgrades including maintenance & monitoring implementation.
• 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.
• Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to
• Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
• Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
• Experience in Upgrading databases, applying patches.
• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
• Checking and resolving Database corruptions using DBVERIFY utility. Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, Grid Control

Operating Systems: Solaris 10/9/8, RHEL 6.X/5.X, HP UX, Windows 2008/2010 server

EXPERIENCE:

Confidential, Waltham, MA

Oracle Database Administrator

Responsibilities:

• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary - standby using duplicate from active database in 2-node RAC environment. Apply SCN-based Incremental backup to sync standby after loss of archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• Tuning Database using AWR/ADDM/SQL trace. Analyzing tuning Advisor. Migrate SQL plans & statistics from QA to PROD. Schedule stats Job using DBMS SCHEDULER. Used AWRSQL/SQL tuning package. Tune various SQL's . Provide Primary investigation on Performance issue to application team in minimal time. Troubleshoot/mitigate various wait events in DB. Tuning of RAC instances and Database.
• ASM storage management. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem. ASM migration.
• GRID - Oracle Cloud Control 12c installation, agent configuration and maintenance.
• RMAN advanced features - Implementation of RMAN duplicate from active database feature for migration.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• 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.
• Generated and automated Stats pack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth .
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
• Upgrade database & ASM instances from 11g to 12c . Apply PSU & bug fix patches. Open tar support.
• Implement Advance partitioning using 11g features like interval, reference and system partition. Partition by virtual columns. Testing of partitioned tables for partition pruning, wise-join in ad-hoc query.
• Backup by RMAN and data pump. Consistent backup using data pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing. Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM. Duplicate database on remote host using 11g active database command. Hands on Veritas NetBackup. Flashback database.
• Setup and maintenance of Physical Standby Database using Data Guard Broker and active Data Guard for faster Disaster Recovery.
• Installed and Configured OEM grid control for maintenance administering the databases.
• Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Performed full and incremental backups using RMAN for development and production databases.
• Database cloning from Production to Test and Development environments.
• Extensively worked on applying patches (CPU&PSU) whenever required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloning database and schemas using Data pump for 10g and 11g versions.
• Cloning 11g and 12c databases using RMAN duplication (with and without backup).
• ASM Disk storage and user Management
• Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ADDM.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls .
• 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.
• Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.
• Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and defined TAF policy for RAC instances.
• Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data Pump, 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 database sand Data Pump import/export to move data between 10g 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).
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Detect corrupted blocks by using DBVERIFY utility.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Implemented table partitioning to improve performance and data management.
• Implemented Security through Virtual Private Database and Fine Grained Auditing.
• Developed RMAN scripts for database backup and recovery.
• Designed and implemented the database servers for two new data centers.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using PLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA etc.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• 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.