2097 Tanglewood, Pacific MO 63069

314-257-8018 nights, 314-694-3207 days

maufe@daugherty.com

Professional Summary

Simon is an 8 year information systems professional who is currently an Oracle and Rdb DBA at a St Louis Fortune 100 biotech company, managing databases in size from 1gig to 40gig. Simon is experienced at all aspects of the logical and physical role DBA role, covering client/server troubleshooting, application architecture design, security, performance monitoring, resource planning, tuning, SQL writing, system monitoring, backup and recovery, table creation and normalization, 3GL and 4GL coding, logical design and replication.

Technical Summary

Hardware	IBM PC compatible, Digital 6xxxx, 7xxx, 8xxxx, Macintosh
Operating Systems	UNIX (Digital), OpenVMS , Windows NT, MS-DOS, Windows 95
Communications	TCP/IP and applications (FTP, TELNET), SQL*NET, Sql/Services, AS/400 Client Access, DECNET
Languages	Visual Basic, C, COBOL, Pascal, DCL, UNIX Shell, MS Access, PL/SQL, LISP, Prolog, HTML/CGI
Databases	Oracle Oracle (7.1-7.3), Oracle Rdb (3.x-7.x), MS Sql/Server (4.2,6.5), Lotus Notes
Applications	OLTP, Data Warehouse, Field Sales Automation, Order Taking, Customer Maintenance, End User (segmented) Marketing
Software	MSOffice, Erwin, IEF, ODBC, Infopump, Data Distributor, Open Gateways for RMS and Oracle, Rally 4GL, Powerhouse, DECtrace, Visio, Enterprise Manager, RdbExpert, JSS, ACMS, Crystal Info, SLS, CDD/Plus, Enterprise Manager

Professional Experience

January 1994 - present Daugherty Consulting, St Louis, Missouri

As a DBA at Monsanto in St Louis Simon works on many application teams, normally joining the team at the beginning of the technical implementation stage and staying through post-production release.

Reference Data - Oracle Rdb, 50 user database recording all customer, product, people, organization and geography data for a business division. Data replicated to other Rdb databases nightly for use in OLTP and batch processing. Data replicated use Oracle's Data Distributor technology. Introduced Data Distributor product, working with system managers, operators and DBAs to ensure smooth implementation, 24x7 monitoring, and time sensitive data replication. Involved in logical design, script creation, performance monitoring, IEF troubleshooting, SQL tuning.

Professional Experience (continued)

Customer Order Logistics Transaction Systems - Oracle Rdb, 120 user database taking all orders for Monsanto business division. Approximately $2bn yearly, involved in security, performance tuning, IEF troubleshooting, backups/restores, table and index scripts, resource planning.

Sql/Services and Rdb software - responsible for Sql/Services installations, troubleshooting and configuration. Responsible for Rdb and related software installs, primary system troubleshooter, rewrote Rdb backup tool to use Storage Library System, reduced night calls by 80%.

EndUser Database - Oracle Rdb, 40 client/servers users (VB/Win95/TCPIP), maintaining call-center and direct marketing data on US soybean and corn farmers. Chief challenges revolved around data volume and volatility, rapid turnaround on new marketing programs, integration with existing business systems, and performance related to remote call centers connected using ODBC over T1 lines.

Infopump - Platinum's heterogeneous data replication tool running on Windows NT servers. Used to connect AS/400 DB2 databases, Dbase, Lotus Notes, Rdb, Oracle, Informix, flat files. Responsible for introducing the technology to Monsanto, providing design and coding assistance on scripts, ensuring production quality availability of NT servers and application software. Microsoft Sql/Server backend. Approximately 120 scripts executed nightly, 200 weekly.

Metadata warehouse- responsible for creating and populating metadata repository covering Rdb (45+) and Oracle databases (85+) at Monsanto. Used by data administrators to audit logical design compliance, provide database historical resource (IO, storage, attach) analysis, auditing of table usage, what-if scenarios. Write reports to quantitatively monitor and report on database performance and resource usage.

Crop Data Warehouse - Oracle 7.1, 20 online users, 16gig, OpenVMS. Reloaded largely from scratch nightly, summarization (fact and dimension tables) provided by PL/SQL scripts. Chief challenges are ensuring access to data by non-Oracle groups, ensuring consistently fast overnight load cycle, ensuring VMS system used to best effect, space management, Oracle education to teams. Use SQL*LOADER, export/import, ULTBSTAT, UTLESTAT, many home-grown utilities.

Siebel/Asgrow - DBA for Sales Force Automation (SFA, 120 salesreps) project implemented using SIEBEL tools on Windows 95, Windows NT and Oracle 7.3/UNIX. Responsible for troubleshooting database communication problems, all database issues, logical design, interface design for legacy AS/400. DBA for a Competitive Marketing Information subsystem running on Windows NT/Oracle 7.3.

Shared UNIX database servers - System DBA responsible for two Digital 8100 database servers running Oracle 7.3.3 on RAID 0+5 devices. Database sizes are 80 gig in devl/test and 40gig in production. Responsible for specifying new servers, planning introduction and OFA compliance, ensuring DBA scripts working, ensuring backups are performed correctly (Netbackup, EBU), helping application DBAs migrate their applications to the servers, ensuring server availability, UNIX performance monitoring.

Professional Experience (continued)

September 1988 to January 1994, Digital Equipment Corp, Colorado Springs,CO and Basingstoke UK

Technical Support for DEC Rdb, now Oracle Rdb. Responsible for technical support on Oracle Rdb and all related products such as Rally, DECtrace, RdbExpert, DECforms, TDMS, ACMS, Sql/Services, CDD/Plus. Responsible for customer problem resolution, mentoring new members, liaison with engineering groups, knowledge base population, automation of call center response statistics.

September 1986 to July 1987, International Computers, Bracknell, UK and Wellington, New Zealand

Quality Assurance team member on Concurrent DOS DRS300 PCs, maintenance of bug database (Dbase II), rolled out field and customer training, technical support in New Zealand.

Education Summary

BSc (2:1), Information Technology Sheffield Polytechnic, UK 1984 - 1988

Microelectronics, Project Management, Programming (C, LISP, PROLOG, Pascal), UNIX, Parallel Programming

Many technical courses whilst at Digital Equipment Corporation

references available on request