SUMMARY

• Over 7+ years of hands on experience on Oracle (8i/9i/10g/11g) database administration, schema implementation, tuning, backup, recovery, cloning and performance monitoring.
• Experienced in maintaining large Production, UAT, QA, SIT and DEV environments.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Planned and Implemented DR & High Availability oracle solutions using Data Guard, Streams.
• Proficieny using Flash - Back Recovery, Automatic Storage Manager(ASM) & Automatic Database Diagnostic Manager(ADDM).
• Tuned the database Confidential various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Have working knowledge on data replication using SHAREPLEX.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts, Autosys.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Designed and developed PL/SQL scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Worked extensively on Oracle Version Upgradation, Migrations and Patching.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Used Repository manager to build Repository and managed Very Large Scale Databases (VLSD).
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica, Dataflux, Data Stage.
• Assisted in designing conceptual, Logical and physical data models using Erwin, Pl/Sql Programming, and Shell Scripts.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call support production database support.

TECHNICAL SKILLS

Database: Oracle 7x, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, SQL Server, MySQL, Oracle Rac (9i & 10g).

Technologies and Tools: Oracle 9i Application Server, Oracle Enterprise Manager Grid Control, Export, Import, Data Pump, RMAN, SQL Loader, Log Miner, ERwin 4 Data Modeler, PL/SQL, DB Solo 3.0, Spotlight, Win SCP, Putty.

Operating Systems: UNIX, Linux, Sun Solaris 5.6/5.8/5.9, AIX 4.3.x, HP-UX10.x/11x,Tru64Unix,WindowsNT/95/98/2000/XP/2003

Utilities: SQL*Plus, SQL * Net, SQL * Loader, PL/SQL, Import/Export, Stored Procedures, Triggers, UNIX Shell Scripting, Oracle Enterprise Manager, SQL-Navigator, Imp/Exp Data Pump, TKPROF, STATSPACK, DBMS SCHEDULER, DBMS Pipe, Toad, SQL Developer

Scheduler: Cron Job Scheduler, Autosys

Recovery tools: HP-Data protector

Remote Software: VNC Viewer, Remote Desktop, VPN, Citrix Remote Access

Networking: TCP, IP Addressing and sub netting, static and dynamic routing, switching.

PROFESSIONAL EXPEREINCE

Confidential, NJ

Senior Oracle DBA

Responsibilities

• Monitoring and supporting more than 60 databases and SME(subject matter expert) for 10 applications ( four P1 applications).
• Supported Major application CMDB(Configuration Management Data Base).
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Experience with streams in enqueuing and dequiuing messages.Starting and stoping streams processes.
• Perform troubleshooting of streams environment.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Confidential, Hopewell, NJ

Senior Oracle DBA

Responsibilities:

• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.
• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL, HORIZONTAL SCALING.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents,Logminer, Segment Advisor, Database Monitor, Server Stat’s, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Database servers using DataStage, Oracle Streams/CDC, SQL*Loader, MS SQL Log shipping and DTS packages.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Installed and Configured Oracle 10g databases on Linux.
• Performed automated backups and scheduling using Perl scripting.
• Upgraded Oracle databases from 9i to 10g.
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid Control.
• Performed necessary aggregation. In dealing with a different set of problems with sharding

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, PL/SQL, Oracle 9i/10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN, IBM DataStage,C++, Weblogic, SQL Server 2005.

Confidential, Middletown, NJ

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle server software 9.2.0.1 and10.1.0.2 on UNIX and LINUX platforms.
• Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
• plemented the specs functionality by developing complex PL/SQL code like functions, procedures and packages.
• utomated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database. Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Implemented OEM for Database.
• Adjusted data models when necessary under direction of data architects.
• Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Implemented replication using shareplex.
• Implemented and maintained Database security. Created / Altered / Dropped Users as and when required and administer their respective quotas.
• Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable tablespaces.
• Created Database Links and Snapshots (Materialized views) using OEM and manually.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN & STATSPACK, ACTIVE CLSTERING.
• Knowledge in Data warehousing and implementation and supported as Oracle Database administrator Datawarehouse projects.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.
• Implemented changes to the init parameters as per the requirements. Part of on-call team and provided 24/7 support.

Environment: Oracle 9i/10g, UNIX, LINUX, Windows 2003 server, SQL server, Shell Scripting, PL/SQL, RAC, OEM, QUEST tools, Erwin, SQL*Loader, Toad, SQL*Plus, Data Mover, Object Security, Import Manager, Oracle Configuration Assistant, PeopleSoft, Oracle Data guard, Oracle Universal Installer.

Confidential, Ann Arbor, MI

Oracle DBA

Responsibilities:

• Installation of Oracle 9i and creation of database.
• Performed regular Backups and Recovery as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Performed Partial, Complete and Metadata Exports & Imports.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Responsible for Oracle 9i logical and physical databases design, implementation and maintenance.
• Created Tables with appropriate Tablespace and Index.
• Created Users, Roles and Schemas with suitable Permissions.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Maintained Logs/Backups using Imp/Exp Utilities.
• Coordinated with Unix Administrators for Space Management on various servers &help in Oracle.
• Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
• Database monitoring for Deadlocked process.
• Installation and configuration of Statspack and analysis of Statspack.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Implementation and supported as Oracle Database administrator Datawarehouse projects.
• Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
• Created Users and Roles with appropriate Privileges.
• Created Materialized views and database links.
• Wrote shell scripts for monitoring the database.
• Designed logical and physical Data Models using ERWIN.

Environment: Oracle 9i, AIX 5, Sun OS 5.6, Exp/Imp, ERWIN 4.14, SQL Developer, OEM, SQL*LOADER, Cute FTP

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Performed Database upgrade of Oracle 9i from existing oracle 8i system.
• Involved in analysis of market risk and claims data.
• Performing backups and recoveries using RMAN/conventional hot backups.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.
• Worked closely with senior DBA to understand the business and technical requirements.
• Developed entity relationship, data flow and functional diagrams.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization, and Rollback.
• Developed oracle forms and reports using oracle designer 2000.
• Involved in all phases of the software development life cycle.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Involved in documenting the entire system architecture and data flow
• Maintained control files, log file, data files, table spaces and rollback segments.
• Developed stored procedures and functions using PL/SQL for complex updates.
• Designed Entity-Relationship model and normalized database.

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