SUMMARY

• 12+years of experience in Oracle Database Administration
• 7+ years of experience in Oracle GoldenGate Administration
• 4+ years of experience supporting Oracle PeopleSoft Environment
• 3+ years of experience with Oracle EBS Database Administration
• 9+ Years of Database Performance Tuning and Application Tuning
• 5+ Years of experience in SQL Server Database Administration
• Expert in Database Administration of VLDB > 100TB
• Expert in capacity planning, database design, database setup & designing Oracle systems per compliance and security regulations
• Expert in oracle software installations, configuration, patching, upgrade - Single Instance and RACwith multiple nodes
• Expert in administering, maintaining and supporting Oracle Automatic Storage Manager - ASM
• Expert in setup and administration of Oracle Enterprise Manager 10G, 11G & 12C
• Expert in database security, database audits and database vault
• Expert in Backup & Recovery strategies, conducted extensive DR Testing
• Configured and Maintained Active Data Guard for High Availability and Disaster Recovery
• Expert on new tools and implemented features like Data Replay, Log Miner and Flashback data Archive, Data guard and RMAN in 10g / 11g / 12c
• Developed Scripts for monitoring oracle systems to report Oracle process failures, disk space issues, Long running queries and report Replication Status
• Experienced on large-scale Enterprise Data Warehouse systems
• Experienced in Rapid Cloning for EBS environments
• Experienced in Defining / Setup / Management of Concurrent Managers & Roles
• Good working knowledge of Linux, Solaris Installation, patching and upgrades
• Broad technical knowledge of SAN, Disk Arrays, Networking and Server configuration.
• Extensive knowledge in working with OWB, OBIE, Oracle Grid Control 11G / 12C, TOAD, SQL developer, Datapump, Exp/Imp
• Extensive knowledge in writing various Shell Scripts for Job automation and database monitoring
• Extensive knowledge on SAN, EMC Storage, NetBackup, IBM Tivoli Storage Manager, TDP &Networking Technologies
• On call technical support for 24x7 mission critical production databases

TECHNICAL SKILLS

Oracle Database Administration: Oracle 8i/9i/10g/11gR2/12C

SQL Server Administration: SQL Server R2

IBM DB2 Administration: DB2 9.7 - 10.1

Oracle EBS: Oracle Applications 11i

Oracle ERP: PeopleSoft 9.1, People tools 8.51

Oracle Enterprise Manager: 9i/10g/11g/12C

Replication Technologies: Oracle GoldenGate, Oracle DataGuard

Operating Systems: AIX, LINUX, Solaris, Windows R2

Storage Systems: EMC storage, SRDF, BCV

ETL Tools: Informatica 7.1

PROFESSIONAL EXPERIENCE

Confidential, VA

Senior Oracle DBA

Responsibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, and Development and QA databases.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Configuration and providing centralized management for Disks.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RACdatabases on ORACLE 10G / 11G / 12C Clusters.
• Good experience with multi master replication setup & Administer with Golden Gate tool.
• Setup reporting server using ORACLE Streams from various data sources.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Upgraded multiple production databases from version ORACLE 10g to ORACLE 11g to Oracle 12C
• Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.
• Performed Backup and RefreshedSQL SERVER Databases using SSMS.
• Identified performance bottlenecks and performed performance tuning of SQL SERVER.
• Performed Export and Import utilities in SQL SERVER databases.
• Monitored Performance of databases and administered user security of MS SQL 2005.
• Monitored SQL SERVER Databases and assisted developers in debugging T-SQL Procedures etc.

Environment: Oracle 10g / 11g / 12C, SQL SERVER / 2008 R, AIX 5 / 6 / 7.1, RedHat Linux 5 / 6 / 7, Windows Server, Oracle Grid Control 11G / 12C, DataPump, RMAN, Golden Gate, SQL *Loader, Exp/Imp, TOAD, SSMS, JBoss Application server, PeopleSoft HCM 9.0 / FSCM 9.1.

Confidential, TX

Senior Oracle DBA

Responsibilities:

• 24x7 Oracle Database Administration of Production, Development, Testing databases.
• Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using Dataguard.
• Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
• Involved in Data Modeling, Design, Implementation and Creation of Databases.
• Worked closely with System Administrators, Network Administrators to build the RAC environment.
• Involved in setting up of ORACLE 10g RAC Databases for test prototype environment with three nodes-cluster on Red hat Enterprise Linux 4.
• Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
• Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
• Documented the procedures for adding a node for current DATAGUARD environment.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• Installed and configured software/databases as of Oracle’s Optimal Flexible Architecture (OFA).
• Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
• Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.
• Configured and performed automated and various levels of backups using RMAN.
• Very good experience with Oracle Application Server & WEBLOGIC servers middle tier.
• Installed ORACLE Enterprise Manager GRIDCONTROL and configured it server targets for a centralized monitoring system.
• Monitored databases Performance using ORACLE Enterprise Manager (OEM) and Grid Control.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
• Responsible for Instance Tuning, I/O Tuning, Identifying and fixed contention waits.
• Used ORACLE Wait Interface, to identify the top most wait events and their causes.
• Used advisor, tasks like ADDM, SQL Tune, Access Tune and Undo Advisors for performance tuning.
• Resolved several performance bottlenecks and poorly tuned Ad hoc SQL Statements.
• Installed and updates critical security Patches using Enterprise Manager and O PATCH.
• Worked extensively with tools like SQL * Loader, Datapump, Exp/Imp,for loading data into database and monitoring and querying databases using TOAD etc.
• Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc. as per the given structures, operations, data in the tables for increased performance.
• Documented the entire core procedures required for the oracle database maintenance.
• Created Materialized Views/Snapshots for replications and increase query performance.
• PartitionedTables, Index for increased query performance and easier maintenance.
• Analyzed query plan using Plan Table, Explain Plan, optimizer Hints and for estimating CPU & Query costs.
• Refreshed PROD, DEV, UAT databases using Datapump, RMAN, and TransportableTablespaces etc.
• Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.

Environment: Oracle 8i/9i/10g / 11G, Solaris 8 / 9, Red Hat Enterprise Linux 5, RAC, IBM SAN Volume Controller, Windows 2003, Oracle Grid Control 11G, TOAD, SQL developer, SQL Server 2005

Confidential, MA

Senior Oracle DBA

Responsibilities:

• Database Administrator for Production, Development and UAT databases and provided on-call production database support.
• Configured Dataguard disaster recovery procedure using Physical Standby Databases.
• Monitored Standby Databases and performed switchover and failover mechanisms of Dataguard.
• Installed ORACLE 9i/10g software’s on Windows and Unix Platforms.
• Supported CRS/RAC Database installation for HA, Scalability of databases.
• Setup and Upgraded ORACLE 9i databases to ORACLE 10g databases.
• Setup backup procedures for various PRODUCTION databases based upon SLA.
• Took Full/Incremental backups using ORACLE Recovery Manager (RMAN).
• Created Entity Relationship model (Entities, Attributes, elements and relationship) normalizing data up to Third Normal Form (3NF).
• Administrated database regarding space related issues- monitoring Tablespaces, users’ security of data accessibility and Configuring Archive log destinations and Flash Recovery Area (FRA).
• Loaded/Refreshed data into database’s using Exp/Imp, Network Links and Datapump etc.
• Wrote Stored Procedures and Packages in PL/SQL that are called by Java code to perform back end processing.
• TunedSQL and PL/SQL code using Oracle Enterprise Manager (OEM) Tools, Query Analyzer and Explain Plans.
• Applied various patches on regular basis to oracle software homes.
• Monitored Alert log and wrote scripts in SQL for quick health check of the databases.
• Monitored databases using Enterprise Manager and resolved issues based upon severity level.
• Created Clone and Duplicate databases for load testing, Acceptance testing etc using RMAN.
• Created Materialized Views/Materialized Views Logs for data replications.
• Analyzed databases using AWR, Statspack Report and resolved issues to maintain performance.
• Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
• Monitored and tuned rollback segment, temporary Tablespaces, redo log buffer, sort area size.
• Assuring Load balancing, monitoring disk I/O statistics, Data file I/O statistics read/write ratios and fixing problems.
• Create Triggers and defined constraints to maintain the data integrity in the databases.
• Installation and configuration of ORACLE SQL*NET, and Net8 for client-server connectivity.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Wrote Perl/Korn script for many databases tasks- backing up databases, Info about CPU/System Stats etc.

Environment: Oracle 8i / 9i / 10g, Oracle Parallel Server, Sun Solaris 7 / 8, AIX 5Windows 2000, TOAD, RMAN, OEM &Erwin.

Confidential

Oracle DBA

Responsibilities:

• Performed Installations of Oracle software on various Windows and UNIX servers
• Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle
• Installed, configured Oracle 9i RAC on Red Hat Linux servers
• Migrated databases from Oracle 9i to 10g from windows to Solaris
• Responsible for optimizing queries and application tuning.
• Performed PL/SQL tuning and assist developers with coding PL/SQL.
• Involved in numerous Shell Scripting pertaining to the activities of the DBA.
• Using SQL*Loader, Export, Import in order to extract and Load Data.
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
• Worked with database export & import scripts to backup database structures and automation procedures.

Environment: Windows-NT, Oracle 8i /9i,RedHat Linux, Designer 2000, ReportsC++, TOAD, Export/Import utilities, Oracle Forms 4.5.

Confidential

Oracle DBA

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database
• Compiling and debugging packages with in-house code, and assisting the developers with optimizing and tuning the PL/SQL code
• Wrote Scripts to perform HOT/COLD backups
• Created users and maintained security with roles and privileges
• Cloning/Refreshing databases from hot/cold backups
• Setup connectivity to databases using NET 8 for clients and server side
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance
• Involving in creation of triggers and handling exceptions
• Developing various Business and ad-hoc Reports
• Creating Data Flow Diagram, Entity Relationship Diagram from Designer
• Involved in administering development databases
• Various stored procedures were written to achieve the back end functionality
• Analyzed performance bottlenecks and provide appropriate solutions
• Wrote various scripts in PERL and SHELL for database health and space checks
• Development, Testing, Implementation and Training

Environment: C/C++, Oracle 8i, 9i, Reports2.5, Oracle Designer, PL/SQL, Solaris 5Windows 2000/NT