Looking for DBA work

I am currently looking for interesting DBA work.

My name is Douglas Burns and I have 6 years solid Oracle DBA experience across a wide range of Unix and PC platforms, running from version 6.0.36 through to 7.3. This includes a spell working for Oracle as a DBA course lecturer.

As well as all standard DBA skills, my speciality is performance tuning (including SQL tuning).

I attach a text-only CV. If you require any further information, please do not hesitate to get in touch.

Thanks for your time.

Curriculum Vitae
Personal Information

	Name			Douglas Ian Burns
	Address		48/7 Learmonth Avenue
				EDINBURGH
				EH4

	Telephone		0976-358141		(Mobile)
				0141-3523340	(Work)
				0131-3432648	(Home)

	email			DougBurns_at_msn.com

	Date of Birth	31/12/65
	Next Availability	Immediate

Education

Secondary School

Archbishop Holgate's Grammar School, Hull Road, YORK YO1 5HA September 1978 - June 1982

7 G.C.E. Ordinary Level
1 C.S.E. (Grade 1)

Occupational Training

	AIX System Administration		June 1991
	Oracle 7 Database Administration
	(Parts I and II)				January 1993
	Unicos Command Language and		June 1993 
	Shell Programming
	Presentation Skills Workshop		November 1994
	Performance Appraisal Workshop	May 1995

Career Resume

(C) Contract (P) Permanent

05/96 - Database Administrator (C) Barclays Stockbrokers

Specific Duties

		Sole DBA for Synergo TAROT Settlements System 
			Oracle 7.1.6
			HP/Ux 10
			ServiceGuard


			(All standard DBA tasks)



		Some Unix administration (cover for primary administrator).

		I was also required to do a vast amount of SQL consultancy, assisting
		Visual Basic Developers and Business Analysts with the production of
		efficient SQL and was the sole PL/SQL developer on site. This involved a
 		small amount of work with MS SQL Server.

		I trained a permanent member of staff to replace me as the primary DBA
		resource.

Referee	Janet Carcherie	Project Manager		0141-3523384
08/95 -	05/96	Database Administrator (C)	Barclays de Zoete Wedd

Specific Duties
		DBA for following Production Systems (all standard DBA tasks) :-
			ARIES (TCAM) Securities Settlements System.
			Gilt Repo Ladders.
			Equities Cost of Carry.
			Inforalgo.
		Training permanent staff.

Referee	Michael Mactavish 	Technical Services Manager	0171-6964744

4/95 - 7/95	MIS Operations Manager (C)  	MFS Communications Ltd.

Specific Duties
		Line Management of 6 people.
		Responsibility for day-to-day operation of all IT hardware and software
		to agreed Service Level Agreements. (Novell LANs, HP G60 and T500,
		Microsoft Office, Oracle Versions 6 & 7, Remedy Action Request System,
		Micabuild etc.
		Evaluation project leader for CA Unicenter and TS Reorg.
		
11/94 -	4/95	Course Lecturer (C)			Oracle Corporation (UK) Ltd.

Specific Duties      
		Lecturer for Oracle7 Database Administration Part II - 
		Maintaining and Tuning the Database course. (Public schedule - 2 
		weeks per month)     

06/94 - 4/95	MIS Consultant/DBA (C)		MFS Communications Ltd.

Specific Duties	(Full Time until 11/94 - two weeks per month thereafter)
   

Reviewed existing Oracle configuration, diagnosing a large number of problems and recommending and performing remedial action. Restructured databases to utilise additional hardware effectively. Implemented scheduled reports to identify any subsequent problems.

Capacity planning.

Project Planning for System Security and System Operational Procedures and Performance projects.

Development of various C and Pro*C programs, including a utility to filter call destinations and allocate them to separate accounts for specific customer billing requirements, based on user-defined rules; and various extract file production programs.

Development of ad-hoc MIS traffic and financial analysis reports, using SQL.

Day-to-day Oracle DBA activities, including on-going support and consultancy to developers for both Oracle and UNIX.

Referee
Trevor Wadcock MIS Director 071-5705700

03/94 - 06/94 Senior AP (C) Student Loans Company

Specific Duties
Development of various reports using Reports 2.0.13 (Windows) for client loan performance analysis, document tracking and post-update data validation. Specific attention was given to tuning, resulting in some very complex SQL statements.

Development of a procedure to populate Oracle database from mainframe extract files. This procedure consisted of UNIX shell scripts, Loader control files and non-trivial PL/SQL scripts, used to check business rule and data integrity during the load process.

Referee

                Aileen Reddox Project Manager 041-3062000

01/94 - 03/94 Senior DBA (C) London Borough of Hackney

Specific Duties
Configuration analysis and subsequent reconfiguration to improve manageability and prepare for accounting year-end procedures.

Performance analysis, subsequent dictionary cache, dictionary storage fragmentation and temporary segment tuning. Production of reports justifying expenditure for additional memory to eliminate UNIX paging.

Standard daily DBA activities, including informal training of existing staff and developer support.
Referee

                Reginald Bassimi Project Leader 081-4425228

01/93 - 12/93 Senior Consultant/DBA (C) Saudi Arabian Oil Company

Specific Duties
Reconfiguration of existing version 6.0.37 database (used for evaluation purposes) and migration to version 7.0.12, followed by the installation of two additional 7.0.12 instances, with associated CDE tools, across a variety of platforms.

Development of configuration and operations standards, using OFA and MOSES documentation as source material. The primary objective was the implementation of 24x7 operation (24x6 on my departure) and ease of administration of a distributed environment. All installations complied with these standards.

Development of a suite of programs (Reports 2, Graphics 2, SQL*Plus), utilities (C-Shell) and automatic DBA alert procedures (C-Shell) to facilitate management of a growing, distributed environment.

Development of procedure to refresh a 35 million+ row Geophysical database, linked to a Model 204 extract job on the ES/9000 mainframe. This included an extended shell script to control parallel downloads and updates, based on ftp and SQL*Loader, as well as SQL scripts to control creation of Referential Integrity constraints. This procedure was executed on a weekly basis, in order to provide data to Geologists and Geophysicists.

Development of a procedure to reorganise extents by tablespace, based on C-Shell and SQL scripts, and Export/Import parameter files.

Extensive use of auditing facilities, as required by Aramco Installation Security, including modification of table creation scripts to prevent SYSTEM tablespace fragmentation and free-space problems.

Providing support to third-party vendors in the creation of GIS environments.

Informal training of two members of staff to act as replacements on my departure, including the development of Oracle Book documentation to provide on-line access to site-specific documentation.

Referee

                Roger Booker Database Services Manager 01096638765867

09/92 - 12/92 Unemployed

04/90 - 09/92 Senior AP (P) Lloyds Bowmaker Finance

Specific Duties

			Supervision of a Project Implementation team with 4 members.


			(Group Marketing Database Project).



			AIX System Administration & Oracle Database Administration.

			Development of a front-end interface for communications
			between PCs and Mainframe, for credit referencing purposes.


			(Microsoft C)



			Maintenance and enhancement of existing Profitlink Motor
			Dealer Finance Quotation system (Clipper)


03/90 - 04/92	Senior AP (C)				Harkins & Andersen

Specific Duties

	Development of Waiting List module for Housing Association Management
	System

08/88 - 02/90	Software Manager (P)		RD Communications Ltd.

Specific Duties

        Pre and Post-Sales Support covering a wide variety of PC Applications

        Development of bespoke applications using dBase III Plus and Foxbase Plus

Details of other Career Positions on request (4 years Z80 Assembly Language Programming) Received on Mon Feb 10 1997 - 00:00:00 CET