Profile:
A versatile technical leader with over 25 years of IT experience spanning a variety of industries (Retail, Healthcare, Finance, Defense, Small and Large Businesses). Team player with leadership qualities.
Strong sense of responsibility and self-motivation. Highly skilled in solving complex problems.

Summary of Achievements:

• Database Expert for over 25 years (Oracle (20 years), Netezza (5 years), Informix (6 years))
• Unix/Linux/Windows System/Application Administration on a variety of platforms
• Managed 7x24 multiterabyte databases and systems for 2000+ users in multiple industries
• Designed Data Warehouses, Datamarts, Automated System Alerts, Pharmacy and ILSA systems
• Received “Whatever it Takes” Award - MedE America, SunStar Award - SunAmerica Financial, “Standing O” Awards, Guitar Center

OS:

• Unix/Linux (Red Hat 3.4 – 5.3 AS, several others, AIX 5.3, Sun Solaris 8/9/10, HP/UX 11.x, Sequent, MAC/OS X , SCO), Windows (2000/03/05/08 AS; XP/7)

Databases:

• Oracle 11.2.0.3 RAC/10.2.0.5/9.2.0.8/8.x/7.x/6.x, Netezza 3.0.2 – 6.0.3, PostgreSQL 7.4.5, Essbase 7.1.5 - 9, SQL Server 2000/2005/2008, Informix

Hardware:

• AIX, Dell, HP DL380/580, Sun, Unisys, MAC, Sequent

Storage:

• EMC Symmetrix/Clarion, NetApp, IBM SAN, Veritas NetBackup/Backup Exec, Hitachi, Data Domain

Tools:

• Database - Oracle (OEM 9i/10g/11gR2 RAC/Clusterware, OEM/Grid Control / Management Packs, PL/SQL, ASM, AWR, ASO, Data Guard, Streams, RMAN, Database Vault, Wallet Manager, TDE, Oracle Standby Database, Exp/Imp/DataPump, SQL Loader, Statspack, tkprof), Quest Central (Toad, LiveReorg, Spotlight for Oracle, SharePlex), Embarcadero DBArtisan, Netezza (Observation Deck, AQT, Aginity); mySQL (Workbench); Sql Server (Management Studio, Sql Sentry, PowerShell, DTS, SSRS, SSIS)
• Case: ER/Win; 4GL/ETL/Shell (Ksh/Bash, Apache Tomcat, Genio, Mercator, Holos)
• Administrative (MS 2010 Word/Excel/Powerpoint/Project)

Experience:

Confidential, Westlake Village, CA 
Sr. Database Architect (Oracle, Netezza, Essbase, mySQL) Aug 2005 - Current

• Oracle (65%)
• Provide top tier 24x7 support for over 25 different applications that run on Oracle databases for Musicians’ Friend and Guitar Center, elaborated upon below:
• E-Commerce (SRS, ATG) (Solaris 9/10, RHEL 5 ; 8i/9i/10g/11gR2 RAC, Hitachi, EMC SAN ~4Tb)
• Inherited an unstable database system (with a Development system running on 9i, a QA system on 10g and a production system on 8i) with no DBA’s or documentation provided.
• Standardized systems to 10.2.0.4
• Conformed to all relevant PCI DSS rules
• Resolved all stability and performance issues
• Migrated to ATG in 2010-11
• Quantum Retail (RHEL 4/5 ; 10gR2/11gR2 RAC, NetApp NAS,EMC SAN ~2Tb)
• The corporations’ first large-scale linux-based system
• Despite using spare parts and limited resources, I was able to show the business how linux is a very reliable, inexpensive option worth consideration.
• Five years after implementing this system, it is now one of the most widely used and trusted systems for determined product mix at the various store types. Switching to Quantum’s adaptive replenishment process and operating on linux saved the company over $2 million.
• Now more than 50% of new distributed systems/VM’s corporate-wide are running on linux.
• Peoplesoft (AIX 5.3 ; 10gR2, IBM SAN ~1Tb), 7 environments
• Implemented Database Vault, an Oracle tool that prevents DBA’s from access to sensitive data. Oracle used us as a reference for other customers on this product.
• Conducted annual SOX audits, performed multiple upgrades and system migrations.
• Implemented password profiles and other security measures as required by SOX.
• Grid Control Repository (RHEL 4 ; 11gR2, EMC SAN)
• Designed systems in accordance with PCI DSS 2.0
• Built 10.2.0.4 Grid on an 11.2.0.1 database with OMS on separate server
• Deployed Diagnostics, Tuning, Provisioning and Configuration management packs; automated several tasks including patching and automated response to certain errors
• Arthur suite (4 applications AIX 5.3 ; Oracle 8i/9iR2, IBM SAN ~1Tb)
• SME on all technical matters; Retail applications for replenishment and analytics
• A ‘catch-all’ system consisting of over 10 distinct applications (Solaris 9, 9i, Hitachi SAN ~8Tb)
• Inherited a system where multiple olap and oltp applications were built on one instance. Users started using system again after they had lost confidence in the data and performance.
• Distribution Center (RHEL 4 / 10gR2 RAC ~0.5Tb)
• A highly visible system used by over 500 users concurrently at a distribution center.
• Made significant performance improvements by locking statistics on certain objects, changing memory configurations and cleaning up system operations, enabling the distribution center to increase capacity during peak to levels previously not attainable.
• Built and maintained several others such as Microstrategy (RHEL 4 ; 10gR2/11gR2 RAC, EMC SAN), B2B, XBR, CDI, ER/Win, Opsware, htmldb, 401k (RHEL 4 ; 9iR2/10gR2, EMC SAN)
• Development, QA and Production for all of the above environments.
• Netezza (30%)
• Designed and implemented all corporate-wide implementations of Netezza, IBM DataStage and Microstrategy systems to support Enterprise Data Warehousing initiatives, supporting a team of 50 ETL/BI developers, 40 Business Analysts and 300 BI users.
• Performed initial setup of all Netezza environments for development/qa/production, integrating Microstrategy, DataStage, odbc and Er/Win tools.
• Designed user access security for development team and service accounts issuing jobs via remote shell.
• Created technical standards (naming conventions, coding best practices, documentation) to support over 90 databases.
• Technical Project Manager and Lead on project migrating from 3 Mustang systems (v4.6.2) to 2 Twin Fin (v6.0.3) systems, including:
• Migrated over 30Tb of data from 108 SPU systems to 48/96 SPU systems.
• Migration path for ETL and BI systems, odbc drivers etc
• Technical lead on all testing/troubleshooting
• Led meetings between ETL, BI, Unix, Storage, Network teams
• Coordinate decommission of old servers including media sanitization
• Provided 7x24x365 operational support for all Netezza-related incidents.
• Performance tuning (query decomposition, how to apply statistics, Netezza-specific concepts (such as use of CTAS in favor of updates, view creation best practices, co-located joins etc), distribution key optimization, process and data skew, load concurrency, proactive disk speed analysis.
• Built a trigger-based incremental backup/restore strategy where a set of production databases (over 2Tb in size) is updated within minutes of ETL job completion to qa environment.
• Designed method to collect event rule alerts and send them to Nimsoft using snmp traps.
• Trained ETL and Microstategy developers on how to operate within Netezza best practices
• Essbase (<< 5%)
• Served as SME for all technical issues for Finance team
• Created Disaster Recovery process and documentation and tested backups annually.
• Redesigned cube build process and tuned long-running jobs.
• Migrated systems from Windows to Linux, resulting in a significant reliability improvement.
• Upgraded systems from version 7.1.5 to 9
• Built scripts to automate backups, other functions
• mySQL (<< 5%)
• Supported 5 applications running mySQL 4.3 and 5.0 on Linux and Windows systems
• Recovered corrupted databases and automated performance management
• Master/Slave replication; backup/restore, storage/memory tuning

Confidential, Westlake Village, CA
Manager of Database Administration, Shared Services Aug 2005 – Mar 2011

• Performed functions of database and application administrator on over 10 applications for my first 2 years with the organization.
• Assumed responsibility for Musicians’ Friend database systems in 2007, which more than doubled the number of systems supported and the team was expanded as a result.
• Built and managed team of onshore and offshore DBA’s to support corporate-wide company initiatives on over 30 distinct applications on 300+ databases.
• Managed operation, administration and development for all Oracle, SQL Server, Netezza, Essbase, mySQL and Pervasive SQL databases for the enterprise.
• Management all logistics and technical details surrounding the migration of over 50 servers from Westlake Village to a new NOC.
• Maintained all Oracle, Sql Server, ER/Win, Essbase, Toad, AQT, several application software licenses
• Migrated over 20 databases from single instances to RAC systems, saving the company about 600k per year in database licensing costs.
• SDLC
• Created best practices, operational and procedural documentation for multiple applications.
• Documented all changes following corporate standards and raised topics in biweekly change management meetings.
• Built numerous Unix, Linux and Windows-based systems using SOX and PCI best practices and standards.
• PCI and SOX compliance
• Discovered group using telnet and ftp and had that changed immediately to ssh/scp.
• Designed and implemented disaster recovery strategies for multiple applications.
• Ensured no stored passwords were present on scripts, hidden files using tools such as Database Vault (Oracle) and nzpassword encryption (Netezza).
• Established, documented and enforced standards in accordance with SOX and PCI DSS 2.0.
• POC
• Built a Test Lab with coordinated efforts from other Shared Services team members, where Grid Control and a major POS migration project were tested.

Sr. Database Administrator/Manager Aug 2004 – Aug 2005
Confidential, Westlake Village, CA

• Database Administrator/Manager (Oracle 10.1.0.4/9.2.0.6 on Red Hat 3.4 AS)
• Perform all 10g and 9i installations, upgrades, performance tuning, sql/plsql tuning, data load automation, disaster recovery and backup and recovery for OLTP and Data Warehouse applications
• Converted system from Oracle 9.2.0.4 on RedHat Linux 9 to Postgres 7.4.5 on MAC OS/X
• Linux Systems Administrator (Red Hat 3 ES on Dell 2850)
• Performed Red Hat 3.4 ES upgrades and kernel tuning for Oracle applications on 15+ servers
• Mentored others with using Linux, vi, bash shell, and basic shell scripting
• Established and maintained security standards for all of the company’s Red Hat servers
• Application Administrator/Build Engineer (JBoss, Tomcat, Weblogic)
• Built several application servers with JBoss 4, Tomcat, Weblogic, Ant, JDK 1.5
• Deployed production code builds into Tomcat, JBoss and Weblogic
• Assist application team in diagnosing and resolving bugs
• Served as focal point joining engineering and product management teams
• Provided 7x24 front line support for all OLTP and Data Warehouse applications

Sr. Database Administrator - Core Services 1999 - 2004
Confidential, Woodland Hills, CA
Reporting to the CTO, served as Lead DBA and/or Manager of Development/QA/Stage/Production environments for each of the applications listed:

• SAP/SAP BW (Solaris 9, Oracle 9.2.0.4, SAP Enterprise Edition, 2.8Tb on EMC Symmetrix, Veritas, 2000+ users)
• Upgrades, performance tuning, disk reorganizations (Quest LiveReorg) and all other DBA duties.
• Provided CPU and disk expansion estimates to allow for addition of American General to SunAmerica\'s SAP system (1Tb per year growth) while maintaining good end user response times.
• Enterprise Data Warehouse (Solaris 8, Oracle 9.2.0.4, 1Tb, Cognos 7, 1500+ users)
• Designed and implemented a strategy to automate data loads which enabled 1000s of users to access data a full day sooner. Reduced technical staffing needs for EDW data loading and validation using daemons and filtering data at OS level.
• Managed team of developers and DBAs on Data Warehouse scope enhancements.
• Imaging System (Solaris 8, Oracle 9.2.0.4, 600Gb, 1000+ users)
• Managed a team of developers for application enhancements.
• Upgraded from 7.3.3 to 9.2.0.4, changed EMC disk striping methodology and created automated alerts for this and each of the other applications with cron, shell scripts, SMTP to CA/TNG.
• Policy Administration (Windows 2000 AS/Red Hat 3.0 AS, Oracle 8.1.7.4.12, OFS 3.3.2, 900Gb EMC, 1000+ users, 100+ databases)
• Led a major initiative to convert the company\'s core business from mainframe to Oracle including DBA tasks setup and tuning with 7x24 support for Dev/QA/Stage/Production.
• Managed 4 offshore and in-house development teams on various phases of the conversion, including interviewing over 300 DBAs and Developers, hiring and firing.
• POC on RHEL 3.0 AS, Oracle 9i RAC on Dell 6650\'s and NetApp vs EMC Clarion.
• Online trading system (Solaris 8/Windows 2000 AS, Oracle 9.2.0.4, OFS 3.3.2, EMC, 2000 users)
• Provided knowledge transfer from Development team for move of New York branch.
• Upgraded from 7.3.3 to 9.2.0.4 and migrated the application from Solaris to Windows 2000.
• 401K Administration (Solaris 8, Oracle 9.2.0.4, 100Gb, 100 users), Call Center (Windows 2000 AS, Oracle 8.1.7.4, 50Gb, 200 users), OEM and RMAN Repositories
• Performed Disaster Recovery planning and testing on each of the above applications.

Sr. Database Administrator

1998 - 1999

Confidential, Santa Monica, CA

• DBA: Managed 3 Oracle 7.3.4 instances, performance tuning and monitoring, upgrades and migrations (Sybase to Oracle), schema design, backup and recovery, capacity planning, RCS code control, SQL/PL/SQL coding/tuning. Served as liaison between systems and application teams. Designed a series of Datamarts, including ER diagrams, system requirements, data collection requirements and project planning.
• Unix System Administrator: Performed crash recovery, printer and modem setups (Sun Solaris, HP-UX), software and hardware installations, performance troubleshooting.

Database/ Unix Systems Administrator

1995 - 1998

Confidential, Burbank, CA

• Database Administrator: Designed an Oracle-based Data Warehouse for pharmacy systems. ER modeling, database backup and recovery, tuning, capacity planning, SQL, PL/SQL coding/tuning.
• Systems Administrator: Upgraded layered Products, third Party Software and Operating system on Sun and Sequent servers. Performed system monitoring, tuning and file system management.
• Data Integration Specialist: Designed and implemented strategy to automate processing of over 70 Data Maps of various sources with TSI Mercator and shell scripts. Served as mentor and key link to Data and Application Teams. Maintained DSS programs and trained end users in Holos 4GL Client/Server applications. Installed software and tested TCP/IP connectivity at Hospital sites.

Programmer Analyst/DBA

1993 – 1995

Confidential, Westlake Village, CA

• Project Manager: Programmed, tested and implemented the company’s primary product. Served as liaison between clients and internal staff for product enhancements.
• Programmer/Analyst: Performed customizations and maintenance programming using SQL. 4GL and shell scripts on SCO UNIX/Oracle 7.3.4.

Computer Consultant

1991 - 1993

Confidential, Burbank, CA

• Provided database programming, analysis and disaster recovery planning for Informix RDBMS.

Logistics Engineer

1984 - 1990

Confidential, Agoura Hills, CA

• Database/Systems Administrator: Administered databases and UNIX systems for USMC ILSA contracts on SCO/Informix.

Education:

• BS Mathematical Physics
• Netezza Database Administration
• Oracle 11gR2 RAC, 10g Admin Workshop II, 9i DBA, 8i Backup and Recovery, 8i/9i Performance Tuning, 8i PL/SQL, Oracle 1997-2011
• Sequent: SA II, ptx/SVM Administration