SUMMARY

• Database Administrator with 7 years of experience in Installation, upgrade/migration, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle.
• Experience in supporting Oracle databases 8i/9i/10g/11g in variety of different environments including Unix, Sun Solaris, IBM AIX, Microsoft Windows 2000/NT Servers and Linux.
• Extensive expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance Tuning, Backups, Recovery, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Experience in installing Oracle patches, Migration of database across different platforms
• Cloning/Data Refresh from production environment to setup test and development environments.
• Proven ability of providing production support for 24X7 on multiple databases.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Implemented disaster recovery for Oracle Production Database as Fail-Over or Standby Server using data guard.
• Migrated single instance databases to multinode 10g/11g RAC Real Application Cluster environment for high availability and load balancing.
• Planned and implemented high availability solutions using Oracle 10g/11g RAC, Standby Database using Oracle Data Guard.
• Experienced in Monitoring/Analyzing performance periodically and to tune, debug and optimize the databases, applications, SQL, and PL/SQL code from time to time.
• Excellent working knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager.
• Point-In-Time Recovery through RMAN.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Experience with Oracle 10g features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Experience in managing large Oracle databases which includes OLTP.
• Knowledge in backing up system with tar, cpio, backup, recover, fbackup, restore etc.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Worked with development teams and data administration staff to enhance Database and application performance
• Delivered associated documentation for user interaction with the database environment
• Experience working on the Postgres Database
• Participated in appropriate consulting, interfacing, and training for users.
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Knowledge in maintaining Database Security using auditing.
• knowledge in Veritas NetBackup , IBM Tivoli Storage Manager (TSM).

Operating System :Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional),
RedHat Linux RHEL 3.x,4.x,Unix,Sun Solaris 2.5,2.6,8,9,10.
Databases :Oracle 11g/10g/9i/8i, MS Access.
DBA tools :SQL Navigator, SQL*Loader, Sql *Plus,10g OEM, Grid
RMAN, DBCA,10g Data Pump, Toad, Data Guard, Export / Import,
TKPROF,Statspack
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.
Languages : SQL, PL/SQL, C, C++, UNIX Shell Scripting, Core java.
Web : ASP.NET, HTML, XML, Dreamweaver.
Packages : MS Office, Adobe Photoshop.
ETL Tools : Informatica.

PROFESSIONAL EXPERIENCE:

Confidential,Sep’11 to Till Date
Role: Oracle DBA
Luxottica Group is a leader in premium fashion, luxury and sports eyewear, with 7,000 optical and sun retail stores in North America, Asia-Pacific, South Africa and Europe and a strong and well-balanced brand portfolio
Responsibilities:

• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and AIX platform.
• Performed Oracle Database upgrades from 10g to 11g in AIX
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management
• Involved in the process of tuning and refining queries of various applications
• Performed database tuning using Oracle Enterprise Manager, Explain Plan and Autotrace
• Installed , Upgraded and Patched Oracle software and associated applications
• Making structural changes to the databases when database design changes are to be implemented
• Setup of High Availability of the database using RAC, Standby, Dataguard
• Used the SQL Performance Analyzer, Implemented table compression in 11g
• Providing the full database dumps and schema / table level dumps to DEV / QA database environment.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Creating and dropping of users, granting and revoking rights as and when required
• Day to day performance monitoring and tuning of database
• Management of table space growth, monitoring data files additions, extent growthConstantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files
• Creation of new database links and materialized views and setting up of database jobs for their refreshment
• Creating tables and indexes, sizing their extent, partitioning and so on
• Involved in taking backups using Oracle RMAN
• Performed partition maintenance and automated the process of creating new partitions as and when required.
• Diagnose and troubleshoot Database problems and failures
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks
• Cloned database for development needs
• Worked on Postgres Database. Upgraded version 7.4.1 /8.1 to 8.3/9.1
• Knowledge of Golden gate environment

Environment: SQL*Plus, Oracle 11g/10g/9i,Oracle Enterprise Manager,PL/SQL, RMAN, Linux

Confidential,Birmingham,ALApr’11 to Sep’11
Role: Oracle DBA
UAB is University of Alabama Birmingham for medical sciences.They develop and install health care information technology systems that eliminate the need for paper prescriptions and paper medical records.
Responsibilities:

• Installed, configured and maintained Oracle Database.
• Apply security patches as and when applicable for the setup using the Opatch tool.
• Perform database/schema refresh using Export/Import and Data Pump
• Refresh/Cloning of Database for development and testing purpose.
• Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
• Standby Database (Data Guard) setup and configuration.
• Perform switchover/failover to standby database
• Used Data Pump in legacy mode and Data recovery Advisor in 11g
• Implemented, documented and support builds of new clusters to use Oracle 10g/11g RAC on Sun Solaris Including installing clusterware, ASM (and shared disks) and creating new databases
• Reclaim space from fragmented sectors of tables which required running the ‘SHRINK’ command on case to case basis.
• Working alongside programmers and contributing to the development process, Enabling and analyzing trace files
• Automation of data load and data parsing using Pl/Sql procedures, Korn shell scripting andSql*loader.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Administration and execution of the hot/cold backup/recovery using RMAN/IBMTSMand begin/end backup.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users
• Open tickets with Oracle Metalink for un-trapped errors and fix issues.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.

Environment:SQL*Loader, SQL*Plus, Oracle 11g/10g/9i,Oracle Enterprise Manager,PL/SQL, RMAN, IBM AIX 5.3,Sun Solaris 5.10,TSM.

McKesson is dedicated to delivering the vital medicines, supplies and information technologies that enable the health care industry to provide patients better, safer care. They develop and install health care information technology systems that eliminate the need for paper prescriptions and paper medical records.
Responsibilities:

• Oracle installation, creation of database, which includes physical and logical design.
• Oracle Security Patches Installation on Oracle 10g R2.
• Involved in the implementation of High Availability solutions with Oracle 10g RAC

Real Application Cluster

• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Modify, and update database structure with respect to the following tasks: Re-Organization Database, Transfer object from tablespace to another one, changing storage parameters.
• Responsible for maintenance and support for corporate Data Warehouse.
• Involved in support for 1TB 2 Node production RAC database.
• Extracting, transforming and Loading (ETL) of data from source systems in the Data Warehouse.
• Planned, redesigned and reorganized the Oracle database.
• Managing Oracle database administration function involving resolution of database start-up problems; managing disk space, user profile creation and user rights management.
• Recovery management and supervision of the technical team to restore the database in-case of system failure.
• Created primary database storage structure and plan future storage requirements.
• Created database instances using appropriate INIT.ORA parameters for efficient database operations
• Assisted developers in tuning SQL statements in the applications.
• Designed and implemented crash recovery strategies, hot and cold backups.
• Support and advice the development teams on database related issues.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.
• Tuning SGA, Rollback segments, Latch contention Issues, Optimize Sort Operation
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment
• Create appropriate indexes for queries and suggesting changes to application developer.
• Involved in a team for the maintenance of SQL Server databases.
• Implemented and maintained high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases.
• Provided production support for 24X7 database availability.
• Carried out the setting up of RMAN back up schedules of databases.
• Formulated & implemented best practice guidelines for OracleDatabase.
• Installed and configured oracle9i databases on Red-Hat Linux servers.

Environment: SQL*Loader, SQL*Plus, Oracle 10g/9i,Oracle Enterprise Manager, ASM, PL/SQL, RMAN, LINUX, Sun Solaris, My SQL, Erwin, Windows 2000.

Under the scopes of this project the administrator was required to Fine-tune the database after gathering performance reports. Total of 30 databases were under my preview and the approximate size of each db was 500GB. Take time-to-time backup of database on tape-drive. Partition large tables to enhance faster querying. Normalize the PL/SQL queries for better performance of the database. Record performance enhancements. Document steps taken.
Responsibilities:

• Tasked with the Oracle database administration of Oracle 10g databases.
• Performed Database creation on Unix, Solaris.
• Upgraded from 9i to 10g
• Database refreshes from production
• Performed Database recovery
• Oracle 10g installations, patch application/upgrades
• On call DBA support
• Rebuilding of indexes, elimination of chaining and migrated rows
• Reviewing of PL/SQL codes
• Backup of database Logical (Import and Export) and Physical (hot and cold) procedures
• Implementation of optimization techniques to resolve performance issues
• Performed database tuning.
• Suggested concept of DBMS_STATS which comprised complete testing of suggesting technique resulted in time elapsed reduction by 60% in comparison to analyze.
• Recovery manager implementation both with and without recovery catalog, Scripting for backups (backup sets, backup pieces) and recovery scripts.
• Extensive implementation and administration of materialized views.
• Monitoring Undo segments ( OEM).
• Use of Explain Plan, and Tkprof to find out performance bottleneck
• Management of schemas, objects partitioning the tables & indexes.
• Index maintenance (implementation of Btree, Bitmap indexes as per application )
• Proposed the plan to optimize the system resources by usage of profiles and database Resource Manager.
• Experience with DATAGUARD/STANDBY databases.

Environment: OS: Sun Solaris. Oracle Versions: Oracle 9i, 10g.

Confidential,Aug ’09 to Jan ’10
Role: Oracle DBA
Integrys Energy Groupis a holding company focused on regulated and non-regulated energy delivery in the United States.
Responsibilities:

• Responsible for support and maintenance of very critical 24x7 Production and Development Databases

in Oracle 9.2.0.8

• Performed Database migration from Oracle 9.2.0. To 10.1.0.3.
• Worked on designing, creation and administration of databases.
• Performed logical and physical tuning, monitored extent growth and fragmentation, audited object creation
• Backup and recovery utilizing RMAN.
• Perform Instance tuning using tools like Stats pack etc.
• Installing patches and upgrades for the database.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Worked on export and import utilities.
• Involved onsite-offsite co-ordination as lead.
• Responsible to see that database backup and recovery strategies are in place, and to coordinate with Network Services and/or Data Center personnel to keep the integrity of the physical system backups.
• Responsible for optimizing data access and performance by tuning indexes.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Refresh/Cloning of Database and applications for development, testing
• Maintain user security.
• Write SQL, PL/SQL to load legacy data to interface tables
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and

Manageability