SUMMARY

• Around 7 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Experience in Configuring Single instance, Oracle Real Application Clusters (RAC). Expertise in Installing, configuring and tuning issues in automatic storage management (ASM) and RAC for high availability databases.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and data Ware-housing.
• Have implemented ORACLE STREAMS and worked on both types of standby databases supported by DATAGUARD (logical standby and physical standby).
• Worked on all kinds of backup operations using RMAN (full database, datafiles, image copies, incremental back upsets, validating), using Flash recovery area, recovery operations (block media, full database, tablespace, datafiles, control files, point in time, validating) and catalog maintenance
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for maintaining many databases together on separate servers.
• Good exposure of oracle DBA task like installation, patching, cloning and upgrade of oracle database
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX- Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Solution with strategic disaster recovery plans with different recovery procedures and methods.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in migration of oracle database to higher version and installing patches.
• Exporting and Importing of dumps using expdp and impdp
• Experience on handling very large database (vldb).
• Knowledge of new features in 11gR2 like RAC-One Node.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities).
• SQL statement tuning using Explain Plans, SQL Trace using TKPROF utility and AUTOTRACE utility. 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sql trace utilities.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA).
• Good coordinator, understanding and presentation skills with all work departments. Work as the subject matter in the matter of performance issues, reorganization, auditing the required down times and the effect on the business application between the developers, system administration and the end clients.
• Experience as On-Call 24x7 production DBA support.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/2000, Windows advanced Server 2000/2003

Databases: Oracle 11gR1, 10gR2 RAC, 9i, 8i, SQL Server 2005.

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools: & Utilities: Export/Import, RMAN, Data Pump, ERWIN

Languages: C, C++, UNIX shell scripts, PL/SQL, perl

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Oracle Database Administrator

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements
• Installation of Oracle database 10g software with RAC using Oracle Cluster-ware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Created Cluster-database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.

Environment: Oracle Database Server 10g/11g. IBM-AIX, SunSparcSolaris64bit, and Redhat Linux TOAD, PL/SQL, PUTTY, Export/Import, RMAN, Data Pump, AWR, TKPROF, ADDM, ERWIN

Confidential, Pittsburg, PA

Sr. Database Administrator

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager
• Installed Oracle Streams for Basic and Advanced Data Replication between Oracle Databases and other databases.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 later 10.2.0.4 and applying patches whenever required.
• Cloned/Refreshed Oracle Databases for development and testing
• Partitioned large tables to increase the performance.
• Performance tuning of Oracle Database Objects by fixing row chaining
• Installed and Configured Oracle Dataguard for Oracle 10g & 9i for the maintenance of Stand by database
• Extensive use of Oracle Dataguard for protection of critical production data & provide data / disaster recovery support.
• Optimization and tuning SQL queries using TRACE FILE,TKPROF,EXPLAIN PLAN
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Tuning heavy data loads, monitoring and Performance tuning
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN
• Performed block recovery using RMAN. Performed backup validations using RMAN
• Oracle Database monitoring, troubleshoot and resolve the issues
• Management of schemas, objects partitioning the tables & indexes
• Automation of data load using Korn shell scripting and SQL*Loader
• Responsible for setting and managing user accounts, Granting required privileges to users
• Defining and Implementation of backup and recovery strategies
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required
• Writing scripts for the system and database for effective functionality and report generation
• Applied High priority, security patches downloaded from Metalink.
• Involved in Logical and Physical database design.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8/9, PUTTY

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Involved in team management, team building exercises for the DBA team.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Creating users with restricted access, with default and temporary table spaces. Partitions on tables and indexes .Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing hot and cold backups. Restoration and recovery from backup.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g, 10g RAC, 9i on Linux & AIX. Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Established standards for all Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA). This initiative involved redesigning all new and legacy environments to adhere to these newly established standards.
• Redesigned a thorough backup and recovery strategy for all major production systems

Environment: ORACLE 11g, SQL, PL/SQL, Import/Export, UNIX AIX 5, Windows NT.

Confidential

Jr. Developer/Oracle DBA

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23
• Migrating applications from non-clustered oracle 8i/9i/10g databases to new
• Monitoring and supporting Applications using OEM 10g Grid Control
• Created PARTIONING of its types like Range, List & Hash by the specific use.
• Implemented Oracle Streams for Replication and applying patches
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to Oracle 10g GRID
• Registering Databases to RMAN Catalog
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Data pump.

Environment: Oracle 9i, ASM, Oracle 10g Grid Control, Oracle 9i, HP-UX 11.23.

Confidential

Oracle Developer

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Creating primary database storage structures (table spaces, datafiles, tables, indexes etc).
• Developing hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Troubleshooting through examining Oracle alert logs, system logs and trace files
• Monitoring the Database storage and day to day activities.
• Configured scripts to monitor activity with database.
• Partitioned large tables to increase the performance.
• Performing all daily maintenance tasks. Interacting with oracle customer service as and when required.

Environment: Sun Solaris, HP-UX, Oracle 8i, 9i