EXPERIENCE SUMMARY

7+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.

• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Worked with a team to provide 24x7 on-call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Installation, configuration maintenance of Oracle 10g RAC, 11g RAC, Standby Databases (DataGuard).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Management of schemas, objects & Partitioning the tables & indexes.
• Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases.
• Excellent knowledge in Backups and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle Standby Database
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in replication using Oracle Streams, GoldenGate and experience in using OEM, TOAD, Database Migrations using transportable tablespaces, transportable database, benchmarking using load testing tools
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Worked on different types of storage structures (SAN/NAS).
• Good written and verbal communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Operating Systems:HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,5.3,6.1  Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/ME/NT/2000/XP.

RDBMS:Oracle 11g/10g/9i/8i, Oracle 11g RAC, Oracle 10g RAC, SQL Server 2000.

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

Tools:TOAD, SQL Plus, SQL Developer, RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, DataPump (expdp, impdp), ERWIN, VMware, Golden Gate, Informatica, Putty.

Tuning Tools:TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Grid Control.

Other :VERITAS, NetBackup.

Web Tools:HTML, XML.

EDUCATION

• Master in Computer Applications from Confidential University.
• Bachelor of Science (Computer Science) from Confidential University.

PROFESSIONAL SUMMARY

Confidential, Reston, VA. March’ 11 – Present
Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Installation and Configuration of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery.
• Involved in the Installation of Active – Passive Golden Gate on RAC.
• Worked on Automatic Storage Management(ASM)for managing data inSAN Storage.
• Setup Active Data Guard for Database Disaster Recovery.
• Involved in Design and implementation of Logical, Physical Standby Databases.
• Upgrade the database from Oracle 10g to 11g.
• Worked on the different environments like test, development and production databases.
• Created and managed database objects.
• Created and managed users, roles, privileges, schemas.
• Developed PL/SQL Packages, Procedures, Functions, Triggers.
• Creating and dropping of users, granting and revoking rights as and when required.
• Worked on Data pump (Expdp / Impdp), Import / Export.
• Have done database backup and recovery using cold backup/ hot backup/ logical.
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN
• Review of Database logical and Physical design.
• Diagnose and Troubleshoot Database Problems and failures.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Performed database and memory tuning using tools like AWR, ADDM, TKPROF, and EXPLAIN PLAN.
• Interacted with developers, application owners for gathering the information and resolving various issues.
• Performing database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Design and Setup backup and recovery procedures.
• Storage and space management including table spaces and data files.
• Analyzing, Sizing the database for future growth.
• Have worked on different environments like test, development and production databases.
• Managing database instances for test environments to ensure strong testing environment and smooth transition to production.
• Working with the off shore team and testers while code deployment and application testing
• Database Monitoring using Database, Grid Control.
• Generated DML, DDL Scripts using the SQL Developer, PL/SQL Developer, and TOAD.
• Schema, Data comparison using the TOAD.
• Supported the Development team, supporting production Environment.
• The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.

Environment: Oracle 11g/10g, Oracle 11g/10g RAC, RMAN, UNIX (AIX, Sun Solaris), Red Hat LINUX, Golden Gate, SQL, PL/SQL, TOAD, UNIX Shell, SQL* Developer,
ASM, TOAD, Data pump, Data guard, OEM (Grid Control).

Confidential, Deerfield, Illinois. Oct’ 09 – Feb’ 11
Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Involved in the installation of the Golden Gate.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, schemas.
• Handling large OLTP/DSS (Data warehouse) environments.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Up gradation and migration from Oracle9i, 10g databases to Oracle 11g.
• Have setup Active Data Guard for Disaster Recovery and reporting purpose.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Expertise in Client server GUI software and different Operating systems.
• Migrated from SQL server to Oracle.
• Worked on import/export, datapump (expdp/impdp) and SQL* loader.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Oracle Streams.
• Proactive database monitoring using 10g Grid Control.
• Capacity planning & Bench marking, monitoring database growth, resource usage etc.,
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using Cold backup, Hot backup and Logical backups.
• Design and Setup backup and recovery procedures.
• Building complex logical data models using sophisticated modeling techniques and tools like Erwin
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, ADDM, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Partitioning of large tables for better performance & Manageability.
• Wrote UNIX shell scripting to automate tasks and crontab and dbms_scheduler for scheduling jobs

Environment: Oracle 11g RAC/10g RAC, RMAN, UNIX (IBM AIX, Sun Solaris, HP-UX), RedHat LINUX,  Golden Gate, SQL, PL/SQL, TOAD, UNIX Shell, SQL* Loader, ASM, TOAD, Data pump, Netapp, Dataguard, OEM (Grid Control).

Confidential, San Jose, CA. Jul’ 08 – Sept’ 09
Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Have worked on different environments like test, development and production databases.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Analysis of the existing Data Warehouse system to understand existing functionality
• Have worked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Managed users, privileges, profiles, and schemas.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for upgrade & migrating databases from 9i to 10g and 9i, 10g to 11g, applying patches.
• Cloned, Refreshed databases from production database to test development using RMAN and manual method using hot backups.
• Involved in the Installation of the Golden Gate.
• Involved in Design and implementation of Standby Databases (Oracle Data Guard)
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Used SQL- Loader and External Tables to load data into tables.
• Identified, designed and developed Oracle PL/SQL Packages, Procedures, Functions, Triggers.
• Automated monitoring the databases, performance parameters, and backup/recovery activities running Cron jobs and write UNIX shells scripts for job automation.
• Performed SQL, database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: Oracle 11g RAC/10g RAC, RMAN, RedHat LINUX, Sun Solaris, HP-UX, Golden Gate, SQL, Shell Scripting, PL/SQL, TOAD, SQL* Loader, ASM, Datapump, Dataguard, OEM (GridControl).

Confidential, Chicago, IL. Aug’ 07 – Jun’ 08
Role: Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation, Configuration, maintenance of Oracle 10g.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 8i, 9i, 10g databases.
• Database monitoring and performance tuning using using Statspack, AWR, Explain plan, TKPROF
• /AWR/ADDM.
• Created triggers, packages, procedures and functions in PL/SQL.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Performed backups and recoveries
• Applying Patches.
• Performing day-to-day database administration tasks like monitoring tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis
• Logical and physical database design
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Migrated databases from Windows to Linux
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Environment: Oracle 10g RAC/9i/8i, RMAN, RedHat LINUX, Sun Solaris, AIX, Golden Gate, SQL, PL/SQL, TOAD, SQL* Loader, Datapump, Dataguard, OEM (GridControl).

Confidential, Louisville, KY. Oct’ 06 – Jul’ 07
Role: Oracle DBA

Responsibilities:

• The work involved overall Maintenance of Oracle Database, Performance Tuning, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan. Implemented Backup and Recovery Plan
• Creation and maintenance of database. Handling day-to-day activities.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups, monthly cold backup
• Database backup and recoveries using RMAN. Performed block recovery using RMAN
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases
• Using TKPROF, EXPLAIN PLAN, AWR, ADDM, STATSPACK for performance monitoring and tuning
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle 10g RAC/9i/8i, RMAN, RedHat LINUX, Sun Solaris, HP-UX, SQL, PL/SQL, TOAD, SQL* Loader, Datapump, OEM (GridControl),

Confidential. Jan’ 05 – Sept’ 06
Role: Database Administrator

Responsibilities:

• Support & Maintenance of Production/Development Databases on various servers.
• Logical and Physical Modeling.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle Installation, Upgrading from 8i to 9i, 9i to 10g.
• Capacity Planning, Storage Allocation and Space Management.
• Creating users, tables, database links, Performing Exports/Imports.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups.
• Database Tuning – Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Created PL/SQL Packages, Procedures and Functions
• Analyzing, Sizing the database for future growth.
• Automating the process/Scheduling Jobs using DBMS_JOB.
• Writing scripts for monitoring the database, Configuring SQL* Net. Integrating multiple application databases with multiple corporate entities, receiving business data feeds.
• Fine Performance Tuning the Databases for optimization, Tuning Application, Estimating Table & Index Size
• Writing PL/SQL Stored procedures, packages & triggers to support e-commerce application.
• Supporting the Development team, supporting production Environment

Environment: Oracle 10g/9i/8i, IBM AIX, Sun Solaris, RedHat Linux, Exports/Imports, SQL, PL/SQL,  SQL* Loader, SQL* Net.

Confidential. Jun’ 03 – Dec’ 04
Role: Oracle DBA / Developer

Responsibilities:

• Database Installations, Creations and Upgrades.
• Analyzed the structures using Analyze command. Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL programs and SQL scripts
• Developed PL/SQL functions, procedures, packages, triggers
• Involved in application Testing, Deployment, and Production Support.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization
• Implemented automated backup strategy using the UNIX shell script Cron Utility.

Environment: Oracle 9i/8i/7.3, SQL, Windows NT, HP-UX, SQL Server 2000, SQL, PL/SQL,SQL * Loader, UNIX Shell Scripting.