Michael Rowe

Experience

• 

  Creative Business Systems Ltd

  May 1998 - Jun 2001

  Database Developer

  A client facing role with most work being carried out at client sites. Develop customised database, enquiry and reporting solutions across a large number of industries. Implement import/export interfaces to a variety of RDBMS systems. RESPONSIBILITIES• Database design and development• Definition and development of specifications• Develop reporting and enquiry tools in MS Access to assorted back-end RDBMS (Sybase, MSSQL, Informix, Oracle)• Customer support

• 

  Cleanflow Systems Ltd

  Jul 2001 - Dec 2004

  Senior Developer

  Core developer of companies’ primary software product. Covered entire SDLC from requirements and concept specifications through to code cutting, unit testing and release procedures.RESPONSIBILITIES• Develop UI design and specifications, develop database schemas• Software development and testing and provide software support

• 

  AgriQuality

  Mar 2005 - Nov 2005

  SQL Server Consultant

  Provide support for company DBA and carry out specific project based functions to evaluate/implement new technologies.RESPONSIBILITIES• Evaluate MS SQL Reporting Services• Develop Database Replication model for Virtuallab LIMS• Install ArcGIS components (SDE and IMS)• Migrate all database environments from SQL 7 to SQL 2000• Provide cover for SQL DBA during sick leave

• 

  AgriQuality

  Jan 2006 - Aug 2009

  SQL Database Administrator

  Monitor, maintain and develop the MS SQL database environment. Provide support for in-house development team, infrastructure team members and users.RESPONSIBILITIES• Installation, configuration, maintenance and administration of SQL Server 2005/2000• Upgrading SQL Server 7 -> 2000 -> 2005 (and application of associated patches and service packs)• Performance monitoring and issue resolution (query optimisation, tracing long running queries and deadlocks, SQL profiling)• Troubleshooting SQL issues raised by users and developers• Design and implementation of replication and log shipping solutions• Implementing jobs, maintenance plans and alerts• Testing database backups / restores against RPO / RTO• Managing security of servers and databases• Provide backup Windows Server System Administrator support Show less

• 

  AsureQuality

  Aug 2009 - Jul 2014

  Information DBA

  Develop and maintain core business support systems (Finance, HR, Payroll, GIS) and act as the key operational liaison for these systems. Lead projects to design and implement solutions that meet business requirements in accordance with company standards and policies. Maintain in-depth knowledge of Asurequality databases and database technologies to provide cover and support for SQL DBA (part-time).RESPONSIBILITIES• Ensure Information environment for Core Business Support Systems (Finance, HR, Payroll, GIS) is operating at its highest functional and technical capacity• Act as key operational liaison for Core Business support systems• Organise and Implement specific technical projects (scoping, planning, scheduling ,delegation and reporting)• Provide cover for SQL DBA role (weekly and over leave periods)• Identify enterprise-wide opportunities to improve information assets• Establish processes and controls to meet or exceed Operational and Compliance requirements• Produce clear, detailed requirements documents to be used by internal technical specialists and third party contractors• Design solutions and database structures to meet requirements in accordance with development and infrastructure standards and policies Show less

• 

  Asurequality Ltd

  Jan 2012 - Dec 2013

  IT Technical Lead (Secondment)

  SCOPEDeliver a Labware (COTS Laboratory Information Management System) IT Infrastructure solution that meets all performance, security, stability and availability criteria. Lead the IT team, external consultants and project team members in the design, planning, resourcing, costing, implementation, testing and documentation of this solution.RESPONSIBILITIES• Relationship management with clients, vendors, steering groups and other stakeholders• Communication across all levels of business• Development of project plans, detailed infrastructure designs, costing and resource planning• Management of implementation, scope, issues, risk and project financials• Design and management of performance testing• Development of operational procedures and documentation Show less

• 

  HUHTAMAKI NEW ZEALAND LIMITED

  Jan 2015 - Mar 2015

  Contract IT Support
• 

  Desktop Imaging Ltd

  Feb 2015 - May 2015

  SQL Contractor

  This contract involves the optimisation of their SQL environment and implementation of best practice guidelines. I am also assisting them with resolution of locking and deadlock issues, the development of SSIS workflows and reporting.

• 

  Simplicity CRM

  May 2015 - Mar 2019

  SQL Database Administrator / Developer
• 

  Waste Management NZ Ltd

  Apr 2019 - Oct 2019

  Contract DBA

  • Migration of SQL databases from version 2012 to 2017• Consolidation of SQL server instances (40% reduction to 22 instances)• Troubleshoot and optimise SQL High Availability Groups• Review SQL environment. Recommend and implement best practice for SQL