EXPERIENCE SUMMARY:

• Confidential is a Senior DBA and has 40 years of experience in the information technology consulting industry, most recently as DBA for the Confidential.
• He has held a variety of senior - level DBA positions where he has helped both government and private sector organization realize efficiencies and enhancement effectiveness through the implementation of intelligent technology solutions.
• He has extensive experience in developing and managing complex operational computer implementations with a specialization in database design, performance, and production operations support.
• He has repeatedly provided expert consulting to solve difficult and elusive performance issues on large, multi-platform computing systems architected on AIX, HP-UX, Solaris, z/OS, and Microsoft Windows using DB2, Oracle, SQL Server, MySQL, PostgreSQL, MongoDB,NoSQL and Sybase.
• Data Modeling using all major methodologies
• Proponent of Service Oriented Architecture (SOA)
• Familiar with Oracle’s JDeveloper UML
• Author of SQL scripts to generate Data Definition Language (DDL) for IBM DB2 and Microsoft SQL Server from an Oracle Designer repository
• Designed and implemented applications including Financial, Manufacturing, Insurance, Healthcare, and Embedded
• Expert in all phases of the Microsoft SQL Server 2000 based application development and deployment, including client server and Service Oriented Architecture.
• Expert in all phases of the Oracle 9i Developers Suite (9.0.2), including Oracle Forms and Reports
• Expert in all components of Microsoft Office 2000 Professional and Microsoft Office XP, including WORD, EXCEL, ACCESS, and VISIO
• Expert in Assembly to PHP (e.g. Participant in PERL/DBI developers group)
• Keyword list: ASSEMBLY, COBOL, FORTRAN, C, C++, Java, PERL, PYTHON, PHP, PL1, SQL, ASP, VBScript, JScript, JavaScript, XML, HTML5, DHTML
• OracleLinux, Solaris, HPUX, AIX, Microsoft, IBM including AS400 z/OS, VMS, MCP, NETWARE, CPM (e.g. July, 2001 performed kernel level tuning of Solaris to support a terra-byte database at the SUN Performance Benchmark Center.
• March, 2002 member of benchmark team implementing standalone PERL as a Windows XP Service
• May, 2004 author of production system resource utilization trace facility scripts for a Windows2000 Advanced Server, Windows2003 Enterprise Edition, SQL Server2000 environment with less than 5% overhead
• Installation and configuration of PC operating systems including Windows NT, Microsoft Windows 2000 Professional, Microsoft Windows XP, Microsoft Server 2008
• Daily use of Microsoft Visual Studio 6, Microsoft Visual Source Safe (VSS), Microsoft Front Page 2000, Internet Information Service (IIS) v5.0, and Microsoft Data Access Components (MDAC) v2.8
• 20% complete in process of migrating to Microsoft Visual Studio .NET, .NET Framework 1.1, and Internet Information Service (IIS) v6.0
• Use SUN J2SDK1.4.2 to support development and deployment of Electronic Data Interchange (EDI)
• Use of Eclipse and Jbuilder as Java Integrated Development Environments (IDE)
• Use of Eclipse IBM Data Studio
• Familiar with Tivoli, Openview, Netview, Solstice, and Unicenter network management tools. (e.g. Participant in the OpenSource Netsaint monitor project.)
• Familiar with System/Operations Management tools such as Microsoft Operations Manager (MOM), Systems Management Server (SMS), Dell OpenManage including Altiris's management suite
• Familiar with all major protocols including TCP/IP and SDLC. (e.g. Author of DECNET/SNA driver for IBM PC)
• Expert in configuring CISCO PIX515 FireWall
• Installed and configured servers from IBM (360,RS6000), HP (D100, HP1000-9000), SUN (Ultra 5-E10000), DEC (PDP, VAX, Micro VAX), BUROUGHS (Small, Medium, Large), and all PC vendors from Morrow to Compaq
• Designed and manufactured the first multi-protocol communications board for the IBM Micro-Channel

SKILLS:

Oracle (5,6,7,8,9,10,11,12); Microsoft SQL Server (6,7,2000, 2005,2008,2012,2014); Sybase (9,10,11); IBM DB2 z\OS,LUW (5,6,7,8,9); Filemaker (4,5,7); MySQL; PostgreSQL

NETWORK (all major flavors of the CODASYL model)

HIERARCHICAL (IMS, C-TREE)

DBASE (all versions) / Paradox (4-9)

HADOOP (0.18.0-0.23.7 )

NoSQL (Mainly Oracle)

MongoDB (1.4-2.4.0)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA, SQL Server DBA

Responsibilities:

• Perform maintenance and performance tuning of Oracle databases
• Perform maintenance and performance tuning of DB2 databases
• Perform maintenance and performance tuning of SQL Server databases
• Interface of Oracle Business Intelligence Suite with Microsoft SharePoint environment
• Perform maintenance and performance tuning of Oracle databases
• Perform maintenance and performance tuning of DB2 databases
• Perform maintenance and performance tuning of SQL Server databases

Confidential

Oracle DBA, SQL Server DBA, and DB2 DBA

Responsibilities:

• Upgraded Information Integrator from Rel 9.5 to Rel 9.7.4
• Upgraded four (4) Oracle Databases from 9i, 10g to Rel 11g
• Upgraded CA GEN from 7.6 to 8.0
• Set up Data Propagator
• Set up Information Integrator
• Performed performance tuning of Oracle databases
• Performed performance tuning of DB2 databases
• Performed performance tuning of SQL Server databases
• Software / hardware used in engagement: Microsoft Windows Server 2003, Oracle 9i, 10g, 11g/ DELL PE6800; Microsoft Windows Server 2008, SQL Server 2008/ DELL PE6800, z/OS 1.10, DB2 9.1/IBM

Confidential

Database Administration Lead

Responsibilities:

• Responsible for managing the SACWIS database architecture and schema to automate all aspects of child welfare in the State of Oregon.
• System included real time links to DB2 and Sybase legacy databases, a data warehouse to support reporting and business intelligence, a complete batch financial sub-system, and conversion of 27 years of historical data.
• Oversaw the planning and design of the logical and physical databases, and determined the content, internal structure, sizing, indexing, and maintainability of the database, as well as engineering the access strategy, security protocols, and database optimization.
• Led the development, testing, and production of the database and the database architecture, and ensured that the database environment remained working at all times.
• Collaborated with the State technical team to validate that the database design supported the SACWIS application and was compliant with all agreed-upon standards.
• Followed all procedures for changes and upgrades to the database, made sure database backup and recovery occurred, and resolved any identified performance issues.

Database Administration Lead

Confidential

Responsibilities:

• Oversaw the planning and design of the logical and physical databases, and determined the content, internal structure, sizing, indexing, and maintainability of the database.
• Engineered the access strategy, security protocols, and database optimization.
• Led the development, testing, and production of the database and the database architecture, and ensured that the database environment remained operational as required.
• Collaborated with the State technical team to validate that the database design supported the SACWIS application and was compliant with all agreed-upon standards.
• Software / hardware used in engagement: Windows Server 2003, SQL Server 2008/ HP-DL380; DB2, Sybase

Database Administration Manager

Confidential

Responsibilities:

• This business intelligence solution uses the Business Objects analytic and reporting platform, the Oracle relational database platform (Release 10gR2), and is hosted on Sun enterprise services under the UNIX (Solaris 10) operating system.
• The solution supports approximately 3,000 State staff in their daily operational and analytic reporting activities.
• Responsible for all facets of the relational database management system (RDBMS) implementation; which included integration of Oracle tool sets including Oracle Enterprise Manager (OEM), Oracle Recovery Manager (RMAN), Oracle Data Guard, and Oracle Data Pump.
• Role also required oversight, installation, and configuration of the physical hardware to achieve project goals.
• Software / hardware used in engagement: Solaris, Oracle 10GR2/SUN

Confidential

Chief Technology Officer / Database Administrator

Responsibilities:

• Managed a large DB2 UDB database implementation to support company-wide activities
• Solved major performance issues by performing benchmarking to identify database resource constraints and capacity problems
• Identified and resolved significant table schema, physical page structure, and database file configuration problems resulting in a several fold increase in production efficiency and performance
• Collected metrics and performed analysis using Performance Expert
• Responsible for all Linux, Apache, MySQL, and PHP (LAMP) configurations which included the complete company information technology infrastructure; this included updates and support for Cedertek’s client Internet Social Networking Site and updates and support for the client’s local area networks
• Software / hardware used in engagement: DB2, Linux, Apache, MySQL, and PHP (LAMP)

Confidential

Chief Information Officer (CIO)

Responsibilities:

• Maintaining the integrity of production data
• Performance monitoring
• Management of schema changes
• Capacity planning in development, staging and production environments
• Database administration including software version management
• Monitoring of data backup and restoration schedules
• Ad-hoc queries of databases and archives
• Deployment of application updates
• Interaction with application developers
• Documentation of development, staging and production systems
• Research new tools and technologies
• Experience and proficiency using the following software:
• Microsoft Windows 2000 Advanced Server (with Active Directory)
• Microsoft Windows 2003 Server Enterprise Edition (with Active Directory)
• Microsoft Windows 2000 Professional
• Microsoft Windows XP
• Microsoft Office 2000 Professional Suite
• Microsoft Office XP
• Microsoft Windows NT
• Microsoft IIS v5.0 and v6.0
• Microsoft SQL 7, SQL 2000, SQL 2005
• Microsoft Access 97, Access 2000 and Access 2003
• Microsoft Visual Studio.Net
• Microsoft Operations Manager (MOM)
• Microsoft Systems Management Server (SMS)
• Microsoft Exchange Server (including Migration Wizard)
• Daily monitor and reporting of Application, System, Security, WEB, FireWall, and SQL logs
• Developed validation scripts for over 3,000 Active Server Page (ASP) programs including Visual Basic, Java, SQLOLEDB, and HTML for our Service Oriented Architecture (SOA) implementation of an Integrated HealthCare Management System
• Authored a similarity algorithm in Microsoft T-SQL for reconciling patient name and addresses from over 100 different data sources
• Architect and modeler of an Asian Data Center for processing HealthCare claims
• Architect, programmer, implementer of 150 class, 250 XML script Electronic Data Interchange (EDI) application using Java (J2EE and running under J2RE-1.4.2).
• Architect of three of high availability cluster infrastructure installations (latest to be deployed August, 2005) including entire network, infrastructure, servers, storage, and applications.

Confidential

Senior Database Architect

Responsibilities:

• Architect for the Special Programs Accounting System (SPAS) developed entirely with Oracle/2000 tools
• Responsible for all database administration for 22 SPAS user groups across 8 geographically dispersed sites
• Managed systems engineering and other architectural issues
• Architect of an Oracle based Customer Relationship Management System (CRM) over a Distributed Wide Area Network (WAN) including Oracle Replication, Oracle Failsafe for NT Cluster, and Power Builder front end - modeling was based on Oracle Designer/2000. Networked storage utilizing EMC CLARiiON Storage Area Network (SAN)
• Developed semi-automatic database version control for regression testing in a Developer/2000 environment.
• DBA for material management logistics system database running under Oracle RDBMS 7.3.4
• Developed database version control for regression testing in a Developer/2000 environment
• Author of SQL view to interface with Business Objects Crystal Enterprise Server v9.0
• Implemented backup and recovery process using Veritas Backup Exec
• Specified and implemented both Wide Area and Local Area networking infrastructure (WAN and LAN) including database replication
• Implemented Microsoft Cluster and Failover environments for high availability. (Similar to NSI DoubleTake)

Confidential

Technology Consultant

Responsibilities:

• Implementation of large scale Relational Database Management Systems (RDBMS) for State governments (e.g. State of California Franchise Tax Board PASS project involving local and mobile connectivity for over 1000 clients)
• Consultant's consultant in resource utilization. Latest success was a 500% improvement in performance for a European telecommunications client. With two weeks effort, on-line response improved from 15 seconds to 3 seconds, batch processing was reduced from 20 hours to 4 hours
• Developed resource utilization plan for State of Kansas, involving all Server, Client, and Network component infrastructure. Senior level management presentation of current metrics with vision of future resource acquisition and configuration
• Architect of logical and physical model of terabyte database using System Architect tool and personally developed scripts for SYBASE v10. (Equivalent to Microsoft SQL 7)