Senior Database Administrator

  • Company:
    THE ICONIC
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    16 hours ago
  • Category:

At THE ICONIC our mission is to deliver seamless and inspiring experiences for our customers and our people. We DREAM BIG through collaboration and innovation, and are supported to bring incredible ideas to life. We are a group of people believing in making a positive difference in this world and liberating our customers through the power of fashion and sports.

The team 

Our Tech Team is driven by innovation. Within our agile cross-functional teams, every person has a voice and skills which contribute to the development of amazing products that our customers use every day. They are focused on being fast and creative to bring the best technology to our customers, moving fast to push through MVPs and learn from data insights.

We have an amazing Data team covering Data Science & Analytics and Data Engineering, who are excited about the power of data, work closely together, support each other and who are capable of stepping up to any challenge. Our Data Science & Analytics crew works to solve complex problems on some of the most sophisticated algorithms to propel our business forward as their insights feed into our decision making; and our Data Engineering crew architect, build and maintain our business data architecture which makes up to date, high quality, high integrity, secured data available to internal stakeholders to support critical data-driven decision making.

The team is curious, value individual contributions and enjoy learning from each other.

What Success looks like

We are now looking for a Senior DBA who can take ownership of our SSAS Cube, AWS Datawarehouse and SQL Server High Availability Cluster. Our systems handle a massive amount of traffic, and with more than 5 million customers visiting theiconic.com.au each month, data is critical!

You will be working in an agile environment providing data dba and cube skills and experience to support THE ICONIC as a leader in the online retail space. The Current stack includes AWS (RedShift), GCP (BigQuery), SQL Server Analysis Services, Airflow, RStudio Server, Superset and Pentaho

Tech you will you’ll need to know:

  • SQL Server DBA
  • SSAS Cube 
  • AWS data experience
  • Visual Studio 2017 experience for Cube Development (or SSDT) 
  • Experience in ETL, Airflow and Pentaho; Data compression and partitioning; AWS Redshift; and Python for ETL would be ideal however not essential
  • What it takes! About you….

    You will need to come from a business data architecture / big data / DBA / data engineering / high volume data background, additionally, you will need to have:

  • Excellent written and oral communication skills
  • 5+ years experience in a similar role
  • 5+ years SQL Server DBA experience
  • 3+ years SSAS Cube experience
  • 3+ years AWS data experience
  • Experience with data models (Snowflake schema, star schema, data vault)
  • Strong query performance and optimisation experience
  • Strong SQL skills
  • SQL Server always-on / high availability
  • Managing Windows Clustered environment
  • Location and Key Extras

    This role is based in Sydney CBD with great transport, shopping and food districts all within close distance to Hyde Park for those who enjoy lunchtime exercise or just some fresh air! We also offer a number of extras including flexible working arrangements, generous employee discounts, birthday leave and loads of learning opportunities and support.

    Health and Wellbeing is extremely important to THE ICONIC, so interviewing and onboarding for this role will be conducted virtually due to COVID-19 and this role will temporarily work from home until further notice.