SUMMARY

• Oracle Certified Professional 9 Years of extensive experience on Oracle 11g/10g/9i Database Administration UNIX (HP - UX, Solaris, Linux, AIX) & WINDOWS Operating systems.
• Installing/Configuring and Maintaining Oracle Real Applications Cluster (RAC) database on 2 node & 3 node clusters.
• Extensive experience in Installing/Configuring/Maintaining Oracle Enterprise Manager Grid Control for enterprise monitoring.
• Expertise in Performance tuning production databases and performing routine DBA functions like space management, extents and invalid objects.
• Extensive experience on Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g (10.1.0.2)
• Experience in Database Migration & Upgradation from 8i/10g,9i/10g to 11g.
• Experience with Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard and Oracle Data Pump.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
• Expertise in Data warehousing Concepts & Data Mining extraction, transportation, transformation, and loading (ETL) solution.
• Supporting ETL teams/ Configuration and administration of Informatica ETL
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity plan and Disaster recovery plan.
• Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Experience in Loading and Unloading of data using utilities like Export, Import, Data Pump Export & Data pump Import.
• Experience in GoldenGate Replication.
• Experience in Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), Decision Support System (DSS) database systems & implementing and managing Very large databases (VLDB).
• Experience in generating OracleMaterialized viewsto replicate data and to cache expensive queries in a data warehouse environment.
• Extensive DBA experience in supporting multiple instances of Oracle database including Development, Reporting, Data Warehousing, User Acceptance Testing & Production.
• Experience in Cloning/Replicating production database using RMAN & OEM Grid control.
• Expertise in enhancing performance, availability and manageability of a wide variety of applications by Partitioning, reducing cost for storage of large amounts of data.
• Experience with Oracle Management Agent & Oracle Fail Safe.
• Expertise in Oracle Maximum Availability Architecture (MAA), in achieving high HA with low cost and complexity.
• Experience on Installing/Configuring Oracle Golden Gate.
• Extensive knowledge in working with the Tools like OEM, TOAD, ADDM, Export/ Import, Stats pack, SQL * Loader, SQL Analyze, TKPROF, AWR, Explain Plan.
• Expertise in daily batch & Report monitoring, Space management, Index rebuilds and statistics collection.
• Expertise in writing backend Procedures, Functions Packages & Triggers using PL/SQL and data modeling.
• Experience in analyzing database and rebuilding indexes to improve database performance.
• Created Primary database storage structures (Tablespaces), Primary objects (Tables, Views and Indexes) and created users, roles and profiles.
• Implemented and monitored daily, weekly and monthly batch jobs in database.
• Good presentation and communication skills to provide support to the customer.
• Very good team member and self starter.
• Dedications with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.
• Strong conceptual, business, analytical skills and innovative problem solving abilities.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10.AIX 5.1, 5.2, 5.3, 6.1RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10.Windows 95/98/NT/2000.

RDBMS: Oracle 8i/9i/10g&11g, RACSQL Server 2000/2005/2008.

Applications: Oracle Applications 11i and R12.

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, EMC NetWorker, Erwin, Power designer, TOAD, Oracle SQL Developer, Golden Gate, Forms, Reports.

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

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

Others: COMMVAULT, BMC Patrol, BMC ticketing.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr.Oracle DBA

Responsibilities:

• 24x7 Production Database administration
• Installed 10g, 11g different versions of oracle databases for implementation work of re-hosting applications as well as new applications.
• Upgrade databases from Oracle 8i, 9i to 10g, 9i to 11g, 10g to 11g, SE to EE.
• Installed, configured and managed 11g Grid Infrastructure RAC databases
• Established Disaster Recovery for 11g RAC database
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Installed and configured OEM Agents on multiple new servers and implemented standard monitoring and alerting procedures.
• Configured Streams and managed data replication.
• Worked on re-hosting existing legacy databases to new AIX servers.
• Configured database backups using Control-M/Autosys and Net Backup, tested and scheduled daily database RMAN backups and other databases jobs.
• Configured and managed physical standby database using data guard for disaster recovery on a different node for production databases.
• Performed Replication using Shareplex.
• Provided database support from small databases to very large databases.
• Extensively worked in tuning ad-hoc SQL queries with both OLTP and data warehouse databases.
• Partitioned Large tables to execute queries in finite window and fine tune the response time of database.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Tested and Implemented Sound backup and Recovery Strategy.
• Worked on Production Scripting and scheduling of oracle database backup using RMAN.
• Involved in performance tuning the database. Analyzed Stats Pack results to tune SQL for improved performance of the stored procedures and created indexes on tables on a case-by-case basis. Rectified fragmentation and row chaining problems in the database.
• Supported OS patching for both Prod & Non-Prod servers.
• Documented various implementation procedures for future needs and shared within the team.

Environment: Oracle 11g,10g,9i,8i, Solaris 7.0,AIX, Application Servers 9i R1 and R2, 10g R1, Grid management, OID, OEM,TOAD, PL/SQL developer, SQL*Loader, Shareplex

Confidential, Mooresville, NC

Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database administration
• Installed, configured and managed 11g Grid Infrastructure RAC databases
• Established Disaster Recovery for 11g RAC database
• Upgrade databases from Oracle 9i to 10g, 9i to 11g, 10g to 11g, SE to EE.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Create and manage Enterprise Manager jobs, alerts and notifications
• Analyzed and wrote various Stored procedures, Functions, Triggers to be created at the backend database to cater for the entire application
• Performed table level replication and administration on GoldenGate.
• Worked on Exadata environment.
• Created and managed ASM instance and ASM disk groups
• Installing ASM environment and migrating database from NON-ASM to ASM
• Worked on several Shell scripts to maintain the database activities, Written shell scripts for backup monitoring,Password management and montoring standby database
• Configured the Flash Recovery Area
• Configured the RMAN with CommVault for backup and recovery
• Applied patches for enhancement and fixing bugs using Opatch, Adpatch
• Installed and Configured OCM on all Prod and DTQ oracle servers
• Worked on Incidents assigned to DBA team on BMC Remedy
• Installed MSSQL server-08 and configured Data collection on sqlservers and managed Sqlserver databases
• Performed table level replication on GoldenGate.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Worked with Oracle support on various bug fixes and ora-600 errors
• Cloned Oracle homes and databases for testing purposes
• Installed oracle Grid control agents on prod and dev servers

Environment: Oracle 11g RAC, IBM AIX 6.1, RedHat Linux 5, Windows, Sqlserver, HP-UX 11.x, Oracle Applications R12, Shell Scripting

Confidential, Los Angeles, CA.

Sr.Oracle DBA

Responsibilities:

• 24X7 Interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement.
• Involved in RAC administration including Installation of Oracle 10/11g, Database cloning, tuning, patching, monitoring concurrent manager processing.
• Installing/Maintaining/Configuring ASM Environment and Migrating Several Non ASM systems to ASM.
• Cloned Very Large Databases from Production to Development/Test clusters.
• Configured/Set up Monitoring through OEM GC as part of database preventive maintenance, the database growth, alert logs and archive log destination space.
• Upgraded/Migrated Databases from 9i/10g to 11g in the SAP Environment.
• Installed/Configured Oracle streams to propagate information within and in between several databases.
• Performing Backups and Recoveries using RMAN/Conventional hot backups and EMC Networker.
• Configured Oracle 10g Data Guard for RAC production systems.
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations.
• Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
• Created and maintained Materialized views for improved query performance.
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Refreshed using Export, Import, Hot, Cold and RMAN backups from Production to non-prod Environments.
• Used data pump import/export utility of ORACLE to create other development and test databases.
• Maintaining schemas and partitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Supported application team to solve any issues in Production Environment.
• Importing data from flat files into database using SQL* loader and External Tables.

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 11.0/10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker.

Confidential, Seattle, WA

Database Administrator

Responsibilities:

• 24X7 interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement
• Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle Clusterware (CRS) on two node clusters starting from scratch.
• Migrated/Upgraded from Single Instance to RAC and 9i to 10g RAC.
• Configured/Integrated multiple Application Environments to use RAC.
• Configured Automatic Storage Management (ASM).
• Migrated Non-ASM systems to ASM systems
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases from legacy server to production server.
• Setup Databases using DBCA and configuration of users, schemas, objects.
• Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM.
• Configuring Oracle 10g Data Guard for RAC production systems.
• Performed and Recoveries using RMAN/Conventional hot backups.
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations.
• Supporting ETL / Configuration and administration of Informatica ETL
• Created and maintained Materialized views for improved query performance.
• Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Fine tuned queries to optimize the application performance.
• Performed system testing and integration testing of large Data Warehouse application.
• Dealing with Oracle Support/Support Requests (SR), one-off patches.
• Daily Production support /Database Maintenance with/without Grid Control.
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
• Performed capacity planning, provided backup strategy for remote production database.
• Worked with Transparent Data Encryption (TDE) in Oracle 10g R2 to encrypt sensitive data within the data files without access from the OS.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Participated in Database Design / Application meeting as DBA representative, Created physical & Logical models using ERWIN, created schema generation scripts, installed & maintained database objects.

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker.

Confidential

Database Administrator

Responsibilities:

• Installation of oracle 9i & 10g databases in production, development and test environments depending on project requirements.
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• All Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents.

Environment: Oracle 8i, 9i & 10g on Sun Solaris 8/9, HP UNIX, Windows, PL/SQL