Resume of Warren Neun Light

Looking For Short Term Contracts In Houston, Texas -- Semi-Retired

Professional Experience

• Delinea, Inc., Houston, TX 10/2000-8/2005
  

  Senior Database Administrator for Merrill Lynch Commodities
  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, SQL, for the RAFT credit risk application for performance. Assist troubleshooting the market risk and credit risk applications using MS SQL Trace and DBArtisan. .

Senior Database Administrator for Entergy Koch Trading
Model data and design databases and access plans with ER/Studio and Erwin for trading applications. 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 to support the power trading, market risk management, and other applications. 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 upon 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.

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
  Senior Database Administrator
  

  Model data and access plans and design database for several E-commerce sites. Write SQL stored procedures to support the site ASP page connections to MS SQL Server 7.0 or Oracle 8.5 databases. Model and design the database for several client/server projects. Employ database based Web security methods. Design and implement clustered MS SQL Server 7.0 databases. Write resource scheduling software in SQL for an Internet company to offer real-time, multi-point videoconferencing services.

• Duke Energy Trading & Marketing Co., Houston, TX 9/1996-6/1999
  Consultant - Senior Database Administrator
  

  Plan and implement Data systems for DETM's Disaster Recovery Plan, including alternate IT locations. Administer of all NT-based M/S 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. Explore new technologies. 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
  Consultant - 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. Incorporate use of stored procedures by AM GUI application. 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
  Consultant - Database Administrator
  
  Create logical and physical designs, 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. Implement extensive business rules via triggers and stored procedures. Tune and optimize the server, database, stored procedures and triggers for performance. Convert existing database to Sybase. Train a Global Marine employee to be an assistant DBA.

• Panhandle Eastern Pipeline Co., PEPL Systems, Houston, TX 1/1993-7/1993
  Consultant - Database Administrator
  

  Conduct requirements analysis, data modeling, and logical design of relational databases to support applications managing energy reserves data. Complete physical design and implementation of databases with SYBASE SQL Server on an HP 9000. Evaluate and recommende the server platform. Plann and guide the migration of existing data from mainframe, hierarchical databases. Implemente significant business rules using triggers. Tune and optimize for the application. Integrate a database to support periodic measurements of pipeline data, supporting users nationwide over a WAN. Train a Panhandle Eastern employee to assume DBA duties.

Additional employment history is available upon request.

Education

• Illinois State University, BS Degree in Mathematics
• Illinois State University, Mathematics, Graduate work
• University of Hawaii, Computer Science, Graduate work