DAVID GILLIVER

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