Professional Summary:

Over 14 years of professional IT experience as an Oracle Database Administrator and experience with Microsoft SQL Server, Sybase and DB2. Solid experience with Oracle Real Application Clusters, Data Guard, RMAN, Golden Gate, Streams, Exadata and expertise in Oracle installation, configuration, patching, backup and recovery, cloning, audit compliance and creating technical documentation.

Core Competencies:

• Solid hands-on experience with Oracle Real Application Clusters, Data Guard, Golden Gate and Streams
• Working experience with large-scale mission critical OLTP and OLAP systems
• Working experience with Oracle Exadata
• Ability to work independently, manage multiple projects and handle a large volume of work
• Expertise in upgrading, migrating, applying PSU/CPU patch sets and one-offs to Oracle databases
• Proficient in database performance tuning using ADDM, AWR, ASH and explain plans
• Working knowledge of RMAN and logical backups using Data Pump and conventional export utilities
• Expertise in Oracle schema and user management
• Developed corporate-wide database technology standards for State Street Oracle Team
• Experience in all phases of the Software Development Life Cycle
• Excellent interpersonal communication skills
• Excellent documentation skills

Technical Skills:

OPERATING SYSTEMS:

Oracle Solaris 2.x, 5.x, Linux 2.x-5,x, AIX 5.x, 6.x, zLinux 4.x, 5.x and Microsoft Windows 2000/2003/2005/2008.

RDBMS:

Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000, Sybase 15.x, 12.x and DB2 8.x.

SQL, PL/SQL, UNIX Shell Scripting and some Perl.

SOFTWARE/APPLICATIONS/TOOLS:

Oracle Grid/Database Control, SQL*Plus, Data Pump Export/Import, Export/Import, SQL*Loader, ADDM, AWR, ASH, Statspack, Explain Plan, TKPROF, Oracle Enterprise Manager, Oracle Golden Gate, Oracle Streams, Toad, DB Artisan, Spotlight, SQL Tuning, Toad Data Modeler, PuTTY, WinSCP, Exceed, SCCS, Clear case, Tivoli Storage Manager, Autosys, Symantec i3, Symantec Veritas Volume Replicator, Symantec Veritas Cluster Services, Symantec Veritas Global Cluster Option, Microsoft Word, Excel and PowerPoint

Professional Experience:

Confidential,Westwood/Boston, MA Mar 07 present
Role: Senior Oracle DBA / Microsoft SQL Server DBA

• Member of the Engineering Team which automated the process of creating a new instance down from 2 days to 30 minutes. This resulted in a streamlined repeatable process which increased DBA productivity.
• 24/7 Production Support for 1750+ Oracle instances and 450+ Microsoft SQL Server databases on a rotating schedule
• Participated on a project to migrate a 17TB data warehouse to Exadata from 5-Node Oracle RAC Cluster. Performed migration to Exadata Machine in two days. This was essential to make a buy/no-buy decision due in sixty days.
• Active member of five Virtual Teams: Engineering, Exadata, Performance & Tuning, Oracle 11g and Security Teams
• Created technical documentation for the Global Database Teams: Troubleshooting Oracle Streams, Add Node Procedure for Oracle RAC, FAQs on the Clone Process, How to Build a Clone File, Clone Test Scenarios, Performance and Tuning Template for Applications, Database Upgrade/Patch Planning Template and PSU Patch documentation.
• Published Standard Operating Procedure (SOPs) documents for Oracle Real Application Clusters and Data Guard to perform switchover/switchback
• Performed Add-Node procedure on a 5-Node RAC Cluster to add two additional nodes
• Performed the role of SharePoint Administrator for the Global Database Team
• On a Project to perform hardware lifecycle migration from EMC to XIV storage with zero downtime to a Production 5-Node Oracle Real Application Cluster. This allowed room for growth not available with EMC storage
• Primary DBA for a large financial data warehouse running Oracle 10g Real Application Cluster with Data Guard
• Responsible for a Record Keeping System running 111 Oracle instances, 11 RAC Clusters on 10g using Data Guard, Oracle Streams, and Oracle Golden Gate
• Responsible for the planning and coordination of upgrades and patching for 140+ databases annually
• Responsible for the planning and coordination of Federal Inter-Agency Disaster Recovery Exercises on an annual basis
• Responsible for database security with schemas and user account management
• Responsible for inserting, updating, creating and removing of all database maintenance jobs, troubleshooting job failures, file system and data file space management, availability and accessibility database issues on a daily basis.

Environment: Linux, Solaris, AIX, zLinux, Windows 2000-2008, Oracle 9i/10gR2/11gR2, Oracle Exadata, Oracle Streams, Oracle Golden Gate, Data Guard with Physical Standby, (OEM) Grid Control, SQL*Plus, PL/SQL, SQL*Loader, Oracle Utilities and Toad.

Confidential,Waltham, MA Aug 06 - Mar 07
Role: Senior Oracle DBA / Microsoft SQL Server DBA / Sybase DBA

• Performed Oracle installations, patching and upgrades on 9i and 10g databases
• 24/7 Production on-call support for Oracle, SQL Server and Sybase databases
• Provide project support for Oracle and SQL Server databases
• Setup/Configure/Install Oracle Enterprise Manager for all Oracle instances
• Provide mentorship on Oracle to other DBAs
• Created technical documentation on Oracle topics such as Oracle patching, installation and upgrading
• Performed daily maintenance tasks on SQL Server databases using DTS packages
• Troubleshoot performance issues on SQL Server databases
• Provide project DBA support on Oracle, SQL Server and Sybase databases
• Provide enhancements to the existing shell scripts for Oracle

Environment: HP-UX, AIX, Windows 2000-2003, Oracle 9i/10gR2,(OEM) Grid Control, SQL*Plus, SQL*Loader and Toad.

Confidential,Framingham, MA Jun 2003 Aug 2006
Role: Microsoft SQL Server / DB2 / Senior Oracle DBA

• I started as a Microsoft SQL Server DBA supporting 600+ databases. I moved to the DB2 Team to support an 8TB data warehouse and for the migration of the Staples.com website to DB2. Lastly, I moved to the Oracle Team to help with the large number of existing applications and take on all new Oracle projects to help ease the workload of the current Oracle team members
• Handled a large volume of work across multiple database disciplines. (Oracle, SQL Server & DB2)
• Participated in On-Call scheduled rotation for Oracle, SQL Server and DB2
• Performed database recovery in annual DR Tests Project Lead for Disaster Recovery exercise on a rotating basis
• Responsible for all facets of database support working with applications to resolve code issues affecting database performance. This included analysis of packages, procedures, functions and triggers and some PL/SQL code.
• Responsible for annual patching of all supported databases, using project plans to plan the patches and database upgrades with rollback plans.

Environment: HP-UX, Solaris, AIX, Oracle 8i/9i/10gR2, SQL*Plus, SQL*Loader, Toad, SQL Tuning Space Manager and Spotlight.

Confidential,Boston, MA Jun 99 Aug 03
Role: Sybase / Oracle DBA

Responsibilities:

• I was a Sybase DBA for the Investment and Pensions sector then added the role of Oracle DBA. I eventually moved to a centralized Oracle DBA Team and supported a wide variety of sectors
• Monitored the growth of the database objects and acquired space as needed
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure availability
• Performed SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints
• Refresh schemas using Export and Import into other environments for testing purposes
• Managed schema and database users per application with privileges, object DDL and DML

Environment: Solaris, AIX, Oracle 7/8i/9i/10gR2, SQL*Plus, PL/SQL, SQL*Loader, Oracle Utilities, DB Artisan and Toad.