SUMMARY:

• Self - driven data modeling Engineer with a successful 7+ year track record of success in Oracle database warehousing, business intelligence, query, performance optimization and object oriented analyses.
• Proven ability to tackle and succeed in all endeavors from high-dollar business development to customized software development and implementation.
• Confident in navigating complex technical environments and possess strong PL/SQL expertise in stored procedures, performance tuning and optimization.
• Met ongoing and overlapping deadlines in fast paced environments, handled multiple assignments simultaneously and coordinated deliverables with key stakeholders in cross-functional groups.

TECHNICAL SKILLS:

Software Applications: HP-UX 11.11, Sun-Solaris 2.7/2.8/2.9, AIX 4.33/5.x/6.1/7.1, HP-UX 9.x/10.x/11.x, Linux 6.x/7.x/8.x, MS SQL Server 6.5, Microsoft Visual Source Safe 6.0, Win NT, Win 2008, Win XP Pro.

Oracle Utilities: Oracle Enterprise Manager (OEM), RMAN, TOAD,Data Guard Oracle, Data pump, Oracle Streams, SQL*Loader, SQL*Plus, Matlab V7.0.1, Orcad 15.7, Samsim router, MySQL 5.7

Networking: Design, implement, manage and troubleshoot Computer Networks using Microsoft Products such as Microsoft Windows XP and in knowledge of Ethernet.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Sr. Oracle DBA

Responsibilities:

• Installed and configure oracle 12c, 11g databases on Linux, AIX 6.1/7.1 and Solaris based servers and applied 11.1.0.7 patch set respectively on Test and Production environment, also applied Quarterly Patches and supported prod and Non Prod Databases.
• Upgrade existing 11.2.0.5databases to latest 12.1.1
• Performed upgrades on Exploris databases and MySQL
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Experience in setting up & configuring enterprise Informatica Implementation with Powercenter 9.X (9.4 and further preferable) on Solaris and Oracle 11g and greater.
• Enhanced skills in metalink, downloading and applying Patches.
• Supported production environments and users on a daily basis by responding to emergency requests implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.
• Exposure to Informatica, ETL tools and Code analytical tools is plus.
• Responsible for Developing, documenting, and implementing security configuration for Oracle software and database instances to comply with existing standards.
• Provided full Setup of OEM ( Oracle Enterprise Manager ) 12C to capture Database Alerts and Page DBA's and production support
• Administered standard database query language capabilities for selected systems and users using MySQL
• Expertise and leadership to resolve complex Informatica infrastructure issues.
• Set up user profiles and roles as per the access level of user for the data and application security.
• Set up Data Guard and Standby Databases on AIX, Linux, Sun Solaris and HP UX servers
• Strong skills in performance tuning with STATSPACK/AWR for database objects and components, Shared pool, Buffer cache, Redo logs, disk utilization and Sort operation, SQL tuning and use of Oracle Expert, SQL Trace with tkprof, Explain Plan, Analyze and dbms stats.
• Configuration and Setup of various MySQL performance monitoring tools like Nagios and MySQL enterprise Monitor for monitoring MySQL Servers. Configuring Perl scripts for monitoring databases and internal health.
• Created RMAN repository and taking backup of the 11g, 10g,9i databases using RMAN
• Performed Database Export/Import, Hot and Cold Backup setup and evaluated the Backup and Recovery procedures periodically
• Setup the Golden Gate Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database.
• Installed and configured Grid Control to monitor instances, patched and upgraded the Grid Control to 12.1.0.3
• Performed Database Data pump utility for import and export, Hot and Cold Backup setup and evaluated the Backup and Recovery procedures periodically
• Created Oracle Backup shell scripts for Hot backup and Cold Backup along with creation of Recovery scripts so as to restore in a very short duration of time.
• Identified row chaining and row migration and de-fragmentation of the table spaces
• Designed, Developed and implemented shell scripts for database monitoring activities
• Performed data loading using SQL*Loader to assist Data Warehouse developers
• Performed Capacity Planning and storage management
• Set up Prod/Test/Development database environment for the application system
• Scheduling Stats pack through DBMS JOB to collect snapshots at regular intervals to generate daily reports to analyze and fine tune performance overheads.
• Analyze and monitor wait events on production databases to implement improvements for buffer busy waits/sequential & scattered read contentions.
• Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.
• Tune the SGA components like buffer cache, shared pool to avoid paging & swapping hence reducing I/O bottle-necks in 9i, 10g environment.
• Performed Database Datapump utility for import and export, Hot and Cold Backup setup and evaluated the Backup and Recovery procedures periodically
• Created Oracle Backup shell scripts for Hot backup and Cold Backup along with creation of Recovery scripts so as to restore in a very short duration of time.
• Compiled, troubleshoot and maintained stored procedures.
• Performed data loading using SQL*Loader to assist Data Warehouse developers
• Developed and maintained Backup Korn shell scripting
• Performed User Schema’s and Table spaces recovery using Data pump utility
• Performed Capacity Planning and storage management
• Enhanced skills in metalink, downloading and applying Patches.
• Worked with JBDC drivers, initialized using conole (DB-Consol)
• Performed Cloning (Hot and Cold) Production Database for reporting and analysis purposes
• Set up Prod/Test/Development database environment for the application system
• Designed, Developed and implemented shell scripts for database monitoring activities
• Created tables, tablespaces, views, indexes and granted privileges on them
• Identified row chaining and row migration and de-fragmentation of the table spaces
• Converted rollback segment tablespace from Directory managed to locally managed table spaces

Confidential, Somerset, NJ

Oracle DBA, Project Lead

Responsibilities:

• Worked with software: Solaris 7, Erwin, ORACLE 10/11g.
• Installed/maintained multiple versions of Oracle (9.2, 8.1.x, 8.x) using Solaris 2.7/2.8/2.9, AIX 4.3.3/5.1/5.2 and HP-UX (11.0), Windows 2000 and NT.
• Provided full Setup of OEM ( Oracle Enterprise Manager ) 11g to capture Database Alerts and Page DBA's and Help desk support
• Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.
• Monitored database/SQL performance using TKPROF, SQL Trace and Explain plan utilities, identified performance issues and tuned application.
• Created and Managed Database Objects and Schemas
• Performed Database Export/Import, Hot and Cold Backup setup and evaluated the Backup and Recovery procedures periodically
• Set up Data Guard and Standby Databases on AIX, Linux, Sun Solaris and HP UX servers
• Used the Grid Control to monitor and manage Oracle Streams Replication which includes the availability of queue for queuing messages, Number of messages received by destination queue, messages spilled by destination queue and time it took to dequeue the messages. Put the Apply queue in order if it was broken by instantiating the Objects and removing the errors from the queue.
• Strong skills in performance tuning with STATSPACK/AWR for database objects and components, Shared pool, Buffer cache, Redo logs, disk utilization and Sort operation, SQL tuning and use of Oracle Expert, SQL Trace with tkprof, Explain Plan, Analyze and dbms stats.
• Created Oracle Backup shell scripts for Hot backup and Cold Backup along with creation of Recovery scripts so as to restore in a very short duration of time
• Rebuilt Multi-master replication and resynchronized databases when they were out of sync
• Configured Data Warehouse environments, created Materialized views, Bitmap indexes and Reverse Key indexes for optimization
• Monitored database/SQL performance using TKPROF, SQL Trace and Explain plan utilities, identified performance issues and tuned application.
• Created and Managed Database Objects and Schemas
• Performed Database Export/Import, Hot and Cold Backup setup and evaluated the Backup and Recovery procedures periodically