I worked in the software development, business intelligence, and IT support teams which allowed me to form relationships and liaise between these teams. Across these teams I administered databases, maintained and developed a .NET Ajax Web application, migrated databases and applications between on-premises and cloud-based environments including Azure, AWS (including RDS), and created Boomi processes to synchronize data between intelliHR, Active Directory and a Data Warehouse as well as… Show more I worked in the software development, business intelligence, and IT support teams which allowed me to form relationships and liaise between these teams. Across these teams I administered databases, maintained and developed a .NET Ajax Web application, migrated databases and applications between on-premises and cloud-based environments including Azure, AWS (including RDS), and created Boomi processes to synchronize data between intelliHR, Active Directory and a Data Warehouse as well as synchronizing data from Monday and Salesforce APIs to the data warehouse. I also provided general IT support for the Perth office. Show less

• Performance tuning of SQL Server 2014 / 2016 databases and ETL processes via data compression, partitioning and re-indexing• Achievements include migrating databases from SQL Server 2014 to SQL Server 2016, performance tuning and migration of a large real-time SQL Server database from a physical environment to a virtual environment with availability groups. Using availability groups, columnstore indexes, filtered indexes and compression to improve generation time for reports while also… Show more • Performance tuning of SQL Server 2014 / 2016 databases and ETL processes via data compression, partitioning and re-indexing• Achievements include migrating databases from SQL Server 2014 to SQL Server 2016, performance tuning and migration of a large real-time SQL Server database from a physical environment to a virtual environment with availability groups. Using availability groups, columnstore indexes, filtered indexes and compression to improve generation time for reports while also improving performance of other operations on the database, reducing blocking and minimising impact on data loading during critical time periods, maximising availability and minimising patching windows.• I also investigated performance bottlenecks and recommended areas for improvement Show less

• BAU administration of SQL Server 2005, 2008R2, and 2012 Databases• This includes scheduled and ad hoc backups, monitoring, performance tuning, and optimization• Monitoring of critical systems using Redgate SQL Monitor and DMVs and taking appropriate steps to eradicate bottle necks and improve performance based on observations• Creation of scheduled jobs to combine data from multiple tables overnight in order for routine queries to run more efficiently• Creation, maintenance… Show more • BAU administration of SQL Server 2005, 2008R2, and 2012 Databases• This includes scheduled and ad hoc backups, monitoring, performance tuning, and optimization• Monitoring of critical systems using Redgate SQL Monitor and DMVs and taking appropriate steps to eradicate bottle necks and improve performance based on observations• Creation of scheduled jobs to combine data from multiple tables overnight in order for routine queries to run more efficiently• Creation, maintenance, implementation and upgrading of ETL processes using SSIS• Migration of SSRS from SQL Server 2008R2 to 2012• Installation and configuring of SQL Server 2012 and SQL Server 2014 instances on clustered physical and cloud (Azure) environments• Configuring and maintenance of database high availability using Windows failover clustering and Always On Availability groups• Adherance to change management and release management through test and production environments using Front Range• Adherance to occupational health and safety processes such as risk assessment and reporting of hazards Show less

• Administration of SQL Server 2000, 2005, 2008, and 2012 Databases• This included backups, monitoring, capacity planning, performance tuning, and optimization both on a routinely scheduled and ad hoc basis as required• Monitoring of critical systems using Microsoft SCOM, SQL Server Profiler, and DMVs and taking appropriate steps to eradicate bottle necks and improve performance based on observations• Migration of databases from SQL Server 2000 to SQL Server 2005 and subsequently… Show more • Administration of SQL Server 2000, 2005, 2008, and 2012 Databases• This included backups, monitoring, capacity planning, performance tuning, and optimization both on a routinely scheduled and ad hoc basis as required• Monitoring of critical systems using Microsoft SCOM, SQL Server Profiler, and DMVs and taking appropriate steps to eradicate bottle necks and improve performance based on observations• Migration of databases from SQL Server 2000 to SQL Server 2005 and subsequently from SQL Server 2005 to SQL Server 2012• Introduction and maintenance of software coding standards and SQL Server security standards• Ongoing maintenance of SQL Server security so that users only had the minimum privileges required on the database• Collaboration with developers to design and maintain database schemas and queries• Disaster recovery and business continuity planning, testing, and documentation using VMWare and database mirroring• Producing reports for business divisions using stored procedures, Database Mail and Reporting Services• Consulting with project and web development teams on the implementation of new applications and modification of existing applications and the associated databases• Installation and upgrading of software requiring a SQL Server back end• Creation, maintenance, implementation and upgrading of ETL processes using SSIS• Developing user defined table functions in CLR to facilitate migration of data to a Business Objects datawarehouse and parsing of insurance claim data from emails to the SQL Server database• Assisting with the administration of Oracle 10g and 11g databases, providing cover for the Oracle DBAs when they have not been available. • Patching of Oracle Financials• Ensuring database availability met agreed business targets• Ensuring incidents and service requests were resolved within agreed business targets Show less

ASP and Microsoft SQL Server support and remediation for the State Intelligence Division of WA Police

Analysing, designing, and implementing a web solution to dynamically generate PDF documents on the fly for courses for TAFEWA. These applications are written in ASP.NET with a VB.NET code behind and a web service with a SQL Server backend. This involved adapting an existing solution using Word templates and documents produced in batches to use HTML templates that could produce documents in real-time