SUMMARY

• Around 8 years of experience in Oracle DBA & Data Analyst on Linux, UNIX and Windows operating system environments.
• Experience as a Production support/Operations DBA with 24x7/large databases and as a Development Engineer/Data Warehouse DBA.
• 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 Databases.
• Very good experience BMC Remedy Tool for ticketing system.
• 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.
• Strong knowledge and experience in using Oracle Configuration and Provisioning Pack.
• Extensive knowledge in working with the tools like Grid Control, Oracle Enterprise Manager, TOAD, SQL developer, Datapump, Exp/Imp.

TECHNICAL SKILLS

Database: Oracle (8i, 9i, 10g, 11g), MS SQL 2000/2005Operating systems Sun Solaris, AIX, HP-UX, Windows 2000/2003/2008, Windows NT, Redhat Linux.

Programming Scripting Languages: SQL, PL/SQL, Shell/Perl scripting.

Tools: Oracle Grid Control 11g/12c, SQL*Loader, RMAN, Toad, Remedy, Quest tools, SQL Developer.PL/SQL Developer,Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle DBA

Environment: Oracle 9i/10g/11g, Solaris 10, REDHAT Linux 4, Windows Server 2008, Oracle Grid Control RMAN, Remedy and Toad.

Responsibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
• Installed & Configured ORACLE 10g RAC, 11g on Red Hat ES Linux 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.
• Very good experience with Oracle 10g RAC administration and HA environment.
• Experience in using DB links & materialized views.
• Wrote PL/SQLstored procedures, functions and packagesfor moving data
• Good Experience with Oracle PL/SQL scriptting
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
• Having experience with Bigdata databases.
• Experience with BMC Remedy tool for all change management process.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Creating Materialized views and Materialized View Logs for Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• 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.
• Experience includes using Golden Gate to support data replication in the Oracle database environment
• 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.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

Confidential, NJ

Oracle DBA

Environment: Oracle 8i/9i/10g, Solaris 9, Red Hat Enterprise Linux 4, HP-UX 11.2, RAC, Windows 2003, Grid Control 10g/11g, 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.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• 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.
• 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.
• 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.
• Documented the entire core procedures required for the oracle database maintenance.
• Created Materialized Views/Snapshots for replications and increase query performance.
• Refreshed PROD, DEV, UAT databases using Datapump, RMAN, Transportable Tablespaces etc.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.

Confidential, CT

Oracle DBA

Environment: Oracle 10g/9i/8i, Sun Solaris 8, AIX 5L 5.3, Windows 2003, TOAD, RMAN, OEM.

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.
• 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).
• 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.
• Managed and resolved design issues during development stage. Worked closely with developers.

Confidential

Oracle DBA

Environment: Windows-NT, Oracle 8x/9i,10g,Redhat Linux, TOAD

Responsibilities:

• Performed Installations of Oracle software on various Windows and UNIX servers.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• 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.
• Good Experience with Oracle PL/SQL scripting.
• Created PL/SQL programs using collections, record types, object types
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing the queries and application tuning.
• Controlling and monitoring user access to the database for new and existing databases.
• Involved in numerous Shell Scripting pertaining to the activities of the DBA.
• Performing Management tasks on Schemas and objects using TOAD
• Using SQL*Loader, Export, Import in order to Extract and Load Data.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.