• Providing support to Oracle 90 instances. • Working on incident/change tickets using tools ITSM & VSM and resolving tickets as per SLA.• Resolving day to day database issues using ticket management software.• New server set-up, which includes Oracle Software installation and database creation.• Responsible for all database deployments, scripts, data fixes for all environments.• Refresh/Cloning of test/development Databases using RMAN / hot backup. • Creating and maintaining database schemas objects like Tables, Indexes, Views, Database links, Synonyms, etc• Building, installing, upgrading Oracle instances.• Providing support to Oracle critical database instances on RAC and Non–RAC env. • Supporting Oracle Primary, Standby databases using Data Guard Technology.• Assisting developers in SQL tuning and optimization using Explain Plan, TkProf and SQL Trace.• Responsible for database backups and Testing of backups.• Providing On – Call Support on rotation basis

Client: LOBLAW Companies Ltd. CanadaRole: Provided Oracle Database support on IBM AIX. Responsibilities: • Worked on ticket management system and resolving incident & SR tickets as per SLA.• Provided support to Oracle 500 database on RAC and Non–RAC environment. • Supported Oracle 11g Primary, Standby databases using Active Data Guard Technology.• New server set-up, which includes Oracle Software installation and database creation.• Maintained database schemas objects like Tables, Indexes, Views, Database links, Synonyms, etc• Refresh/Cloning of test/development Databases form production backup. • Resolved day to day database issues.• Provided On – Call Support.Environment: IBM AIX 5.3, Oracle 10.2.0.4(10g R2), Oracle 11.2.0.2(11g R2), Remedy 5.x.

Client: BELL Canada.Role: Provided Database support (Oracle / Sql Server) on Solaris & Windows environment. Responsibilities: • Provided support to Oracle and Sql Server critical database instances. • Supporting Oracle 11g Primary, Standby databases using Data Guard Technology.• Largest database size is 2TB+.• Performed regular Oracle / MS SQL Server DBA functions like Install, configure and upgrade software • New server set-up, which includes Oracle/Sql Server Software installation and database creation.• Maintaining database schemas objects like Tables, Indexes, Views, Database links, Synonyms, etc• Assisting developers in SQL tuning and optimization using Explain Plan, TkProf and SQL Trace.• Responsible for all database deployments, scripts, data fixes for all environments.• Refresh/Cloning of test/development Databases. • Resolving day to day database issues.• Responsible for database backups and Testing of backups.• Implemented MySql 3 node cluster 7.0 on Solaris Plateform.• Providing On – Call Support.Environment: Sun Solaris 5.8, Oracle 10.2.0.4(10g R2), Oracle 11.2.0.2(11g R2), Sql Server 2008/2005 , My Sql 7.0 , eSA, window server , AquaData Studio.

Client: TIAA – CREF, Charlotte, NC. USARole: Provided Production Database support to Oracle clustered and non- clustered oracle databases on Solaris environment. Responsibilities: • Provided support to 100+ Oracle instances. • Largest database size is 15TB+ running on ASM.• Involved in new server set-up, which includes Oracle Software installation and database creation as per OFA standard.• Supporting RAC as well as non RAC databases. • Installed Oracle RAC software, Created Cluster Database.• Created and maintained database schemas objects like Tables, Indexes, Views, Database links, Synonyms, etc• Assisting developers in SQL tuning and optimization using Explain Plan, TKProf and SQL Trace.• Responsible for all database deployments, scripts, data fixes for all environments.• Refresh/Cloning of test/development Databases using RMAN / hot backup. • Build, installed, upgrade and administration of Oracle instances on Sun Solaris and window NT systems.• Resolving day to day database issues.Environment: Sun Solaris 5.8, Oracle 9.x., Oracle 10.2.0.4(10g R2), Remedy 5.x, window NT, Toad.

• Provided Technical Oracle Database support to DBA working at client site. • Upgraded database from oracle 8i/9i to oracle 10g on IBM AIX platform.

Client: Family Dollar Stores, Charlotte NC.Role: Provided Production Database support to Merchandise Financial Planning (MFP)/Assortment Planning (A/P) Oracle Instances on UNIX and windows environment. Client has approx 7,000 stores in all over US.Responsibilities: • Provided support to 60 Oracle instances. • New server setup for AP/MFP application which includes Oracle 10g installation, ASM setup and creation of new database and schema design.• Loaded data into database using MDI tool provided by SAS.• Database size was 10TB+ running on ASM. • Partitioning of huge tables using range partitioning. Experience in list, hash and other partitioning too.• Did maintenance of partitions tables/index. • Implemented hot backup and RMAN backup for the databases. • Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms.• Performed regular refresh from production to dev and QA databases. • Applied hot fix at database level provided by Vendor (SAS). • Resolved day to day database issues.Environment: Sun Solaris 5.8, Oracle 9.x., Oracle 10.2.0.2(10g R2), Windows 2003, ASM, Remedy 5.x, Sql* loader, Toad

Client: Stanford University, Palo Alto, California.Role: Provided Production Database support to Oracle Instances on Sun Solaris environment. I was mainly involved to provide support to oracle instance running on Sun systems and new database server (Oracle 10g R2) set-up.Responsibilities:• Resolved day to day database issue to end users.• Created New Instance as per Oracle OFA standard.• Provided technical guidance for Oracle database migration from 9i to 10g.• Identify the problematic performance issue area in the application using Sql Trace. • Database code reviews for application stored procedures and functions. • Assisted developers in SQL tuning and optimization using Explain Plan, TKProf and SQL Trace.• Creating and maintaining databases for Technical Assessment environment.• Created database indexes based on code analysis.Environment: Sun Solaris 5.8, Oracle 9.x., Oracle 10.2.0.2(10g R2)

Client: AMD California, USA.Role: I was working as Database Administrator (Oracle/Sql Server). The team was supporting almost 160 Oracle instances & 50 Sql Server databases. Our teams were located at Sunnyvale, California, Chennai and Noida. Responsibilities: • Performed Oracle / MS SQL Server DBA task. • Largest database supported was 3TB+. • Installed Oracle RAC software and created Cluster Database for new applications. • Hands-on experience with most of the Oracle 9i features like Undo Management, locally managed tablespaces, multiple block size tablespaces, partitioned tables and auto segment space management. • Worked on New Service Request to Build, installed Oracle Databases for new application.• Upgraded Oracle instances on Sun Solaris and window NT systems. • Configuring and managing oracle database backups like logical, hot/cold and RMAN backup as per the requirement of application owner. • Fully conversant with Oracle security features. • Managed schema objects and space allocation parameters for storage structures. • Diagnosed and Trouble shoot the performance issued by tuning the SQL statements.• Implemented Stand-By Databases. • Extensive experience with Import, Export, SQL*Loader, RMAN. • Managing Data Files redo log groups & Redo Log files, Controls Files and Archive log files. • Used OEM for monitoring databases. • Automating Administrative tasks by scheduling Jobs, Alerts, etc. • We were also providing support to sql server 2000 databases, the concern issue were backup failures, job failure and space issues. • Set up Multi Master Replication. • Implemented RMAN backup for many databases to retire SONI backup. • Upgraded databases from oracle 8i to oracle 9i/10g. • New server setup & installed10g on Linux. • On- call support was also given on rotation basis.Environment: Sun Solaris 5.8, Linux, Oracle 10g/9i/8i , SQL Server 2000/2005, Windows NT, Remedy 5.x, Sql* loader, Informatica Powermart 5.1.2

Role: Team was supporting almost 800+ Oracle instances. Different Oracle versions were being supported, including the Oracle 9i. Most of the supported servers were in Atlanta and Denver, although some servers were in Germany and Singapore. A few of the instances that this team supports are from external customers, but the majority is from the internal hp account. The team members are located in Roseville and in Atlanta. The team supports a few oracle instances running on NT, but the bulk of operations are on HP-UNIX. The team at HP - GDIC (Bangalore) was an extension of the team scattered across various parts of USA. Responsibilities: • I was working as a System DBA. • My major roles and responsibilities were to Build, installed, and administration of Oracle instances on HP UNIX system. • Managing the features like Undo Management, locally managed tablespaces and auto segment space management. • Fully conversant with Oracle security features. Creation of new databases, migration of database and installation of new patches. • Managed schema objects and space allocation parameters for storage structures. • Tuned SQL statements. • Performed Backups & Recovery of mission critical databases. • Designed backup strategies and wrote scripts for automation of hot backup of database using RMAN and Normal Hot backups. • Implemented Stand-By Database. • Diagnosed and troubleshoot the performance problems. • Extensive experience with SQL, PL/SQL, Import, Export, SQL*Loader, RMAN. • Managed Data Files, redo log groups & Redo Log files, Controls Files and Archive log files.• Automated Administrative Tasks by creating and scheduling Jobs, Alerts, etc. • Resolved problems to ensuring continuous operational excellence. • Provided on- call support on rotation basis.Environment: HPUX, Oracle 8.x, Oracle 9.x., Remedy

Client: TUI London, UK.Project: TUI UK is the UK's largest holiday company and includes the leading UK brands of Thomson Holidays, Lunn Poly and Britannia Airways. One EPIC web based application was running on the database, which was used to provide the detail information of the various holiday package launches by the company at worldwide location & for booking of the packages by various dealers & distributors.Responsibilities: • Supported completely OLTP environment. • Supported Four no of database. • Maintained cold, hot, RMAN as well logical backup of the databases. • Major responsibility was availability of database, performance of the database & troubleshooting the problems. • Gathering statistics at schema & object level. • Space management, managing the data query. • Tuning the trouble shooting queries. • Loading data into oracle database from flat files using Sql*Loader utility.• Worked with end users to resolve day to day issued.Environment: Sun Solaris 5.8, Oracle 8.1.7.4, Toad, Sql*loader

Projects: The AXIS Bank, a real time OLTP production database is one of the largest banking databases in the country, and in a little over 9 years of operation the size of the database was approximately 800 GB, and growing at a rate of almost 100GB per year over the last 3 years, since an average of 12,00,000 transactions is performed on the database per day. At present we are maintaining database for 350 branches & 1500 ATM’s counter at all India level.Responsibilities: • I was part of a 7-member Oracle DBA team responsible for the 24*7 maintenance of the live all-India OLTP Oracle Production database, including supervising backup of database using IBM Tivoli Storage Manager’s and recovery solution along with Oracle RMAN.• Tested month ends backups.• Performed switchovers to standby database for routine maintenance on production database.• Composed RMAN scripts for backups.• Maintained replica of production database for queries performed by various departments of AXIS Bank like retail banking, MIS, Operations, HR and others.• Write and tested scripts for performance tuning on production database.• Performed regular export/import of important schemas and tables. • Purging of Data into history database.• Removing of fragmentation at tablespace/segment level.• Rebuilding of indexes to improve the performance of databases. • Migrated database from Oracle 8.1.7.4 to Oracle 9.2.0.4.• We were maintaining 7 Production databases.Environment: Oracle 8.1.7, IBM AIX 4.3, RS/6000 IBM server, Oracle Recovery Manager.

Project: My employer was mainly into support services of clients. As part of a team of technical support analysts and database administrators, I had to visit client sites and perform database activities on the 24*7 production databases of the clients, gave recommendations on acquiring of new hardware, up gradation, and logical / physical changes to be introduced to the databases at client sites.Responsibilities: • Creation of users & roles• Configured user profiles• Scheduling scripts to report space issues at table/index/tablespace/file system level.• Installation of database as per OFA standards.• Migration of database from Oracle 7.3.4 to Oracle 8.0.5.• Regular monitoring of trace files & log files.• Monitoring hit ratio of SGA components.• Monitoring locks and auditing information of waiting sessions and physical data modeling. Maintained regular backups.Environment: Oracle 8.1.7, Sun Sparc Solaris 2.6, IBM AIX 4.3

Environment: Oracle 7.3.4, Oracle8.0.5, IBM-Server, Windows NT(4), Developer/2000Project: Punjab Financial Corporation is one of the largest financial institutions in northern India having 9 Branches, which provides loans for various industrial projects. All the branches are fully computerized .It has approximately 40000 live loan accounts for which the daily transactions involving project appraisal, loan disbursement, loan recovery, sale of Property, and other related activities with the customers are recorded. Responsibilities: • Independently maintenance of hardware setup and software maintenance at all district offices and head office.• Designing and structuring of tablespaces, tables, rollback segments, indexes and users for the production database.• Extensively involved in the performance tuning of production database which includes identifying and resolving fragmentation and disk contention.• Installation of Oracle 8i and Oracle 7 databases.• Testing the performance of various front end applications on the production database.• Migrated the database from Oracle 7.3.4 to Oracle 8.05.• Responsible for security management which included creation of users and roles.• Involved in transaction analysis (number of concurrent users and programs and response time).• Checking for row chaining and row migration, preparing the migration plan, analyzing operational requirements. • Analyzing disk storage requirements and data placement strategies.• Reorganization of tablespaces.

Project: This was a project that demanded heavy customization. It was designed to extend the clients ability to manage the supply chain right down to the customers. Integrating the sales process to the front end of your supply chain, the system allowed the business to benefit from an end-to-end demand-driven supply chain. The system delivered a single point of entry for customer demands no matter where the order originated, ensuring effectiveness across the entire multi-channel sales structure. Customers needed to get consistent, up-to-date information, whether technical, commercial or administrative.Responsibilities: • Developed various Entry and Query Screens using Forms 3.0. And reports in SQL*Reports 1.1.• Provided support to the client at its sites.• Loaded data into database from flat files using SQL* Loader. Wrote PL/SQL and Pro*C programs for batch Queries and Reports.• Tuning queries in modules for optimum response time. Design and testing of functionality of module developed. Environment: Oracle 7.2, Developer/2000 (Forms 3.0 & Reports 1.1), Winix 2.3 (Proprietary operating system of Wipro)