SUMMARY:

• Over 8 years of experience in Information Technology as an Oracle DBA on Linux, UNIX and Windows operating system environments.
• Experience as a Production support/Operations DBA with Multi - Terabyte 24x7/large databases and as a Development Engineer/Data Warehouse DBA.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 5TB.
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version’s 8i, 9i, 10g & 11g.
• Configured and maintained Real Application Clusters environment for high availability and scalability.
• Experience in configuring Data Guard -- Physical Standby and Logical Standby Databases.
• Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc.
• Experience in implementing Automatic Storage Management for simple storage interface.
• Experience in installing and configuring/Monitoring Enterprise Manager Grid Control.
• Experience in working and administrating ORACLE Golden Gate 8, 9.
• Experience in configuring and Installing/using various Quest Tools- TOAD.
• Expertise in SQL and PL/SQL, writing stored procedures, triggers and functions.
• Extensive knowledge in working with the tools like Grid Control, Oracle Enterprise Manager, TOAD, SQL developer, Datapump, Exp/Imp.
• Extensive knowledge in writing various Shell/PERL Scripts for automation and monitoring of databases.

TECHNICAL SKILLS:

Database: Oracle (8i, 9i, 10g, 11g)

Operating systems: Sun Solaris, AIX, Confidential -UX, Windows 2000/2003/2008, Windows NT, Redhat Linux.

Programming &Scripting languages: SQL, PL/SQL, Shell/Perl scripting.

Tools: Oracle Grid Control 5, SQL*Loader, RMAN, Toad, Quest tools, Weblogic, Statspack, Foglight, Golden Gate, TKPROF, Data-pump, DBCA, DBUA.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, 11g RAC, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN, ASM.

Responsibilities:

• Provided On-Call rotation and 24x7 supports for very large databases
• Installed, configured Oracle 11g grid infrastructure for standalone & RAC databases
• Good experience with Oracle 11g RAC including installation & managing the databases in ASM & non-ASM.
• Upgraded Oracle 9i/10g to the Oracle 11g R2 database version.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
• Implemented the Golden Gate Replication
• Extensively worked in migration & up gradation projects i.e. from Oracle 9i/10g to Oracle 11g in cross platform.
• Setup the Oracle Advanced Replication using DB links & materialized views.
• Good experiences with UNIX shell scripting.
• Having experience with Oracle Partitioning
• Good experience with Oracle performance issues in both application tuning &memory tuning.
• Responsible for maintaining Oracle 10g data guard and 9i standby databases.
• Very good experience with Oracle RMAN & other backup utilities
• Applied the Oracle security patches and application patches using the OPATCH utilities.

Confidential, Pennington, NJ

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, 10g/11g RAC, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN.

Responsibilities:

• Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
• Upgrade oracle 10g databases to 11.2.0 version
• Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases Maintenance.
• Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.
• Installed, configured Oracle 10g & 11g RAC with advanced features
• Very good experience with Oracle 10g RAC administration and HA environment.
• Setup reporting server using ORACLE Streams from various data sources.
• Setup the Oracle Advanced Replication using DB links & materialized views.
• Good experiences with UNIX shell scripting.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc
• Very good experience with Oracle RMAN & other backup utilities
• Partitioned the table using split & merge utilities
• Good experience with Oracle database & application performance tuning.

Confidential, Trumbull, CT

Oracle DBA

Environment: Oracle 8i, 9i/10g/11g, 10g RAC, Oracle AS, Solaris 10, REDHAT Linux 4, Windows Server 2008, Confidential -UX 11.2, Oracle Grid Control 5, SAN, Datapump, RMAN, Golden Gate, SQL *Loader, Exp/Imp, Toad.

Responsibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
• Installed & configured Weblogic server on UNIX platform and deployed applications.
• Contention and providing centralized management for Disks.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
• Used Weblogic server to integrate the OID enabled applications.
• 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.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• 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.
• 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.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.
• Writing Triggers and debugging Stored Procedures and Functions-PL/SQL.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

Confidential, Charlotte, NC

Oracle DBA

Environment: Oracle 8i/9i/10g, Oracle 10g/9iOAS, Solaris 9, Red Hat Enterprise Linux 4, Confidential -UX 11.2, RAC, IBM SAN Volume Controller, Windows 2003, Grid Control 2, TOAD, and SQL developer.

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 GRID CONTROL 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.
• Partitioned Tables, 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, Transportable Tablespaces 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.

Confidential

Jr. Oracle DBA/Developer

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

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 user’s 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.
• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.
• 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.
• Wrote Embedded SQL in C (Pro * C).
• Developing various Business and ad-hoc Reports.
• Creating Data Flow Diagram, Entity Relationship Diagram from Designer.
• Involving in writing PL/SQL Triggers, Procedures, Functions and Packages.
• 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 .