DAVID GILLIVER

EMPLOYMENT HISTORY:
August 2009 - present	Pulse Global, Melbourne Database Administrator Providing remote Sybase/MS SQL DBA support for multiple clients.
February 2007 - July 2009	BlackRock, Melbourne Database Administrator Supporting Sybase and MS SQL Servers in Australia, Japan, UK and USA. Part of global team responsible for large global database environment consisting of Sybase ASE on Solaris, Sybase IQ, Sybase Rep Server and MS SQL Server. DBA duties include rostered on-call and follow-the-sun support. Specific projects include: May 2008: migration of Sybase ASE 12.5 server from Windows to 64-bit Redhat Linux using Replication Server 15 (MSA and warm standby) November 2008: migration/upgrade of Sybase ASE 12.5 server (32-bit Windows) to Sybase ASE 15 (64-bit Redhat Linux)
February 2004 - January 2007	Visy Industries, Melbourne Database Administrator A continuation of the Visy Industries work conducted at Rami Logistics (see below), but directly employed by Visy. Managed the following technology: Sybase Adaptive Server Enterprise 12.5.x (HP-UX Itanium & Linux) Microsoft SQL Server 2000 Sybase Replication Server 12.6 (HP-UX Itanium) using table replication, warm standby and multi-site availability (MSA) functionality Sybase Directconnect for Oracle (HP-UX PA-RISC) Sybase Directconnect for MS SQL Server (HP-UX PA-RISC) Sybase Replication Agent for Oracle (HP-UX PA-RISC) Sybase SQL Anywhere Mobilink (Linux) Specific projects included: 2005: Technical lead - migration of Sybase environment from HP-UX PA RISC to HP-UX Itanium 2006: Technical lead - migration of Sybase environment to HDS disk storage solution
November 2000 - January 2004	Rami Logistics Pty Ltd, Melbourne - a division of Adacel Technologies Sybase Database Administrator Supporting Rami development team and production/test/development server environments for Visyboard Australia and Armaguard. Visyboard production/test environment consisted of Sybase ASE 12.5 servers in Sybase HA configuration (64 bit HP-UX) in combination with Sybase Replication Server 12.1 (table and warm standby replication) and multiple Sybase ASE 12.5 (Redhat Linux) servers. Visyboard development environment consisted of Sybase ASE 12.5 (Redhat Linux and Windows NT) servers. Armaguard environment consisted of Sybase ASE 11.5 (Sun Solaris) and Replication Server 11.5 utilising warm standby functionality. Responsibilities included: general Sybase database administration tasks in production environments deployment and support of in-house Linux/Sybase development environment rostered 24/7 on-call support of Visyboard Sybase ASE/Replication Server extensive Bourne and Perl scripting to automate common tasks general Sybase/Linux developer/customer support refreshing development and testing databases with production data liaison with Visyboard, Armaguard and HP technical staff regarding Sybase requirements and related issues Specific tasks included: assisted initial deployment and provide subsequent support for Sybase/Linux servers within Visyboard production environment. Involved Sybase ASE installation (using Sybase XFS option) and configuration of Jetform printing software and associated Linux printing environment. support deployment and assist troubleshooting of Sybase ASE High Availability within Visyboard involved in project to migrate and merge state-based databases into a single national database (subsequent to HA deployment). Involved restructuring replication requirements using Perl and Bourne shell scripts. development and maintenance of team intranet site (HTML and Perl CGI scripts) to provide information about Sybase environment and reporting tools for management. Audience included both internal developers and customers. development of tool to deploy compiled applications to Netware and NT servers (Perl CGI scripts using Sybase back-end) development of tool to deploy and manage database schema change requests (Korn shell script) technical requirements advisor (network/Sybase/Linux) for Adacel office re-location from Mt Waverley to Brighton preparation of regular written status reports for Armaguard technical management
May - November 2000	American International Assurance, Melbourne
	System Administrator (Sybase/Solaris/Linux) Supported small team of Java developers. Environment consisted of two Sybase 11.9.2/Solaris 2.7 servers and approx 10 Redhat Linux workstations. Responsibilities included: general Sybase and Solaris system administration tasks delivery of Java application to test/production environments handle general Sybase and UNIX queries from development team liaise with various software suppliers Specific tasks included: rebuild existing Sybase server to enable full disk mirroring develop and implement basic Sybase capacity monitoring
July 1998 - January 2000	Lehman Bros - London, UK
	Sybase Database Administrator (April 1999 - January 2000) Rolling contract providing general Sybase support of production, development and Year 2000 testing environments. Production environment consisted of over 100 Sybase SQL servers, versions 11.0.3-11.9.2. Responsibilities included: general system administration duties and troubleshooting supporting various application development teams system installation/configuration shell scripting rostered 24/7 on-call support
	UNIX System Administrator (February - March 1999) Short term contract (2 months) providing general UNIX support to production environment
	UNIX System Administrator (June - September 1998) Short term contract (3 months) providing general UNIX support within Year 2000 testing lab. Environment consisted of approx 20 machines: Sun Sparc 2 workstations to Ultra 450 servers Responsibilities included: general system administration duties supporting various application testers system installation/configuration shell scripting incidental Sybase support/troubleshooting
February 1995 - March 1998	Information Services Division, Macquarie Bank - Sydney, Australia
	UNIX System Administrator (February 1997 - April 1998) Member of UNIX Systems Group, responsible for support and maintenance of UNIX environment of approx 100 Sun servers. Specialty within team: Internet technology Responsibilities included: general system support tasks various shell scripting tasks UNIX server installation and upgrades installation, support and upgrades of multiple web servers basic firewall configuration tasks design, implementation and maintenance of team intranet pages, used by UNIX team and various development teams. Included Perl coding of web page for graphing system performance statistics (based on sar output). coding of utility to accurately detail disk partition usage limited on-going support of Sybase environment rostered 24/7 on-call support
	Sybase Database Administrator (February 1995 - February 1997) Member of DBA team, responsible for support and maintenance of Sybase environment of approx. 80 servers (featuring SQL Server, OMNI and Net-Gateway) running under Sun Solaris and SunOS UNIX. Specialty within team: infrastructure maintenance Responsibilities included: installation of new Sybase servers (4.9, 10 and 11) migration of existing Sybase servers to new hardware database creation, backups and restores capacity planning basic server configuration tasks troubleshooting server (SQL, OMNI & NGW) problems planning and performing Sybase server upgrades from SunOS 4.1.x to Solaris 2.x planning and performing Sybase server upgrades from Sybase 4.9.2 to Sybase System 10/11 design, implementation and maintenance of Sybase disaster recovery environment using Bourne-shell scripts design, creation and maintenance of DBA intranet pages, now heavily used by DBA team, developers and end-users. Included coding of a web interface (using Perl) for database change control system used by developers. rostered 7 days/24 hour on-call system support maintenance and documentation of the Sybase infrastructure, including extensive re-coding of in-house server monitoring (Bourne shell scripting, stored procedures) and completely re-coding database backup utility (using C and DB-Lib) managing implementation of database backups under Control-M scheduling package (UNIX version) training new DBA staff in operation of Macquarie's environment general developer support
QUALIFICATIONS:
1992-1994	Charles Sturt University (Australia) - Mitchell campus Bachelor of Applied Science (Industrial Mathematics & Computing) graduated with distinction Core units studied included: statistics, mathematics, operations research and computing. Options selected with an emphasis on computing and maths.
1993	Mitchell Foundation Scholarship Winner awarded for scholarship and leadership potential sponsored by AMP
COURSES:
April 2008	Oracle Database 10g: Administration Workshop I Oracle 5 days
September 2006	Performance & Tuning: Configuring Adaptive Server Enterprise Sybase Australia 5 days
May 2002	Sybase High Availability Companion Server Sybase Australia 2 days
Jan 1997	Solaris 2.x System Administration Sun Educational Services (Australia) 5 days
Apr 1996	Introduction to Solaris 2.x System Administration Sun Educational Services (Australia) 3 days
February 1995	Sybase Database Administration Sybase Australia 3 days
February 1995	Introduction to Sybase Sybase Australia 5 days
OTHER:
2003 - present	Melbourne Camera Club I have held a number of roles at the Melbourne Camera Club since joining the club in 2003: 2005-2006, 2009-2010: elected member of club council 2006: Vice President 2005-2007: Portrait Group Co-ordinator 2008-2011: "Introduction to Photography" course presenter ("Light and Lighting", "Digital Photography") 2010-2011: club studio co-ordinator In 2011 I created and presented a 7-part Photographic Lighting course for 20 students. The course consists of slideshow presentations, live demonstrations and conducting practical hands-on sessions for students. I also regularly run presentations at other camera clubs around Melbourne.
June 1999 & October 2001	Stephen Cummings/Wminc Productions Primary instigator of volunteer projects to create CDROM component for Stephen Cummings' "Spiritual Bum" (1999) and "Skeleton Key" (2001) albums. Responsibilities included: general management and guidance of projects HTML design and coding extensive liaison with co-designer/graphic artist writing of Stephen Cummings biographical notes included on CD editing/proofreading of all written components liaison with Stephen Cummings, WMinc Productions (management) and other contributors liaison with production staff for preparation of final CD master
INTERESTS:
	1995 - present: design and maintenance of official web site for Australian musician Stephen Cummings (www.lovetown.net) 1998 - 2004: design and maintenance of fan web site for Irish rock band Hothouse Flowers (gilliver.net/hothouse) photography (including portraiture, music performance and events) music creative writing