|
|
|
|
| Desired Industry: Information Technology |
SpiderID: 5450 |
| Desired Job Location: Houston, Texas |
Date Posted: 2/17/2006 |
| Type of Position: Full-Time Permanent |
Availability Date: one week |
| Desired Wage: 95,000 |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: Yes, Less Than 25% |
| Highest Degree Attained: Bachelors |
Willing to Relocate: No |
Objective:
I am a senior DBA who was recently working for Delinea Corp. in Houston and doing all the usual DBA duties including T-SQL scripting, mentoring other DBAs and SQL programmers. I have considerable experience in requirements analysis via customer interviews and also requirements documents. I have many years experience in data modeling. I have been responsible for data server high performance and high availability for mission-critical, MS SQL Server database systems.
Please consider that I have experience with all three of the major RDBMS, but most extensively with the MS SQL Server, and with directing and mentoring other data workers. As the principle data architect for a large E-Commerce web site, I modeled their data access requirements and security requirements. I designed the database, both logical and physical. Then I completed the database installation, writing all SQL to support the ASP. I have designed and completed the IT portions of several Disaster Recovery systems that vary from the simple to the complex.
Please read my resume.
Thank you,
Warren N Light
warren@wnlight.com
Experience:
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.
Professional Experience
Delinea, Inc., Houston, TX For Merrill Lynch Commodities 2/1/2005-8/31/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/1/2000-2/1/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.
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
Skills:
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
Reference:
Professional references are available upon request.
Candidate Contact Information:
This candidate has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|