Experience Summary

• 9 years experience as an Information Technology Professional. Performed as Oracle DBA in a variety of (life Cycle) environments including: Insurance & Telecom Industry
• Oracle RDBMS Database Administration, Disaster recovery, Performance Tuning, Cloning, Migrations, Hardware and Capacity planning, Installations, Upgradations, Patching, RMAN backups, 24x7x365 production support for mission critical systems.
• Proficient with Oracle 10g,11g RAC,Data guard physical standby & Logical Standby Database, Data Guard, Replication, RMAN, ASM, Enterprise Manager/Grid Control
• Proven Experience with 11g, 10g , 9i & 8i
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, and LINUX.
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB).
• Proven experience with database performance and tuning techniques to enhance database optimization plans.
• 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 etc
• Experience in installation, configuration of Oracle 10g RAC & 11g RAC.
• Managing the RAC database such adding new nodes and deleting the existed node from cluster and managing ASM such as disk group maintenance database replication
• 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
• Installation and Configuration and administration of Oracle 10g application Servers.
• Team leader with good project management and diagnostic skills
• Excellent ability to work both independently and in team

Technical Skills

Sun Solaris 8,9,10 , HP-UX 10.x, 11.x, RHEL 3.x, 4.x and Windows 98/NT/2000/XP

RDBMS

Oracle 11g/10g/9i/8i

Languages

PL/SQL, SQL, Unix Shell Scripting

TOOLS

RMAN, OEM, TOAD, SQL *Loader, Exp/Imp, Expdp/Impdp, Autosys etc

Tuning Tools

TKPROF, EXPLAIN PLAN, AWR, Tuning Advisor etc

Change Tracking Tools

REMEDY

Assignments

Confidential,CT

Duration

Oct 2010 to till date

Company Profile

usually known is a Fortune 500 company and one of America’s largest investment and insurance companies. The Hartford is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans. The company’s earnings are divided between property-and-casualty operations and life operations

Projects Handled & Handling

New Business Vision(NBV)
The New Business Vision (NBV) program is focused on transforming our New Business functionality for Small Commercial. Small Commercials position in the marketplace. relative to ease of doing business has been deteriorating over the last few years.
NBV will drive more quotes and issues from engaged and unengaged agents by providing an improved user experience.

• Deliver Real-Time Bind-able Quotes (Automated Underwriting) at an increasing rate over time while maintaining profitability
• Deliver an Easy, Predictable experience for Underwriter Referred Quotes
• Provide support for proprietary and non-proprietary access, enabling anticipated business strategies

BladeLogic
BMC BladeLogic Automation Suite Manages, controls and enforces configuration changes in the data center.
BladeLogic is used for multiple functions, including IT service management, data center automation, performance management, virtualization lifecycle management and cloud computing management.

Enterprise Oracle Planning(EOP)
Enterprise wide initiative to consolidate, upgrade and migrate databases on to linux platform from sun Solaris, HP-UX. Actively doing the DB consolidations, migrating the databases to Linux platforms, upgrading the databases to 11gR2 for all the databases in business insurance domain

Maintenance of current databases on solaris
production support DBA for all Prod and Non-prod databases of Business Insurance

Role/Responsibilities

Senior Oracle DBA and Lead

• Involved in design, implementation and maintenance of NBV

Multi million dollar project.

• Leading the EOP program for migrating the databases from solaris

And HP-UX farm to Linux.

• Implemented BMC product BladeLogic for The Hartford datacenter

For datacenter automation.

• Installation and configuration of single instance and RAC databases
• configuration of RMAN backups clubbing them as Autosys jobs

scheduled in Autosys

• Setting up the DR databases at DR site in Boulder Colorado.
• Participating in DR Drills Quarterly to set up the DR databases for

end to end testing of databases and applications to ensure a
smooth work-flow for the business in a real-time disaster scenario

• Performance tuning of poorly performing sql queries to enhance

performance

• Troubleshooting all operational issues to ensure smooth day to

day operations

• San Forecasting for all the applications yearly
• Production Support 24x7

Work Location

Confidential,Redwood Shores , CA

Duration

Mar 2008 till sep 2010

Company Profile

American multinational computer technology corporation that specializes in developing and marketing computer hardware systems and enterprise software products – particularly database management systems
Oracle is the world\'s largest enterprise software company, offering solutions for middleware, business intelligence, business applications, and collaboration.
Client list included online trading companies like Amazon and Ebay, entertainment media like ESPN, Financial and banking institutions like Fidelity, Capital One, Duetsche Bank, HSBC, Royal Bank of Scotland, ICICI Bank and Citibank, Postal companies like UPS, Airlines like Boeing and Qantas, IT majors like Cisco, HP, Sun, Dell and SAP, Telecom sector companies like Vodafone, AT&T, Bharti Mobile, BT, Korea Telecom and China Telecom, Car majors like Ford and Williams, Manufacturing and other majors like General Electric, Goldman Sachs, EDS, Xerox, Lucent etc

Role/Responsibilities

• Solving performance problems with the databases with respect

to sql tuning,Db parameters tuning,OS level, storage and network level
Issues.

• Performing Database recoveries, handling corruption issues, troubleshooting DB related issues
• Installed, Administered and Troubleshooting issues related to

oracle Real Application Cluster Databases ( RAC ) for oracle 10g
and 11g.

• Performed Database Migrations and Upgrades on the same platform and across Platforms.
• Tuned the RAC database for performance issues using AWR Reports.
• Installed, Created and Administered Automatic Storage (ASM) instances for use with both single Instance and RAC set ups.
• Setup and Managed Oracle Data Guard / Standby both Physical and Logical for Oracle9i and 10g performing both planned and unplanned switchovers and fail-overs
• Formulated Backup strategies & performed numerous Recovery operations.

Methods include cold, hot, recovery manager (RMAN) and logical backups.

• Performed tuning of adhoc queries using various tools like explain plan, sql_trace, events like 10046, 10053 and 10060, tkprof, utlxpls, utlxplp, dbms_stats, ADDM and OEM.
• Performed patching of data block and data dictionary and debugged numerous ora-600, ora-7445 errors and other corruptions. Used in-house utilities to extract data from corruptions.
• Optimization of the Linux based servers for higher throughputs, kernel compilation and tuning.

Work Location

Confidential,

Duration

Jan 2004 till Mar 2008

Company Profile

presence in the telecom sector. Incorporated in 1996, Tata Teleservices is the pioneer of the CDMA 1x technology platform in India. It launched mobile operations in January 2005 under the brand name Tata Indicom and today enjoys a pan-India presence through existing operations in all of India\'s 22 telecom Circles. The company is also the market leader in the fixed wireless telephony market. Tata Teleservices Limited has also become the first Indian private telecom operator to launch 3G services in India under the brand name Tata DOCOMO.
Today, Tata Teleservices Ltd, along with Tata Teleservices (Maharashtra) Ltd, serves over 85 million customers in more than 450,000 towns and villages across the country

Projects Handled

EVDGSM RAC installation, configuration and migrating the data
Electronic voucher Distribution: - Application used to Re-charge the pre-paid Vouchers online
TIBCO-BPM RAC Configuration
TIBCO and EI application tool used for implementing BPM (Business Process Management), which is supported by staffware (TIBCO i-Process engine) running on a database for integrating different applications like CRM, Billing and Metasolv etc. Different TIBCO tools like Business Works Administrator, Adaptors and EMS are used for integrating applications.
Upgradation of databases from oracle 8 to 9i, 9i to 10g
Taken up the project of upgrading the databases in the datacenter to 10G.Planned prepared and executed the plan with in the timelines in a flawless manner
Disaster Recovery Databases Configuration
All the Database services across the company is being served by the single Data centre located at Hyderabad, which hosts about 300 Production Database instances serving the customers across the country. DR site is set up at Delhi, which has copies of major production databases kept in sync with production databases using standard DR replication methods.
Production support 24x7x365 for Mission Critical Systems like Metasolv, Billing,Online Recharge,CRM Systems, VTM, TIBCO etc
Metasolv
Operations support system mainly used for order management. In TTSL metasolv is used for raising orders, new connections, change, and disconnections
Billing
Kenan is the billing product. Supported 25 states of billing production databases. These are the absolute revenue critical databases for the company.
CRM
This is the crucial database which is critical for the call-center operations interlinked with the billing, tibco, metasolv and all the main applications. The setup is on a 3 node RAC.
Reporting Data Warehouse databases
Daily recovering the report databases after BCV sync from production billing databases during nights.

Role/Responsibilities

Module Lead

1) 24*7 production Support for mission critical production
Installation and configuration of Oracle single instance
Databases.
2) Installation and configuration of RAC instances in oracle 10gR2
3) Configuring RMAN backup for the databases.
4) Trouble shooting the databases for various dynamic issues
during run time

• Solving performance problems with the databases with respect

to sql tuning,Db parameters tuning,OS level and network level
Issues.

• Migration of the databases to different servers and Cloning of the databases
• Restorations of databases using RMAN
• Upgrading the databases to higher versions of oracle
• Experience in various recovery scenarios.
• Configuring the DR databases and troubleshooting the various

Issues related to the DR recovery.

• Performing switch-over between Primary and standby

Databases.

• Performing DR Drills once in every year
• Installation and configuration of oracle application servers.
• Deployment of applications and troubleshooting the issues

Related to application servers.

• Generating stats pack reports on regular basis to identify the

database performance at peak load

• Tuning the SQL statement by analyzing the explain plan

and ADDM reports

• Implemented scripts to monitor the health of the databases

and application servers

• Design & developed PL/SQL Stored Procedures & Database

Triggers to Implement Business rules & Security.

• Experience in planning and implementing the maintenance

activities to reduce fragmentation and improve performance

• Planning and implementing the Archival policies as per the

Requirements.

• Working with the solution design team and identifying solutions

to the new business functionalities.

• Preparing the weekly and monthly status reports to the

Management.