SUMMARY

• 7 plus years of experience as Oracle Data Base Administrator, providing 24x7 production support of development and production 11gR2/10g/9i/8i databases on different Platform.
• Installed oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i, 9i to 10g and 10g to 11g applied oracle patches.
• Migrated single instance databases to multimode 10g, 11g R1, R2 RAC environments for high availability and load balancing.
• Installed, configured and maintained single node/multi nodes E-Business instances with RAC, ASM, Shared Application Top, Parallel Concurrent Processing.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by logical standby and physical standby databases.
• Hands on experience in Data guard, Grid control, streams, replication.
• Extensive knowledge on database backup/recovery strategy (RMAN),Import/Export & Data pump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.
• Established Disaster Recovery for Oracle 11g RAC database.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql’s for better performance.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), Crystal reports and PL/SQL Developer.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g R2.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.

TECHNICAL SKILLS

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

Data Bases: Oracle 11g,10g/9i/8.x/7.x, Oracle 10g Real Application Clusters (RAC).MS SQL Server 2000/2005/2008

Software Applications: Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, IBM RSA, Clusters, Veritas Backup, SQL Loader

Tools: SSIS, SSRS, SSAS, Informatica

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

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Involved in the installation of 10 g RAC on LINUX environment.
• Administered Oracle 11g R2/10g production, test, development environment on RHEL, IBM-AIX.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Worked on tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducted sizing & capacity planning for Oracle databases.
• Involved in Migration of Database from 9i to 10g and applying patches whenever required.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• RAC Troubleshooting.
• Worked on maintaining schemas and partitioning tables.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Created tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with precise (DB performance tuning tool)
• Generated ERD, OOM, PDM, CDM and Class Diagrams with Data modeling tools ERWIN.
• Experienced with Dataguard Implementation
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.

Environment: Oracle 10g, 11g R2 RAC, GridControl 10gR5, ASM, RHEL 4, 5, Shell Scripting.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Administration of a 3 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Creating new environments for data loading and manipulation for various states in the US, according to the specification provided by Century Link.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Involved in the documentation of every task involved in the recovery issues or backups.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Creation of various database objects including materialized views.
• Troubleshooting errors and using the expdp/impdp utiliy on a very regular basis for copying data across schemas.
• Running scripts and monitoring the load process to avoid roadblocks in ETL jobs running for a long duration.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Monitored Database growth and provide Database capacity planning for applications expansion.
• Upgraded from 9.2.0.x to 10.2.0.x.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8,9.

Confidential, TX

Oracle Database Administrator

Responsibilities:

• Provided 24X7 supports for all the production and development databases.
• Installed and configured Oracle 9i.10g
• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Applied patches using OPATCH and Patch sets using OUI
• Cloned/Refreshed Oracle Databases.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Implemented Disaster Recovery plans
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Worked on several shell scripts to maintain the database activities
• Mentoring the Database Performance using automated scripts.
• Answerable for setting and managing User Accounts, Granting required privileges to users.
• Experienced in Security Administration and Space Management
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Dataguard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.

Environment: RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, SQL, PL/SQL, UNIX scripting.

Confidential

Oracle DBA Developer

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• 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, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY

Environment: Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities

Confidential

Oracle PL/SQL developer

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Involved in designing the database, identification of the objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Created various Database triggers using PL/SQL.
• Extensively used Explicit Cursors in stored procedures.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Developed PL/SQL scripts for exception handling.