University of Houston, Houston Community College: 116 semester-hours, majoring in Math and Computer Science. Have not been in school since 1986.
REST1: Off and on, have been working on a control/accounting application in Java for the restaurant industry.
Jughosting.com web hosting
May, 2003-present
Linux system administration, including setting up DNS on an internet server;
setting up and maintaining Apache web server:
cpanel administration of machine and users.
HTML/CSS/PHP/Java/Python/MySQL: wrote all web pages and forms to operate the site.
Northern Telecom
11/97-9/98
Performed DBA support of Sybase 11 (on HP-UX) databases of clients around the world via modem. Did troubleshooting of database problems. DBA support of local Sybase 1 1 development databases. Advised local users on SQL, Sybase issues. Did some Unix system administration. Programmed in Korn shell, C++, Python, Unix/C/Sybase CT-Library, Bulk-Library, primarily database-related work.
Southwestern Bell Mobile systems
7/96-11/97
Performed as sole DBA for 28 databases on 7 instances of Sybase in a 3-tiered C/S application. This is run on an SP/2 (multiple RS/6000 machines), with Sybase System 10. Performed upgrade of Sybase (4.9 to 10) and application. Migrated some systems to System 11, testing application against that Sybase version. Moved data from one platform to another. Modified existing shell scripts. Bounced Sybase, application when required. Created documentation for system. Ran dbcc, analyze output. Analyzed Sybase logs. Set up machines to allow backups over network. Monitored space requirements; performed capacity planning. Handled problems as they arose. Set up PC-based tools (SQL Server Manager ). Dealt with users via phone, e-mail, in-person.
EDS
Plano, TX
5/96-7/96
Applications design for Unix/C/Oracle, mulit-tier Client/Server project.
The Hub Group
Downers Grove, IL
3/95-3/96
Using Sybase System 10 on Netware 3.12, performed as DBA in development environment. Did logical, physical database design, based on existing non-relational AS/400 database, plus interviews with managers. Started, shut down Sybase; performed backups, load of databases. Installed Sybase SQL Server, Sybase Open Client. Loaded data into Sybase with BCP. Configured, installed ODBC drivers, PC front end software. Performance Tuning via configuration, logical, physical design. Documented database design with Easy-CASE software; coded, designed MS-Windows interface with Forest and Trees. Wrote up maintenance documentation; evaluated PC front end products. Made recommendations to management on operatiing systems, development tools.
Added, deleted users. Dealt w/ Sybase tech support people. Physical/logical database design. Wrote documentation. Wrote stored procedures, triggers. Wrote programs to bring data down from AS/400 via AS/400 PC Support program. Wrote reports in SQR.
Visual C++, Visual Basic Programming. Wrote an app to send query from remote PC via networked AS/400s, pass output back. ODBC programming; forms programming.
Brought Novell server up/down. Installed printer server for AS/400 PC Support, Netware. Installed software. Administration of ODBC. Tested PC front ends such as Forest & Trees, Impromptu, etc.
Amoco
Houston, TX
12/94-3/95
Wrote reports using SQR report writer, designed screens in MS-Windows environment, using Gupta SQLBase. Documented procedures. Created, modified tables. Used SQR for reports, as well as data manipulation. Started, shut down database. Wrote macros in Word for Windows macro language (Word Basic).
Sabre Decision Technologies
Allentown, PA
11/94-12/94
Analyst position. Did Performance tuning on existing Unix/C/Sybase application. Analyzed system for performance improvements. Mapped, analyzed triggers, stored procedures for performance, contention problems between tables. Did SHOWPLANs on all triggers, stored procedures, looking for table scans, use of temp tables, index usage. Designed indexes, re-wrote triggers, made recommendations on physical database design, including normalization/denormalization, addition/deletion of indexes. Interviewed programmers, DBAs for information on system design. Performed testing of different configurations. Mapped all triggers in database for the purpose of finding contention problems.
Tenneco Gas
Houston, TX
6/94-11/94
Developed Server-side (back end) of Client/Server system (migration from mainframe) using MS-Windows, and Unix/Sybase v4.8 on Sequent machines. Primarily did Unix/C/Sybase (DB-Library) development. Wrote stored procedures; helped other project team members with Unix/C/.Sybase/SQL problems; kept all code under SCCS. Transact-SQL in stored procedures consisted of many nested selects (mostly correlated sub-queries). Tuned SQL of myself, others. Used PowerBuilder (not programming), isql (interactive or inside shell scripts) for development. Participated in daily staff meetings; used CC:mail, Lotus Notes, Ami Pro, Lotus 1/2/3 for documentation.
Southwestern Bell Telephone
Dallas, TX
10/93-6/94
Programming/analysis of existing commercial application using Sybase 4.8, System 10, DB-Library, Windows for Data forms, design package, Unix/C systems programming on Pyramid 4T platform, using X-Window (Motif) services from Sun Sparc I. Wrote reports, screens, some programmer documentation. Ported Sybase applications from v. 4.8 to 10 to different machines (HP9000, IBM RS6000); maintained SCCS files through several releases, edited make files, used sed, tar. Wrote Transact-SQL scripts; stored procedures and triggers. Did System testing of applications. Analyzed hardware (especially X terminals), fortware, software development practices of software development team Met with vendors' representatives. Analyzed issues related to platform change due later in 1994. Provided Informix support, including porting applications, life-cycle management; wrote utilities in Unix/C; configured X-terminals. Did analysis of system performance. wrote a testing utility, logging and process mapping utilities in Unix/C using pipes, signals, ioctl, fork/exec.
AT&T
Clark, NJ
8/92-1/93
Specializing in database issues, served as 1 of 2 programmers on a project, using Sybase SQL Server v. 4.8, on Sun workstations and Open Look windowing system. Modified existing C/DB-Library programs, designed and coded reports using SQR report writer, wrote make files. Made recommendations on physical logical design, Performance Tuning to project manager. Participated in group discussions on system performance and other issues with team members, customers, and other consultants. Wrote shell and Transact-SQL scripts to run procedures in batch. Did full regression testing of reports and other modules. Wrote system documentation in Word Perfect for Windows. Interfaced with customers, kept project manager apprised of progress. Performed basic system administration and Sybase DBA work: started, shut down database, Unix system, added users. Used tar to back up work. Kept all work under SCCS.
Naval Ordnance Missile Test Station
White Sands Missile Range, NM
2/88-8/92
Served as only computer specialist, working without daily supervision. Re-engineered work processes. Designed and programmed original application for Unix on a Unisys 5000 minicomputer, in C, Informix, ESQL/C, Informix-SQL, Unix shell, PERFORM screen-generator and ACE report generator. Design decisions included system analysis, Performance Tuning. Configured PCs, installed software, hardware. Served as DBA for approx. 10 databases, handling all user privileges; creating , dropping databases, tables; moved databases between machines, file systems. Helped users with Unix applications problems, terminal/printer problems, and PC software (Lotus 123, MS Excel, Windows, HG, Word Perfect, autocad, modem communications)/hardware problems. Reset Mux lines. Installed PC cards, disk drives. Discussed possible changes/new applications with end users. Advised superiors on a wide range of computer issues.
Designed, coded and tested the Station Accounting System which enables real-time queries by accounting customers, input of accounting information by accounting clerks, submission of material purchase request (simultaneously creating accounting documents, linking the customers, Accountng and supply), and entry of military/civilian labor data by the entire Station, which is put onto mag tape. Status of funds, reports show expenditures, budget balances by category for each program, simultaneously approving pending material requests. Accounting customers re-allocate funds between cost-centers via input screen. System also includes semi-annual budgeting system. Integrated the Engineering work request system in the financial database. Monitored system performance, killed processes, used tar to back up databases. Started, shut down database. Created databases, moved data between databases. Relocated databases across file systems.
Unix/C system programming included using malloc, pipe , dup, fork, exec system calls, signals, reading directories and inodes, structures, password verification, linked lists, screens in C with curses, low-level and standard I/O, and daemons.
Make, ar (libraries), SCCS lint header files, macros, conditional compilation used for maintenacnce.
Also wrote a C menu system including help documents; a database in C for official Station instructions; and database of imaged documents using linked lists and C/curses screens; personnel budgeting system in MS Excel; a daemon to allow qualified row deletion privileges to users who didn't even have any such privileges in database.