SUMMARY

• Over 22 years of professional IT experience as an Oracle Database Administrator and additional RDBMS experience with Microsoft SQL Server, Sybase, DB2, Vertica, PostgreSQL, EnterpriseDB and MySQL.
• Solid experience with Oracle Real Application Clusters, Active Data Guard, RMAN, Golden Gate, Streams, Exadata and expertise in Oracle installation, configuration, patching, backup and recovery, multi - tenant architecture, audit compliance and creating technical documentation.
• 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: Linux 4.x-8.x, Oracle Solaris 2.x, 5.x, AIX 5.x, 6.x, zLinux 4.x, 5.x and Microsoft Windows 2000/2003/2005/2008/2012.

RDBMS: Oracle 19c/18c/12c/11g/10g/9i/8i, SQL Server 2008/2005/2000 , Sybase 15.x/12.x and DB2 8.x, MySQL v5.x, PostgreSQL 8.x-9.x, EnterpriseDB 9.x, Exadata, Teradata and Vertica.

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, Ruby and some Perl.

SOFTWARE/APPLICATIONS/TOOLS: Chef, Git, Oracle Enterprise Manager, Oracle Grid/Database Control, SQL*Plus, Data Pump Export/Import, Export/Import, SQL*Loader, Oracle Recovery Manager, ADDM, AWR, ASH, Statspack, Explain Plan, TKPROF, Oracle Golden Gate, Oracle Streams, Nagios, Toad, DB Artisan, Spotlight, SQL Tuning, Toad Data Modeler, MobaXTerm, iTerm2, PuTTY, WinSCP, Exceed, SCCS, Clearcase, 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, Burlington, MA

Senior Oracle Database Engineer / Automation

Responsibilities:

• Deploy Infrastructure as a Service for repeatable processes which reduced rework and human error
• Consistent evolution of automation process to deploy infrastructure adding functionality and repeatability
• Support for internal group (Level 3 Engineering)
• Support for Database Operations Team while on Automation Team
• Part of on-call rotation for Database Operations Team
• Create documentation for the Database Operations Team in these areas:
• Transparent Data Encryption
• Oracle Enterprise Manager Cluster, ASM, listener and database registration
• Oracle Real Application Cluster Physical Standby Database registration
• OCI Classic database build process

Environment: Linux, Microsoft Windows

Confidential, Waltham, MA

Database Consultant

Responsibilities:

• Migration of legacy applications into Exadata environment
• Creation of database template for automated database deployment using Oracle Grid Control
• Documentation of Golden Gate in bi-directional, one-way and synchronous instantiation configurations
• Documentation of creating Active Data Guard instance using Oracle Grid Control
• Execute data migrations from legacy to Exadata using Oracle utilities
• Recommend code changes for developers to align with Exadata environment
• Enforce standards in Exadata environment to comply with Financial Regulatory requirements
• Full understanding of complex Exadata environment
• Understanding of Golden Gate architecture in the Exadata environment
• Understanding of Active Data Guard architecture in the Exadata environment

Environment: Linux, Solaris, AIX, 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 and Oracle Utilities

Confidential - Watertown, MA

Senior Production Oracle Engineer

Responsibilities:

• Support for all Oracle databases in all phases of development lifecycle
• Support for four-way replication using Active Data Guard
• Ongoing Oracle license evaluation reported monthly
• Evaluation of backup solution using RMAN
• Available for 7x24 on-call support in two-person rotation
• Evaluation of database parameter settings to measure performance
• Created automated database tasks to alleviate alerting disk space issues
• Performed tuning for application teams for poorly performing SQL statements

Environment: Linux, Microsoft Windows, Oracle Data Guard, Nagios

Confidential - Waltham, MA

Senior Oracle Database Administrator

Responsibilities:

• Implementation of Oracle Virtual Directory to authenticate database users using Microsoft Active Directory credentials
• Installed and configured Oracle WebLogic for database connectivity using Oracle Virtual Directory and Microsoft Active Directory
• Performed an evaluation of the database environment and provided recommendations to enhance Oracle performance
• Performed upgrades from Oracle 10g to 11g
• Created database maintenance scripts to alleviate space issues
• Created database design proposal to consolidate large sets of historical data into one centralized database utilizing Oracle Real Application Cluster instances with High-Availability
• Analyzed and optimized SQL for performance with unique application batch processing
• Negotiated all Oracle annual contracts for renewal and managed license compliance

Environment: Linux, Oracle Data Guard

Confidential - Boston, MA

Senior Oracle Database Administrator / Microsoft SQL Server Database Administrator

Responsibilities:

• 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 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.