Oracle DBA

Pallaswamy

ac5122@r.postjobfree.com; 609-***-****;

SUMMARY

Over 11+ years of experience with oracle products in production and development environment spanning several industries.

Expert in resolving production support issues – handled several month end and quarter end closes for clients

Exceptional ability to work with cross-functional teams including Super users, Business Analysts and Technical Consultants

Proven ability to adjust quickly to shifting priorities, multiple demands, ambiguity and rapid change

Worked in a multicultural environment and skilled at people management of internal teams and executives of geographically dispersed teams including offshore development

Capability to work independently with minimum supervision with excellent communication skills with people from all levels of corporate management

Excellent Communication, Positive Outlook, highly result Oriented, Good Leadership qualities, aggressive team member and great flexibility towards success

Highly proficient in handling core production Non-RAC & RAC databases on Unix/LINUX platforms

Strong experience in database trouble shooting, performance tuning and SQL code tuning

Proficient in installing and administering Oracle databases and application tools

Expertise in supporting Large Application Production systems

Exposure to an on-site/offshore delivery model involving close client interaction

Supporting 24x7 operational database in critical production environment

Quick adaptability to new technologies & ideal zeal to improve technical skills continuously on demand

Involved in on-call (off hours) support to very large scale database systems and instances as a part of rotation

Interact with business users to gather requirements

Map the requirements with standard functionalities and identify custom functionalities, develop scripts to automate database specific activities

Hands on experience in Cloning of Oracle databases, performed Database backups, Upgrade, migration and database refresh activities

Participate in yearly Disaster Recovery activities

Configured the Oracle Golden gate

Implemented SOX controls in SOX regulated databases

Hands on experience in Change Management processes and Incident Ticket Management processes

PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions US Corp June 2011 till Date

Role: Senior Oracle DBA

Project: DBA Managed services JnJ

Client: The Johnson and Johnson, NJ USA

Currently involve in DBA Managed services – JnJ as Sr. Oracle DBA and working with different database implementation projects as per requirement.

Responsibilities

Evaluating the Database Backups and Recovery Procedures periodically.

Restoration and recovery from backup as timely manner to support application development team for testing.

Monitoring the table growth, database growth, current users, and system resource usage.

Generated scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth.

Involved in team management, team building exercises for the DBA team.

Periodic Database Refresh/CLONING from production to Development and QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.

Performed database Migration/upgrade activity

During my role I have handled the activities like DR Implementation, DB refresh and cloning.

Installation and Administration of 10g/11g and 12c physical/logical standby database (Data Guard)

Configured the Oracle Golden gate and performed a cross platform database migration (AIX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2

Provided technical assistance to Application team for SQL code tuning, troubleshooting long running processes

Automated day-to-day Oracle DBA functions

Implemented and maintained Oracle security & auditing policies and procedures

Participated directly in testing and planning to prepare for system upgrades

Performed troubleshooting and problem resolution activities with other support teams (e.g. Network Support, SA and Vendors). Produce Root Cause Analysis findings that focus on recommendations to learn from and avoid problem recurrence

Involved in allocation of System Storage and planning Future Storage requirements for production databases on ASM and on Non-ASM.

Analyzed performance issues related to month end processes and provided solutions

Regular interaction with client and customer managers and system administrators in coordinating projects.

Expert in resolving production support issues – handled several month end and quarter end closes for clients

Wipro Technology Solutions PVT LTD Oct 2006 to May 2011

Role: Senior Oracle DBA

Project: Specialty NADB/CDAP/Livestock/@venture 1.0

Client: The HARTFORD INSURANCE, Hartford, CT USA

Responsibilities:

Performed Database Administration (9i, 10g & 11g) functions: Design, Development, RAC configuration, Maintenance of Oracle Report Server, Oracle Listener Server, Tomcat Server and Business Objects servers

Handling production Database Administration activities for 4.5 TB database (9i) size in HP-UX servers (Business Insurance Applications) and 4 TB (10g) database size in HP-UX server (Specialty Risk Applications)

Involved in various teams like UNIX, IBM, Application Server, Network, SAN to resolve critical issues in Specialty projects

Installation and Administration of RAC database on Solaris server

Hands on experience in applying Oracle Patches for database bug fixes and updating patches as requested by Oracle support

Allocation of system storage and planning future storage requirements for development and production databases

Enrolling users, maintaining system security and controlling and monitoring user access to the databases

Expertise in supporting Large Application Production systems

Cloning Oracle databases

Strong experience in RMAN backup strategies and procedures

Installation and Administration of 10g and 11g physical/logical standby database (Data Guard)

Expertise in handling UNIX storage system from DBA’s perspective

Provided technical assistance to Application team for SQL code tuning, troubleshooting long running processes, DBMS Job Schedulers, Version Control System (PVCS), Database code Release Management procedures and Database Code Deployment procedures in UNIX and Windows servers

Hands on experience in Database and non-database code release management

Strong exposure to Interfacing Application team and System Administration

Hands on experience in Change Management processes and Incident Ticket Management processes

Using REMEDY/IRIS tool for Change Management and co-ordinate with users for scheduling tasks and others activities

Worked as an On-Call DBA and supported 24/7 machine critical databases

Automated day-to-day Oracle DBA functions

Implemented and maintained Oracle security & auditing policies and procedures

Participated directly in testing and planning to prepare for system upgrades

Performed troubleshooting and problem resolution activities with other support teams (e.g. Network Support, SA and Vendors). Produce Root Cause Analysis findings that focus on recommendations to learn from and avoid problem recurrence

Maintain productive relationships with peer organizations & vendors

iNetframe Technology Solutions, Bangalore, Karnataka Feb 2006 to Sep 2006

Role: Oracle DBA

Client: ORACLE Corporation

Project: Database support for Delmonte (Production Environment)

Description: Delmonte is one of the highly paying customers to ORACLE. Delmonte is an US based company that deals with fresh fruits

Responsibilities:

Space management issues involving resizing table spaces, data files and rollback segments

Creating, altering the tables, views and PLSQL objects as per the development team requirement

Collecting the statistics of the database and tuning the resource consuming SQL statements

Installing application patches, tuning & maintaining production as well as development databases

Cloning and refreshing the databases as per requirements of the development team.

Automate and implement day-to-day Oracle DBA functions

Maintain oracle security and auditing policies and procedures

Participate directly in testing and planning to prepare for system upgrades

Perform troubleshooting and problem resolution activities with other support teams and Produce Root Cause Analysis findings that focus on recommendations to learn from and avoid problem recurrence

IT Support Division Oct 2003 to Feb 2006

Project: Support office Tech Info System

Role: Oracle DBA

Responsibilities:

Monitoring Extents and growth of Tablespaces, Tables, and Indexes. Recreating Indexes

Backup & Recovery. Online Database Backup, Archived redo log files and Offline

Tuning Database according to the growth of the Database, tuning of SQL statements using database utilities

Interacted regularly with the developers for implementing DBA level tasks like database deploys on the production, development and Test servers

Worked on migration of data and implementing structural changes from development servers to production servers using Export, Import

Also worked on tuning of SQL scripts, tuning of memory and tuning of disk utilization

Used SQL Loader for loading external data into Oracle tables

Other DBA activities included creation, management, startup and shutdown of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and manipulation of init, ora parameters

Past experience:

Prime Communication Davangere March 1996 to August 2002

Service Engineer

Education: B.E (Electronics and communication), Malnad College of Engineering, Mysore University, India

Contact this candidate