Professional Summary:

• Sr. Oracle DBA with 7 years experience on Various platforms HP-UX, Solaris, Linux, AIX WINDOWS .
• Installation and administration of Oracle 11g/10g/9ion OEL, RHEL, HP-UX, Windows, UNIX and Sun Solaris in OLTP environment.
• Managed Databases in the range from 50GB to 3TB.
• Performed Migration and Upgrade of databases to 11g and 10g.
• Upgradation of databases by applying patches, patch sets and critical patch updates.
• Extensive experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
• Extensive experience in configuring and managing Dataguard on RHEL, OEL and Windows.
• Configuration of Dataguard broker on RAC.
• Handful experience with Conflict Handlers in Streams.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on DataReplication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Design and implementation of Backup and Recovery strategies both cold and hot backups and performing periodical backup, restoration and recovery using RMAN full and incremental
• Migration of databases from one platform to another platform.
• Implementation of Flashback Technology.
• Experience in Uni-directional and Bi-directional replication through Golden Gate.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• 24 7 on-call production database support and maintenance including remote database support

Professional Experience:

Confidential

Role: Sr. Oracle DBA

Responsibilities:

• Install , configure and maintain 11g RAC with ASM on Solaris, create and manage Services in RAC with dbca/srvtl. Manage Disks in ASM. Worked on Projects having RAC from scratch through golive.
• Implemented 11gR2 RAC with ASM and SCAN listener technology.
• Expertise in Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Partitioning of regular table for performance gain, redefine table structure to have partitioning key. Maintained Partitions with automated scripts to drop old partition and add new partition to keep desired data in database. Manage Global and Local Indexes on Partitions.
• Use of RMAN for Backups , RebuildDataguard using RMAN , Rebuild out of sync Dataguard with incremental backup using RMAN.
• Configured 11g Active Dataguard, Monitor and maintain dataguard, , Switchover Primary to Standby.
• Upgrade 10g databases to 11g
• Support day to day user issues and troubleshooting like Locks, Blocking sessions, Space issues, Slow performance, Grants, Roles, Profiles, SQL troubleshooting etc.
• Monitoring with EM Grid and supporting load tests with AWR / ASH Reports, Blackouts for maintenance etc. Monitored CPU, concurrency etc during load tests and batch activites. Configured Targets , alerts through OEM. Managed Backouts during maintenance windows.
• 24 7 Production Support with oncall rotation 12 12 Onsite/Offshore model with Pager support and using PAC2000 Ticketing tool.
• Heavy use of DataPump for archiving data , refreshing data and daily backups.
• Using RMAN for database backups, resolve day to day issues like backup failed, archive destination full etc.
• Performance tuning of time consuming queries and database level.
• Managing TAR with Oracle Support and providing requested information like AWR/ASH Reports, RDA Reports , File versions, doing OWC etc.
• Database Migration from one server to another server with zero downtime by configuring replication to new server.

Environment: Oracle 9i/10g/11g RAC,ActiveDataguard, ASM, Solaris 10, Linux AS 4.0, HP-UX, AIX, Shareplex, Java

Confidential

Role: Sr. Oracle DBA

Responsibilities:

• Analyzed requirements and prepared system flows, specifications, and database designs.
• Installed, Upgraded and Configured Oracle 10.2.0.3/ 9.2.0.8/8i on Red Hat Linux 5 environment.
• Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle RAC on Red Hat Linux
• Written various Shell Scripts for production, development and QA databases such as startup, shutdown, backup, analyze statistics and generate consolidated status reports.
• Startup and Shutdown of Individual instances on RAC database using OEM.
• Successfully maintained Oracle RAC environments.
• Experienced in using the commands srvctl, crsctl to start, stop manage configuration information for the Server Control Utility and for Oracle Cluster ware management in Oracle RAC environment.
• Implemented schema replication, information propagation from one database to another database using Oracle Streams.
• Used Data guard cluster techniques to provide a high level of data protection and data availability.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Management of schemas, Data modeling, objects partitioning the tables indexes.
• Worked on Advanced Replication including synchronous and asynchronous scenarios
• Designed, Developed and generated reports to provide up-to-date information for production planners using Crystal Reports and MS Office.
• Upgrade and Migration of Database from lower version to 11g R2 and applied patches whenever required.
• Successfully provided 24x7support and monitoring of databases.
• Implemented the data migration from the previous database.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Gathered requirements by interviewing production employees, production planners and management team.
• Involved in extensive usage of Erwin 4.0 for Data Modeling for both logical physical design of the database including creation of E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams.
• Automated the Sending, receiving data from clients Electronic Data Transfer and uploading data into database from flat files using SQL Loader and shell scripts.

Environments : Oracle 10G/9i/8.x, SQL, PL/SQL, SQL PLUS, SQL Loader, Import/Export, OEM, RAC, RMAN, Crystal Reports, Developer/2000, Erwin, Shell Scripting, Solaris, HP-Unix, Windows 2000.

Confidential

Role: Sr. Oracle DBA

Responsibilities:

• Installed Oracle 9i/10g standalone, RAC with ASMon HP-UX 11.2, Red Hat 4.
• Performed conversion of Non RAC single instance to Real Application Cluster RAC database instances.
• Setup, integrated and managed Standby databases for 9 locations getting replicated at corporate office.
• Worked on Automatic Storage Management ASM for managing data in SAN.
• Configured Oracle Enterprise Manager Grid Control for monitoring multiple databases and notification of database alerts.
• Setup Basic replication using Materialized views for replicating data.
• Backup plan designing and implementation using cold/hot backups for database running on raw devices and Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using Data Pump, RMAN backup technology.
• Worked on PITR, TSPITR scenarios using RMAN.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 11g using Oracle data pump.
• Used Cross-platform Transportable Tablespacesmethod to move data is more efficient than the traditional method of export and import.
• Upgraded the production database from 9.2.0.6 to 10.2.0.2 within tight cutover window, around 45 databases with max database size of 2.6 TB.
• Applied security patches on both Server side and Client side and Performed testing.
• Intensively used latest 10g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM , ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Monitor performance, Storage, backup logs, database logs, tables, extents, indexes, and all other back-end objects in production.
• Capacity planning for tablespaces, datafiles, tables, indexes according to DW requirements and size production instance.
• Write scripts to automate the synchronization process between local and remote database.
• Document all the back-end objects, logical and physical data model and database structures.
• Troubleshoot user related and database related issues using Oracle Metalink.
• Provided on-call support regarding production related database problems.

Environment: Oracle 11g/10g/9i, RAC, ASM, Dataguard, HP-UX 11.2, Linux Red Hat, Toad, Oracle Enterprise Manager, SQL Plus, SQL Loader, PL/SQL.

Confidential

Role: Oracle DBA

• Implemented wide variety of applications by Partitioning and reducing costfor storage of large amounts of data.
• Migration of databases from one platform to another platform.
• 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.
• Performance tuning on sqls and instances.
• Created local and global indexes on huge tables 5TB . And gathering stats on those indexes.
• Performed SQL LOADER to import new data.
• Configured and resolved Oracle Enterprise Manager OEM issues.
• Most of the jobs where taking more than 10 hours to complete, I modified the procedures to complete in less time.
• Helped the application team in writing PL/SQL and shell scripting.
• Perform SQL tuningadvisors and checking Explain Plan on the SQLs.
• Adding Profiles and roles to the existing users and creating users.
• 24 7 on-call production database support and maintenance including remote database support.
• Created views and Mviews.

Environment: Oracle 11g, Linux, SUN Solaris, AIX, SQL Developer, PL/SQL, Shell scripting Bourne/ Korn/ C , OEM GC,RMAN, Dataguard, DataPump, SQL Loader.