RUSHIKESH SOCHA

Sr. Oracle DBA

acxsna@r.postjobfree.com / 860-***-****

LinkedIn: www.linkedin.com/pub/rushikesh-socha/13/650/b8a/

Experience Summary

** *****’ experience as an Information Technology Professional. Performed as Oracle DBA in a variety of (life Cycle) environments including: Banking, Insurance, Finance & Retails domains.

Oracle RDBMS Database Administration, Disaster recovery, Performance Tuning, Cloning, Migrations, Capacity planning, Installations, Up gradations, Patching, RMAN backups, 24x7x365 production support for mission critical systems.

Experience in database architecture, design, development and deployment

Experience in PL/SQL programming and Unix Shell Scripting scheduling Application jobs like archival of data, reporting jobs, database alerts, writing triggers for audit jobs etc…

Extensive experience in troubleshooting production issues in OLTP environments troubleshooting PLSQL code, SQL queries for performance, SqlLoader for Loading issues

Extensive experience in working on oracle portioning, Materialized Views and Data Archival methodologies, Design Changes, suggesting SQL query re-writes for the developers.

Proficient in Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, STATSPACK/AWR Reports, SQL TRACE, Outlines, Baselines, custom scripts and Wait Event Analysis, Database parameters, OS parameters etc.

Administering all database objects including tables, clusters, indexes, views, sequences, packages & procedures

Documenting and adhering to change management and release management procedures and guidelines and implementing the same.

Consulting on various aspects of service delivery and support procedures according to industry best practices and implementing the same

Proficient with Oracle 10g, 11g RAC, Data guard physical standby & Logical Standby Database, Data Guard, Replication, RMAN, ASM, Enterprise Manager/Grid Control.

Knowledge in UNIX platforms includes HP, SOLARIS, and LINUX.

Proven experience with database performance and tuning techniques to enhance database optimization plans.

Experience in installation, configuration of Oracle 10g RAC & 11g RAC & RAC ONE

Managing the RAC database such adding new nodes and deleting the existed node from cluster and managing ASM such as disk group maintenance.

Experienced in Disaster Recovery setup.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Experience in database recovery techniques and implementation of those recovery techniques to ensure business continuity.

Expertise includes management of schemas, objects & partitioning the tables & indexes.

Team leader with good project management and diagnostic skills.

Excellent ability to work both independently and in team.

Technical Skills:

Operating Systems

HPUX, SUN SOLARIS, IBM AIX, RHEL & Windows 98/NT/2000/xp

RDBMS:

Oracle Database administrations 9i, 10g, 11g, 12c

Languages

SQL, PL/SQL,UNIX Shell scripting etc.

Tools

RMAN,OEM 12c,TOAD,SQL *Loader, Exp/Imp, Expdbp/Impdp, Autosys, Siebel Tools, PVCS,

HP Data Protector, Subversion, BMC Perceiver 9.5 etc

Tuning Tools

TKPROF,EXPLAIN PLAN, AWR, Tuning Advisor, Precise i3 etc.

Ticketing & Tracking Tools

BMC REMEDY

Work Experience

Staples Inc, Framingham, MA Dec 2014 – Till date

Sr. Oracle DBA

This role involves leading a production support DBA team for maintaining and supporting the Staples infrastructure Services Operation for around 800+ databases.

Responsibilities:

Leading a team with providing hands-on L3 support for 24X7 production environment.

Working with oracle database 10g, 11g and 12c on Linux, AIX & HP-UX

Providing support to RMAN backup jobs, configuring and troubleshooting the backup failure and other RMAN related issues,

Regularly performing Database DUPLICATION using RMAN to refresh existing database or to create a clone databases for RAC & Single instances

Installation of oracle databases (11g & 12c) Single instance, RAC, RAC ONE along with configuring ASM disks for oracle Automatic Storage Management.

Troubleshooting the performance issue, performance tuning

Applying quarterly database PSU Patches to Single instance, ASM, RAC Databases, OEM 12c

Database upgrades & Migrations between different versions

Administration and providing support to oracle enterprise manager 12c,11g and 10g.

Installation/Upgardation/Patching of grid agents and grid infrastructures.

Creating different type of OEM (information publisher reports) reports for all database targets.

Installation/configuration of oracle Datagurard for high availability and supporting the datguard environment for any log gaps or any other issues.

Performing datapump export/import for various maintenance activities

Working with shell scripting for daily database monitoring

Providing support to daily alerts setup via grid control/custom scripts and HP OVO

Documenting and adhering to change management and release management procedures and guidelines and implementing the same across the team.

Oracle Data redaction & Masking

Environment: Oracle Database administrations 10g, 11g,12c on RHE 6.X, AIX and HP-UX. ServiceNow, HP OVO, Toad, OEM 10g, 11g & 12c

The Hartford Insurance Group (HIG), Hartford, CT April 2011 – Dec 2014

Sr. Oracle DBA

This role involves leading a production support team in the Managed Data Services (MDS) space which is one of the largest support teams involved in maintaining and supporting The Hartford’s IT infrastructure and databases. The fact that the The Hartford is a key player in the Insurance business and combined with the diverse technologies involved in its IT space makes this project a very critical and challenging one in terms of supporting the environment.

Responsibilities:

Leading a team with resources in onsite and offshore to provide a 24X7 on call production support on rotational basis to support databases and applications.

Documenting and adhering to change management and release management procedures and guidelines and implementing the same across the team

Consulting on various aspects of service delivery and support procedures according to industry best practices and implementing the same in the team

Carrying out extensive performance tuning using explain plan, sql profile, SPM.

Leading various initiatives for capacity planning/providing Yearly forecasting for database storage and automation of monitoring and database health checks across all portfolios in the enterprise

Working with PL/SQL programming and Unix Shell Scripting scheduling Application jobs like archival of data, reporting jobs, database alerts, writing triggers for audit jobs etc

Supporting applications and databases across various platforms including Siebel and multiple versions of Oracle, viz 9i, 10g and 11g

Closely looking or process improvement opportunities

HA Testing once in a year which involves FAILOVER and DR testing

Code analysis which includes reviewing of oracle related code which going for release. in case if needed providing suggestion to improve the performance of the code,

Weekend reveres demand management related outage management

Coordinating various support groups for support, outages as well as regular activities like patching, releases, etc.

Taking initiatives for proactive monitoring and database health checks to ensure performance and round the clock availability of survival critical databases

Getting involved in status calls and review meetings and producing reports to multiple stakeholders along with clients.

Training and mentoring new inductees in the team to provide support

Environment: Oracle Database administrations 10g, 11g, on Sun Solaris 10 and RHE 5.X, SVN, PVCS, Toad, OEM,Siebel Tools, Precise i3 etc

Tata Consultancy Services Ltd (BαNCS – CoreBanking Solutions), Mumbai, INDIA May 2007 - April 2011

Oracle DBA

Core banking solutions is a project to centralize the banking system. The software involved in this project is procured from FNS, Australia (now a fully owned subsidiary of TCS). System Integration and Implementation at pilot sites of a Core Banking Solution package to deploy a high-performance, 24x7 state-of the art “Anywhere Banking” Core Banking Solution that

Interfaces with different banking channels. This comprehensive solution will ensure the realization of a fully functional Centralized Core banking solution for SBI and its associate and many other banks across the world.

Responsibilities:

Installation of different versions of oracle software on different UNIX and windows environment.

Done DATAGURAD (10g)/11g setup and switchover testing and RMAN for COMANWEALTH BANK OF AUSTRALIA and QATAR DEVELOPMENT BANK

Involved in TCS BαNCS Performance Benchmarking with ORACLE 10g,11g on SUN SOLARIS & LINUX platforms

Database creation, configuration and schema creation.

Installation and configuration of different oracle database related tools.

Monitoring heavily loaded databases regularly and tuning.

Different kind of exp/imp as per the user and client requirement.

Resolving issue regarding sql and pl/sql coding as per the user requirements.

Writing triggers as per the related events and resolving problems related to packages and procedures.

Taking daily backup of all UNIX servers using data protector including oracle export database backup.

Data Protector Configuration for taking automatic backup.

Restoration of database tables and region related files whenever required.

Modify all Backup specification regularly for adding new regions.

Regularly remove obsolete files and directories from backup specification & backup Verification

Space management in oracle related file systems.

Troubleshooting PL/SQL and SQL code and to suggest developers about any improvements.

Basic OS Administrations, Volume Groups & logical volume creation in hpux, IBM AIX and Linux el5.

Environment: Oracle database 9i and 10g, DataGuard,RMAN,RAC on HPUX 11.X.X, SUN SOLARIS 9/10, IBM AIX, RHEL 4.X,5.X & Windows, PVCS, HP Data Protector, Cobol, Toad,

WIPRO Infotech (Client- 3Global Services Pvt. Ltd), Mumbai, Maharashtra INDIA Sept’06 – May’07

Oracle DBA

Responsibilities

Complete installation of the Oracle database server 9i on the Solaris 9 platform and Oracle 9i.

Applying the Solaris and the Oracle Application11i patches as and when required.

Designing the Backup and Restore policies for taking the daily physical hot and cold backups and logical exports of the databases.

Constantly looking at the database size and then increasing the space as and when required.

Analyzing the database tables and Indexes and then rebuilding the indexes if there is too much fragmentation in the indexes.

Using the STATPACK reports to look at the various statistics of what all is going on in the DB.

Cloning the Oracle databases across the multiple platforms.

Environment: Oracle database 9i and 10g on HPUX 11.X.X, SUN SOLARIS 9/10 and RHEL 5.X, Enterprise Manager and Toad

Accel Frontline Ltd., India July 2005 – Sep’ 2006

Oracle DBA

Responsibilities

Installation and configuration of oracle software and database on different Platforms like UNIX and Windows.

Configuring Backup strategies like cold backup, hot backup, RMAN.

Perform Export/Import as per requirement.

Creation of Standby database and regular testing, mostly for the RTGS and E- treasury Department as per the Bank’s requirement.

Database Migration/up gradation, as per the client requirements.

Creation of different database objects as per the client requirements.

Database performance Tuning, Monitoring Disk I/O, processes, etc.

Installation and configuration of ORACLE REAL APPLICAION CLUSTER in client locations.

Environment: Oracle Database administrations 9i, 10g, ASM, RAC on HPUX 11.X.X, SUN SOLARIS 9/10, IBM AIX, RHEL 4.X & Windows

Sai InfoSystem (I) Pvt Ltd., INDIA May 2004 – Oct’ 2004

Engineer – Customer Support (Hardware & Networking)

Responsibilities

Maintenance, Installation and troubleshooting of windows and Unix software

Hardware support & Troubleshooting.

Basic Networking related Support.

EDUCATION: B.Tech Computer Science & Engineering, Motilal Nehru National Institute of Technology (MN-NIT), Allahabad – 2003

CERTIFICATIONS

OCP - Oracle Certified Professional, Oracle9i (OCP DBA 9i) – 2004

Contact this candidate