DAVID GILLIVER

operational Sybase DBA with strong UNIX skills

Bentleigh, VIC, Australia

mobile: 0402-323-739
email: david@gilliver.net

EMPLOYMENT HISTORY:

February 2007 - present

BlackRock, Melbourne

Database Administrator

Supporting Sybase and MS SQL Servers in Melbourne and Tokyo.

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:

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-2006

Melbourne Camera Club

  • 2003-present: club member
  • 2005-2006: elected member of club council
  • 2006: Vice President
  • 2005-2007: Portrait Group Co-ordinator
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 portraits, music performance and events)
  • music
  • creative writing