Summary

Total 7+ years of professional experience in the IT consulting and service based industries as Oracle DBA.
Supported over 500+ environments consisting PROD-UAT-TEST-DEV for oracle databases starting from Version 9i, 10g and 11g, hosted on Sun Solaris, IBM AIX, HP-UX, RedHat LINUX and WINDOWS platform. Very good experience on 24x7 support model.

Technical Summary

• Supporting 10g, 11g RAC Environment with ASM Storage.
• Good knowledge in implementation of Client side and Server side load balancing in RAC environment.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
• Expertise in Clone database for testing and training.
• Expertise in Data pump Export and Import utility. Heavily working on this utility to recreate uses using remap schema.
• Expertise in generating/analyzing database reports like AWR, ADDM,ASH reports.
• Setup and configure Physical standby database using Data Guard.
• Good Experience in Backup and Recovery using RMAN, SQL-Backtrack.
• Implemented 10g Flashback features for production databases.
• Experience in Database upgrade from 10.2.0.5 to 11.2.0.2.
• Experience in applying patch using opatch utility.
• Extensively used Unix shell scripting for refresh automation, scheduling backup, database monitoring, backup verification and weekly reporting.
• Good understanding of PL/SQL and relational databases. Database design experience in both in logical and physical modeling using Erwin tool.
• Good Experience in resolving performance related issues including statistics, explain plan.
• Implemented auditing in database.
• Experience in resolving Hung database issue for RAC environment with Oracle Support ticket.
• Ability to operate successfully in multi-tasked environment. Documentation and team leadership skills.
• Be able to communicate effectively with people at all levels.
• Ability to identify skill gaps and plan for training. Strong desire to upgrade technical knowledge. Excellent attention to details
• Knowledge of Web Logic Server and BEA

Technical skills

OS: Unix on (Sun Solaris, HP-UX, AIX), Linux and Windows
RDBMS: ORACLE Server 7x, 8i, 9i, 10g and 11g
Scripting: Shell scripting, PL/SQL
DBA Tools: Toad, SQL*PLUS,OEM, Precise, HPOV, Spotlight, Golden Gate
Backup Tools: BCV, RMAN, Veritas NetBackup, BCV Sync Split,SQL-Backtrack
Ticketing Tools: Remedy, HP Service Desk, Tivoli Service Request Manager(TSRM)

Educational Qualification

Bachelor in Computer Engineering

Assignments

Client : Confidential
Duration : July 2011 to till date
Location : Pasadena, CA
Role : ORACLE DBA
Environment : Oracle 10g, 11g , HP-UX,AIX, Linux, RAC,ASM
Team Size : 8

Description:

Working as a DBA for Claims Datawarehouse (CDW) application. Handling day to day on support activities and all database admin work. Working on Implementation on Database Central authentication using Kerberos authentication.

Responsibilities:

• Supporting single instance and RAC databases.
• Handling Day To Day Activities - Resolving Service Requests.
• Work on database upgrades, Patch apply
• Export and Import of Database using data pump utility.
• Backup and Recovery of database using RMAN.
• Monitor scripts for - Backup of database.
• Perform Recovery of database as per the need.
• Create new database for test environment using RMAN
• Working on Flashback feature of database. Perform In Time Recovery of database using Flashback feature.
• Create RFC for Production Database.
• Generate AWR Reports, Explain Plan
• Help users in resolving Performance related issues
• Implement single sign-on in databases using Kerberos authentication to meet SOX requirement.

Client : Confidential
Duration : Apr 2010 to July 2011
Location : Dallas, TX
Role : ORACLE DBA
Environment : Oracle 10g, 11g, HP-UX
Team Size : 10

Description:

Supporting multiple databases used by FedEx Inc, Handling day to day Lights-On support activities which includes but not limited to database backups, refreshes, performance tuning, database access, maintaining inventory. Handling Projects work, which includes understanding new business requirements, setting up new environments as per requirements, Capacity planning for next 6 months, upgrade to latest database versions, supporting Application upgrades,

Responsibilities:

• Primary DBA for production, development and testing databases
• Install and configuring oracle database 10g,11g on Linux, HP-UX
• Implementing Organization standards on newly created and existing databases
• Supporting 10gRAC environments
• Upgrading 9i and 10g database to 10g or 11g
• Supporting 10gDataGuard Environment
• Implementing 10g flashback database features
• Extensively worked on SQL Tuning using in various versions of Oracle
• Working on Capacity planning
• Mentoring and knowledge transfer to other DBAs
• Working with Developers to review coding standards and code push to UAT and Prod Environments.
• Doing database backup and Recoveries using SQL Backtrack
• Implemented Single-Sign-On using Kerberos Authentication
• Implemented Oracle Gateway to Teradata, DB2 and MSSQL Server for data archiving using Optim tool

Client : Confidential
Duration : Oct 2005 to Dec 2008
Role : Oracle DBA
Environment : Oracle 8i,9i, Sun Solaris9, HP-UX, DataGuard
Team Size : 7

Description:

During my tenure with Wipro, I’ve supported 50+ Oracle Databases for Shell. Few are sized in TBs. I have worked on Data Center setups and Data Center move projects. Implemented Logical standby Database as replacement of Shareplex utility

Responsibilities:

• Configured Physical Standby Database as DR for Production database using Data Guard.
• Develop, implement and schedule database backups using RMAN with Veritas NetBackup
• Tune the SQL queries with explain plan, SQL Trace, TKPROF
• Worked on SOX critical databases and applications auditing with external auditors for getting data change evidence, Half yearly password change, yearly restoration of tape backups and getting business sign off.
• Implemented SOX requirements like auditing logons, setting up Password expiry, auditing key data modifications etc.
• Assist the SQL developers to optimize the SQL queries and stored procedures.
• Worked closely with application owners to meet their requirements
• Prepared SOP on day to day DBA Activities like Database refresh, patches, resize, bouncing application and database services.
• 24/7 support for 50+ Production/Development/Testing databases with offshore/ onsite model
• Done major Database upgrades from 8i to 9i for 30 database in span of 3 months
• Worked on Data Center setup for GEAE in Cincinnati and moving databases from Singapore Data Center to Cincinnati Data Center
• Extensively written shell scripts for scheduling backup and monitoring and reporting database health status
• Performance monitoring, tuning and troubleshooting production Oracle databases. Tuning includes - SQL, memory, I/O, O.S, procedures and packages
• Backing up huge databases using BCV sync-split technology
• Worked with SOX team for Database auditing and enabling auditing features
• Managed tables replication using shareplex tool and suggested few cheaper options for replication like oracle streams and logical standby database.
• Implemented Logical Standby Database as alternative for 3rd party shareplex software
• Major De-fragmentation of tables and indexes extensively used for DMLs over a year and released space over 70 GB
• Used RMAN extensively for backup and recoveries/restorations
• Documenting procedures about change management, Work order, new configuration and Installations

Client :Confidential, Mar 2003 to Sep 2005
Role : Oracle DBA
Environment : Oracle 7.3, 8i, 9i, Sun Solaris9, Data Guard
Team Size : 10

Worked for ICICI Bank Data center, Supporting major banking databases, including Treasury, Web Trade, Money2India, Deposis, Home loans, Personal Finance System, etc. All database servers are located at Mahalaxmi Data center (Mumbai). Key DBA for setting up Disaster Recovery site at Hyderabad using Physical standby database for above critical banking databases.

Responsibilities

• 24/7 DBA Support for development, testing and production databases
• Installation and administration of Oracle 7x, 8, 8i & 9i databases
• Database Upgrades from 8i to 9i
• Performance monitoring, tuning and troubleshooting Oracle databases
• Worked extensively on SQL Tuning and memory Tuning
• Maintaining Oracle files system in Sun Solaris
• Maintaining database space requirements (Tablespace, Extents)
• Monitoring resource utilization/Memory utilization in Sun Solaris
• Automation of maintenance and monitoring scripts using Shell scripting
• Applying RDBMS patches using OPATCH and maintaining Oracle Inventory
• Monitoring database growth and planning in advance for future storage requirements
• User administration, file System management, device management, volume management, spool administration, shell scripting and admin tool
• Maintaining Oracle files system in Solaris, AIX & HP-UX
• Monitoring Unix processes in HP and Sun
• Backing up huge databases using Veritas NetBackup
• Database refresh from production to development for development purpose
• Handling user trouble tickets and change requests/Code movements
• Implemented Disaster site setup between Mumbai and Hyderabad using Physical Standby Database
• Documenting procedures about change management, Work order, new configuration and Installations