SUMMARY

• 8 plus years of experience as an Oracle DBA working in various versions of Oracle like 11g, 10g, 9i and 8i.
• Installed and Maintained Oracle RDBMS Software(11g, 10g, and 9i) on different flavours of UNIX (HP - UX, AIX), Linux (RHEL, SUSE, OEL), Sun Solaris and Windows 2000/2003/2005 .
• Installation of 4 Node Oracle RAC on Linux includingOracle Clusterware and OCFS/OCFS2. Maximumnumber of nodes installed and maintained was4.
• Experience in upgrading databases from 9i(9.2.0.8) to 10g (10.2.0.3) and 10g (10.2.0.4) to 11g(11.1.0.6), migration of databases from one platform to another (windows/Unix to Linux).
• Experience working with Oracle Advanced Technologies like Oracle Enterprise Manager GridControl, Oracle Streams, Data Guardand Real Application Clusters, Oracle Warehouse Builder.
• Part of the team implementing ORMS, OReSAand ORIB applications.
• Knowledge in Oracle Retail Merchandising system, Oracle Retail Sales Audit and Oracle Retail Integration Bus modules in Oracle Retail Product.
• Implemented different Backup and Recovery strategies using Recovery Manager (RMAN),Complete and Incomplete Recovery of databasesduring database crash, disk/media failure, etc.
• Used RMAN DUPLICATE to clone/duplicate target database and restore tablespace past in time.
• Efficiently Implemented logical backups using tools like Oracle Data pump Export/Import and classic Export/Import.
• Experience working with Oracle tools like Oracle Warehouse Builder (10g, 11g) for data warehouse and some reporting tools like COGNOS and ReportNet.
• Hands on experience with the new oracle FLASHBACKTechnology like enabling Flashback feature, configuring FLASH RECOVERY AREA and implementing Flashback recovery strategies like FLASHBACK Drop, FLASHBACK Table, FLASHBACK Query and FLASHBACK Database.
• Performance Monitoring and Tuning of databases usingtools like SQL Tuning Advisors, Segment Advisors, STATSPACK, AWR, ASH and ADDM reports.
• Experience working with SQL Tuning tools like SQL Trace, Explain Plan and SQL profiles.
• Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.
• Expertise in writing BASH, KORN and SHELL Scripting for databases and server requirements.
• 24/7 Production Support for the databases and support to the developers and end-users.
• Good understanding of System Development Life Cycle, Automatic Undo management, RAID concepts and advanced features of Oracle 11g.
• A self-motivated, responsible and reliable team player with a set of strong technical skills with excellent analytical, interpersonal and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows NT/ 2000/2003/2005 , AIX, Sun Solaris, RHEL, OEL and HP-UX

Languages: C, C++, SQL, PL/SQL, UNIX Shell Programming

Databases: Oracle 11gR1/R2, 10g,9i and 8i

Case Tools: OEM Grid control, Toad, Quest Spotlight, Oracle Warehouse Builder

Tools: & Utilities: Data Pump Export/Import, SQL* loader, ASMLIB, RMAN, AWR & ADDM

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Sr Oracle Database Consultant

Responsibilities:

• Maintenance and Administration of 11g/10g databases on, Red Hat Linux 4 Node Cluster with database sizes ranging from 30GB to 12TB and managed these databases in different Data Centersi.e USA, San Diego, Annapolisand Reporting databases.
• Performance Monitoring, Troubleshooting and Tuning at Instance level.
• Supporting three tier applications consisting of Web based Front End, WebLogic Application and Oracle backend database.
• Maintenance and Administration of the reporting database i.e CGA basically used for reporting to the external customers via daily ETL reports.
• Maintenance and Administration of 4 node High availability RAC 11g databases with ASM shared storage, failover and Disaster Recovery procedures using a Physical Standby.
• Involvement in the timely Database and Application releases for PeopleSoft application. Interacting with the Development team, Application Team, System Administrators and Release Teams.
• Attending to the requests and tickets using ServiceNow and HCCP ticketing system.
• Monitoring of Databases using Oracle enterprise Manager and Toad. Monitoring at OS Level and Backups using oasis tool.
• Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, Data Guard(Physical Standby) and Failover procedures.
• Day to day activities like, Capacity planning, Tablespaces and Segment Space management, Security Administration, database refresh and database copies etc.
• Administration and Verification of Backup procedures and backup failures using RMAN and recovery Catalog. Integration of Backups with Media management layer tools like Symantec NetBackup and backups pointing to Data Domain with Duplication and De-duplication.
• Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate and scheduling the backups using Crontab.
• Assist in the daily maintenance and tuning of RHEL 5.8 kernel parameters that host Oracle databases. Manage disk space on Linux file system and ASM file system

Environment: & Tools: Oracle 11gR1/R2, 10g, RAC, ASM, OEM Grid Control and TOAD.

Confidential, Washington DC

Lead Oracle Database Administrator

Responsibilities:

• Maintained and Administered 11g/10g databases on Windows 2000/2003, Red Hat Linux and HP-UX servers with database sizes ranging from 30GB to 5TB and managed databases comprising both Spatial and Tabular data for different vendor products and different Applications.
• Maintenance and Administration of 3 node High availability RAC 11g Clusterware databases with ASM shared storage, failover procedures.
• Applied quarterly CPU patches and one-off patches using OPatch Utility.
• Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, DataGuard and Failover procedures.
• Day to day activities like, Capacity planning, Tablespaces and Segment Space management, Security Administration, database refresh and database copies etc.
• Administration and Verification of Backup procedures and backup failures using RMAN and recovery Catalog. Integration of Backups with Media management layer tools like Symantec NetBackup and backups pointing to Data Domain with Duplication and De-duplication.
• Implementing backups using Oracle Advanced features like Flash Recovery Area and Flashback technologies like FLASHBACK DATABASE, FLASHBACK TABLE, FLASHBACK QUERY and FLASHBACK TRANSACTION QUERY.
• Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate.
• Performance Monitoring and Tuning at Instance level, Database level, OS level and Query level using Oracle diagnostic tools like Explain plan, STATSPACK, AWR, Tuning Advisors like SGA/Shared Pool/PGA tuning advisors etc.
• Daily database monitoring using Oracle Enterprise Manager Grid control and troubleshooting ORA 600 and ORA 7445 errors if any.
• Experience in scheduling tools like Autosys and Oracle Enterprise Manager.
• Experience in writing Shell scripts (purging and archiving data for partitioned tables) and automating day to day maintenance procedures.
• Experience with classic export/import, Data pump export/import and SQL loader.

Environment: & Tools: Oracle 11g, 10g, RAC, ASM, OEL, HP-UX, MS Windows, OEM Grid Control, TOAD 10.0 and Oracle workspace Manager.

Confidential, Frisco, TX

Production Oracle Database Administrator

Responsibilities:

• Installed and Created 11g/10g databases on Red Hat Linux and UNIX servers.
• Experience working with non RAC ASM and RAC with ASM, maximum number of nodes worked are 4 nodes. File Systems are OCFS2, Oracle Clusterware and VERITAS Cluster file system.
• Upgraded databases from 9i (9.2.0.8) to 10g (10.2.0.3/4) and 10g (10.2.0.4) to 11g (11.1.0.6) versions using DBUA and manual upgrades. Experience applying quarterly CPU patches one-off patches using OPatch Utility.
• Experience working with Oracle Advanced features like Oracle Streams (setup and administration), Data Guard setup and Failover procedures.
• Setup of Bi-directional and Uni-directional replication, Replication at table level and Schema level.
• Design and Planning security guidelines for database structures and schema applying the Least Privilege Principle.
• Administration and Verification of Backup procedures and backup failures using RMAN and recovery Catalog. Integration of Backups with Media management layer tools like Legato, Tivoli and Symantec Netbackup.
• Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate.
• Performance Monitoring and Tuning at Instance level, Database level, OS level and Query level using Oracle diagnostic tools like Explain plan, STATSPACK, AWR, Tuning Advisors like SGA/Shared Pool/PGA tuning advisors etc.
• Implemented different Table partitioning schemes like Range Partitioning, Hash Partitioning, List partitioning etc.
• Experience in writing Shell scripts (purging and archiving data for partitioned tables) and automating day to day maintenance procedures.
• Participated in Database deployments which include code changes and data to Acceptance and Production Environments.
• Experience with classic export/import, Data pump export/import and SQL loader.
• Performed 24*7 Production support for databases on a rotation basis.

Environment: & Tools: Oracle 11g, 10g, RAC, ASM, RHEL 4.0, AIX, Microsoft Windows, OEM, TOAD 9.6.

Confidential, Milford, MA

Oracle Database Administrator

Responsibilities:

• Worked with databases of sizes ranging from 16GB-3TB of data supporting different Applications like Empower
• Installation and Creation of 11g database and software on an Oracle VM server and database servers on Linux, AIX and Windows 2003 platforms.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass AgentDeployment on several hosts.
• Upgraded the database from 9i (9.2.0.1, 9.2.0.4, 9.2.0.6) to 10g (10.2.0.3 & 10.2.0.4) and 10g(10.2.0.4) to 11g.
• Tested for database Replication and Integration (Oracle streams) on Oracle VM machine.
• Migration of databases on 32 bit Unix to 64 bit Unix and 32 bit Windows to 64 bit Linux using Cross Platform Tablespaces.
• Developed RMANLevel-0 & Level-1 Backup & Recovery Shell Scripts for Development & Production Databases which contains 10g Features like Flashback, Block Change Tracking and linking with Tivoli Storage Management.
• Installed Oracle Data Guard for Oracle Disaster Recovery, High Availability and Data Protection.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Handling day-to-day activities and user requests in maintaining and creating databases, managing segment space and storage including tablespaces and datafiles for tablespace growth, extent growth and monitoring datafile additions. Applying the Patches as and when required.
• Expertise in troubleshooting skills including Diagnostics and Connectivity issues, resolving ORA Errors.
• Worked with database utilities like Export & Import (Exp\Imp &Expdp\Impdp), SQL Loader to backup database structures and automation procedures.
• Created BASH Shell Scripts for Startup & Shutdown the Databases, Alert Log notifications through mails, Archivelog& Flashback Space alert scripts
• Coordinated with System Admin’sfor Server Support, NAS and SAN storage.Coordinated with System Engineer’s for Application and Database Tickets.
• Successfully implemented SQL LOADER Technology for DATA INSERTION into the tables by using their Control Files & Bad Files.

Environment: & Tools: Oracle 11g, 10g, 9i, 8i, RAC, RHEL 4.0, AIX, MS Windows, TOAD 9.6.

Confidential -Dallas, TX

Oracle DATABASE ADMINISTRATOR

Responsibilities:

• Worked with different applications like Statement Archival and Retrieval (STAR), ETA (Enterprise Transaction Archive) and AIDB(All Item Database).
• Installed, Upgraded (9i to 10g )& maintained Oracle 10g R2 RAC on Red Hat Linux 4.0.
• Creating a new change over schema on the production databases. Was involved in the Quality Assurance (QA) and the Enterprise Change Management (CM) as well.
• Implemented Oracle Data Guard for oracle disaster recovery and OEM for database monitoring, performance and diagnostics have been configured
• Migration of database servers from Non-RAC (non-ASM) environment on 64 bit UNIX to RAC (with ASM) environment on HPUX.
• Monitored and tuning database to optimize the performance. Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, Statspack, SQL*Trace, Tkprof, AWR & ADDM.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, TOAD and Oracle Enterprise Manager.
• Implemented Oracle Data Change Capture supported by Oracle Streams
• Successfully implemented Backup & Recovery using RMAN which includes database hot backup, archive backup, obsolete backup and crosscheck backups.
• Performed export and import of different databases using Oracle DATA PUMP Export / Import utilities
• Upgrading and Migration of a Datawarehouse on Solaris Non-RAC environment to 64 bit LinuxRAC Clustered environment.
• Experience in Designing and Creating a Physical/Logical modeling of database, Oracle RDBMS skills which include Implementation, Normalisation and Integration in an OLTP environment.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different tablespaces.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check. Developed scripts to monitor the storage usage, object status for daily job .
• Given 24*7 Production database for supporting developers & end-users.
• Utilized OEM SQL Analyze, OEM performance manager, STATSPACK, SQL Trace, etc

Environment: & Tools: Oracle 10g, 9i, RAC, RHEL 4.0, Solaris, UNIX, OEM, DB Artisan, TOAD.

Confidential

Database admin (Internship)

Responsibilities:

• Creation of new databases, deciding the location of data, index, rollback, redo log and control files on the disks.
• Defining and developing data inter-relationships and designing the Dataflow diagrams in building an efficient Database architecture.
• Creating, checking, extending table space. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity, monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Identified common functionalities, implemented them using PL/SQL, Stored procedures,Packages, Triggers, form Libraries.
• Implemented and maintained database activities include database backup (Cold, Hot,Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Database activities include allocation and maintenance of Rollback and Undo Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Oracle 9i, Microsoft Windows 2000/2003, RHEL, SQL and PL/SQL, Data Pump Export/Import.