Education

MS Computer Science
BS Mathematics

Professional Experience

2010 Confidential, Fort Monmouth, NJ
Senior Oracle DBA/Contractor
Senior Oracle DBA for the Army’s acquisition system. All Army organizations (330+ organizations) will be moving to a single platform, where contracts will be viewable online. All documents and images are stored within the database as LOB data.

• Configured RMAN backups on production database (changed from full daily to incremental)
• Reorganized development environment onto separate server (Sun M5000)
• Currently supporting 10 Army bases Wrote migration scripts using SQL*Loader and PL/SQL
• Consolidation of all schemas using Oracle Virtual Private database (VPD)
• Oracle list partitioning with LOB data
• Database Sizes: 1TB(QA)-10TB (Prod)

2001-2009 Confidential, Freehold, NJ
Engineering Fellow / Senior Oracle DBA
Technical Director and Senior DBA for the development of a Class 5 soft-switch. Company wide tech lead for platform migration and next generation HA replacement to Oracle RAC.

• Database Sizes: 250-500GB

Technical
Lead

• Technical lead for cross platform standardization on Oracle RAC.
• All DB teams reported directly to me
• Technical lead on choosing the next generation server platform. Provided database benchmarks comparing RHL on Sun/Intel 4250 vs. Sun “Niagara” T5220.
• Technical lead for choosing next generation storage platform. Benchmarked legacy DotHill SanNet II and Sun StorageTek 2540 iSCSI and Fibre Channel.

RAC
11.1.0.7

• Developed the next phase of our HA replacement platform, running nine node Oracle RAC, connected to dual Qlogic Sanbox, on Oracle 11.1.0.7/Solaris 10 using RAW devices
• Replaced Veritas functionality with native Solaris utilities, such as DMP (MPXIO), IP Multi-pathing and local disk mirroring using Sun SVM

RDBMS
9.2.0.6 11.1.0.7

• Modeled all business requirements (Logical/Physical) in Erwin/ERX
• Maintained physical and logical models of the database. All entities in logical model normalized to 3rd normal form.
• Physical model de-normalized to match business rules and performance criteria
• Wrote all database infrastructure scripts and files (tablespaces, init.ora, tnsnames, listener) and all schema scripts (tables, partitions, indexes, RI constraints, etc…) Used Erwin’s DB compare to validate installation scripts
• Tuned all running queries via AWR and TKPROF, development queries via explain plan. Provided the development team with CGI based explain plan tool
• Wrote provisioning tool (used at all customer sites, used in trials and customer demos) to provision data. Screens were dynamically generated via information in the Oracle catalog. Written in KSH, C++, javascript via Apache CGI
• Re-wrote security procedures leveraging Oracle’s built in MD5 hash function (Oracle Crypto)
• Wrote insert/update triggers and stored procedures in support of replication.
• Researched, Designed and implemented cross platform solution leveraging the power of TimesTen (Cache Connect to Oracle).

HA

• Developed from the ground up our HA solution, using Veritas VxVM/VCS (5.0)
• Wrote all OS installation/upgrade scripts, including Symantec (VCS and VxVM) installations, Oracle ( RDBMS, Clusterware, RAC ), RAID array volume creation (Sun and DotHill)

Backup
and DR

• Implemented Oracle’s Master/Master symmetric replication
• Wrote Logminer based replication, to replace Oracle’s Master/Master replication, which outperformed Oracle Streams with a sustained throughput of 500tps (avg record length 100 chars), compared to Oracle Streams at 100tps
• Wrote wrapper scripts around imp/exp and impdb /expdp

2009-2010 Confidential, Middletown, NJ

• Creator and developer of a video hosting site, written in C++ and MySQL. Meta data is stored in the database, while video content (converted to Flash Video) is stored on disk.
• Database Sizes: +50GB
• Installed MySQL on Linux (RHL and Fedora)
• Designed database objects in Erwin/ERX following standard rules of data normalization.
• Created all scripts to create database “on the fly”, including all tables, primary keys, RI constraints
• Uses the innodb engine for transactional integrity (used in conjunction with “start transaction”)
• Ran all SQL through “explain” utility to determine access path
• Run analyze command on all tables to gather statistics
• Core code written in c++, maintenance scripts written in bash.

1999- 2001 Confidential, Lakewood, NJ
Senior Oracle DBA / Manager

• Managed a group of five(5) database administrators, in conjunction with the following projects:
• Database Sizes: 500GB 1.2 Terrabytes

Sun E6500
Oracle 8.1.5

• Specified and ordered all hardware for new OLTP system, including the clustered environment, storage (IBM 7133), and installed software.
• Configured clustered environment using Veritas VCS, with Oracle (8.1.5) and NetBackup plug-ins.
• Installed all network cards (QFE), I/O cards (JNI), unipacks (for the OS).
• Wrote Oracle backup scripts to use in conjunction with Quad Mirroring.
• Configured all Volumes for the new tablespace layouts.
• Wrote all migration scripts, in conjunction with SharePlex to migrate database to new layout (included all changed security, ownership of schema’s, sys grants and objects grants, etc.)

Sun E4500

• Designed a data warehouse (1.2 Terrabytes on RAW), to move all ad-hoc queries and reports off the production OLTP database. Since Oracle replication did not work from version 8.1.5 to 7.3.4, wrote a hybrid replication scheme using Oracle Snapshot replication, and a replication program written in proc*C++.
• Installed Solaris, Volume Manager and Oracle on all database servers.
• Installed and configured SharePlex on all database servers.

Sun E3000

• Audited OLTP database for all performance bottlenecks (including low level I/O conflicts - vxstat, shared pool utilization v$sqlarea , swap space usage , swap -l, table scanning, row chaining “analyze chained rows” , etc..).
• Implemented profile limits to reduce the impact of run-away queries.
• Migrated in place, part of the database from Quick I/O to RAW volumes (which included allocating the volumes, assigning mirrors, etc..) NOTE: Quick I/O was causing system to panic and throughput comparisons couldn’t compare to RAW.

1993-1999 Confidential, Lincroft, NJ
DBA Distinguished Member of Technical Staff

• Consolidated multiple sids running on one server, into one database SID.
• Migrated database from SparcCenter 2000 to 6way Uitra 6000, at the same time migrating database from v. 7.2.3 to 7.3.4.
• Wrote all migration scripts for database migration, and completed migration within a 4 hour window (using single tasking export/ import The single tasking export/import utility needs to be generated via the make utility and isn’t the same as the regular export utility)
• Implemented MTS (only for customer service), due to a rise in the number of customer service agents accessing the system. De-activated MTS when customer service database migrated to a transaction monitor (Cheetah).
• Implemented snapshot replication for provisioning systems..
• Implemented roles and profiles on production system.
• Created multiple test databases, Q/A databases, etc.
• Conducted classes for development group on benefits of running queries using an “explain plan”, and other database techniques (ie. normalization of data).

1990-1993 Confidential, New York, NY

Project Manager DBA

• Supported 26 DB2/VM database, 3 DB2/MVS application and 2 Oracle applications running on Sun Solaris and IBM AIX.
• Extensively involved in database modeling using LogicWorks and Erwin. This involved data normalization / de-normalization, supporting the logical and physical model.
• Extensive documentation of database objects (table definitions, column definitions, using 3rd party data dictionary warehouse.
• Wrote database-monitoring tool in visual basic to monitor application specific events (ie. Lock contention and then tracing back rogue SQL)

1987-1990 Confidential, NewYork, NY
Systems Administrator

• System administrator on VM/CMS supporting a user base of 500.
• Installed all OS Patches, and database patches for DB2/VM aka SQL/DS)
• Configured / allocated storage for database.
• Involved in all aspects of system administration on an IBM Mainframe running VM/CMS.