Deep knowledge of DBA roles including
strong design and development skills using OO/UML; extensive
experience in developing complex business solutions.
·
Recently an Oracle DBA with
a developer of advanced B2B software used in the free market
in electricity.
·
Previously involved in the
development of large scale retail management solutions since
their inception, through successive iterations of hardware,
operating systems, network technologies and business needs.
·
Able to manage development
teams, work alone on analysis, design and coding or provide
a focus from business into technical workstreams; also
company DBA and extensive user contact.
·
Noted for high quality
code, troubleshooting the challenges, building robust and
versatile systems.
“[snip]
works to a consistently high standard, both as a member of a
team and whilst
DBA MANAGER
working alone…I have no hesitation in recommending
[snip] for
a similar role
ABB
elsewhere…”
“..Within
a busy team, he influences the quality of production of
younger members and
ex CHAIRMAN helps
to steer the project with his advice and guidance…He is more
than a member of
the team; he is the
guy you choose for the toughest programming tasks and the
most severe problems stalling the project….His rapport with
clients is terrific and he has the kind of perceptive mind
that quickly bridges the gap between business needs and
technical solution….His ability to use both Oracle and SQL
Server databases to manage business requirements is simply
exceptional and he readily adapts to new technologies such
as OO…”
Technical
·
Oracle DBA
since 1995; also Oracle PL/SQL;
Oracle Forms; Oracle Designer;
·
Formerly
prominent in the development of several iterations resulting
in the Mercatus retail enterprise system (used
by major chains such as NewLook, Monsoon, Allsports, Oasis,
Kookai, Country Casuals, Bay Trading and Harvey Nichols) -
all the way through from the early 1980's to the latest
e-commerce possibilities; virtually all technologies used at
some time; also developed accounting packages.
·
Applications:
Retailing; Accounting; Sales Order Processing; Purchasing;
Stock Control; Customer Database; Education; Warehousing;
MIS; Planning.
·
Evolving platforms:
SUN UNIX (Solaris); Windows NT/2000/XP; DEC/VAX; Alpha; IBM
AIX; etc.
·
Strong understanding of OO technologies,
used in the design of a large and complex retail
application; training in Analysis and Design with UML.
·
Microsoft Certified
Solutions Developer
2000
(summary): solutions development (multi-user; web based;
N-Tier; transaction based; etc.), architectures, DB
development, applications, MS front and back ends; SQL
Server 7 option taken.
·
Learning Tree SQL 7 DBA Certified Professional
1999: OO Analysis and Design with UML; C++ for C
Programmers; Visual C++ for C++ Programmers; Programming
Active‑X with MFC; SQL Server 7 Introduction/for Database
Developers/DBA; Windows NT4 Workstation & Server; Exploiting
Advanced Features of MFC (Visual C++); Microsoft Transaction
Server
·
Networks/e-commerce:
have participated in thin and thick client server-client
interfacing and worked freelance on e-commerce (HTML/Pearl
CGI/Borland/MS Visual C++)
·
Operating Systems:
NT4; Windows 2000/XP/98/95; Unix Solaris; Unix AIX; VAX VMS.
·
Other technologies:
HTML; XML; Visual Basic; Pearl; TCP/IP; NFS; DecNet; PCNFS
Pro; Business Objects; MS Office; Borland C++ Builder;
Postscript; Basic Plus; VAX Basic; Cobol; Fortran; VNC; PC
Anywhere.
·
B.Sc. was
a 2:1 in Mathematics at Southampton (1972)
Career
Development Contract, [snip]
Apr 2002 – Present
·
Design of merchandise
planning system, including design of Oracle Database schema.
·
Designed and Developed VB
program to load Excel spreadsheets from Oracle database,
parameterised to deal with various types of spreadsheet.
·
Designed and Developed VB
program to create XML purchase orders from Oracle database.
Oracle 8i.
DBA, [snip] Jan-Dec 2001
·
Joined this 150 staff
subsidiary about midway through the development of
GenesisplusÔ,
a £200K software suite used by power generators and traders
to manage the sale of electricity under the NETA free
market.
·
Specifically recruited
because they’d had no DBA for 6 months and urgently needed
“version control” in the generation of scripts to match
their stream of update executable being shipped out to
customers:
-
These upgrade scripts were
required for very numerous software changes (several each
week)
-
Created/maintained test
database and tested live on major customers’ systems
-
Post live bug fixes and
diagnostics using copies on project server + addition of new
features
-
Developed and fixed storage
procedures and triggers, including C Library routines
-
Addressed performance
problems including improvements to existing SQL
-
Recommended database design
changes to improve performance.
·
Designed and developed
general purpose database archiving package.
·
Replaced DBAs on other
projects and on some production and troubleshooting issues,
occasionally achieving some dramatic results for specific
customers ([snip] processing speed increased
1000%).
·
Designed and developed a
cost saving in-house system in Perl for maintaining a
standby Standard Edition Oracle DB.
·
Designed and developed a
Perl program together with Visio software capable of
generating an entity relationship diagram from an Oracle
schema.
·
Supported Oracle running on
NT4 server; Windows 2000 server; Unix Solaris; Unix AIX.
Senior
Designer, Analyst, Programmer, DBA
1999-2000
Start-up project, no
formal company name adopted, permanent throughout period:
·
Use
of OO techniques
in the design and development of the system and architecture
for an all new retail enterprise system to be aimed at
smaller users, incorporating maximum flexibility and
expandability.
- overall
planning and design as an N-tier, e-commerce enabled system
which would integrate proprietary user and business engines
with highly sophisticated database functionality
- creation of 200
business case scenarios as main system input
- UML analysis
and relationship mapping
- Design of DB
schema across 9 databases (SQL Server 7)
- early stage
prototyping using MS Visual C++
Senior
Analyst/Programmer/Software Engineer & DBA
1977-98
NSB Retail Systems/APT - 80 staff software house providing
retail solutions (bought out 1998)
·
Technical No 1
at the London site, managing key areas within ad hoc project
teams of analysts and programmers, contributing to the most
challenging problems, constantly designing and developing
new functionality for a stable of legacy, migrated and up to
the minute software solutions for the retail industry,
resulting in the widely used Mercatus product.
·
Workstream focus,
channelling business analyst input from pre sales and
existing clients and converting requirements into project
specification, database designs and planning briefs (with
costings) - usually customisations of the applications or
database requirements.
·
DBA
for Oracle and System
administrator for SUN Unix Solaris and VAX machines.
