Resume of Warren Neun Light warren@wnlight.com 7818 Ensemble Dr Database Administrator Houston, TX 77040-2479 Looking For Short Term Contracts In Houston, Texas -- Semi-Retired Summary Data modeling, logical and physical database design, implementation and performance optimization. Database administration with a pro-active stance to maintain high-availability, multi-server data systems to support business continuity employing replication, clustering and other fail-over mechanisms. Databases: MS SQL Server, Sybase, Oracle OS: Win 2000, NT, Linux, UNIX, HP, Sun Languages: SQL, VBScript, Javascript, Python, PHP Techniques: ASP, stored procedures Tools: MS Enterprise Manager, Performance Monitor, SQL Trace, DBArtisan, ER/Studio, Erwin Projects Lead by Mr. Light - Conversion of eighteen MS SQL 6.5 servers to the 2000 version. Delinea/EKT, five people, six months. - Setup and purchase proper failover hardware for SQL server databases. Delinea/EKT, two people, two months. - Create and implement the IT portion of the EKT Business Continuity Plan. Delinea/EKT, three people, four months. - Design and implement a SQL log-shipping system for mission-critical warm spare SQL Servers. Delinea/EKT, myself, two months. - Investigate conversion of legacy S/W to a single-signon password. Delinea/EKT, myself, two months. - Design and create a Web-based database server status monitoring system. Delinea/EKT, three people, six months. - Setup a group of three SQL Server DBAs, including standards and procedures. Duke Energy, three people, twelve months. - Head project to convert mission-critical databases to M/S SQL server version 7.0. Duke Energy, three people, four months. - Create on-site hot backup database systems and off-site fail-over database systems (HADR). Duke Energy, three people, three months. - Implement a "Warm Backup" scenario with Sybase Replication Server. SONAT, myself, three months. - Develop a requirements matrix for portions of the FAA Advanced Automation System project. CTA, three people, 4 months. - Develop an interface in 'C' from the Object-Oriented ADA design to the SQL- driven Sybase database servers. GE Aerospace, three people, four months. - Lead S/W engineer for a classified FORTRAN/VAX system. DBA Systems, eight people, seven months. - Deputy program manager. DBA Systems, twelve people, twelve months. - Test Director for an 18 month re-engineering project. DBA Systems, five people, 18 months. Professional Experience Delinea, Inc., Houston, TX 12/2000-8/2005 For Merrill Lynch Commodities 3/2005-8/2005 Senior DBA Model data and design database for market reporting applications. Monitor and support the fifty MLCI SQL Servers during the period of transition from EKT ownership. Optimize data access for the RAFT credit risk application for performance. Assist troubleshooting the market risk and credit risk applications using MS SQL Trace and DBArtisan. Delinea, Inc., Houston, TX For Entergy-Koch Trading 12/2000-2/2005 Senior DBA Create and implement the IT portion of the EKT Business Continuity Plan. Create and execute the plan to upgrade all of the EKT MS SQL Servers from version 6.5 to version 2000. Manage the upgrade of in-house software to be compatible with SQL Server 2000. Optimize application SQL statements to match characteristics of the new SQL version by reducing the dependence on the SQL tempdb database. Identify SQL statements with poor performance using the MS Performance Monitor and SQL Trace tools. Design and implement the SQL log- shipping system for mission-critical warm spare SQL Servers to provide high- availability, and reliable business continuity. This system saves EKT thousands of licensing dollars by avoiding purchase of enterprise upgrades to use the Microsoft log-shipping software.Model data and design databases and access plans with ER/Studio and Erwin for trading applications. Support databases for market risk and credit risk applications. Assist troubleshooting application databases access. Study the use of Python as a database management tool builder. Design and create an internal DBACentral WEB application (ASP, VBScript, Javascript) to monitor the fifty EKT SQL Servers. Macro Enterprises, Inc., Houston, TX 8/1999-10/2000 Consultant Model the the data access requirements and security requirements for an Internet company offering real-time, multi-point videoconferencing services. Design the databases, logical and physical. Complete the database installation, writing all SQL to support the ASP. Write SQL stored procedures to support those Web site ASP page connections to M/S SQL 7.0 or Oracle 8.5 databases. Model and design the database for several client/server projects. Employed database based Web security methods. Duke Energy Trading & Marketing Co., Houston, TX 9/1996-6/1999 Senior Database Administrator Plan and implement Data systems for DETM's Disaster Recovery Plan, including alternate IT locations. Administer all NT-based MS SQL Servers for Duke's mission-critical trading and marketing applications. Provide technical leadership for Duke's DBAs. Head project to convert mission-critical databases to M/S SQL server version 7.0. Develop new databases to support new applications. Help select storage hardware for speed optimization. Design plan for testing hardware configurations. Model these new databases according to good standards to ensure optimal performance. Optimize existing mission-critical databases that were not built to standards. Create on-site hot backup database systems and off- site fail-over database systems. SONAT Marketing Co., SONAT Services, Houston, TX 3/1995-9/1996 Senior Database Administrator Maintain a mission-critical, Sybase System 10 database in support of gas marketing. Optimize system for performance. Provide triggers for relational data integrity. Write stored procedures for GUI applications. Develop a reliable data recovery system. Implement a "Warm Backup" scenario with Sybase Replication Server. Implement access control and auditing for enhanced security. Install a web server and created intranet (internal corporate) Web pages that are connected to a Sybase data server via the Web server. Global Marine Drilling Co., MIS, Houston, TX 7/1993-12/1994 Database Administrator Create logical and physical database designs and then implement SYBASE databases that support GUI applications for Preventive Maintenance of drilling rig machinery, Rig Location database, Materials Requisitions and Purchase supporting users world-wide over a WAN. Guide the migration of legacy data from mainframe hierarchical databases. Implemented extensive business rules via triggers and stored procedures. Tune and optimize the server, database, stored procedures and triggers for performance. Convert existing SYBASE database SCL to Sybase. Train a Global Marine employee to be an assistant DBA. Panhandle Eastern Pipeline Co., PEPL Systems, Houston, TX 1/1993-7/1993 Database Administrator Conduct requirements analysis, data modeling, and logical design of relational databases to support applications that manage energy reserves data. Complete physical design and implementation of databases with SYBASE SQL Server on an HP 9000. Evaluate and recommend the server platform. Plan and guide the migration of existing data from mainframe, hierarchical databases. Implement significant business rules using triggers. Tune and optimize database for the application. Integrate multiple databases to support periodic measurements of pipeline data, supporting users nationwide over a WAN. Train a Panhandle Eastern employee to assume DBA duties. CTA Incorporated, Pleasantville, NJ 11/1989-11/1992 Chief Engineer Write RFP documents for portions of the FAA Advanced Automation System project. Review project designs submitted by IBM Federal Sysyems. Develop a requirements matrix for portions of the FAA Advanced Automation System project. Requirements analysis, data model, and design of a relational database to support the Oceanic Development Facility System Integration Testbed at the FAA Technical Center in New Jersey. Use SYBASE RDBMS serving client applications written in C within the ULTRIX environment. GE Aerospace, Camden, NJ 7/1087-11/1989 Senior Engineer Design a distributed relational database used in a world-wide networked system and the design of real-time, memory cached databases for several performance-bound system components. Develop an interface in 'C' from the Object-Oriented ADA design to the SQL-driven Sybase database servers. Reverse engineer several surface navigation algorithms based on high frequency radio propagation theory that fix transmitter locations from direction finding data. Transfer varied databases to one, integrated, relational database for navigation algorithms. DBA Systems Incorporated, Melbourne, FL 1/1981-5/1987 Senior Engineer Lead S/W engineer for a classified FORTRAN/VAX system. Deputy program manager, to provide the technical leadership, of a contract to extend the math analysis capability of a system written in FORTRAN and install on a multi-VAX network. Manage software engineers. Extensive customer interaction. Lead Engineer in the design and implementation of applications for a classified DOD system written in FORTRAN 77 using Oracle. Test Director for an 18 month re-engineering project. EG&G, Incorporated, Las Vegas & Nuclear Test Site, NV 10/1977-1/1981 Senior Scientist Design and maintenance of nuclear test analytical SW in FORTRAN. Fermi National Accelerator Laboratory, Batavia, IL 7/1972-10/1977 Systems Analyst II Design and maintenance of control room display SW for the world's largest synchro- cyclotron in FORTRAN. Design and maintenance of process control SW for a synchro- cyclotron in assembly code. Additional employment history is available upon request. Military: U. S. Air Force Education Illinois State University, BS Degree in Mathematics, Illinois State University, Mathematics, Graduate work, University of Hawaii, Computer Science, Graduate work