Database Engineer

Working at Transurban is different; it’s a place where you can see the benefits of your work play out in real life, every day. We create city-sized solutions—building and operating safer, smarter, and more sustainable roads—to solve pressing transport challenges that are slowing cities down.

About the role

We’re seeking a Database Engineer to be responsible for maintenance and support of the Transurban database environments. The environment must deliver capability and performance that is aligned to business expectation of service levels, compliance, and risk. The Database Engineer will also be required to work on various project deliveries as directed.

You’ll join an innovative and collaborative team to provide 2nd and 3rd level support for the service desk and desktop support teams, and as there are many critical and high availability systems in use at Transurban, the incumbent may be required to provide business hours support, and on-call 24x7 support as directed for these crucial systems.

As our Database Engineer, you’ll contribute to lasting and positive changes that shape the future of our cities and communities. It’s meaningful, challenging and exciting work.

Day-to-day, you will:

· Manage production systems availability to meet or exceed agreed SLAs.

· Manage test and development systems availability to agreed SLAs.

· Manage systems performance and capacity requirements ahead of expected business growth.

· Provide 2nd and 3rd level support for Infrastructure incidents. Manage logged incidents to meet SLA objectives.

· All Incidents are logged in the IT Service Desk system and are maintained with accurate, complete, and up-to-date information.

· Participate in DR activities as required, including documentation of DR Planning, Recovery, and potential Improvements for future exercises.

· Threat and risk analysis is performed against any relevant vulnerability.

· Focus on operational efficiency, by looking for development opportunities to improve processes and workflow in the environment

· Perform after hours work as required and perform 24x7 on-call duties on a rostered basis.

· On-call Incidents are logged in the IT Service Desk system.

· Major after-hours incidents are appropriately escalated.

This role will suit someone with a curious mind and transferrable skills and experiences, including:

· Extensive experience in installing, configuring, and maintaining high availability databases.

· Expert in server database administration and development functions, including performance tuning, DB backup and recovery, capacity planning, replication, high availability, monitoring using SQL Server Management.

· Understanding of Service Oriented Architecture (SOA) and its application in the Oracle product suite

· Understanding of Data Warehousing and ILM principles

· Understanding of Web based technology and solutions

· ITIL foundation version 3

· Computer Science or related tertiary degree

· For Oracle and related databases and technologies, extensive experience in;

o Oracle RDBMS versions (12c onwards)

o Oracle backups (RMAN and scripted).

o Oracle Data Replication techniques - DataGuard, GoldenGate

o AIX and RHEL operation and working

o Oracle 12c/13c Grid Control (OEM)

o Oracle Database Certification

o SQL, PL/SQL and Shell scripting

· For SQL Server and related databases and technologies, extensive experience in;

o Microsoft SQL Server versions (2012 onwards)

o Database HA and DR technologies (Clustering, Mirroring, Log Shipping, AlwaysOn)

o Windows Server Administration, Active Directory, DNS, VMWare.

o MCTS, MCSE, MCSA or equivalent certification.

o SSRS, SSIS and SSAS development and support.

o SQL, TSQL and PowerShell scripting

· For Cloud based databases and related technologies, extensive experience in;

o AWS Architecture and operations

o AWS RDS, Redshift, PostgreSQL

o Data warehousing and ETL processes

o Big data and analytics tools

o Python, PHP and Shell scripting

If you meet some of these requirements, but not all, we encourage you to submit your application.

With a career at Transurban, you’ll enjoy a range of benefits, including:

· A range of flexible working and leave options, including the option to purchase an additional six weeks of leave each year

· 16 weeks paid parental leave (regardless of gender or carer status), with no waiting period, with Superannuation paid during unpaid leave as well

· Learning and development opportunities to support your career interests

· Health and wellbeing support—access to Headspace and our EAP program, wellness facilities, and more

· Share offers and insurance benefits

· Social activities, community give-back programs and paid volunteer days

We offer a range of flexible working and leave options, so you can balance your work and life commitments and interests. Have a conversation with us about how this could work for you.

We embrace diversity with a foundation of safety, wellbeing and inclusion; where everyone belongs. We treat everyone with fairness, consideration and respect, regardless of gender, gender identity, marital or family status, sexual orientation, age, ethnicity, religious beliefs, cultural or socio-economic background, perspective, and experience – whether they work for us or not. We want to ensure everyone feels comfortable and safe to express ideas, questions and concerns.

We strongly encourage applications from candidates of diverse backgrounds and lived experiences, including Aboriginal and Torres Strait Islander people and people living with disability. If you require any adjustments or support during the recruitment process, please contact us on .

Ready to help us keep cities moving? Apply today.

Job Type:Permanent

Closing Date:02-July-2024 0:00

Please note: The closing date reflects the time zone of the Primary Location for this job posting.

Primary Location:Melbourne CBD & Inner Suburbs Melbourne VIC

R010742