Database Administrator
Share
Job Location:
Monthly Salary:
Posted on:
Vacancies:
Job Summary
We are seeking an experienced and detail focussed Database Administrator (DBA) to join the Technology Innovation Group (TIG) to support the Atlassian Williams Racing database estate and provide support to users and application owners across the team. This role comes with a high degree of responsibility for critical databases supporting the Race Team Wind Tunnel Manufacturing and Design.
Working with the wider Data Team you will also support pipelining/ETL and development of our next generation Data Platform and ensure that data access is optimal at every level of the organisation as well as automate and integrate data across a diverse range of systems.
Main duties:
Provide support for mission critical databases supporting both our manufacturing and race operations functions ensuring 24x7 availability
Install configure and upgrade database solutions to support application teams across the organisation
Take a proactive approach to patching monitoring security and ensure best practices across an extensive database estate
Plan and execute database migrations for legacy on-premise databases to a modern cloud platform ensuring application compatibility and efficient cost management
Support the wider Data Team with pipeline development and ETL processes ensuring required data in all locations at the required latency
Support application teams during development to ensure performant database access and support best practice approaches
Automate routine tasks and maintain documentation for database configurations processes and procedures
Work with our partners providing out of hours support for databases
Design database solutions that are in line with long-term business objectives
Skills and experience required:
Bachelors degree in computer science Information Technology or related field (or equivalent experience)
Previous proven experience in SQL Server database administration (AWS RDS experience is desirable)
Production experience of running critical services on PostgreSQL
In depth knowledge of high availability approaches backup and recovery procedures as well as database performance tuning
Experience with PowerShell or other scripting languages for automation
Experience building and debugging database stored procedures triggers and functions
Experience of change management procedures and documentation of technical solutions
Working knowledge of Python and Spark is highly desirable (particularly in an AWS environment)
Experience of Kubernetes
Experience in SQL server availability groups and database replication
Understanding of ETL processes using SSIS or equivalent
Excellent communication skills and the ability to work individually and with a diverse range of stakeholders in a rapidly changing environment
Additional Information :
#LI-KW1
Atlassian Williams Racing is an equal opportunity employer that values diversity and inclusion. We are happy to discuss reasonable job adjustments.
Remote Work :
No
Employment Type :
Full-time
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
114 race victories in Formula 1, nine times Formula 1 Constructors Champion, seven times Formula 1 World Drivers Champions and the only team to have won in F1, 24h Le Mans and British Touring Cars. A proven track record that sets Williams Racing apart from the competition. Our unique ... View more
