SUMMARY

• Over 9 years' experience in the Information Technology field, with comprehensive hands-on expertise as an Oracle DBA in Installation, Administration, Monitoring, Support, Database Backup and Recovery and 5 years of experience as a SQL DBA in Installation, Administration, Monitoring, Support, Database Backup and Recovery. Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams. With experience in different domains like BFSI, Oil Gas Utility , Logistics and Manufacturing across a wide variety of systems and companies from large to small.
• Configuring back up schedules for Development, QA and Production Databases.
• Expertise in Backup and Recovery for HA/DR Scenarios in Oracle and SQL Server.
• Expertise in Database Cloning, Database Refreshing and Standby Databases.
• Having good experience in RAC Cluster Ware installation and Network Configuring and Disk management with ASM.
• Having good experience in configuring OEM Grid 10g, 11g and 12c Cloud with ASM.
• Experience with different databases like Oracle 8i, 9i, 10g, 11g, 12c and PostgreSQL in multiple OS environments like Windows, UNIX, Linux, AIX, Oracle Solaris and VMware Environments.
• Having good knowledge on Microsoft SQL Server 2005, 2008, 2008 R2, 2012 Database Administration.
• Creating Backups, Restoration and Replication on Microsoft SQL Server 2005, 2008, 2008 R2, 2012 using MS SSMS and LiteSpeed for SQL Server.
• Performing backups with Delphix for Oracle Databases.
• Performing Cloning and Refresh databases with Delphix.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries performance, hit ratios, I/O, lock, and latch contention.
• Implementation of Log Shipping.
• Strong knowledge on scripting languages like UNIX Shell Scripting, Perl Scripting and Windows Power Shell.
• Logical Backup and Physical Backup schedules using Import/Export, Data pump and RMAN.
• Analyzing trace files using SQL Server Profiler and Performance Monitoring using Activity Monitor.
• SQL Server Log Reviews Windows Event Logs, SQL Server Error Logs and Agent Logs .
• Configuring and Scheduling mail alerts using SQL Server Agent.
• Database Performance Tuning using AWR, ADDM, Explain Plan, SQL TRACE, STATSPACK, TKPROF, SQLTXPLAIN and different OEM utilities.
• Expertise in implementing Oracle Golden Gate and Oracle Data guard.
• Expertise in implementing Kerberos External authentication for Oracle Databases.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net App backup utilities.
• Good knowledge on Creation and Configuring Disaster Recovery DR Databases for Production.
• Expertise Physical Standby and Logical Standby using Data guard.
• SQL Server Backups, Restoration, User Management and Memory Management.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Management of Development, QA environment for new development requirement.
• Performing Cloning and Refresh databases with Delphix.
• Taking database backups and recovery using RMAN.
• Database Cloning from Production to QA and DEV Environments.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.

Environment: Oracle 11g, 10g, MS SQL 2005/2008/2008R2/2012, Linux, Windows Server 2003/2008/2012, Oracle Golden Gate

Confidential

Role: Senior Oracle DBA MS SQL Server DBA

Description : The Fitch Group is a jointly owned subsidiary of FIMALAC and Hearst Corporation. On April 12, 2012, Hearst increased their stake in the Fitch Group to 50 . Fitch Ratings and Fitch Solutions are part of the Fitch Group. Fitch Ratings, dual-headquartered in New York and London, was one of the three Nationally Recognized Statistical Rating Organizations NRSRO designated by the U.S. Securities and Exchange Commission in 1975, together with Moody's and Standard Poor's. It is considered one of the Big three credit rating agencies Standard Poor's, Moody's Investor Service and Fitch Ratings .

Responsibilities:

• Oracle 11g Real Application Cluster Grid Implementation and Production support.
• Maintaining and supporting 7-node RAC.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Management of Development, QA environment for new development requirement.
• Data migration to other database as per requirement for new systems.
• 24x7 support for Production Databases i.e. performance, backup and recovery.
• Standby database Maintenance and Configuration data guard.
• Applying Quarterly CPU PSU Patching.
• Performing Cloning and Refresh databases with Delphix.
• Taking database backups and recovery using RMAN.
• Database Cloning from Production to QA and DEV Environments.
• Installation/Upgradation of Database and Client Software.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Cold/Hot Refresh/Cloning QA, DEV databases from Production environment for testing purpose.
• Building and Monitoring Disaster Recovery DR database from Production.

Environment: Oracle 11g, 10g, MS SQL 2005/2008/2008R2/2012, Linux, Windows Server 2003/2008/2012

Confidential

Role: Oracle DBA

• Description : Xerox Capital Services XCS is a joint venture owned 81 by General Electric and 19 by Xerox Corporation, aiming to bring interest and fee income to GE, while providing cash flow and outsourcing the order-to-collection process for Xerox. Today XCS are a world-class provider of specialized financing and servicing programs for Xerox, its vendors, and resellers. Primary functions include financing, risk analysis, credit approval, order processing, billing and collections. We are handling some of their critical production databases as well the QA/Dev environments.
• Xerox Corporation is a Fortune 500 global document management company founded in 1906 that manufactures and sells a range of color and black-and-white printers, multifunction systems, photo copiers, digital production printing presses, and related consulting services and supplies. Xerox is headquartered in Norwalk, Connecticut, though its largest population of employees is based in and around Rochester, New York, the area in which the company was founded.

Responsibilities:

• Physical database design, Table, Column mapping with existing requirement.
• Creating/Dropping Database, Users, Table spaces, Tables Database Objects.
• Oracle 10g Real Application Cluster Implementation and Production support.
• Stats Gather at Database, Schema, Table and Index level.
• Query Tuning using ADDM, AWR and Stats pack Reports.
• Applying quarterly CPU patch to all Databases.
• Implementation of Log Shipping.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Data migration to other database as per requirement for new systems.
• 24x7 support for Production Databases i.e. performance, backup and recovery.
• Standby database Maintenance and Configuration data guard.
• Monthly range partitioning of tables.
• Creating/Resizing of Tablespaces, Tables, and Users for custom applications.
• Installation/Upgradation of Database and Client Software.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Monitoring Table space size and file system size alerts using UPTIME tool.
• Cold/Hot Refresh/Cloning QA, DEV databases from Production environment for testing purpose.
• Monitoring Blocked and Inactive database sessions and take proper action.
• Weekend on call support, Payroll support and bundle upgrade support for PeopleSoft applications.

Environment: Oracle 11g, 10g, Solaris, MS Office, MS Access MS-Sharepoint

Confidential

Role: Oracle DBA SQL DBA

• Description: Hitachi Global Storage Technologies is a wholly owned subsidiary of Hitachi, Ltd. Hitachi purchased IBM's hard disk drive division, integrated their own HDD operations, and launched the new company in January 2003. Hitachi GST is headquartered in San Jose, California, USA. Another US development site is located in Rochester, Minnesota. In Japan, development sites are located in Odawara and Fujisawa.
• Hitachi Data Systems Credit Corporation HDSCC provides Credit, Leasing and Financial services.

Responsibilities:

• Building and Monitoring Disaster Recovery DR database from Production.
• Monitoring Blocked and Inactive database sessions and take proper action.
• Query Tuning using ADDM, AWR and Stats pack Reports.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Management of Development, QA environment for new development requirement.
• Data migration to other database as per requirement for new systems.
• Creating/Dropping Database, Users, Table spaces, Tables Database Objects.
• Configure RAC/RHCS clusters, Failsafe, ASM.
• Oracle 10g Real Application Cluster Implementation and Production support.
• Stats Gather at Database, Schema, Table and Index level.
• Analyzing the ADDM, Stats Pack reports and Explain plan output.
• Daily, Weekly Database Server Health Checks in PROD QA Environments.
• Creating/Resizing of Tablespaces, Tables, and Users for custom applications.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Monitoring Table space size and file system size alerts using UPTIME tool.
• Cold/Hot Refresh/Cloning QA, DEV databases from Production environment for testing purpose.
• Database Cloning from Production to QA and DEV Environments.
• Standby Databases using Data guard when needed.
• Generating daily reports and submitting to the client.
• Verifying corrupted data blocks using DBVERIFY Utility and recovers corrupted blocks using backup.
• Write UNIX shell scripts to monitor and maintain the Oracle database.

Environment: Oracle 10g, 9i, MS SQL 2005, Linux, Windows Server 2003

Confidential

Role: Oracle DBA September 2005 October 2009

Description: The CampaignToolCommon is a Tool of serving ads in between Network provider and the end user. It offers a wide variety of Wallpapers, Ringtones and Caller Tunes. By using this tool we can download wallpapers and ringtones in a single click. This Tool supports Android, IPhone and Black Berry Devices.

Responsibilities:

• Created new Databases, Users and Table spaces.
• Developed database Tables, Views and Indexes using primary keys and foreign keys.
• Database backups and recovery using RMAN.
• Data transfer from External files to Database using SQL Loader.
• Created Database templates using Oracle DBCA.
• Monitoring and Managing database backups and when needed restoring big loads to databases.
• Prepared Database level and table level backups in PostgreSQL.
• Troubleshooting previously written PL/SQL packages and procedures.
• Created database Triggers, Stored Procedures and Functions for the validation of input data and implementing business rules.
• Monitored database performance using Toad and Oracle Enterprise Manager.
• Write UNIX shell scripts to monitor and maintain the Oracle database.
• Responsible for Reports Generation and submitting to the Client.
• Refresh/Cloning of Database for Development and QA.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries performance, hit ratios, I/O, lock, and latch contention.
• Assist Programmers and Developers with Oracle problems.

Environment: Oracle 9i, 8i, PostgreSQL, Linux