Senior PostgreSQL Consultant for Atlassian in Sydney, Australia (Full-time)
Atlassian is looking for a Senior PostgreSQL Consultant to work with our teams in Sydney, Australia.
Atlassian helps teams everywhere change the world through the power of software and we are looking for a part advisor, part database wizard to join Atlassian's Platform and Infrastructure team. We are building a new relational database competency who will provide in depth advice to our engineering teams on performance, reliability and operational best practice. This is the chance to get in at the start of the journey, with options in both leadership and technical expertise.
As part of this team you will spend you time working with products like JIRA and Confluence to design table schemas, optimise queries and observe how they behave at scale in our production environment. You will also work with our infrastructure teams to ensure that we have the visibility into everything the DB is doing, providing advice on metrics, thresholds and configuration parameters. We have standardised on RDS PostgreSQL, and would like to build deep expertise in this area.
More about you
On your first day you will be able to:
Glance over our monitoring dashboards and identify hotspots and focus areas
Look over the EXPLAIN output of a slow query and suggest improvements
Review our deployment in AWS and explain the high level architecture
Evaluate the schema from our applications and suggest improvements
Write SQL or scripts to pull out performance data from the DB that we did not already have
We would be super excited if you have:
A record of contribution to PostgreSQL or other open source DBs
8+ years of experience working as a professional DBA
Previous experience as a consultant or performance advisor