PROFESSIONAL SUMMARY:

• Around 8 years of experience as a Database Administrator, providing 24/7 support for both development and production environments having hands on experience in installation, configuration and administration of Oracle databases on various platforms.
• Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.
• Expertise in installation, configuration, upgrades, patches, cloning, backup & recovery of Oracle 9i, Oracle 10G, Oracle 11G and Oracle 12C on various platforms like IBM - AIX, Sun-Solaris, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
• Over 3 years of experience working with Oracle Golden gate with complete end-to-end support for Golden gate - Configure, Setup, Install, & Support.
• Over 5 years of experience working with Oracle Data Guard - Implement & support.
• Experience in planning and implementing high availability solutions using ORACLE RAC - Install & configure.
• Hands on experience on Oracle Exudate Database Machine - Implementation and Maintenance.
• Working experience of setup, configuration and implementation of Cloud-Control/Grid-Control/Automation.
• Extensive knowledge of Automatic Workload Repository (AWR), Oracle Data pump, Flashback, RMAN.
• Skilled in dealing with ASM environment such as Installation, configuration. Administered Oracle ASM disk groups (mirroring, compatibility) and migrated database from NON-ASM to ASM environment.
• Proactive monitoring and identifying issues in database and its services using OEM Grid-Control/Cloud-Control (10G, 11G, 12C).
• Experience in upgrading CRS, ASM and Database and also applying oracle patches for CRS and RDBMS homes.
• Experience in database performance and tuning techniques using SQL Trace, TKPROF, and Explain Plan and generating statistics of database using ADDM and tuning the database accordingly.
• Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics using DBMS STATS.
• Hands on experience in using dbms packages like DBMS JOB, DBMS SCHEDULER and DBMS SQL.
• Analyzed Tables, Indexes periodically to optimize the SQL queries and assigning proper indexes such as BIT map or B-Tree Index according to requirements.
• Expert experience in Hot and Cold Backup of databases. Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN and VERITAS Netback up.
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Implemented Oracle Security / Auditing techniques for SOX compliance. Created roles, profiles and privileges and assigned roles to users.
• Experience in creating different kinds of partitions on tables and indexes for managing large tables.
• Experience in using tools such as OEM, TOAD, Fog light, and SQL Developer.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL Loader utility.
• Administered and Managed Oracle Point of Service (ORPOS 13.1) database.
• Performed complete multi-master replication with updateable materialized views.
• Strong knowledge in SQL, PL/SQL and also strong knowledge of creating Public/Private Synonyms, DB Links, Ref Cursors, Raise Application Error, Parameterized Cursors.
• Experience in Tablespace management both local and dictionary. Managed Undo Segments in order to avoid "Snapshot too old".
• Automated many common tasks with Scripts by scheduling jobs (crontab) including: Backups, exports and imports, archiving old records and verification of such processes.
• Experience in working with different FTP clients like Smart FTP, cute FTP, SFTP and SCP.
• Performed 24x7 production system problem analysis and recommend corrective measures in a timely manner.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 7.1, 6.1, 5.1, 5.2, 5.3OEL5.6Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 6.x and Windows

95/98/ME/NT/2000/XP.:

RDBMS: Oracle (9i, 10G, 11g, 12C), 11g RAC, 10g RAC. SQL Server 2005/2008

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

DB Utilities: RMAN, SQL Loader, EXP, IMP, expdp, impdp, Opatch, Golden GateNID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, DBUA

Tools: OEM, SQL* Developer, Putty, TOAD, Foglight.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling: Erwin 4.0, Toad Data Modeler.

Other: EMC, NetApp, Veritas NetBackup, TSM, HP Omni Back.

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Sr. Oracle DBA

Responsibilities:

• Overall planning, installation & support store databases on Oracle 12C and 11G (Multitenant and NON-CDB).
• Developed, communicated and implemented Database upgrade plan for store database upgrades.
• Installed, configured, and managed Oracle database 12C on Red Hat Linux and Windows platform.
• Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2.
• Implementing quarterly patch cycles for databases systems in 12C.
• Administered and managed databases for Oracle Retail Point of Service (ORPOS 13.1).
• Responsible for proactive monitoring and identifying issues in database due to upgrades.
• Implemented Recovery Manager (RMAN) for Pluggable Databases in Container Database (CDB).
• Implemented Database Resource Manager (DBRM) for Pluggable Databases to achieve equal resource allocation in Container Database (CDB).
• Cloning/Data Refresh from Production to Test and Development environments using Backup-duplication method and Active duplication.
• Ensuring database logs are turned on, logging appropriate information, protected from unauthorized disclosure or modification, and retained for the time period specified.
• Installed Central office Databases on Oracle 11GR2 RAC Environment.
• Converted a single instance database to Oracle RAC.
• Installed & configured Data guard using physical & logical standby for high availability and reporting purpose.
• Discovering, Promoting and adding target hosts and databases in Oracle Enterprise manager (OEM) 12C.
• Defining and Implementation of backup and recovery strategies.
• Configure database backups using RMAN, EXP/IMP before upgrades for recovery purposes.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Upgraded Oracle databases from 11.1.0.7 to 11.2.0.4 in windows environment.
• Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).
• Data loading from flat files and external files activities through SQL loader and External tables.
• Configured a job to gather the statistics of database objects using DBMS STATS on various databases.
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis.

Environment: Oracle 12c/11g, SQL, PL/SQL, SQL Development, UNIX shell scripting, RHEL, Windows

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Configured, Setup and maintained Oracle11G RAC two-node environment on ASM on EXADATA (X3 - Half rack) machine.
• Monitored Oracle Exadata database servers and storage servers including Cell Server Administration.
• Responsible for Patching/Firmware Upgrade /Re-image of Oracle Exadata Systems (X3 - Half Rack).
• Installed and Configured Oracle Data guard for Oracle 11G & 10G for the maintenance of Standby database.
• Responsible for managing complex Standby databases and Data Guard for disaster recovery.
• Monitored Database performance, identified issues and resolved them using OEM Cloud Control 12C and Foglight and TOAD.
• Involved in installing, configuring, upgrading, replication monitoring, capacity planning and tuning Oracle Golden Gate.
• Troubleshot various Golden gate replications and Performance issues on Exudate environment.
• REFRESH/CLONE Database using RMAN Duplicate for development, testing.
• Upgraded Oracle database from 11.1.0.6 to 11.2.0.1 in Red Hat Enterprise Linux environment.
• Applied PSU patches and other security patches on Oracle 11G RAC and Standalone Databases.
• Converted large Non-Partitioned tables to Partitioned tables following Range partitioning method, to improve the performance.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Optimized and tuned SQL queries using SQL* TRACE, EXPLAIN PLAN and by monitoring STATS PACK report generated from snapshots taken at the peak business hours.
• Worked on database security with audit vault and database vault including installation, configuration monitoring and troubleshooting.
• Defined and Implemented backup and recovery strategies. Tested many backup and crash recovery scenarios on test environment (10g, 11g), using RMAN tool.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Management of schemas, objects partitioning the tables & indexes.
• Detected locks and resolving in-doubt transactions manually.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Responsible for preventing residual data from exposure to unauthorized users as information resources are released or reallocated.
• Wrote SQL scripts to monitor tablespace and extent growth.
• Developed, communicated and implemented Disaster Recovery plan for DR exercise.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Development, Windows, Oracle Linux, Solaris, RHEL

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Installed and configured Oracle database Setup on brand new machines including Oracle software installation, Oracle database creation, and backup setup on multi-node RAC environment.
• Created and maintained Oracle11g database on RAC four-node environment on ASM.
• Upgraded Oracle database from 10.2.0.5 to 11.2.0.3 and applied oracle patches to rdbms homes from 11.2.0.3.0 to 11.2.0.3.6.
• Installed and Implemented Oracle GOLDEN GATE. Configured Extract, data pump and Replicate processes for Basic and Advanced Data Replication between Oracle Databases and other databases.
• Configured and built heartbeat monitoring in golden gate.
• Configured error handling for restart, logging, production support and status reporting in golden gate.
• Implemented necessary monitoring scripts for golden gate in Unix/Perl scripting.
• Wrote shell scripts for various database activities like space cleanup, data pump refresh, and RMAN refresh.
• Migrated data using import/export, oracle data pump, transport tablespaces and standby databases.
• Converted single instance to three-node Real Application Cluster (RAC) database instances.
• Reorganized existing database to standardize the placement of various databases related files.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.
• Converted/altered existing manual Partitioned tables for large customer related data in to Interval-Partitioned tables.
• Involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise.
• Monitored and configured, oracle 9i, 10G and 11G databases using OEM 11G.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Implementing user level security, object level security, data encryption, data masking, and Fine Grained-auditing using DBMS FGA package.
• Migrated oracle databases from oracle 10.2.0.4 to 11.1.0.7 on AIX to RHEL.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database objects by fixing row chaining, I/O and CPU bottlenecks.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Migrated Data from Legacy Databases (9i/10g) to target databases.
• Responsible for maintaining data integrity and tune database for optimum performance and availability.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Development, UNIX shell scripting, AIX, RHEL

Confidential, Saint Louis, MO

Database Administrator

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager.
• Supported both production and development activities.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Installation of Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• Supported Production Database Oracle 10G RAC 4 Node with High Level Evaluation, performance tuning, instance recovery, load balance.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK, AWR, ADDM.
• Upgraded of Database from 9.2.0.6 and to 10.2.0.2 and applied patches whenever required.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Configuration and Maintenance of RAC, Standby database.
• Extensive use of Oracle Data guard for protection of critical production data & provide disaster recovery support.
• SQL tuning with Extensive SQL and PL/SQL experience.
• Rebuilt Indexes for better performance, maintenance of Oracle Database.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Configured Oracle Data Guard on Oracle 11G and 10G databases for Disaster Recovery.
• Supported custom application development team including database objects deployment, migration and troubleshooting.
• High-speed data transfer between one database to other by using two utilities of oracle data pump, which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
• Installed and configured Oracle Enterprise Manager (OEM) 10G & 11G and Enterprise Backup Utility to monitor databases and its services.
• Established a DB Link between two Oracle Servers.
• Used SQL*Loader and External tables to load data from flat files.
• Provided Solutions to the Problem Faced by end Users.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, SQL Development, UNIX shell scripting, AIX, Sun Solaris, Windows NT/2003

Confidential

Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Created and Managed Physical Standby database for failover and switch over operations.
• Installed and created Oracle 9i and 10g databases in development, Production and QA environment including configuration, backup & performance tuning.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow.
• Conducted sizing & capacity planning for Oracle databases.
• Involved in Upgrade of production and development databases to Oracle 9i.
• Applied patches to Oracle Databases and Oracle Applications.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Involved in taking Backups using Oracle RMAN (Recovery Manager) and TSM (Tivoli Storage Manager). Defined Data Storage policies like number of backup versions to keep, the retention period for inactive copies etc. Installed and configured TDP using dsm.opt, tdpo.opt files.
• Management of schemas, objects and partitioning the tables & indexes.
• Used DBMS STATS to gather the statistics along with analyze command.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Helped Development team to troubleshoot and establish Oracle Connection to Oracle Database through ODBC and JDBC.
• Performed other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Application Clusters, and Oracle Standby.

Environment: Oracle 9i, SQL, PL/SQL, RHEL 2.1, Windows 2000 Server.