SUMMARY

• 8 years of total Experience as Oracle 8i/9i/10G/11G DBA in Production, Test and Development Instance environment.
• Experience in Installation, Configuration and Re - Configuration of Oracle Database on UNIX, Red Hat Linux AS/ES/4/5, and Windows advanced servers.
• Setup Data Guard on 10g R2 and 11g R2
• Configure, trouble shoot, switchover, failover Data Guard on 10g and 11gR2
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import utilities).
• Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat Enterprise Linux.
• Migrated both RAC and NON-RAC databases
• Experience in Implementation and Troubleshooting in RAC Databases.
• Set up Multi Master (Advanced Replication)
• Used RMAN Restore, Data Guard Methodologies for Migration
• Extensive uses of UNIX shell scripting.
• Worked with ASM extensively
• OEM Grid Control
• Daily health check of databases using STATSPACK, AWR, ASH, ADDM Reports
• Tune the new databases for Maximum performance
• Configure, troubleshoot in Streams in multi way replication
• Experience with handling of medium to large Oracle OLTP (Online transaction processing).
• Administered databases on Linux(RHEL), Solaris, Windows
• Experience in working with Cost-Based Optimizer and SQL Tuning.
• Experience in Oracle Enterprise Manager (OEM) & Oracle Management Server (OMS).
• Experience in UNIX shell programming.
• Experience in working with Large Tables and VLDBs
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables
• Experience in upgrading the databases from Oracle 9i to 10g and Oracle 10g to 11g using DBUA, Manual Upgrade, Export/Import methods.
• Applied patches and involved in patch set up gradation
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Experience in Design, Creating and maintaining the Oracle Database.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, AWR etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Experience in doing Backups and Recovery using RMAN and Scripts.
• Experience in applying Patches on database

TECHNICAL SKILLS

Operating Systems: HP-UX10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, Windows 98/NT/2000/XP, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x.

RDBMS: Oracle 11g,10g/9i/8i, Oracle 10g and 11g Real Application Cluster (RAC)

Languages: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting.

DB Management: TOAD, OEM 9.2

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Crystal Report, MS Access, Oracle Streams.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM,ASH

Database Modeling: Erwin 4.0

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Oracle DBA

Responsibilities:

• Experience in Installing and Maintaining the Oracle Databases 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Involved in the 11g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration projects Extensively using Data pump and RMAN utilities
• Experience in using Data pump.
• Involved in the migration of huge databases of sizes ranging from 100GB to 4TB
• Daily Health Check Up of the Database and SQL Queries using Stats pack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP,FTP and SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method, exp/imp and Data Pump utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Experience in ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Excellent in writing SQL scripts.
• Troubleshooting ORA errors when occurred

Environment: Oracle 11g/10g, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, Explain Plan, Toad 10.6.1.3, SQL Developer, PL/SQL Developer, Data Pump, Export/Import PUTTY,FTP, SFTP,SCP.

Confidential, Germantown, MD

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 DBs on Linux(RHEL) and also Upgraded from Oracle 10g to 11g
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Responsible for setup and implementation of 2 Node RAC on RHEL in 10g and 11g R2.
• Configured and Implemented Cold/Hot Backups.
• Implemented and Managed Oracle Data Guard on Oracle 10g and 11gR2
• Implemented Data Guard on production database.
• Configured Oracle Streams on Linux and windows.
• Implemented, Configured and Troubleshooting the ASM in the RAC databases.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• 24*7 on call support for the production environment.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, ASH.
• Experience in perform the tuning with Cost-Based Optimizer and SQL Tuning.
• Configured Flash Recovery Area in Dev databases.
• Involved in Migration of applications of the clients. Used Data pump and Transport table spaces for that.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Database Backup & Recovery with Export and Import for Non archive and Archive database with RMAN commands.
• Also configured database cloning using RMAN.
• Upgrading the database from Oracle 10g to the Oracle 11g and applied patches as required.
• Knowledge on the Golden gate.
• Used Database Upgrade Assistant (DBUA), Manual Upgrade and Export/Import methods for Database Up gradation from Oracle 10g to 11g.
• Develop and enforce both database and OS-level security policies for data protection.
• Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to Testing/Development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Managing databases on multiple servers.
• Disk Space Monitoring.

Environment: Oracle 10.2.0.3/11.1.0.6/.7 , Linux (RHEL), Windows 2003/2008, RDBMS, OEM Grid Control, ASM, RMAN, RAC, Data Guard, Streams, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential, Foxboro, MA

Oracle DBA/Developer

Responsibilities:

• Managed Backups for Oracle RAC databases.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training
• Database Creation, Parameter Assignment in init file or session level assignment; database startup and shutdown process.
• Implemented the Data Guard i.e., setting the logical and physical standby database and setting the migration from primary to standby databases.
• Database configuration on parameter file and operating system file.
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking.
• Configured listener for external procedure calls.
• Responsible for Troubleshooting the RAC databases.
• Configured the Streams for replication of data from one database to another.
• Database backup & Recovery with RMAN and Export/ Import.
• Upgrade the databases from Oracle 9i to Oracle 10g using DBUA and Manual Upgrade methods.
• Creation of database objects like Tables, Indexes, Views, Users, etc.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader
• Provided guidance for developers in writing and tuning PL*SQL stored procedures and SQL queries.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Alert monitoring and Ticketing.
• Worked on replicating tool like Streams and Golden gate eventually to migrate data from source database to other databases.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 9i RAC.

Environment: Oracle 10.1.0 RAC on RHEL, Window NT/2000/2003,Solaries 10, Oracle Enterprise Manager, Oracle Advance Replication, RDBMS, RMAN backups, Data Guard, SQLPLUS, PL/SQL, TOAD7.5, Shell Scripting, HTML, ASP, DBA, Stored Procedures, Triggers

Confidential, Stevens Point, WI

Oracle DBA

Responsibilities:

• Managed Backups for Oracle Transactional and Data warehouse databases.
• Supported different Databases like Production, Testing, Staging and Training
• Database backup & Recovery with RMAN, Export/Import methods.
• Responsible for setup and troubleshooting in RDBMS databases.
• Helped business users in resolving many issues in all the manufacturing modules.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Established Application environment set up at offshore.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, SQL*Net and IMPORT/EXPORT.
• Month end job monitoring and checklist preparation and co-ordination.
• Enact an aggressive backup strategy for all production databases.
• Creating Logical and Physical database structure, Creating and altering Table spaces, Managing Users and Resources, Granting and Revoking privileges through Roles.
• Hands on experience working on High Availability Environments.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 9i versions in RAC
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 10g and Oracle 9i on operating system AIX.

Environment: Oracle 10g, Oracle 9i, RHEL, Window 2003,Oracle Enterprise Manager, RDBMS,RAC, RMAN SQLDBA, PL/SQL, TOAD7.5

Confidential, VA

Oracle DBA

Responsibilities:

• Designed and Developed Oracle database logical and physical standards as needed.
• Architecture design based on objective rather than off-shelf applications documentation.
• Tuned the current Application Architecture to Optimal Performance Architecture.
• Backup and recovery utilizing RMAN.
• Worked in Oracle SQL, PL/SQL, SQL*Plus, IMP/EXP, Query performance tuning, Created database objects like Tables, Views, Indexes.
• Setup standby database via Data Guard for database disaster recovery.
• Installation of Oracle Patches
• Writing PL/SQL procedures.
• Implemented flashback technology and materialized views.
• Performed ongoing tuning of the database instances.
• Installation and configuring the oracle software.
• Make the database Optimal Flexible Architecture Complaint.
• Managing of Table space of different user by granting quota on Default & Temporary Table spaces.
• Monitoring CPU resource utilization and database growth.
• Cloned database from Production to Testing.

Environment: Oracle 9.2.0.7, Oracle Advance Replication, Window NT/2000/2003, Oracle Enterprise Manager, MS SQL Server 7/2000,RDBMS, VERITAS Netback up, SQL, PL/SQL, TOAD7.5, Shell Scripting, HTML, DBA, Stored Procedures, Triggers.

Confidential

Software Engineer/Oracle Developer

Responsibilities:

• Involved in requirement gathering, user interaction, study, business model designing.
• Designing the prototype application for presentation.
• Developed database Schema, Stored Procedures and Database Triggers for data manipulation.
• Extensively used Informatics to load data from wide range of sources such as Flat files, Relational Sources to Target Data Warehouse database built on Oracle.
• Establish connectivity to the applications based on Oracle for ETL.
• Setup the RDBMS databases.
• Extracting the data from different databases.
• Transforming the data before loading data mart.

Environment: Oracle 8.3, Windows 98, RDBMS, SQL, PL/SQL, SQL* Plus