Asher Rankin

Contact
  • Website
  • http://rankin.co.nz
  • Email
  • asher@rankin.co.nz
Work Experience

2019-03-01 till today

Database Administrator at B Braun Group:

Database Administation in an environment comprising SQL Server, SAP HANA/ASE + Oracle.

I am responsible for managing 2000+ databases and stabilising our global environment while pursuing continual improvement.

Before joining the company, they were experiencing repeated outages due to lack of monitoring and poor implementation of maintenance tasks.

I sought to modernise out infrastructures maintenance and implemented a more intelligence index maintenance activity and resized TempDB to a sufficient size which has resulted in a significant reduction in downtime.

As part of a global team that was suffering from lack of communication, I implemented triggers which monitored activity within our Central Management and VisionApp databases in order to create a weekly report to gain more overview of system changes.

Before we had monitoring in place, I developed a stored procedure to monitor free-space within our Datafiles and Log-files, this resulted in a significant reduction in time spent on menial tasks.

Assisted with the deployment and configuration of our new open-source monitoring solution: CheckMK and GrayLog log monitoring with MSSQL plugins.

Troubleshooted a continually growing MDW data-warehouse and fine-tuned our purge and rention policies.

Developed a weekly report implemented as a stored procedure which reports on misconfigured policies within our environment.

Improved our powershell installation scripts to automatically restore our DBA database and automatically configure TempDB sizing.

Migrations of legacy SQL systems.

Updated server template to correct separation of data-files.

Performance tuning for replicated systems suffering performance degradation.

Creation of reports for monitoring replication performance & blocked TSX jobs.

Undertook SAP BW/BO training.

2017-07-01 till 2018-11-01

Database Administrator (BI/DW) at Merivale:

Within this role I was responsible for company wide BI Reporting, Data Engineering as well as Database Administration

Created static and automated data pipelines to ETL for various reporting databases.

Installation and configuration of SQL Reporting Services.

SSRS report development and administration.

SQL/ETL development (Custom scripts, GoAnywhere, Attunity Replicate & SSIS)

Built and deployed C# application that ingested CSV data and transforms to bulk import point-of-sale format to allow business to mass import new products.

Report and dashboard development

Ad-hoc SQL reporting

Power BI reports (desktop and cloud) and dashboards

Crystal Reports 2013 development (Ungerboeck).

Database Administration of several production and development databases.

(SQL Server 2008 R2, 2012, 2017 On-prem & Azure)

SQL transactional replication

Installation and configuration of SQL Server instances

Monitoring and Alerting

Performance tuning and maintenance

Disaster Recovery

Database Security - Active Directory

2016-04-01 till 2017-03-03

Data Manager at ClassRepublic, Ltd.:

Eduational startup

Primarily involved with Managing off-shore resources, data manipulation, validation, data stewardship. Database management of MySQL instance.

2015-03-01 till 2015-07-31

Oracle Data Warehouse Developer at BetFair/ServusTech:

Contracted to BetFair's Romanian development centre during their transition from Oracle to Amazon Redshift. I assisted with the process of documenting, reverse engineering and development of their existing PL/SQL stored procedures to RedShift, as well as performance tuning PL/SQL.

Oracle Database 11g / Data Warehouse development

Amazon RedShift Development

PL/SQL Development

PL/SQL Performance Tuning

Postgresql development and performance tuning

SAP BusinessObjects Reporting

Tableau Training

2013-02-01 till 2013-12-31

Oracle BI Consultant at James and Monroe, Pty Ltd:

Business Intelligence Development and Systems Administration focused role.

Oracle Business Intelligence (OBIEE) consulting.

Main clients NZ Government agencies, and blue-chip clients (NZ/AU).

Installation and configuration of Oracle Database 11g &

Oracle Business Intelligence Enterprise Edition,

ETL development with Informatica Powercenter,

Dashboard and Report Development (OBIEE),

Oracle Hyperion financial report development.

Systems Administration/Infrastructure: Development of host Windows Server (incl configuration of VDI/DHCP/DC/IIS) administration, development and configuration.

2012-06-01 till 2013-02-31

Technical Consultant at Business Mechanix, Ltd:

Technical Consultant deployed to a multitude of different client projects including:

Oracle Database Administration 10/11

SQL Server Database Administration

Microsoft Dynamics CRM 2011 Development (Plugins, Workflows)

Sharepoint,

Azure C# Web Design & Development w/CRM Customer Portal customisation,

Windows Server 2008 Administration

2008-12-01 till 2009-03-01

Intern Software Developer at Unleashed Solutions, Ltd:

Primarily responsible for data modelling and documentation

Reverse engineered existing undocumented MS SQL Server database.

Created highly detailed documents and data models to enable management to gain a more coherent understanding of their current systems.

Data modelling for an efficient SaaS database schema to enable the successful deployment of SaaS ERP system (Unleashed).

Data modelling for SaaS database schema for a family portal system (Dazed & Confused).

Education

2009-03-01 till 2010-03-01

University of Otago - Dunedin, New Zealand

PgDipCom: Information Science

2005-03-01 till 2009-03-01

University of Otago - Dunedin, New Zealand

BCom: Information Science

Skills

Languages: ANSI SQL, T-SQL, C#, Stored Procedures, PL/SQL, Java

Tools: PowerShell, Git, SSRS, SSMS, SQL Operations Studio, Visual Studio 2017, PLSQL Developer, Toad, Power BI, OBIEE 11g, Crystal Reports 2013, Tableau

Databases: MSSQL 2008 R2 - 2017 (azure + on-prem), SAP ASE 16, Oracle 10g/11g, MySQL, AWS RedShift (PostgreSQL).

Languages
  • English
  • Native speaker
  • German
  • Elementary proficiency
  • Polish
  • Elementary proficiency