Randall J. Burns
5622 Skamania Mines Road
Washougal, WA 98671
rburns@andrew.cmu.edu http://www.outlander.com
360-835-0559
Expert Database Administrator (DBA)
and Software Developer
with extensive experience using SQL, Perl,
HTML,C and Python on Unix and NT. Have managed databases and developed
applications with a very high degree of complexity, high data throughput and
large data volume. Able to design, create and modify database schemas, build
logical and physical databases. Over ten years experience writing, supporting
and optimizing stored procedures. Familiar with fundamentals of System
Administration, Networking and Security.
Have worked successfully in environments where it was necessary to use
multiple languages and learn new languages quickly. Familiar with a variety of project roles including Project Lead,
Quality Assurance/Testing, Product Support, Documentation, Software Development, Database/System Administration. Basic
knowledge of modeling methodologies and formal software development processes.
Languages
Strongest languages
include SQL (familiar with several dialects)
and Perl. Have used Python, ASP, JavaScript
and HTML for small projects recently (have
basic familiarity with style sheets, rollovers, field validation, use of
cookies). Have done substantial product development in
C. Supported development effort using Java,
XML, XSL that required ability to test, modify and document code.
Supported or used in
past projects: Lisp, Cobol, M1,S1,
PL/M, Pascal, Objective C, Power Builder, Fortran, C++
Academic Exposure: Recent coursework using Java 2.0 EE, Forth,
Mozart-Oz ,Prolog, Modula-2, Smalltalk, C#.
Operating Systems: Sun OS, Solaris, Windows NT 4.0,
Linux, HP/UX,
AIX, Pyramid(DC/OSx). Windows 3.x.,
NextStep. Comfortable working in mixed NT/Unix environments.
Development Tools: PHP, Dreamweaver,
Flash, CVS, Microsoft Front Page, ASP,PythonCard,
CVS, WinCVS, Bugzilla, ERwin, Crystal Reports, Rational Rose, Magic, EasyER, CGI, DBI, Apache, Xalan, Xerces, Cocoon,
Jserv, Visual Studio for .Net, Komodo, Next Interface Builder, DTS,
Purify, Jboss, Eclipse, Zed-Eves, Microsoft Project.
Databases: Microsoft SQL Server(6.5/7.0/2000), Sybase, Oracle,
MySQL, Informix, Versant, Postgresql, LDAP,
Verity.
Network Protocols:
TCP/IP, SNA, Microsoft Networking.
Administrative
Tools: Versant, HP OpenVue, IBM Smit, Informatica.
Sybase Products: Open Client (CT-LIB, DB-LIB), Open
Server, Replication Server, SQR, SQL Monitor.
Modeling/Development Methodologies: Z, CSP, UML, Schlaer-Mellor,
IDEF, CMM, RUP
June 2003-Present,
Webmaster/DBA, Tacoma Public Schools
via Tek Systems, Tacoma, WA.
Administered web server and several databases servers.
Established database administration procedures and web development procedures
for team of less experienced developers. Work required knowledge of ASP, VB
Script, Microsoft SQL Server 2000, JavaScript and HTML. Administered CVS
repository. Developed several Python scripts for administrative work. Created
Python Application using PythonCard and WxPython that allowed browser users to
easily switch between test, production and development environments to
facilitate movement of software through development cycle.
August 2001- Present,
Consultant, BadgeCam Systems, Ltd. via Aardeus, Inc., Toronto, ON.
Developed specifications, requirements and marketing
literature for Badge Camera. Work
included creation of Software Project Management Plan and capacity planning for image database to support embedded systems
product and DSP software development. Designed authentication and security
strategies. Designed and implemented demonstration programs using Perl,
DBI, HTML, SQL and Javascript portable
between Linux/Postgresql and Windows 2000/SQL Server 2000. Created embedded
data compression software in C and assisted development of special-purpose
codec.
April 2001-August 2001,
July-August 2002 Consultant, Technical Pursuit, Inc. via Aardeus,
Inc., Cupertino, CA.
Supported
development of TIBET Javascript applications framework. Duties included test
plan development, quality assurance, technical documentation, customer support
and integrating Javascript/HTML applications with Postgres and Oracle databases
in a web environment using Perl and DBI. Work required understanding of HTML
and Javascript. Supported conversion of database from Oracle to Postgres.
Implemented replication mechanism and schema, stored procedure and trigger
changes.
August 2000- March 2001, Consultant, VoiceStream Communications via Aardeus, Inc., Bellevue, WA.
Administered Microsoft SQL Server 7.0/2000
reporting databases for team of VBScript/VB/Com web front-end developers at
leading wireless provider. Created Perl scripts and DTS jobs to automatically refresh data from Oracle
database sources for use in SQL Server data warehouse and Informatica.
Optimized queries and stored procedures. Acted as intermediary between
Unix/Oracle and NT/SQL Server based developers. Worked to establish development
procedures in newly assembled teams of less experienced developers.
August 1999-August 2000, Pilot Coordinator, Hewlett-Packard via Aardeus, Inc., Cupertino, CA.
Helped with market research, web-based technical documentation and
specification of pilot projects for e-Speak
(an e-commerce development framework) including specification and design of
portal database. Created CMM based software development procedures. Supported
development and lead quality
assurance of
application that used Wireless Access Protocol (WAP),
Java, Apache, Jserv, Xalan, Xerces, WML, MySQL,
XML and XSL to deliver information from LDAP
database. Implemented stress and volume test procedures (using Python
based web test harness), modified code to facilitate testing.
July 1997-August 1999, Senior Database
Administrator, Zenith
National via Aardeus Inc., Sarasota, FL.
Provided
technology support of Price Waterhouse Coopers and Oracle consulting through the due diligence
process of a large Property Casualty insurance
company acquisition.(Provided as a sole administrator, operational
support equivalent to what was being provided by a team in the company being
acquired). Enhanced VIA/Watermark
Imaging system using SQL Server database, adding reports, triggers and stored procedures. Maintained ASP web page that
delivered customer information. Lead DBA staff’s development of security,
performance and applications tuning, database schema maintenance, database
monitoring, end-user support, backup and database maintenance procedures. Supervised performance and application tuning. Built logical and physical databases using
Erwin. As an appointed member of the Internet/Intranet strategy
committee, evaluated WebLogic, Oracle
Application Server and EAServer against
selection criteria. Responsible
for security strategies, disaster recovery strategy, production replication
server installation, database layout,
quality assurance procedures and design reviews. Supported Power Builder and Visual Basic
Developers using Sybase and Oracle. Created archival data warehouse through all
phases of Software Development Life
Cycle(SDLC). Supported movement to multi-tiered development platform.
March 1994-September 1996, Senior Database Administrator, Filoli Information Systems, Palo Alto, CA.
Was
brought in as one of 6 initial contributors to a company that eventually grew
to over 120 people. Created foundation for
Database Technologies Group which grew to 30 people. Key member of Customer
Information Sharing System development team. This system transferred
data from IBM mainframe to Sybase database for use with Windows clients running
custom Visual Basic application software. Managed
team of DBA's responsible for
maintaining production and development databases using Sybase System 11 and Replication Server on SparcServer 1000's running Solaris
and HP 9000 servers running HP/UX. Responsible for all aspects of database design, performance
tuning, database schema maintenance and database security. Established mainframe interfaces and
supported Object Oriented front end development team.
Supported
data modeling group in converting from Erwin based logical designs to SQL
Server based physical designs. Developed Perl scripts used in database maintenance and initialization,
transformation and conversion of data. Supported in-house project communication by
development of intranet web pages.
August 1993-March 1994, Consultant, TRW Financial Systems via Aardeus, Inc., Oakland, CA.
Mentored team's first Sybase implementation. Created
triggers, stored procedures, administered databases and coded using Sybase's ctlib and
Visual C++ for NT. Helped experienced C++ developers get up to speed
with SQL Server and ctlib.
March 1993-August 1993, Database Developer, HNC Software via Aardeus, Inc., La Jolla, CA.
Created high performance database interface using C/dblib for first
generation of Falcon (Neural Network Credit Card Fraud detection system). Mentored HNC technology team
in database development, and performance tuning
methodologies. Falcon is used by 16 of
the top 25 credit card processors.
July 1992-March 1993, Consultant, Amdahl Corp. via Aardeus, Inc., Fremont, CA.
Enhanced problem tracking system written using C/Xview/Sybase/dblib, handled database administration.
February 1990-July 1992, Software Developer, Aardeus, Inc., Palo Alto, CA.
Developed,
Supported and marketed SQL Express- a toolkit that
supported development of SQL Server applications in Microsoft Visual Basic or Asymetrix
Toolbook
(a product similar to Apple’s Hypercard). Sql Express was among the very first means
to develop SQL Server applications outside the
C SDK-and was used to successfully field applications in several Fortune
500 corporations. The VB version of SQL
Express was available several months before any equivalent offering from
Microsoft. The Asymetrix Toolbook version of SQL Express included a forms
generator that could be used to generate simple client-server GUI applications
when supplied with a simple SQL select statement. Developed a system to process motion picture contracts.
March 1988-Febuary 1990, Consultant, Sun Microsystems
via Aardeus, Inc., Mountain View, CA.
Project Lead for
Software Quality Assurance testing of Language
Products. Oversaw integration of documentation examples with test
suites. Worked
in environment with formal Quality assurance process. Wrote
report for Sun directors instrumental in
initializing Ruby Hypermedia project. Work required ability to handle
network configuration and system administration, create formal test plans
May 1986-March 1988, Product Support Specialist, Teknowledge, Palo Alto, CA.
Supported
M1 and S1 Expert System tools. Wrote over 100 technical notes for end users.
Created Informix applications.
February 1984-May 1986, Product Support Specialist, Fortune Systems, Belmont, CA.
Supported
networking tools, operating system and development languages (Pascal, Fortran,
Cobol, C) for early Unix system vendor.
Other Experience
·
Created PHP forms
applications using MySQL for subscription web page.
·
Helped develop web
page for school for disabled children.
·
Created
Perl/CGI decision support system.
·
Enhanced
financial software
using Oracle OCI libraries.
·
Mentored
team of C++ developers creating wafer test software in use of Microsoft SQL Server 6.5
and Erwin.
·
Enhanced
reconciliation system's stored procedures.
·
Created NT
application delivery system.
·
Early
contributor to Linux and
Wine development.
·
Early
advisor for founding of Inc. 100 company.
·
Helped
develop Basic compiler for Macintosh
released shortly after 1984 production introduction.
·
Contributed to
creation of Grand Slam (third best selling game in early introduction of
Macintosh).
·
Wrote
Popular Computing feature articles.
·
Wrote data compression
portions of Control Key's telephone accounting system.
Certifications/Education
·
Carnegie Mellon University, M.S.,
Software Engineering (in progress, 2001-2003-GPA 3.89).
·
Microsoft
Certified Systems Engineer(MCSE), 2002.
·
CIW
Security Analyst, 2002.
·
Master
CIW Administrator, 2002.
·
Master
CIW Site Manager, 2002.
·
Oracle
9i Certified Database Associate,
2002.
·
Microsoft Certified
Database Administrator (MCBDA), SQL Server 2000, 2002.
·
Master CIW Designer, 2002.
·
Certified Sybase Professional, Interfaces
Developer, 1996.
·
Certified Sybase Professional, Database Administrator,
1995.
· University of Chicago, AB Economics, 1981.