Experience
Contract Business Solutions Engineer
* SQL Server database admin and consultant sub contracting to clients
* Support other consultants with project management skills
* Process development champion
* Xero reconciliations, bill payments, invoicing
* Projectworks projects, invoicing, quoting, configuration
* Created onboarding process for other contracted consultants
* Created consultant contracts
* Created client connectivity documentation
* Created marketing material
* Created consultant profiles
* Critical and Creative thinking during team huddles
* Upskilling in Azure - Database, DevOps, Purview, Policy
* Upskilling in Power Platform - App, Automate, BI/Fabric, Dataverse, Data Factory
* Upskilling in Make Automation Platform
Data Analysist
* Provide insight to the development and reporting teams regarding how data was consumed by Directors, Team Managers, Project Managers, Consultants, and external Clients.
* Propose changes to sources systems for better understanding of the data stored.
* Collect requirements from the business for reporting needs and translate them into stories for the team to build and implement.
* Created a repeatable process using SQL scripts and Excel Spreadsheets to perform audits of current data stores (JIRA Reports, Folio, Oracle database, MySQL databases)
* Performed the audit task and investigate discrepancies identified in reports and data.
* Used JIRA to document findings for the development teams to resolve.
* Keep track of data exposed to users to ensure security policies were upheld.
* Track source systems that are part of data governance policies to ensure compliance to industry best practices.
* Used Atlassian SCRUM and Kanban boards to manage workflows.
* Run daily standup calls and weekly sprint meeting.
* Ensured user stories were size appropriately, clear, linked, prioritised, and followed best practices.
* Peer review client and business Tableau reports and underlying queries to ensure the reports were displaying correct data and for the intended audience.
* Provide feedback on the useability of the report and suggest changes to layouts to ensure reports were consistent and in accordance with business policies.
* Ensure the business data was monitored, maintained, optimised and recoverable.
* Ensure underlying data warehouse systems were monitored, correctly configured for reporting purposes and internal documentation updated accordingly.
Reliability Team Manager
* Developed team member onboarding handbook.
* Developed Acting Team Manager Handbook.
* Developed team process guidelines to ensure quality and set expectations within the team and business.
* Performed weekly 1-1 video calls with globally dispersed team members, Technical Project Managers and Directors.
* Participated in weekly client stand up calls with internal teams and clients.
* Prepared meeting agendas and delivered call summaries.
* Wrote and delivered team performance reviews.
* Worked closely with clients to bridge the gap between technical and non-technical clients.
* By the minute time recording.
* Audit team member logs for quality, added value and efficiency.
* Allocated skilled resources for multiple projects running concurrently and across multiple technical teams.
* Ensured tasks progressed, quality of work was high, time spent on budget and delivery time targets met.
* Set expectations with Client facing Technical Project Manager regarding policy, process, and availability.
* Projected and planned globally dispersed resources for project(s) up to three months in advance taking into consideration vacation needs, on call rosters and unplanned events.
* Worked with HR manage team performance issues.
* Worked with Talent Acquisitions to acquire consultants that enhanced the existing team.
* Set team KPI’s and supported individuals to achieve them.
* Set up personalised training plans and career progression processes.
* Use technical, business policy and process, and client knowledge to support team during investigation, documentation, route cause analysis, reporting and delivery of RCA of an incident.
* Performed Managerial and Client Escalation On-call 24x7x365.
* Use technical, business policy and client contract knowledge to support team members during an incident.
SQL Server Database Consultant
* Performed the role of Production Database Administrator for between 15-30 managed services client at a time.
* Install and maintain the performance of SQL Server database servers.
* Develop processes for optimizing administrative tasks.
* Insured database and servers were configured to best practice/industry standards.
* Manage database access.
* Supported DR and HR incidents.
* Performed performance tuning of database.
* Install, upgrade, and manage database.
* Performed daily, weekly, and monthly maintenance tasks.
* Diagnose and troubleshoot database errors.
* Create and manage database reporting.
* Create automation for repeating database tasks.
* Participated in on-call support roster.
* By the minute and 15-minute time recording.
* Created and maintained client and team documentation.
* Assisted Team Lead with managerial tasks including on-call escalation.
* Developed and maintained team roster.
* Worked within a globally distributed multi-cultural team.
* Worked on financial, medical, training, GDPI governed database systems in Canada, US, UK, NZ and Australia.
* Assisted with the onboarding of new clients and team members
Database Administrator/Senior Consultant/Technical Team Leader/Trainer
* Performed the role of Production Database Administrator for between 15-25 managed services client at a time.
* Install and maintain the performance of SQL Server database servers.
* Develop processes for optimizing administrative tasks.
* Insured database and servers were configured to best practice/industry standards.
* Manage database access.
* Supported DR and HR incidents.
* Performed performance tuning of database.
* Install, upgrade, and manage database.
* Performed daily, weekly, and monthly maintenance tasks.
* Diagnose and troubleshoot database errors.
* Create and manage database reporting.
* Create automation for repeating database tasks.
* Participated in on-call support roster.
* 15-minute time recording.
* Created and maintained client and team documentation.
* Developed and maintained team roster.
* Worked on financial, medical, training, utility database systems in NZ and Australia.
* Assisted with the onboarding of new clients and team members
* Developed team processes.
* Trained junior DBA's.
* Performed onsite consulting.