Job Requisition ID: 33321
- Work in a highly innovative and transformative business
- Salary packaging – to suit your personal and financial circumstances
- Work in a highly innovative and transformative business
What will your typical day look like?
As a database administrator, you will be involved in:
-
- This role is joining a team of SQL Server DBAs working in a fast-paced environment
- Providing database administration support for both BAU and projects
- Ensuring database environments are managed in line with defined practices
- Ensuring database environments are secure, recoverable and well maintained
- Responding to and resolving tickets within SLA’s
- Participating in meetings both internal within ITS & with our key business stakeholders
- Committing to and delivering on project deliverables
About the team
The DBA team are part of Enterprise application services within the IT business unit, with six DBAs based in Sydney, they are a very friendly supportive team working in a fast-paced environment.
The work is administering databases for the Australian firm, not directly for the firm’s clients. The majority of SQL Server on premise is SQL 2019 with some SQL 2017/2016 along with Azure SQL, Synapse, ADF and ADLS with an increase in support work on the cloud data platforms moving forward.
The work involves a mix of BAU/Operational and project work including but not limited to actioning ServiceNow incidents/tasks/change requests, patching, password rotation, encryption, deployments, performance tuning, configuration, SQL/PowerShell scripting, least privilege role definitions, data masking, capacity planning, backup/restores, monitoring, troubleshooting issues, providing guidance to developers, adhering to compliance controls
Enough about us, let’s talk about you.
You are someone with:
-
-
- Minimum 5+ years as a Microsoft SQL Server database administrator
- A proactive team member who takes initiative and will take ownership of tasks works with minimal supervision
- Expertise in installation, database server builds, applying patches, upgrading, configuring, trouble shooting of SQL SERVER 2016/2017/2019/SQL Azure
- Strong SQL scripting skills
- Experience with PowerShell scripting for automation
- Highly skilled at troubleshooting with a focus performance tuning
- Proven knowledge and experience in configuring solutions - AlwaysOn Availability Groups, Log shipping, Failover clustering and transactional replication
- Hands on experience with database encryption
- Must be security focused with experience in ensuring adherence to least privilege access controls
- Experience with data masking and privatisation
- Experience participating in disaster recovery testing
- Good knowledge in administering PowerBI, SSRS, SSIS, SSAS, ADF, Synapse
- Experience in a SQL DevOps/Continuous delivery environment highly desirable
- Experience with AWS/MongoDB/PostgreSQL database administration desirable
-
Why Deloitte?
At Deloitte, we create positively differentiated work experiences that enable our people to feel valued and achieve their full potential. Deloitte Australia opens the door to a career that can cross borders virtually and physically across Asia Pacific to gain experience and access projects beyond Australia’s borders. We value difference, and embrace people with diverse backgrounds, experiences, gender identities, abilities and thinking styles. Knowing that people work best in a variety of ways, we are happy to discuss alternative arrangements if the working pattern you are looking for is not specifically indicated.
We’re committed to continually building a safe and respectful workplace, where all our people feel appreciated and accepted. Through the creation of endorsed employee-led diversity networks which promote cultural, disability, LGBTI+, Aboriginal and Torres Strait Islander people and gender equality, we’re leading the way to shape an environment where everybody can thrive.
We are proud to have been recognised for our efforts in inspiring change and accelerating progress – check out our careers site for recent recognition in this space.
Next Steps
Sound like the sort of role for you? Apply now.
By applying for this job, you’ll be assessed against the Deloitte Talent Standards. We’ve designed these standards so that you can grow in your career, and we can provide our clients with a consistent and exceptional Deloitte employee experience globally. The preferred candidate will be subject to background screening by Deloitte or by their external third-party provider.