SUMMARY

• Over 7 years of experience as an Oracle DBA in Performance Testing, Production, Development environments, and transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, MS SQL Server 2008, JDBC, Visio,VB.NET C#, Windows and Solaris Linux, Unix Environment.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, 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 using customized shell scripts and stepwise.
• 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, PL/SQL,UNIX Shell Programming.
• 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.)
• Experience in using Tools like OEM, TOAD, E - Business suite, Data Migrations & export/import.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, TKPROF,STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• 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.
• Excellent experience in applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Designing the ETL processes and Experience designing the DW model USING TABLEAU.

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, E-business suite.

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

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

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

Oracle DBA/Database Analyst

Responsibilities:

• Installed and configure oracle 10g, 11g databases on Linux, AIX and Solaris based servers on Testing and Production environment, configuration for the new RAC databases (Solaris Linux)
• Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Performance Testing Environment.Import from one user schema to another schema user in performance testing databases. Checked Load balancing of RAC instances.
• Extensive use of AWR to generate database statistics, ADDM to find the performance issues and get recommended solution to improve the performance.
• Running the scripts for the partitioned table using Range, hash, list partitioning them.
• Plan, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Bakupsets, Implementing retention policy for backup sets, clean the archive log after backup and write the shell script to automate the backup process by scheduling in crontab.
• Unlock the user accounts and grant roles to specific users.
• Worked on 2 nodes Rac and created scan listeners. Performed RDBMS Upgrade for Oracle 11.2.0.3 release for the Rac.
• Worked on GRID Install for Oracle 11.2.0.3 release. Performed RDBMS Install for Oracle 11.2.0.3 release.
• Design schemas (Star, Snowflake) for dev and test databases using Erwin.
• Setup the Streams Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database.
• Provide and implemented RMAN backup strategy with retention policy of 35 days to keep the latest2days backupsets on disk and move rest of the backupsets to location.
• Configured RMAN for above scenario, write shell script and set a cron job to automate the backup process nightly bases for ASM environment.
• Performed the RMAN complete recovery, tablespace recovery, datafile recovery, controlfile recovery.
• Recover/Cloned the database using RMAN duplicate command.
• Cloned databases using cold backup, by re-creating controlfile, using RMAN duplicate command, putting the database in backup mode in case of production environment.
• Moved columns containing Lob Objects to a new tablespace to improve the Database performance, rebuild indexes after table or column move.
• Upgrade/Migration of Databases from Oracle 10g to 11g
• Enable the SQL tracing at session level by setting the SQL TRACE parameter to true.

Environment: Oracle11g RAC, 11gR1,R2 11.2.0.3, Streams Replication, RMAN, Data Pump, Shell Scripting, Sun Solaris Linux Enterprise, SAN, Grid Control, TOAD, Putty.

Confidential, NJ

Senior Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 11g, on, LINUX, IBM-AIX and Windows platforms.
• Utilized Grid Control to administer multi-node RAC database also managed in the RAC environment. Load balancing of RAC instances.
• Used golden gate for real time information acess and availability & High data replication.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 10g Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Table spaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using tools and UNIX command-line utilities.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 9i to 10g to 11g, Cross platform migration from different platforms.
• Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• 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).

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, RAC, Shareplex, TOAD, OEM, DATAGUARD, RMAN, Golden Gate, Data Pump, Diagnostic and Tuning Advisors.

Confidential, Tampa, Florida

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,9i on Linux & AIX.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Established and wrote the Performance Tuning guidelines for the Engineering Department to enhance the quality of the product for all current and future code development. This document includes hints for SQL, PL/SQL and JDBC performance tuning, application tuning.
• Led the application design team in developing a custom ETL application using built-in Oracle technology (Oracle Replication, Materialized Views, Snapshot's, and PL/SQL) as well as designing the Star Schema used to support the company's Enterprise Business Intelligence system.
• 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.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for Java and PL/SQL, policies, practices and procedures.
• Redesigned a thorough backup and recovery strategy for all major production systems.

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

Confidential, Philadelphia, PA

Oracle Database Administrator

Responsibilities:

• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Database Restore using RMAN, Cold Backup and Export.
• Setup, configured and managed oracle 9i RAC database for high availability.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Used importdp/exportdp and SQL- loader to load data into tables.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Monitoring the table growth, database growth, current users, and system resource usage and so on. Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i, RAC, OEM, RMAN, DBCA, Data Guard, Putty, Java, XML, Load Runner, TOAD, Erwin, UNIX, RHLinux 4.0.

Confidential

Oracle Database Administrator

Responsibilities:

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

Environment: Oracle Grid Control, Oracle 9i, HP-UX 11.23

Confidential

Oracle Developer

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup scheduled Script creation and Standardization. Performed Database Installation and upgradation.
• Experience in working with cold and hot backups and recoveries. Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Setting up new development and QA environments and involved in deployments and migration. Cloned databases for development and testing. Refreshed Dev &QA databases from production.
• Customized database backups for Disaster Planning and implementation.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Used STATSPACK, TKPROF utilities for Tuning and analysis.
• Recovery of database from media failures, dropped accidentally and data block.
• Created new reports for billing inquiry,Summary reports and creating primary objects.

Environment: ORACLE 8i, 9i, SQL, PL/SQL, Import/Export, UNIX AIX 5.1, Windows NT.