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