EMPLOYMENT HISTORY: |
June 2022 - present
|
Medibank, Melbourne
Application Engineer
Same role as below, now directly employed by Medibank.
|
January - May 2022
|
PBT Group, Melbourne
Application Engineer
Employed by PBT Group and working for their client Medibank.
Part of an Agile team enhancing the capabilities of the iMed claims processing system.
Role involves coding Transact-SQL against SAP ASE 15.7 databases.
Software tools used include Jira, Confluence, Git/Sourcetree and RapidSQL.
|
November 2013 - December 2021
|
Freelance database administrator
Employed by different companies to assist with fixing short term issues or provide
support coverage while DBA staff have been on leave.
Primary client has been PBT Group, providing support coverage and working on projects for their clients
Medibank, SP Ausnet and EPA.
Specific client engagements have included:
- 2018-2020 - Medibank
Designed and coded solution to extract data from Sybase ASE to import into AWS data warehouse. Tasks included:
- Solution design, including table schemas and changes to Replication Server configuration
- Performance testing of possible extract solutions
- Update existing Replication Server deployment shell scripts
- Write new shell scripts to facilitate configuration and data extracts
- Evaluate use of Replication Server to replicate data into SAP Sybase IQ
- Document all aspects of extract solution (design, implementation runsheets)
- March 2019 - Medibank
Provided Replication Server support for application production deployment to implement PHI reforms. Tasks included:
- advise on Replication Server tasks required for runsheet
- provide onsite overnight support during outage window
- May 2017 - Feb 2018 - SP Ausnet
Responsible for planning and completing SAP ASE (Solaris) version upgrade from 15.5 to 15.7. Tasks included:
- Client meetings to discuss upgrade options and planning
- Writing planning documents
- Deploy upgrades to development, test and production servers
- 2014-present - SP Ausnet & EPA
Provide Sybase ASE expertise as requested. Client environments consist of Sybase ASE (Solaris, Windows) and MS SQL. Tasks include:
- Assist with responses to client requests and questions
- Provide replacement DBA support coverage while PBT staff on leave
- 2 days/week oncall engagement for emergency issues
Other non-PBT clients have included:
- Visy Industries - provided emergency assistance with Replication Server issues
- Drake International - provided emergency assistance to fix a database log issue on a production server
|
November 2013 - December 2021
|
david gilliver photography
Freelance photographer and photography teacher
Various assignments photographing portraits and events. Recurring workshops teaching concepts related to light and lighting, using both available
light and flash photography.
Photography clients have included:
- iBuildNew
- Century 21 Australia
- Everperform
- Open Universities Australia
- Railway Hotel, South Melbourne
|
August 2009 - October 2013
|
Pulse Global, Melbourne
Database Administrator
Providing general Sybase/MS SQL DBA support for multiple clients.
DBA duties include responding to client requests, dealing with issues raised by Pulse database monitoring technology and rostered on-call.
As the lead Sybase DBA, also provide training/assistance to other Pulse DBAs when dealing with Sybase ASE and Replication Server issues.
Specific projects included:
- 2012-2013: DBA resource at Medibank (Business Projects division, subcontracted through PBT Group Australia)
I worked onsite as part of a team of DBAs designing, advising and supporting the Ancillary project, with my principal
focus being the implementation of Sybase Replication Server 15.7 within the Medibank ASE 15.5 environment. This implementation involved
the use of the Replication Server warm standby and MSA features.
Specific tasks included:
- writing various Replication Server technical documentation, including technical specifications, implementation runsheets and support/troubleshooting guides
- specifying Replication Server monitoring requirements (eg. connection status, latency)
- coding UNIX shell scripts to manage Replication Server setup and failover/failback process
- providing Replication Server training and support to Medibank production DBAs
- evaluation of Sybase Control Center monitoring product
- refreshing ASE 15.5 test/development database environments
- deploying application database patches to test/development environments
- 2009-2011: Technical lead for project at Visy Industries to migrate Sybase ASE environment from HP-UX Itanium
to Solaris.
Migration was managed by creating new Sybase servers as warm standby copies of
existing servers and then reversing the direction of the replication.
Specific tasks included:
- write documentation proposing migration strategy and detail various relevant technical issues
- installation of production and development Sybase ASE on Solaris as per Visy standards
- assist setup of Sybase ASE within Solaris clustering technology
- basic performance testing of supplied Solaris hardware
- connect new production databases to existing Replication Server environment
- manage replication switchover to new production servers
- provide general post-migration support
- decommission HP-UX Sybase environment post-migration
- 2011: Technical advisor for migration from Sybase Replication Server 12.6 (HP-UX Itanium) to Sybase Replication Server 15.5 (Linux).
This was also for Visy Industries and was performed after the Sybase ASE migration mentioned above had been completed.
A single production Replication Server was replaced with 4 inter-connected Replication Servers.
Tasks included:
- review plan prepared by client DBAs and offer technical advice
- provide on-site support during migration weekends
|
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 Replication 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.
|
|
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.
|
|
|
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
|
|
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
|
|
|
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: database infrastructure maintenance
|
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.
|
OTHER:
|
|
2003 - 2022
|
Melbourne Camera Club
I held a number of roles at the Melbourne Camera Club:
- 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-2013: club studio co-ordinator
- 2013-2018: Photographic Lighting Group co-ordinator
- 2018-2021: Portrait Group co-ordinator (part of 3 man team)
|
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, performance and event photography)
- music
- creative writing
|