Alfred Ticman Email & Phone Number

Porirua, Wellington, Nz

Wellington, New Zealand

• Deploy Landing Zone in Client’s tenancy using IaaC based on agreed architectural design with the client. • Migrate Clients on-premise Windows and Linux servers to Azure Cloud. • Review Clients Landing Zone and Azure Cloud tenancy. • Part of developer team\squad that develops, update\upgrade and maintain CCL’s internal product for deploying Landing Zone and Azure resources. • Building infrastructure resources in Azure platform based on project requirements• Provide advise in any Azure-related issues and designs internally• Support clients in their BAU coding for infrastructure as a code update and platform as a code deployments.

Wellington, Wellington Region, New Zealand

• Building infrastructure resources in Azure platform based on project requirements • Pioneering Terraform CICD pipeline to standardized infrastructure deployment in Azure in accordance to infrastructure as a code policy of StatsNZ • Working with architects and developers to design and implement new technologies for StatsNZ such as Azure Kubernetes, Data Factory, Data Lake, and Solr • Working with the security team to assess and implement security standards • Migrating legacy servers to Azure IAAS • Maintaining operational control and management of Business Intelligence Systems • Working with developers on performance issues and tuning offensive query. • Working with security team to ensure the database instances and database servers are not vulnerable to attacks. • Planning, coordinating, and implementing security measures to safeguard data. • Acting as a mentor and advisor to colleagues as well as team members on DBA experiences as well as project POC for new technologies

Wellington & Wairarapa, New Zealand

• Involved in database upgrade projects (in place or parallel) and migrations to higher version of SQL server.• Involved in data migration through SSIS and BCP from one SQL database server to another.• Involved in automating the creation of DB maintenance SQL job via command line as part of Automation projects.• Involved in creating enterprise wide Database growth report using SSRS for capacity planning purposes.• Involved in creating integration scripts to gather DB disk utilisation, top sql queries based on CPU and IO usage as part of monitoring projects. • Acted as consultant and support for project managers with regards to SQL licensing.• Migrated / Archived old Sybase databases to MS SQL 2012 • Migrate on-premise SQL Server databases to Azure (PaaS) SQL DB and SQL Server on Azure VM (IaaS).

Wellington & Wairarapa, New Zealand

• • Decommissioned SQL Server 2008 and migrated\upgraded databases to SQL 2012.• Builds and maintains FNZ SQL Server database environments in physical server (stand alone or geo clustering) or Virtual Machines and ensure that FNZ standards are applied.• Involves in projects for new clients from client demo to production deployment. • Reviews existing SQL Server environments in compliance with FNZ standards and audit reviews.• Works with Security team for potential security vulnerabilities. • Updates maintenance scripts to be more flexible and suitable for different environments.• Supports, troubleshoots and deploys SSRS reports. • Troubleshoots Application and DB performance issues and work with application supports and developers.• Does on-call for weekend releases and support production issues for APAC region.• Updates Database related documents and outdated processes for report deployment.• Monitors and creates logshipping using Litespeed for Disaster Recovery and Support Environments.• Maintains • Tests disaster recovery capability by restoring back ups from tape, failing over geo cluster SQL instances from one data center to another and by switching the passive databases to active through logshipping.

Wellington & Wairarapa, New Zealand

• Decommissioned old version of SQL Server such as SQL 2005 and 2008, migrated and upgraded databases to SQL 2012.• Sets up SQL server standards for the company.• Plans, setups and maintains Disaster Recovery environment for critical SQL server databases. • Automates the creation of DB maintenance job via command line as a part of automation process for System engineers.• Updates SQL and application release note document.• Sets up reporting services and creates report for database growth for capacity planning• Maintains operational control and management of the Relational Database and Business Intelligence systems.• Manages problems and create quality outputs.• Uses standard management tools and processes to carry out all defined housekeeping tasks.• Plans, coordinates and implements security measures to safeguard information against accidental or unauthorised damage, modification or disclosure.• Manages Changes via Change/Release Management process• Follows operational security policies, processes and procedures.• Creates scripts for gathering data from different application database for IT hardware, application and database cataloguing and monitoring in MSD.• Migrates and upgrades Sharepoint foundation from SP 3.0 to SP 2013.

Wellington & Wairarapa, New Zealand

• Maintains operational control and management of the Relational Database and Business Intelligence systems• Maintains disaster recovery environment.• Manages problems and create quality outputs• Uses standard management tools and processes to carry out all defined housekeeping tasks• Plans, coordinates and implements security measures to safeguard information against accidental or unauthorised damage, modification or disclosure.• Manages Changes via Change/Release Management process• Follows operational security policies, processes and procedures.• Improves the existing DB growth and Server disk utilization reports.

Singapore

• Does set ups and migration for cluster and non-cluster environments for MSSQL 7.0, MSSQL 2000, MSSQL 2005, MSSQL 2008 and MSSQL 2008R2.• Does set ups and migration for physical servers to virtual servers (VMWare) for MSSQL 2005, MSSQL 2008 and MSSQL 2008R2• Manages all SQL server licensing for all SQL server databases in Starhub under the Information Service department.• Acts as consultant and support for project managers with regards to SQL licensing and database designs for new projects.• Manages and support RDBMS for transactional and reporting requirements of Starhub’s business.• Manages and monitors databases under different platform versions of MSSQL from 7.0 to 2008 R2• Creates monitoring tool for database disk utilization and top SQL queries based on CPU and IO usage.• Sets up and maintains the communication between MSSQL and Oracle as per application needs.• Does research and test for the improvement of existing databases.• Creates and proposes database security guidelines to security team.• Coordinates the upgrade plans for all Platform End of Support life for platform version Upgrade.• Conducts tests and implements security hardening on all cluster and non-cluster SQL Servers.• Installs different versions of cluster and non-cluster environments of MSSQL Servers as needed (on a project basis).• Plans, sets up and maintains Disaster Recovery environment for critical SQL server databases.• Performs database re-structuring.• Tests and Installs the latest Service Pack of MSSQL 2005, MSSQL 2008 and MSSQL 2008R2 in all the databases either cluster or non-cluster, physical or virtual servers.• Supports users\developers in their test and production problems.• Maintains proper documentation of database configuration and upgrades.• Provides on-call support for database related problems.

Singapore

• Manages and monitors RDMS of existing clients.• Installs different versions of MSSQL Servers as needed by the clients.• Performs Health Check in all production, UAT and development servers every 6 months.• Implements client’s standard database and security hardening settings in all existing and new production, UAT and development servers.• Assists developers in their UAT database environment needs. • Promotes new application programs in production.• Performs data patching as requested by the client.• Performs database re-structuring as requested by the client.• Migrates client databases from MSSQL 7.0 to MSSQL 2000.• Installs the latest Service Pack of MSSQL 2000 in all the clients’ databases.• Installs and prepares the databases for the disaster recovery exercises.• Assists the DR Team in case there will be a problem in the database during the disaster recovery drill.• Provides on-call support for database related problems.