SQL Database Admin/power BI Analyst

**Introduction**:
At Lite n' Easy our goal is to create a healthier Australia by changing the way Australians eat. We make it easy for people to eat well, whether they want to lose weight or simply stay healthy. As a quality driven food company, all of our creative energies go into making our meals as delicious as they are healthy.

**Description**:
Due to continued growth within our business we currently have a position for an SQL Database Administrator / Power BI Analyst to gather and deliver insights that will lead business intelligence solutions.

**The Role**:
As the successful applicant, you will have a recognised tertiary qualification in an IT or Computer Science related field, and ideally have:

- A minimum of 5 years’ experience in a data analyst position and experience with report creation, modelling and trend forecasting
- A strong background in Microsoft SQL
- Proficiency in MS Word, MS excel and PowerPoint
- Skills in statistical and econometric modelling, quantitative analysis and technological data mining and analysis techniques
- Upgrading, configuring, and troubleshooting of SQL SERVER on Windows 2016/2019 servers and Clustered VMware Environments
- Expertise in database back-up, restore, and recovery, and in updating statistics, rebuilding and reorganizing indexes, defrag tables, replication, linked servers and database maintenance plan
- Monitoring instances, configuring and enabling alerts using PRTG
- Expertise in Transact SQL, SSIS, SSRS, SSAS, SQL Broker Services, Filestream
- Experience in query optimization and performance tuning
- Experience in using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
- Good knowledge in using DMVs and DMFs to find and solve performance issues
- Expertise in disaster recovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional)
- Implementing High Availability in SQL 2016/2019 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering.
- Visualisation tools such as Power BI/Tableau

What’s In It For You?
- Free secure onsite parking
- Access to our onsite wellbeing centre:

- Free gym with equipment as good as your local gym
- Free personalised fitness plans
- Free gym classes (Zumba, Circuit, Yoga and Core)
- Free onsite doctor (general health checks, Flu shots, skin checks)
- Free ongoing professional training opportunities - Certificate III in Food Processing, plus other accredited internal and external training opportunities to develop your personal skills
- Excellent discount on our food products for you and a family member plus daily discounts at our onsite canteen
- You can shoot some hoops or play some table tennis on your break
- Annual Themed Events - Melbourne Cup, Easter Coffee Cart, Family fun day at a theme park, Christmas gift card, Christmas Ham/Fruit box (after 3 years of service)
- We recognise and reward our team for being awesome

You must be an Australian Citizen or Resident to apply.