EMPLOYMENT HISTORY
Company: Colonial Leisure Group
Site:http://www.clg.com.au/
Start Date: 22/09/2014 End Date: Current
Position/Title: MSSQL DBA, MySQL DBA, Linux Admin, MS Server Admin, AWS Admin, Software Consultant
Responsibilities:
Manage the IT infrastructure for the Colonial Leisure Group and all of its subsidiary businesses.
These include …
The Townsville Casino, Orpheus Island, The Albert Park Hotel, The Middle Park Hotel, The Portsea Hotel, The Botanical, plus many more sites.
(please refer to www.clg.com.au for a list of other sites)
Tasks include…
Admin for the Database System used by the QDOS POS product. This is used in all of the subsidiary companies.
Administer the Web Servers and DR (backups, recovery processes, GIT repositories)
Administer the Magento Web System for QDOS
Task Details….
Microsoft SQL Server DBA,
– PLSQL Performance Tuning
- Database Performance Tuning
- Disaster Recovery Strategy and implementation
- Backup strategy and implementation
- Database upgrades and patching
Microsoft Server Administration
- Patching / upgrades
- RAID5 and 1 Disk setup and management
- Storage management
- Backups
- DR Strategy and implementation
- SSH interconnectivity
- Firewall management
- All other normal Server AdminTasks
AWS (Amazon Web Services) Administrator
- Setup AWS VPC
- Deploy EC2 Instances
- Deploy RDS Instances
- AWS Management
AWS RDS – DBA
- Setup and Manage the AWS RDS Mysql Database
- Performance tuning and host monitoring
- SQL Tuning – Slow Queries and Application issues
- Snapshot Backups
- Snapshot recovery
AWS EC2 – Linux System Administration
– patching
- Performance management, CPU load,Disk IO issues
- Access management
- LAMP setup
- Webserver Setup and admin
- WordPress Setup and admin
- Storage management
- Backups
- DR Strategy and implementation
- SSH interconnectivity
- Firewall management
Software Developer/Consultant
- PLSQL stored procedures, PHP, Shell Scripting, C# (.net), etc
Achievements of note in this Role:
Issue: Business Critical SQL Server running at 100% for significant periods during the day.
This server is the data source for over 400 pos terminals as well as the entire framework for the QDos inventory management system.
Impact : Daily Traffic load – Slow response times, Peak Daily Traffic – On occasion, server flooding with incompleted transactions and data loss.
Analysis: Identified missing indexes, poorly written stored procedures, stale table statistics, badly fragmented indexes.
Solution: Put in place maintenance scripts to monitor and selectively identify badly fragmented indexes and perform re-index tasks when required (plus update table statistics when required (stale)). Using SQL I identified many high volume poorly performing stored procedures. Selectively executing parts of these procedures would generally identify table scans rather than seeks, fixed by changing the “where” condition in the offending query or adding a required index to the underlying table(s). Other situations required recoding (replacing cursors with a query, using a temp table rather than a cursor, etc).
Outcome: CPUload dropped from average of 80-100% down to 15-20%. Disk IOPS were reduced by 70%
Issue: Mission critical Database. Server single point of failure. No DR infrastructor, process or policy
Impact : Potential catastrophic business downtime, dataloss of up to 24 hours (nightly backup – recovery)
Analysis : Single points of failure identified – Server hardware, network, Storage.
Solution: Redeployed low usage company hardware to act as a standby database. Upgraded the DR host software to align with the production host (Windows server 2008 R2 and SQL Server 2012 – 11.0.2100.60 (X64). Restored a backup of prod to the DR Serverdatabase and opened it into Standby mode. Setup logshipping from prod.
Outcome:Standby Database DR failover system. Recoverable to within 15 mins of production failure. Fully documented failover procedures.
Issue: AWS EC2 WordPress Webserver farm – No backups, No Patching, No Security Hardening, Compromised Server
Impact : One of the hosts was infiltrated and was used as a malicious proxy attack server.
Analysis: No Patching procedures in place, insecure WordPress deployment, firewall not configured, insecure account policies
Solution: Deployed a new AWS EC2 instance to replace the compromised host. Formulated a migration plan to re-deploy sites to the new host. Created a git repository on a bastion host to keep a working copy of each wordpress site. This source repository is a recovery option in the event of future attacks. Ensured all word press sites were patched appropriately. Created a backup strategy. Backups for the code and Database contents. Installed wordfence firewall onto each site.
Outcome: Server restored back to operational status. DR and failover procedures established and tested
Other
Examples...
Wrote MD5 monitoring scripts to track system changes on the Linux AWS Hosts
Setup SSH interconnects between hosts for scripted backups
Fixed Magento product synchronizing issues
Diagnosis of Magento Mysql Slow Queries. – identified missing indexes, inefficient sql.
IPtables blocking of active server attacks – dos and login attacks
Upgrades and patching of windows and linux hosts
Hardware repairs of raid arrays and raid controller cards
SQL Server DBA Duties
Company: Mistro
Site: http://www.mistro.ag/
Start Date: 30/06/2014 End Date: 19/09/2014
Position/Title: Software Engineer (PHP), MySQL Developer, MySQL DBA, Software consultant
Responsibilities:
Design and implement a system to manage the Export Heifer process for the Australian Dairy Herd Improvement Scheme (ADHIS)
The application was written in php, c# (.net), javascript and MySQL, hosted on a Linux Server.
The application was delivered on time and incorporated into the ADHIS Management System.
Company: IntoCloud Consulting Group
Site: http://intocloudconsulting.com/
Start Date: 31/03/2014 End Date: 27/06/2014
Position/Title: Software Engineer (PHP, Javascript, AJAX), MySQL Developer, MySQL DBA, Software consultant
Responsibilities:
Create a Web based management portal for a VIPR Storage Solution (http://australia.emc.com/cloud/vipr/index.htm)
The portal is designed to allow customers to self manage security in the VIPR product and provide access to other products that IntoCloud Consulting offer. The application was written in PHP, Javascript, AJAX and hosted on a Linux Server using MySQL as the database.
The application was delivered on time and hosted as a service offering on the IntoCloud Portal.
Telstra IT Service Management System
I received an award of excellence for managing and creating a Service management system for Telstra IT.
Some of the features…
- An indexed searchable catalogue of all Telstra IT Products, Services and Standards
- A workflow mechanism for the management and certification of Standards, new products and new services
- Lifecycle roadmaps for all Telstra IT Products, Services and Standards
- Pass through Authenticated Management facilities that allowed each group to maintain records relevant to their domain
Technology used to achieve this goal
Oracle Developer, SQL, Javascript, Ajax, JQuery, PLSQL, HTML
Telstra Unix Build System
I created a Unix Tool to automate the deployment of Unix OSI’s. The user entered in the unique OSI parameters and the OSI was automatically installed and configured on the target server. The Backend rendering and storage product was Oracle and the site resided on a SunOne webserver with PHP and Oracle connection objects compiled into the server kernel.
- I Installed and built the Unix server : It was a SUN T2000 with Solaris 10
- I installed and configured the Oracle Database : Oracle 10g (Release 2)10.2.0.1
- I installed and configured the SunOne Webserver and incorporated the Oracle and PHP modules
- Also required was an Apache webserver on a different port to deploy the Solaris Build package of which I installed and configured
- I wrote the entire build tool site using HTLM, PHP, SQL, PLSQL, Unix Shell Scripting, Javascript amd JQuery
- The deployment product was written by myself in perl
This site is operational in Telstra and extensively used by Telstra’s IT partners IBM and Accenture.
Technology used to achieve this goal
Oracle DBA, Oracle Developer, Unix Shell Scripting, Unix Systems Administrator, SQL, PHP, Javascript, Ajax, JQuery, PLSQL, HTML, PERL
Telstra wide Content Management System
I Installed and maintained the Database infrastructure for the Telstra wide Intranet Content Management System. I Installed and built the Unix servers which provided the backend storage infrastructure.
- 5 Unix Midrange Servers
- SUN Fire V480’s running Solaris 9
- I Installed and configured the Oracle Databases : Oracle 9i (Release 2): 9.2.0.1
I provided all of the Unix System Administration for these hosts (patching, replication, DR, etc) plus the Database administration and development.
I also created an active failover system which enabled us to perform system administration operations without inducing an outage. The hosts could be actively failed over to the remote replication hosts and failed back with minimal downtime (5 seconds) but not loss in data. This failover mechanism was written by me in Java which I installed and configured on the hosts
I also provided Database hosting on these servers for other groups and sections in Telstra
Technology used to Achieve this goal
Java, Oracle DBA, Oracle Developer, Unix Shell Scripting, Unix Systems Administrator, SQL, PHP, Javascript, HTML
Server Detection Scanner
Developed a Server detection tool
This product scanned the network for a known list of hosts and reported back their status and existence. This product is extensively used by the IT lifecycle group to monitor and report on host status for Billing and server de-commissioning purposes
Technology used to Achieve this goal
Visual Studio, C#, Oracle
Web Site Development
Developed various web sites for external customers using WordPress, PHP, Highlights of my work …
http://www.myafltips.com.au
There are other sites which I can provide on request
Technology used to Achieve this goal
Javascript, JQuery, MySQL, HTML
Other Projects of interest
- Developed a customer loyalty system for a book store.
- Developed a Number Plate Recognition System for Armoured Car Security Companys
- Created an Electronically controlled heater for a Jacuzzi
- Interactive Exercise bike (using similar technology as the Spa controller)
- Remote weather station using the PIC Microcontroller
- Web based home security camera
- Pulse width modulation controlled Electronic goCart for the kids.