SUMMARY

• Nine years of IT experience which includes Seven plus years of experience in Oracle database (8i/9i/10g,11g) administration, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, HP - UX, AIX, LINUX, Windows 2003, Windows Bit.
• Good understanding of Oracle Architecture.
• Installation and Configuration of Oracle 9i, 10g and 11g Real Application Clusters (RAC) with multiple nodes.
• Experience working with Golden gate for replicating the database.
• Installing Oracle 10g RAC using ASM as a file system.
• Extensive working on Oracle 10g on Solaris Zone for virtualization.
• Experience in taking logical backups of data using oracle data pump utilities like exp, imp, expdp and impdp, to move Oracle data from one server to another server.
• Experience setting up Backup strategy for Oracle DB using RMAN.
• Experience in RMAN tape backups using net backup and data protector.
• Install & Managed Physical Standby databases & Data Guard for disaster recovery.
• Logical and Physical Data modeling using Erwin Data Modeler.
• Oracle Streams configuration and performance tuning using Oracle 10g.
• Migration of databases from Lower Version (8i) to Higher Version (9i, 10g and 11g).
• Migration of SQL Server database to Oracle database
• Experienced in Automatic workload repository (AWR) to collect memory statistics, automatic database diagnostic monitor (ADDM) to monitors and analyzes statistics and Active Session History (ASH) reports.
• Involved in Performance tuning, database monitoring activities using STATSPACK with Perfstat User.
• Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace of Multi Terabyte Database.
• Applied DST Patches and Security Patches for production and development databases.
• Experience in Tablespaces management both locally (LMT) and dictionary managed tablespaces (DMT).
• Experience in writing scripts Proactive Monitoring like monitoring the disk usage and the memory usage of the server and monitoring Tablespaces.
• Used various packages extensively like DBMS JOB, UTL FILE, DBMS STATS, and DBMS SQL, DBMS REORG, DBMS SCHEDULER.
• Worked on PL/SQL for implementing Triggers, Procedures and cursors.
• Extensively used tools like SQL*Loader, Toad, SQL developer, Oracle Enterprise Manager (OEM) using DBConsole.
• Experience in creating Materialized Views specifically for Replication.
• Experience in Extracting, Transforming and Loading (ETL) tool.
• Writing ETL scripts for loading and unloading data for Dataware house environment.
• Experience in working with Data Mart using SQL LOADER with direct or parallel option.
• Worked both as a development and Production Support DBA and having experience in full life cycle of database administration.
• Database Administrator (Oracle 8i/9i/10g) of the database size varying from Medium to Large (300 GB to 10 TB).
• As a production DBA, troubleshooter and resolved several types of production issues during the off hours and over the weekends by 24x7.

TECHNICAL SKILLS

Database Skills: Oracle 8i/9i/10g,11g SQL, PL/SQL

Operating Systems: UNIX(Sun Solaris 8/9/10,Sparc - AIX4.3), Red Hat/Fedora Linux, HPUX-11.23,Tru64 Windows NT/ 2000/2003/2008

Applications Tool: SQL Navigator PL/SQL Developer 7.0, SQL *PLUS Oracle Enterprise Manager (OEM) Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump) Quest Toad 8.5, 11.0, PUTTY, Reflection, BMC, Oracle BI Publisher, Oracle BI Discoverer, WinRunner, Silk VERITAS Netback up 5.3/6.0, Netapp Filer Erwin 4.1, Rose 7.0, Hummingbird, Golden Gate Technology, Tivoli

Protocols: FTP, SSH, Telnet, TCP/IP,VNC Viewer

Languages: UNIX Shell Scripting, SQL, PL/SQL, C++, COBOL, PHP, Perl

PROFESSIONAL EXPERIENCE

Confidential, Davis, CA

Oracle DBA

Responsibilities:

• Managed Physical Standby databases and Data Guard for disaster recovery.
• Maintain database security and access permissions working with end users (technical and non-technical) in defining requirements
• Involved in designing and creating database objects.
• Up gradation from 10g to 11g database for using Oracle 11g new features.
• Created Partitions on large tables for easier manageability.
• Tested and implemented many backup and recovery scenarios on test environment (9i) using RMAN.
• Configuration and installation of 11g RAC databases in dedicated server mode using ASM.
• Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.
• Used Oracle GoldenGate to replicate between source and target Oracle databases
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
• Installing and configuring Recovery Manager (RMAN).
• UNIX Shell scripting in ksh.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc. kept in CRONJOB.
• UNIX shell scripting in ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
• Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD.
• Automatic workload repository (AWR) to collect memory statistics and automatic database diagnostic monitor (ADDM) to monitor and analyze statistics.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure. developing financial and business unit reports required in a manufacturing environment
• Create and modify scripts used in daily batch jobs
• Perform and test routine database backup and restore using HP-UX Ignite
• MS Excel including Pivot Table development, complex formulas, and macros write and create reports from database queries against Oracle and MS SQL databases
• Create and maintain relevant technical documentation

Environment: HP-UX, Windows 7, Visibility ERP, TOAD, OEM, Oracle 9i/10g/11g, PHP, RMAN, Data Guard, Goldengate, EXCEL 2007, 2010, IQPLUS, SQL 2008 Reports.

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Configuration and installation 3 Node RAC on Oracle 10gR2 databases in dedicated server mode using ASM on Sun Solaris OS.
• Configure Physical standby Dataguard using Oracle 10g for Disaster Recovery.
• Working on Oracle 10g on Solaris zones.
• Install and configure Oracle 10g Grid for the monitoring of RAC databases.
• Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using RMAN.
• Configure Incremental and full Backup on Oracle 10 and 11g Databases.
• Experience working in Oracle Application Server using oracle 10g (10.1.3.3) and oracle 11i.
• Implementing High Availability using Oracle Fail Safe Software.
• Duplicate and refresh Oracle DB from Production to QA and DEV boxes for testing purposes.
• Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup and Migrate databases at hardware level.
• Hardware Migration from Sun Sparc to Sun Solaris x-86.
• Migration of databases from Single Instance to Oracle 10g 3 Node RAC.
• Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK,AWR, ADDM, ASH reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
• Sql tuning of Multi Terabyte Databases for improving the application performance.
• Upgrade Oracle binaries in the development environment and production environment.
• Participated in data modeling review for designing object relational database.
• Experience implementing Streams on Oracle 10g server.
• Implemented Oracle Downstream capture using Oracle 10g for capturing redo log at target Database.
• Experience in working OLAP systems for data warehousing using Partitioning.
• Experience working with different types of Partitioning methods.
• Experience working with Extracting, Transforming and Loading (ETL) tool using the use of flat files with Sql Loader utility.
• Experience in working with Data Mart using SQL LOADER with direct or parallel option.
• Partitioning of big tables in Oracle Database to improve the Performance.
• Write monitoring/health check scripts to database for alert team of database uptime/downtime status, sizing issues with help of grid controlling.
• Design databases, Tables, Views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• TAR/SR Management with Oracle when we had very critical issue with the oracle Database.
• Extensive use of flat files with Sql Loader utility.

Environment: Sun Solaris 5.10, TOAD, OEM, Oracle 10g/11g.

Confidential, Foster City, CA

Oracle DBA

Responsibilities:

• Configuration and installation of 10gR2 RAC databases using OCFS as a file system using Linux OS.
• Configure Physical standby Dataguard in oracle 10g for high availability.
• Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using Netapp filer.
• Responsible for scheduling full and incremental backups using Netapp filer.
• Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup.
• Refresh the database using hot, cold backups and Transport Tablespaces.
• Experience working with new feature of Oracle 10g called Database replay.
• Using Database Replay from production system to test system for recreating the production workload environment.
• Maintaining Oracle initializing parameters like (SGA, PGA, SGA MAX SIZE) for the Performance tuning of Database.
• Sql tuning of Multi Terabyte Databases for improving the application performance.
• Up gradation from 9i to 10g database for using Oracle 10g new features.
• Used Oracle SQL Developer to migrate a SQL Server database to Oracle database
• Logical and Physical Data modeling using Rational Rose Data Modeler.
• Participated in data modeling review for designing object relational database.
• Implemented Oracle Downstream capture using Oracle 10g for capturing redo log at target Database.
• Experience in working OLAP systems for data warehousing using Partitioning.
• Experience working with different types of Partitioning methods.
• Experience working with Extracting, Transforming and Loading (ETL) tool.
• Extensive use of OEM using DBConsole for monitoring purposes.
• Write monitoring/health check scripts to database for alert team of database uptime/downtime status, sizing issues with help of grid controlling.
• Worked on Oracle Enterprise Single Sign on using Oracle Application Server.
• Extensive use of Data Links for accessing tables remotely from another schema.

Environment: Linux, Sun Solaris, Windows 2003, Net app filer, TOAD, OEM, Oracle 9i/10g, WINSCP, Rose 7.0.

Confidential, Brisbane, CA

Oracle DBA

Responsibilities:

• Install & Managed Physical Standby databases & Data Guard for disaster recovery.
• Configuration and installation of 10gR2 RAC databases in dedicated server mode using ASM.
• Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using RMAN tool.
• Maintenance and troubleshooting of Oracle network files like listener, tnsnames.ora.
• Responsible for scheduling full and incremental backups using export, RMAN.
• Migration from lower Oracle Version to Higher Oracle Versions e.g. 9i to 10g and 11g database.
• Upgraded Oracle binaries in the development environment and production environment from 10gR2 to 11G (11.1.0.7).
• Logical and Physical Data modeling using Erwin data model.
• Participated in data modeling review for designing object relational database.
• Install Oracle Downstream Capture at high volume OLTP environment.
• Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor
• Performance tuning of SQL queries in oracle 9i, 10g and 11g environment for Multi Terabyte Databases.
• Configured and implemented using 10g new feature BFT (Big File Tablespace) for storing large objects.
• Creating and Managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, database.
• Experience in working high transacted OLAP systems for data warehousing.
• Experience in working with Data warehouse environment using ETL solution, OLAP and data mining capabilities.
• Experience in working with flat files using SQL LOADER with direct or parallel option.
• Troubleshooting various Database Features like Mean time to recovery (MTTR), Flashback Query, LogMiner, Replication to keep database as available as possible.
• Extensive use of Oracle BI Discoverer and BI Publisher for generating reports.
• Using the DB Artesian /10g Grid, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.

Environment: Oracle 9i/10g, 11i, Sun Solaris 5.8, TRU 64, HP-UX, SQL Navigator, Toad, RMAN, Net Backup, DB Artesian, ERWIN.

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Managed Physical Standby databases and Data Guard (9i) for disaster recovery.
• Successfully implemented Physical standby database using Oracle Data Guard feature for High availability configuration.
• Experience working with third party tool Cluster Ware tool VERITAS for High Availability.
• Implementing High Availability using Oracle Fail Safe Software.
• Experience Upgradation of Oracle database from 9.2.0.5 to 10gR2.
• Involved in upgrading application database from Oracle8i to Oracle9i/10g.
• Performed logical backup using export and import utilities.
• Design and implement database backup and recovery procedures (RMAN).
• Designing the Oracle backup strategy, scheduling and implementing database backup.
• Load data from flat files into Oracle using SQL*Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Experience Working with Physical and logical Data modeling for developing application which is used for business purposes.
• SQL query optimizing using CBO, overhead, bind variable, explain plan, TKPROF, Utlbstat/ Utlestat, Statspack and instance, latch contentions as per company’s requirement for high tuning.
• Refreshing indexes and materialized views using data warehouse for consistency of data.
• Worked on PL/SQL Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
• Experience in using packages like DBMS SECHDULER for scheduling tasks.
• Working on an Indexing Strategy to create various types of Indexes rebuilding them and monitoring those indexes for better performance of SQL quires.
• Created/Alter Partitioned tables for large customer related data.
• Used DBMS STATS to gather the statistics along with analyze command.

Environment: Oracle 10g/9i, SQL Navigator, TRU 64, Toad 4.5, SQL*Loader, Windows 2003, Linux, Sun Solaris5.9

Confidential, Okemos, MI

Oracle Developer

Responsibilities:

• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers
• Developed Database triggers and PL/SQL Procedures.
• Generated various reports using Crystal Reports
• Created tables and indexes by analyzing and rebuilding of Indexes for better performance.
• Developed the databases, Tables, Views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• Experience in using Oracle supplied packages such as DBMS STATS, DBMS JOBS, DBMS SYSTEM and DBMS DDL.
• Extensive use of Oracle BI Discoverer and BI Publisher for generating reports.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Used PL-SQL features like Cursors, Ref Cursors, Exception handling records
• Rewrote many ORACLE stored procedures, resulting in a performance increase.
• Data Loading from Flat files using SQL*Loader.

Environment: Windows 2000, Oracle 8i (8.1.5.0 - 8.1.5.1 ), SQL, PL/SQL, PHP, TOAD 6.5, OEM, Developer 2000, SQL *Report, Form Builder6i, SQL*Loader, WinRunner