SUMMARY

• Around 7+ years of IT experience working as an Oracle Database Administrator, having hands on experience in Installation, Configuration, Backup and Recovery, Migration, Upgrades, Patches, Cloning Replication, Database Security, Memory Management, RAC, Data Guard, Performance monitoring and Tuning, Grid Control, Oracle Streams, Golden Gate, Data Modeling, Production, Development, Implementation and Testing of Relational Database
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, UNIX Shell Programming.
• Installed and configured oracle database server on SOLARIS, HP - UX, IBM-AIX, WINDOWS, and REDHAT LINUX.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Point-In-Time Recovery through RMAN and Monitoring the Alert Logs of all databases.
• Experience in using Tools like OEM, TOAD, Data Migrations & export/import.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Data loading using SQL*LOADER, Logical backups using full Export and DATAPUMP.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• 24*7 on-call production database support and maintenance including remote database support
• Responsible for interacting with business partners to identify information needs and business Requirements.
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

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

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

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

Languages: C, Unix shell scripts, PL/SQL, Perl.

Web Tools: HTML, SQL NET, TCP/IP.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Fl

Senior Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 10g, 11g on LINUX, IBM-AIX and Windows platforms.
• 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 and 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.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• 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.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Logical and Physical data modeling using Erwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: IBM-AIX, REDHAT LINUX, Windows 2003/NT,ERWIN, Putty, Oracle 10g,11g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump.

Confidential, Plantation, Fl

Oracle Database Administrator

Responsibilities:

• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Oracle Grid Control11g Installation and Configuration.
• Supporting Data Warehouse Database i.e., over 20TB
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health check up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions.
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML.

Confidential, Houston, TX

Oracle Database Administrator

Responsibilities:

• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL.

Confidential, Cincinnati, OH

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 table spaces, sizing the system table space, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces. creating different kinds of 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 on Linux & AIX.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Redesigned a thorough backup and recovery strategy for all major production systems.

Environment: ORACLE 9i/10g, RAC,OEM, RMAN, DATAGUARD, SQL, Import/Export, PuttyRH Linux, UNIX AIX, Windows NT.

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

• Installing, Creating and Migrating the Oracle database on 10g.
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM)
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Physical Database Capacity Planning and data-files mapping.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using AWR, ADDM.
• Install, Configure and implement Oracle Advanced Replication as the lead DBA.
• Management of schemas, objects partitioning the tables & indexes.
• Tested the loaded data and documented the errors and reporting.
• Taking Periodic Backup of the databases and the software using RMAN.
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• 24x7 on-call production database support.

Environment: HP -UX, Solaris, Windows XP, Oracle 9i/10g, RAC, OEM, RMAN, DBCA, Data Guard, Putty, XML, Load Runner, TOAD.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 8i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Applied patches, keeping applications software bug free and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• 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.

Environment: ORACLE 9i, 10g, SQL, Import/Export, UNIX AIX, Windows NT.

Confidential

Jr. developer/Oracle Database Administrator

Responsibilities:

• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges
• Configured Recovery Manager (RMAN) and Performed Hot and Cold backups for production databases using RMAN.
• Involved in checking the status of listener and restarting listener.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Performed auditing on user activities on request and per organization policies.
• Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.

Environment: Oracle 9i, 10g, RHEL 4, Import/Export, windows RMAN 2003.