SUMMARY

• Consolidated 7+ years experience in Oracle DBA and Oracle Application DBA.
• Oracle database and applications 11i Expertise with Solaris, HP, AIX, Linux and Windows platforms.
• Extensive experience in SQL tuning and database troubleshooting.
• Configure the all instances on Foglight Monitoring tool for the performance review.
• Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Thorough knowledge of ORACLE 7.x / 8.0 / 8.1.5 / 8.1.6/ 8.1.7/ 9 i, 9iAS, RAC, SQL Server 6.5/7/2000, SAS 6.12/8.2, Server Administration, system study, analysis, design, development, testing and implementation with expertise in online transaction processing and multi - user systems involving large and distributed databases.
• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• Creating and configuring Development, Test and Production Database Servers.
• Capacity Planning, Re-allocation and proactive approach in Monitoring Databases. Extensive experience with Oracle tools like Server Manager, Export/Import and RMAN.
• Experience in Oracle Enterprise Manager (OEM) and DBA Studio. Installation and configuration of OEM 2.2 server and client
• Cloning Databases on both Unix/NT boxes.
• Data Conversion and Data Migration using SQL*Loader, Export & Import Utilities, PL*SQL Built-ins (UTL File) and scripts.
• Planning and implementation of Backups used physical (Hot & Cold) and logical backups using Export/Import RMAN utility.
• High availability environments with Updatable and MultiMaster replication setups
• Log Miner, locally managed Table spaces, Transport Table spaces, and Partitioning of tables
• On-call 24x7 production support.
• Writing Shell Scripts and Perl Scripts for the tasks automation.
• Performed Performance Tuning of Database Application, System Global Area, I/O, Rollback segments using different tools like Toad, Explain Plan, Utlbstat/Utlestat and TKProf reports.
• Experience in analytical and troubleshooting skills and problem solving.
• Proficient in Unix Administration part pertaining to DBA i.e. User maintenance, Performance Monitoring of CPU, Disk and Memory usage, and File system monitoring.
• Experience with tools like Enterprise Manager, the EM Diagnostics Pack, and the EM Performance Pack.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Java, C, C++, VB6.0, XML, HTML, Perl, UNIX Shell Scripting

Operating Systems: Sun Solaris 2.5.1/2.6, HP-UX 11, Windows 2000, NT, Windows 95/98, Novell NetWare 3.12 & 4.11, MS-DOS, UNIX (HP-UX, SUN Solaris)

ERP: Oracle Applications Release 11i (11.5.3, 11.5.4, 11.5.6, 11.5.7, 11.5.8, 1.5.9)

Hardware: COMPAQ PROLIANT, DIGITAL HX, LX Series, HP9000

Databases: Oracle 11g, 10g, 9i, 8i, MS Access, MS SQL Server 7.0 & 2000, DB2

Tools: Oracle Forms 9i, 6i, 6.0, 4.5, 3.0, Reports 6i, 6.0, 3.0, 2.5, Designer 9i, PL/SQL Web Toolkit, SQL*Loader, SQL*Plus, RMAN, OEM, TOAD, Grid Control, Informatica5.5, MS Office, SQL*Navigator

Data Modeling: Power Designer 7.0, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Oracle DBA

Responsibilities:

• Support, Maintenance, Installed and configured 2 node server side load balancing Oracle RAC 10g, 11g databases on Linux with ASM and Data Guard.
• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Upgraded databases from 9i to 10g, 11g and 10g to different 10g versions.
• Table created with Daily Range partition and script automated which add/remove partition as per client requirement.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Configuration and optimization of oracle 9i & Oracle 9ias (Apache HTTP Server) with oracle 9ias Portal and oracle 9ias web Cache.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Creating and Managing stored procedures and triggers, distributed data, server tuning, automation of administrative tasks, database.
• Worked on Auditing and security with Oracle databases.
• Working knowledge of DATAWAREHOUSING tools like ETL
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Flash Recovery Area.
• Created and Managed user, table spaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Worked on Clone the databases.
• Worked on oracle Public and Private Database Link.
• Applied client patches and other patches as required.

Environment: Oracle 10G, Oracle 11G, Solaris 10, Linux, RMAN, SQL, PL-SQL.

Confidential, Upper Saddle River, NJ

Sr. Oracle DBA / Application DBA

Responsibilities:

• Upgraded Oracle from 10.2.0.1 to 11.2.0.2 in development, test and production databases.
• Sizing the database as per the growth of the Siebel data and written space management scripts.
• Performed Oracle Apps upgrade from 11.5.2 to 11.5.3, 11.5.3 to 11.5.5 & 11.5.5 to 11.5.6.
• Refreshing the Test and development databases with the production data. Analyzing and rebuilding of indexes. Created Rollback segments with different storage parameters to suite for Siebel databases.
• Support, Maintenance, Installed and configured 2 node server side load balancing Oracle RAC 10g, 11g databases on Linux with ASM and Data Guard.
• Designed Backup & Recovery strategy for 24x7 Siebel applications, Written Hot & Cold Backup scripts for the Production databases. Also implemented RMAN for Siebel production and Test databases.
• Designed Backup and Recovery strategies and written unix and sql scripts to implement them.
• Loaded data from .dat files to Oracle TABLES using SQL*LOADER. Many times copied DB’s from Dev to Test, PROD to Test Using EXPORT BACKUPS.
• Wrote shell scripts in Ksh to run stored procedures and scheduled them on crontab to run daily.
• PORTLETS-Trigger-Functions-Procedures-Packages-Tables-Tablespace-Rollback-Datafiles-indexes-redo logs-system-databases creation
• Converted tablespaces to locally managed tablespaces to eliminate fragmentation, better performance and reduced maintenance.
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments
• Design, deployment, monitoring and troubleshooting of rollback segments.
• Create and Maintain databases and their objects that best fits to OLTP environment
• Applying security patches in 10g and 9i software.

Environment: Sun Server E4500, Sun Solaris 7, Windows 2000, Oracle10.2.0.1, OEM, Legato NetWorker, WebLogic WebServer, Siebel EPharma 7.0.4, Siebel Gateway (clustered) Servers, Siebel Application Servers

Confidential, Jersey City, NJ

Oracle DBA / Application DBA

Responsibilities:

• Support, Maintenance, Installed and configured 2 node server side load balancing Oracle RAC 10g, 11g databases on Linux with ASM and Data Guard.
• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Supported database platform are Solaris 10, RHEL and Window.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Upgraded databases from 9i to 10g, 11g and 10g to different 10g versions.
• Table created with Daily Range partition and script automated which add/remove partition as per client requirement.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Recovered huge Database (1 Terabyte) when UNDO tablespace got corrupted in RAC Environment.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Creating and Managing stored procedures and triggers, distributed data, database replication (Golden Gate), server tuning, automation of administrative tasks, database.
• Worked on Auditing and security with Oracle databases.
• Working knowledge of DATAWAREHOUSING tools like ETL
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Flash Recovery Area.
• Created and Managed user, table spaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Worked on Clone the databases.
• Worked on oracle Public and Private Database Link.
• Applied client patches and other patches as required.

Environment: Oracle 10G, Oracle 11G, Solaris 10, Linux, RMAN, Golden Gate, SQL, PL-SQL.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Involved in Implementation, upgrading and recovery. Implemented new instances for 3rd Party Applications and involved in performance monitoring
• Designed and implemented comprehensive disaster recovery functionality for production database environment
• Demonstrated Recovery strategies under different failure conditions
• User Interface & Prepared User Requirements Specification (URS)
• Database design and Database administration

Environment: Sun Enterprise Server E4500, E6500, Sun Solaris 2.6, Erwin3.5, SQL Server, Oracle 8.0.5, Server Manager, OEM, Oracle 8.i, OAS, Perl, Pro*C, PL/SQL