SUMMARY

• 10 years of experience in as Oracle DBA
• Involved in DBA activities operating with 4.5TB of data
• Highly proficient in handling core production Non-RAC RAC databases on IBM, HP, SUN LINUX platforms and Application HTTP Servers
• Strong experience in database trouble shooting, performance tuning and SQL code tuning
• Proficient in installing and administering Oracle databases Oracle 7.3, Oracle 8.0, Oracle 8i, and Oracle 9i, Oracle 10g Oracle 11g and application tools
• Installing and administering 9i and 10g RAC databases on Sun, LINUX and HP-UX servers
• Installing and administering 11g/10g Data-Guard and RMAN backup setup
• Involved in allocation of System Storage and planning Future Storage requirements for production databases on ASM and on Non-ASM.
• Enrolling users, maintaining system security and controlling and monitoring user access to the databases
• Expertise in supporting Large Application Production systems
• Proficient in managing databases using database management tools like: Oracle Enterprise Manager OEM and Oracle 10g Grid Control
• Hands on experience in Cloning of Oracle databases on HP-UX and Solaris servers
• 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
• Excellent logical analytical skills, good communication interpersonal skill and strong commitment to work
• Involved in on-call off hours support to very large scale database systems and instances as a part of rotation

TECHNICAL SKILLS

• Databases : Oracle 11g 11.2.0, 11.1.0.7 , Oracle 10g 10.2.0.4 and Oracle 9i 9.2.0.4,
• 9.2.0.8 , Oracle 8 8.1.6, 8.1.7
• Operating Systems : Sun Solaris 5.8, HP-UX Itanium B.11.23, Linux 2.6, TRU64
• Database Management tool : Oracle Enterprise Manager, Oracle 10g Grid Control, I-3, SQL Navigator, Toad, SQL plus and SQL developer
• Programming Language : SQL, PLSQL, Pro C, Shell
• Database Backup : 11g/10g/9i RMAN Backup, 11g/10g/9i Data Guard/Standby, Symantec Net Backup 6,
• BCV hot/cold Backup, Full System Backup, Archive Logs Backup
• Change Management tool : BMC Remedy, IRIS tool.
• Version Code System : PVCS

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management of all the databases
• Extensive experience in Unix scripting, database performance tuning and administration and system administration of various platforms of Unix systems and window.
• Experienced in automating routine server tasks and alerts using various scripting technologies Unix Shell scripting, batch files, etc.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities
• Analyzed Automatic Workload Repository AWR , Active Session History ASH reports.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2
• Timely Reorganization of the tables and rebuilt of indexes to improve the performance of the SQL queries as part of scheduled maintenance window.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically performing backups using RMAN.
• Restoration and recovery from backup as timely manner to support application development team for testing.
• Cloning of application from production environment to test environment.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• 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.
• During my role I have handled the activities like DR Implementation, DB refresh and cloning.

Environment:

Databases : Oracle 9i 9.2.0.4, 9.2.0.8 , Oracle 10g 10.2.0.4 , Oracle 11g 11.1.0.6.0,

11.2.0.1.0

Application HTTP Servers : 10g 9.4.0.1 , 6.8 patch-17

Operating System : Tru-64 OS version 5B, HP-UX 11.23, Sun Solaris 5.8, LINUX 2.6

Monitoring Tools : I-3 Tool

Database Management tool : Oracle Enterprise Manager OEM , Oracle 10g Grid Control, SQL Navigator

SQL plus

Version Manager : PVCS Version 8

Change Management tool : BMC Remedy Action request system 7.1

Reporting Tool : Oracle Discoverer 10g 10.1.2.0.2

Backup : 10g RMAN, 10g Data Guard, BCV hot/cold, full system, Archive logs

Confidential

Senior Oracle DBA

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/AIX, Application Server, Network, SAN to resolve critical issues in Specialty projects
• Perform DR Test by every quarter.
• Schedule tasks Involved in developing UNIX shell scripts to automate and scheduled the database backup.
• Installation and Administration of RAC database on Solaris server
• Extensive knowledge in database upgrades 9i, 10g 11g
• Hands on experience in Large Database Migration 9i from Tru-64 Unix to HP-UX 11.23 servers
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and active session history.
• Hands on experience in applying Oracle Patches for database bug fixes and updating patches as requested by Oracle support
• Schema level refresh on user's request using import/export and data pump.
• 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 9i and 10g
• Cloning Oracle databases in HP-UX and Solaris servers 9i and 10g
• Strong experience in RMAN backup strategies and procedures
• Installation and Administration of 10g and 11g physical/logical standby database Data Guard
• Strong experience in Database hot and cold backup procedures
• Expertise in handling UNIX storage system from DBA's perspective
• Involved in configuring administering 10g Oracle Enterprise Manager Grid Control for 9i 10g databases
• 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 Application version 7.1 .
• Hands on experience in PVCS code control system
• Using REMEDY tool for Change Management CRQ , JAC, AutoSys and co-ordinate with users for scheduling tasks and others activities
• Consistently met 100 response and resolution SLA
• Worked as an On-Call DBA and supported 24/7 machine critical databases

Environment:

Databases : Oracle 9i 9.2.0.4, 9.2.0.8 , Oracle 10g 10.2.0.4 , Oracle 11g 11.1.0.6.0,

11.2.0.1.0

Application HTTP Servers : 10g 9.4.0.1 , 6.8 patch-17

Operating System : Tru-64 OS version 5B, HP-UX 11.23, Sun Solaris 5.8, LINUX 2.6

Monitoring Tools : I-3 Tool

Database Management tool : Oracle Enterprise Manager OEM , Oracle 10g Grid Control, SQL Navigator

SQL plus

Version Manager : PVCS Version 8

Change Management tool : BMC Remedy Action request system 7.1

Reporting Tool : Oracle Discoverer 10g 10.1.2.0.2

Backup : 10g RMAN, 10g Data Guard, BCV hot/cold, full system, Archive logs

Confidential

Oracle DBA

Responsibilities:

• Involved in Delmonte Monitoring team Process. Checking the Blocking sessions, if the blocking session is inactive then clearing those sessions
• 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 using Tool Kit Utility
• Tuning maintaining production as well as development databases
• Cloning and refreshing the databases as per requirements of the development team. Optimize and tune all aspects of the Oracle architecture
• Automate and implement day-to-day Oracle DBA functions
• Provide production Oracle reporting capabilities for Sr. Management
• Perform daily DBA support activities for the Oracle production Systems
• Perform and test Oracle backup and recovery policies and procedures
• Maintain oracle security and auditing policies and procedures
• Help develop and implement a capacity model, total cost of ownership model and augmentation plan for the platform
• Participate directly in testing and planning to prepare for system upgrades

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

Environment:

Databases : Oracle 10g 10.2.0.4 and Oracle 9i 9.2.0.8 RAC

Servers : LINUX

Backup : 9i RMAN, 9i Data Guard

Database Management Tool : Oracle Enterprise Manager OEM , SQL Plus and SQL Developer

Confidential

Oracle DBA

Responsibilities:

• Installing, Migrating and Upgrading Oracle DB products
• Make the Database Optimal, Flexible and Architecture Compliant
• Involved in the Design and Development of Database
• Tuning of Database after testing before making it online
• Managing of Table Space for different users by granting quota on Default Temporary Table spaces
• Managing Redo log files in archive log mode
• Tuned the databases to reduce fragmentation
• Maintained constraints
• Creating users and their profiles
• Connecting Database Server to Production operators by creating Database aliases for different databases using TCP/IP addresses of database servers Client Server Architecture
• Performing Backup Recovery of Databases Using Logical Export Import and Physical Online Offline BackUp
• Continuous monitoring of Oracle Buffers and identifying any bottlenecks hindering the performance of the database
• Monitoring the CPU usage, IO statistics, CPU time to identify any OS level performance killers
• Regularly updating the Cost Based Optimizer statistics for optimum performance
• Taking Reports day-to-day for Checking Performance of database using Oracle Scripts UTLBSTAT and UTLESTAT and tune database by examining the report file generated by UTLESTAT.
• Creation of database indexes on certain tables to highly improve query performance and testing the same in the development environment

Environment:

Databases : Oracle 8.1.6, 8.1.7, Microsoft SQL Server

Operating System : Sun 5.8

Database Management Tool : Oracle Enterprise Manager OEM , SQL Plus and SQL Developer

Confidential

Junior Oracle DBA

Responsibilities:

• Planning of space requirements in terms of one unit record length and subsequently for the storage parameters extent sizes, numbers etc. , tablespace design and database files and the number of data file's required in accordance with the Optimal Flexible Architecture
• Planning the backup strategy
• 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

Environment: Version: Oracle 8.0.5