PROFESSIONAL SUMMARY

• Over Seven years of experience as Oracle Database Administrator with notable success managing production, development and test databases for a broad range of corporate IT applications
• Complete Oracle lifecycle experience from concept to design, architecture, hardware selection, installation & patches, configuration, security & space management, performance monitoring & tuning, data integrity, backups & recovery planning and 24 x 7 supports.
• Worked on Oracle 10g RAC database, Backup & Recovery, online/offline backups, Physical and logical backups (Import/Export), Oracle Datapump, complete recovery with and without RMAN complete/incomplete recovery with archiving, Recovery manager and recovery catalog maintenance, configured Dataguard physical standby / logical standby database for High Availability (HA) database environment.
• Proficient in database analysis, modeling, scalable design, development, deployment and support of VLDB, OLTP and DSS databases.
• Working with Oracle Support Team, creation of Service Requests for Oracle Software, database, Grid Control, RAC related issues.
• Proven success in analyzing business needs, customer service, operations and technology.
• Ability to demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis.

Oracle 11g Certified Professional Database Administrator
Oracle Database 10g: Real Application Clusters Administrator Certified Expert
Oracle 10g Certified Professional Database Administrator
Oracle 9i Certified Professional Database Administrator
Oracle Application DBA 11i

Education
Master in Computer Application
Bachelors in Civil Engineering

TECHNICAL SKILLS

Databases
Oracle 11g, 10g / 9i / 8i / 8 / 7.3. , SQL Server, Microsoft Access
Languages
SQL, PL/SQL, Unix Shell Programming, Java, C, C++, VB 6.0.
Tools
Oracle Enterprise Manager Grid Control, Export, Import, Datapump,RMAN, SQL Loader, Log Miner,Tkprof, Data Warehouse, DB Verify, Oracle DBCA,Oracle Migration Assistant, ERwin Data Modeler, HP Omni Back - II, HP Glance, SAM, Exceed, Developer 2000(Forms 4.5,Report 2.5), Crystal Reports , MS Visio ,Toad, PL/SQL Developer, DBArtisan,Autosys, Mercury Test Director, Remedy, Edify.

Operating System
Sun Solaris (2.8,2.10), HP-UX (11.x, 10.x), AIX (5.3), Enterprise Red Hat Linux 4.0, Windows XP/ 2000/NT/98/95
Hardware
HP 9000 Servers (Superdome, RP-8400, N-Class, L-Class, K-Class), EMC SAN-Symmetrix, HP Sure Store XP512, RAID 5 Disk Storage, HP Ultrium backup device, Sun Server (V880, 4900, V280), IBM Server, Windows 2003 / 2000 / NT

WORK EXPERIENCE
Confidential, Iselin, NJ
Sep 2009- Till Date
Oracle DBA

Environment
Oracle 11g/10g/9i, Oracle RAC, Data Guard Broker, Logical / Physical Standby Database, OEM Grid Control ,Data Warehouse, SQL*Plus, PL/SQL, SQL*Loader, PLSQL Developer, Unix scripting, Windows Scripting, RMAN, Red Hat Linux, AIX 5.3, Solaris, Windows 2000, SQL Navigator.
Responsibilities

• Installation, configuration and maintenance of Oracle 10g /11g RAC database with ASM.
• Install and configuration of Grid Control for centralized monitoring of Oracle 9i, Oracle 10g and Oracle 11g databases.
• Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, architecture and design, mentoring and support.
• Implementing user level security, object level security, dataencryption, data masking, Fine Grainedauditing using DBMS_FGA package.
• Tuning of SQL queries using AWR, ASH, SQL Tuning Advisor, ADDM, Explain Plan, Stats gathering etc.
• Designed and developed Packages, Procedures, Functions and Triggers to handle errors and exceptions at database level.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Developed Unix / Windows scripts for Primary / Standby switchover and failover, RMAN backup / recovery, Datapump export / import, purging archive log files, old backup files etc.

Confidential, South Brunswick, NJ
Feb 2009- Aug 2009
Oracle DBA

Environment
Oracle 11g/10g/9i, Oracle RAC, Data Guard Broker, Logical / Physical Standby Database, OEM Grid Control ,Data Warehouse, SQL*Plus, PL/SQL, SQL*Loader, PLSQL Developer, Unix scripting, RMAN, PeopleSoft , Red Hat Linux, AIX 5.3, Solaris, Windows 2000.
Responsibilities

• Configured Physical Standby database using Oracle Active Data Guard for disaster recovery, business continuity and reporting purpose.
• Grid Control installation and setup, created monitoring templates, User Defined Metric for customized monitoring.
• Setup Oracle 11g Active Physical Standby database using Dataguard Broker forPeopleSoft.
• Providedmultiple database environments for development, integration test, system test, and production using RMAN duplicate database and datapump utility.
• Installation, configuration and maintenanceof Oracle 10g RAC / OLTP database and OEM Agent. Applied CPU patches suggested by Oracle.
• Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, architecture and design, mentoring and support.
• Upgrading database from version 10.2.0.4 to version 11.1.0.7.
• Migration of databases to ASM.
• Tuning of SQL queries using AWR, ASH, SQL Tuning Advisor, ADDM, Explain Plan, Stats gathering etc.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.

Confidential, Wilmington, DE
Dec 2007- Jan 2009
Oracle DBA

Environment
Oracle 9i/10g, Oracle RAC, Dataguard, Logical / Physical Standby Database, OEM Grid Control ,Data Warehouse, SQL*Plus, iSQL*Plus, PL/SQL, SQL*Loader, PLSQL Developer, Unix scripting, RMAN, Peoplesoft , Windows 2000/NT, AIX 5.3, Red Hat Linux.
Responsibilities

• Oracle database installation, patch installation, configuration, and maintenance. Installed and configured enterprise manager agent using Oracle Universal Installer (OUI).
• Installation and configuration of OEM Grid Control for various databases for centralized monitoring and administration of hosts / databases.
• Migrate Oracle 8i database to Oracle 10g RAC database.
• Well versed with Oracle 10g Enterprise Manager Grid Control for space management, init parameter settings, alert message notification, system and database policy definition, databaseand application server monitoring, and patch installation.
• Configuration and maintenance of logical and physical standby database, Oracle 10g RAC 3 mode cluster database and regular databases.
• Created and modified existing Unix scripts for Oracle 10g.
• Migrate local file system database to ASM database.
• Implemented Oracle Security / Auditing techniques for SOX compliance which includes Fine Grained Auditing (FGA), Fine Grained Access Control (FGAC) using DBMS_FGA and DBMS_RLS for implementing Row Level / Column LevelSecurity, data and backup encryption, strong authentication.
• Well versed with Autosys and dbms scheduler to automate batch job scheduling with oracle 10g chain concept, and unix/window script scheduling.
• Backup and Recovery using RMAN, Datapump Export and Import using Oracle 10g new features.
• Performance and Tuning of database by identifying bottleneck in SQL queries and batch processes using Explain plan, AWR reports and Grid control.
• Worked with development team for database object creation, query tuning and regular database related issues.
• Worked with Data Warehouse team for Dimension tables, Fact tables, Star schema, ETL data load and report generation related issues.

Confidential, Arlington Heights, IL
May 2005- Nov 2007
Oracle DBA

Environment
Sun Solaris, Red Hat Linux, Oracle 9i/10g, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, iSQL*Plus, PL/SQL, SQL*Loader, PLSQL Developer, Unix scripting, RMAN, Windows 2000/NT.

Responsibilities

• Conductedsystemfocusedrequirementanalysisandquantitativeassessment ofbusinessneed.
• Extensively involved with end system users and developers to facilitate optimum database design, development, and enhancement.
• Setting Dataguard Physical Standby database.
• Responsible for Oracle database installation, patch installation, configuration, and maintenance. Installed and configured enterprise manager agent using Oracle Universal Installer (OUI).
• Automate batch processes from Autosys to Oracle Scheduler chain jobs.
• Extensively used Automatic Workload Repository (AWR), and Active Session History (ASH) to collect database statistics.
• Effectively improved database performance byidentifying bottlenecks, tuning SGA, rebuilding indexes, using hints in queries, creating materialized views, usingcluster tables, and usingpartition tables.
• Balanced I/O by multiplexing of redo log groups, control files, and spread data files across several disks.
• Used DB Verify utility to detect database block corruption, used log miner package to mine archive files.
• Solely developed and managed automated alert and notificationsystem to monitor database errors, jobs, invalid object status, database space, and locks on objects.
• Configured database system security using Virtual Private Database (VPD), user profiles, data encryption using DBMS_CRPTO and firewall traffic restriction usingSQL*Net, TNS Listener configuration, remote hosts configuration, andlistener ports configuration.
• Handled administrative activities like kernel parameter configuration, user management, startup/shutdown of clusters and packagesand nodes during server maintenance, generating nickle output, and HP Glance and SAM utilities.
• Designed and developed back up and recovery procedure using various techniques like logical bakups (exp/imp), physical backups (hot/cold), datapump (expdp/impdp) and RMAN backups using unix shell scripts.
• Worked with ETL and Reporting team for tuning of complex data warehouse queries and batch processes.
• Tune the SQL queries by creating proper index, using hints and changing database parameters.
• Provide development and QA environment using RMAN backup and recovery.

Confidential, Atlanta, GA
January - April 2005
Oracle DBA

Environment
HP Unix, Oracle 8i/9i/10g, Toad UNIX Shell Scripting, RMAN, HP Sure Store XP512, RAID 5 Disk Storage, HP Ultrium backup device
Responsibilities

• Involved in designing, developing and maintaining Financial System in Client/Server environment.
• Developed various Forms, business reports and relational database stored procedures, packages using Visual Basic, Oracle and Crystal Reports.
• Installation, configuration and maintenance of FAS on various systems for production, development and test instances.
• Involved in development of application functions, triggers, PL/SQL and packages.
• Monitored and maintained archive logs, alert logs, traces, free spaces, file systems using shell scripts.
• Developed and managed alert system to monitor database errors, broken jobs, invalid object status, space, and locks on objects.
• User Account auditing by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.
• Implementing logical/ physical backups (Hot Backup & Cold Backup)/ RMAN Backup.
• Setting up of either full export, partial export, or export of just the structure of schema objects and, cold or hot backups, depending on the database.
• Proactively monitored database performance including tuning SGA and modification of initialization parameters; rebuilding of indexes; reallocation of memory and other system resources, tuning SQL statements using Explain Plan.

Confidential, Ahmedabad, India
September 2003 - December 2004
Oracle DBA

Environment
Sun Solaris, HP Unix, Red Hat Linux, Oracle 8.1.7, Oracle 9i, EMC SAN, HP Omni Backup.
Responsibilities

• Build ER model, Normalize data to eliminate redundancy.
• Solely performed installation, configuration and patch installation of Oracle database on heterogeneous platforms.
• Allocated and maintained locally and dictionary managed tablespaces and creation of schema as per security policy of company, management of Archive Logs and Trace Files.
• Involved in development of application functions, triggers, PL/SQL and packages.
• Take lead responsibilities to perform Oracle DBA activities like backup and recovery, space management, performance tuning.
• Security Management by granting roles, privileges and profiles. Solely responsible to review security policy for database users.
• Extensively coordinated database and OS support with global vendor support team of Oracle, HP-Unix and EMC SAN Storage.
• Upgrade Production/development databases from Oracle 8.1.6 to 8.1.7.4 to 9i with Installation, Applying patches, Parameter Setting.
• Involved in deployment and configuration of system on client/server machine.
• Implement and maintained different types of applications in Oracle Financial, Payroll, Accounts and Inventory system for clients.
• Creation of schema owners and all other database users.
• Planning future storage requirement for the database
• Used bitmap indexing for large tables in Decision Support System

Confidential, Ahmedabad, India
August 2002 - August 2003
Oracle DBA

Environment
HP Unix, Windows NT, Oracle 8i, HP Storage.
Responsibilities

• Monitored and maintained archive logs, checking alert logs, traces, free spaces, Oracle managed file systems.
• Performed scheduled maintenance for backup and recovery.
• Performed logical backup and physical backup.
• Involved in tuning of Forms & Reports of Devloper2000.
• Solely performed installation, configuration and patch installation of Oracle database on heterogeneous platforms.
• Documentation of the database, backup schedules and the database maintenance activities.
• Solely responsible to review security policy for database users using Profiles, Roles, Privileges.