Glenn Welsh Email & Phone Number

Perth, Western Australia, Australia

Perth, Western Australia, Australia

• Primary responsibilities included administering and maintaining Production, Test and Development SQL Servers in a fully virtualised environment (VMware using 2 primary ESX hosts). 50+ SQL instances.• Heavily involved with the implementation of the business’s new ERP MinePoint (built on the Dynamics AX platform). Worked closely with Business Analysts to resolve any pre and post implementation issues.• Provided 24/7 technical support dealing with priority 1 & 2 incidents ensuring a high level of availability for all SQL environments. • Completed all SQL Server (2008 r2) installations across all environments as required. • Performed BAU Database Maintenance tasks – Security Admin, Database Monitoring, Backups & Restores (using Avamar disk backup system), Space Management, Resource Utilization, responsible for performing object migration between all test, UAT and production database servers.• Excelled in troubleshooting database performance issues and tuned database objects. Set up traces and Profiler to troubleshoot performance issues. Analyzed deadlocks & diagnosed issues on the server and configured SQL Server as required.• Worked closely with internal application developer to resolve long running query issue which was causing end of month processes to fail. Through a combination of rewriting SQL code and setting SQL’s max server memory options we were able to reduce the specific processes to sub 3 minutes (a fraction of its original running time). • Worked closely with external contractors to resolve Application/Database performance related issues. Managed and worked with Junior DBA involved in a database migration project.• Provided consulting to internal Application Developers in the following areas: Database Design, Programming techniques, Application performance tuning, Data conversion and loads, Recovery of data after system, application and media failure.• Responsible for all Microsoft AX Dynamics code, SQL and SSRS deployments into Production.

Perth, Western Australia, Australia

• Initial 3 month contract (extended)• Support DBA – Primarily involved with BAU day to day tasks at Health WA. In excess of 150 SQL instances shared between a team of 3 SQL Server DBA’s.• Also part of a 24/7 On-call roster to deal with mission critical incidents – Rostered on once a month. • Performed day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups & Restores (using Tivoli tape backup system), Space Management, Resource Utilization, responsible for performing object migration between all test, UAT and production database Servers.• Supported multiple SQL Server 2000 / 2005 / 2008 databases in both clustered and non-clustered environments with replication/DTS extracting data from ORACLE databases etc. Performed troubleshoot procedures with issues within a clustered server configuration.• Installed UniVerse(U2) drivers on SQL Servers and completed linked server setup for data migration from legacy systems.• I also worked closely with 3rd party vendors to resolve Application/Database performance related issues.• A number of these server instances were running on windows server 2003 and 2008 VM farms. Part of my role was the administration and maintenance of these SQL SERVER environments.• Whilst at CBH I developed a command line program(using RSScripter) to assist in the deployment of SQL SERVER reporting services reports, created by report developers to migrate SSRS reports into TEST environments. This proved to be a very successful and well-utilized tool.

East Fremantle, Western Australia, Australia

• 3 month contract (extended)• Primarily involved in the management of the University’s SQL Server 2000/2005 – 2008 Migration Project.• Responsible for setting up new database servers (using SQL custom templates) within a Virtual server environment and migrate the legacy SQL server database’s to SQL SERVER 2008.• Created SQL templates to allow for fast and repetitive deployments of SQL environments.• Implemented full maintenance plans for the University databases including database integrity checks; full and transaction log backups and maintenance cleanup. Scheduled to run daily.• Implemented Log Shipping between the Fremantle and Sydney DR hosts. Log shipping being the preferred DR model for the University’s requirements.• Migration project completed successfully in early July.

Duncraig And Carramar

• Full maintenance and administration of the School’s SQL Server Databases.• Implementation, operation, maintenance and development of the school’s authoritative data management systems (MAZE & Synergetic). Initial primary function was to manage the migration of the schools admin system from MAZE to Synergetic, which was successfully completed in September of 2009.• Managed and involved in Synergetic Training sessions for staff at both campuses. • School’s management Systems (Synergetic & MAZE) Administrator.• On-going Development of crystal reports and user forms for the various areas within the school, including both academic and administrative.• Primary contact with CDA & RM Asia Pacific (Developers of the school’s admin software) for the resolution of software related issues etc.• Identified and assessed user requirements to develop prototype specifications (if work needed to be carried out by CDA or any external party).• Synergetic Support within the school for any user related requests or issues.• Directed and managed part time database support officer.• Attended 2 day Synergetic Administrators course in Melbourne to fulfill school’s synergetic training requirements.

Technology Park

• Full System maintenance and development of the current tyre management system including ASP, ASP.Net and 3rd party reporting software. • Database (SQL SERVER) Administrative duties for Production & Test environments including maintenance, tuning, performance and troubleshooting.• Database Design and Development work.• Microsoft Certified Partner administrative duties.• Microsoft Exam preparation.• Liaising with external parties for current system improvements.• Provide technical guidance and assistance to Snowden.

Perth Cbd

• Contracted to develop several intranet applications• Design, development, testing and maintenance of numerous application solutions for the department’s intranet environment. Branch Project Manager for multiple projects across various areas of business within the organization.• Responsibilities include providing technical advice to system owners and technical assistance to junior programmers.• Working with non-technical staff to refine user requirements.• Identifying opportunities for streamlining applications and leveraging data integration opportunities; and• Optimizing screen design/user interface and report design.