SKILLS SUMMARY

12years of diverse engineering and development experience with concentration in RAC/ASM/Data Guard/ GRID and SQL. I have developed and displayed n-depth knowledge of Oracle 10g/11g R1/R2 RAC implementation and administration on RHEL Linux and UNIX Solaris. I possess a Result Driven, Team Oriented and proactive problem solving personality. Exceptional Soft Skills, Excellent Written and Verbal Communication Talent, Exceptional Multi Tasking Abilities and Reliability.

Networks: Windows NT O/S Windows NT/95/98/2000, MS-DOS, RHEL Linux, UNIX Solaris, Net App SAN,VCS, NetApp Snap Manager for Oracle, DataGuard, Enterprise Storage Networking Languages: SQL, Pl/SQL,HTML, ASP, VB

RDBMS/Storage: Sybase, MySQL, SQL Server,Oracle8i, Oracle9i, 10g,11g R1 and R2 ,Dataguard local standby and DR ,RAC, Data warehouse, Cognos, Datastage, Oracle Portal Infra and Mid-tier, Oracle Weblogic ,PeopleSoft Enterprise Portal, PeopleSoft EPM, PeopleSoft HCM 8.9-9.1, People tools 8.49 8.5, ASM,OCFS2,MS Access, SQL SERVER 2005 , Teradata ,Golden Gate.

GUI Tools: Oracle Reports, OEM, Crystal reports, SQL Navigator, TOAD, SQL, 10g,11g, Grid Control, 12C cloud control,

ACHIEVEMENTS

• Built Oracle 11G RAC environment on RHEL Linux
• Involved in successfully migrations, and operational support of Oracle EBS 11i, R12 .
• Upgrade 11gR1 to 11gR2
• Worked with team to Install PeopleSoft and PeoplTools in development and production.
• Upgrade PeopleSoft campus solution and People Tools.
• Built Data warehouse Databases
• Built Data guard local standby and DR
• Built Oracle 11G Grid control environment on Linux
• Performed Oracle Database upgrades from 9i to 10g in Linux RAC
• Performed Oracle Database upgrades from 10.2.0.3 to 10.2.0.4 in Linux RAC
• Migrated MS SQL to Oracle
• Clone and Refresh Databases from cold and RMAN backups
• Experience in installation, configuration, administration of Oracle 8i, 9i, 10g, 11g, 10g RAC, 11g RAC database on Red Hat Linux, and Windows environment.
• Expertise working on oracle 11gR2 RAC environment.
• Started working on new 12C databases and its new features by involving in POC's.
• Experience on installation and configuration of 12C OEM.
• Continuous research in leveraging new features of oracle and bringing them under day to day DBA activities
• Expertise in troubleshooting Cluster issues in 11g RAC and 10g RAC databases.
• Upgrade/Migration of oracle databases from 8i to 9i and 9i to 10g and 10g to 11g.
• Worked on Set up, configuration and maintained Oracle Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager OEM .
• Good knowledge in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning of databases using RMAN.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Implemented automated backup strategy and monitoring of databases using UNIX shell script CRON UTILITY.
• Expertise in overall tuning of Database using Automatic Workload repository AWR and Automatic Database Diagnostics Monitor ADDM tools and tuning of SQL using STATSPACK, EXPLAIN PLAN and TKPROF.

Working experience on both OLTP and OLAP environments.

Project Experience

Confidential

Oracle DBA

• Provided Oracle/PeopleSoft database administration support in OLTP and DSS corporate environment.
• Created and Managed Data warehouse Cognos Databases DSS
• Applied patches and upgraded Release 11gR1 to 11gr2
• Built Development, UAT, QA, Performance and Production environment to support People soft application.
• Built and supported Data Guard standby and remote DR
• Built and supported database environment to support HECH application.
• Maintained the Heart beat tables to check the lag between the sites.
• Worked with application team to help resolving the conflict and trouble shouting the replication issues.
• Experienced in Design, implementation and generation of documentation on Oracle 11g Data Guard on physical standby databases in Maximum performance mode.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Performed Setup Recovery Manager RMAN and Flash Recovery in RAC Environment.
• Built and supported stand alone, RAC 2node cluster RAC 3node Cluster databases
• Clone and restore RAC to None RAC and RAC to RAC databases.
• Refreshed RAC to RAC and none RAC to RAC databases
• Configured and setup the RMAN
• Configured Grid control 10g,11g for monitoring multiple environments
• Implement patches, updates, and fixes as necessary following established Change Management processes
• Work with team members to provide 7x24 production support
• Utilize a working knowledge of Oracle database and consuming third-party applications to troubleshoot technical issues, i.e. error messages, software bugs, availability, etc.
• Worked very closely with developer for performance and tuning for database and application.
• Worked with ADDM, AWR and SQL tuning advisor to tune any long running queries and overall database sessions.
• Performed cold backups and restore
• Participated auditing session to comply with SOX requirements
• Participate effectively in execution of projects to support development, integration, production and infrastructure deliverables.
• Ensure system stability, availability and performance
• Upgraded 11 Rel1 to Rel2 RAC and Standalone Databases
• Implemented local and Remote Data guard.
• Troubleshooting Database environments challenges/exceptions/alerts

Confidential

Oracle DBA

• Responsible for performance and tuning, Performance Monitoring Stats Snapshots.
• Installed and configured 10g Grid Control to maintain and monitor databases
• Configured, implemented 10g RAC with ASM disk on Linux servers.
• Installed Oracle 10G RAC on Linux platform using ASM for a storage manager Provided performance tuning on a 10G RAC database on a Linux platform
• Implementation and support of 10g RAC instances
• Administration of development, test and production databases
• Provide on-call support for critical database issues on a rotational basis
• Perform database upgrades and migrations to updated version
• Experienced in patching, upgrading, and monitoring multiple database environments
• Monitoring Development, Test, Staging and Production Environments
• Responsible for system and capacity planning
• Responsible for software installation and database creation
• IP reconfiguration for entire Data center move in Development, Test, Stage and Production environments.

Confidential

Oracle DBA

• Monitoring multiple production and development databases. Monitor RMAN backups.
• Support of over 150 development, test and production Oracle databases and SQL Server.

• Responsible for performance and tuning, Performance Monitoring Stats Snapshots.

• Working on Database Hardening Edit and Monitor the daily jobs Process data dump requests for clients Process database changes for clients.

• Working with DBA team to re-structure the windows environment to accommodate ESC Database Standards.
• Work closely with software developers to meet user requests and assist with prioritization

• Responsible for capacity planning weekly and performance overview reports for all Production databases.

• Responsible for database documentation.

• Responsibilities included configuration and installation for Test and Production.

• Responsible for patch management and upgrades.

• Responsible for 10G upgrade from 8i and 9i oracle versions.

• Applied all DST patches for Application infra and mid-tier production environments.

• Responsibilities included running the daily batch loads from the ESC Data center, monitoring the automated daily backup routines, writing documentation for new components being added to the system, performance tuning and monitoring of database using Oracle Enterprise Manager, 10g Grid Control and performance evaluation utilities.

Confidential

Oracle DBA

• Database 10g in Oracle Real Application Clusters RAC environment.

• Involved in configuration of 10g RAC on EMC Storage Area Networks SAN Migration from SQLServer to Oracle.

• Working with development team for conversion of objects from SQLServer to Oracle.

• Monitoring the database activities jobs, backups, Logs, table space, user activities. Monitoring the tables on sqlserver for daily data update.

• Updating development database daily with fresh data from production

• Setup backup and recovery procedures.

• Monitored server disk spaces, databases performance, replication, and backups and scheduled tasks. Daily management of Oracle database, support and development of applications using PL/SQL
• Oracle DBA support including backups, recoveries, installations, database performance analyzing existing databases and their interfaces looking for opportunities to improve efficiency.
• Configured and managed users, security and redo logs.

Confidential

Oracle DBA

• Introduction and firm foundation in clustering technologies RAC Designed, implemented, and maintained a new Request tracking system. Installation.

• Solution in the COPE environment. Interfaced with users and technical staff to troubleshoot and implement rules. Provided appropriate reports and views into the data for process.

• Generated information sensitive reports with visual pro as front-end tool with SQL Server. Wrote queries against the database for analysis with the help of shell scripts. Programmed, searched and sorted using UNIX tools.

• Collected data from remote system using FTP. Involved in Oracle Forms conversion. Responsible for the back up of databases on regular basis and performing recovery operations when necessary.