Senior Database Administrator

Job Description - Senior Database Administrator (0000B99L)

Senior Database Administrator - 0000B99L

• Ongoing Full-Time

About us

The NSW Police Force (NSWPF) is one of the largest police forces in the western world, with more than 20,000 employees, including more than 4,000 administrative employees who support the sworn officers that provide a range of law and order services 24 hours a day, seven days a week to the socially, geographically and culturally diverse community of NSW.

About the role

Senior Database Administrator is part of the Database Support team within Technology and Communication Services Command. The Senior Database Administrator is responsible for planning, designing, supporting and maintaining the organisation's ICT database systems to ensure secure access and availability in accordance with business needs. This role provides 24x7 support for NSWPF's mission critical database systems across multiple database technologies, ensuring the performance, availability and security of database platforms.

Key Responsibilities of the Role

• Perform day to day support and administration of Informix and Oracle database systems, ensuring stability and reliability.
• Participate in on call roster to provide 24h/7d support.
• Plan, schedule and apply database patches, upgrades and routine maintenance activities.
• Diagnose and resolve complex database issues promptly; escalating unresolved problems to vendors to minimize downtime.
• Monitor database performance and implement tuning strategies to optimize system efficiency.
• Provide technical support for incident resolution and problem management.
• Support and participate in disaster recovery planning, testing and execution.
• Implement and maintain robust backup, recovery and disaster recovery procedures.
• Maintain system documentation, standards and procedures.

Preferred Qualifications

• Extensive experience in day to day management and administration of Informix and Oracle database systems.
• Experience in planning, implementing and managing Informix RSS and/or Oracle RAC/GRID/ASM high availability technologies and disaster recovery solutions.
• Demonstrated experience supporting mission critical, high availability systems in large, complex environments with 24/7 on call.
• Extensive experience in database performance tuning, monitoring and optimisation.
• Experience in planning, scheduling and applying database patches, upgrades and routine maintenance activities.
• Expertise in diagnosing and resolving complex database issues, incident resolution and problem management.
• Experience in disaster recovery planning, testing and execution.
• Experience in planning, implementing and maintaining robust database backup and recovery procedures.
• Experience in shell scripting and crontab jobs in Linux/Unix environment.

Benefits

• Flexible work options.
• Opportunity to purchase leave.
• Annual leave loading.
• Corporate wellbeing programs including seminars and the Fitness Passport.
• Salary packaging options via superannuation contributions or a novated vehicle lease.
• Convenient location for public transport and to shops.
• In house gym facilities.

Location

Sydney Region - Sydney - Greater West

Work Type

Full time

Number of Positions

1

Total Remuneration Package: $176,910 pa. Package includes salary from $149,739 to $156,088, plus employer's contribution to superannuation of 12% and annual leave loading.

Diversity and Inclusion

At the NSW Police Force, we are committed to reflecting the diverse community we serve and creating an inclusive and respectful workplace for all employees. We welcome applications from individuals with diverse skills, experiences and backgrounds including Aboriginal and Torres Strait Islander peoples, LGBTQIA+ individuals, people with disability, neurodiverse individuals and people of all ages. If you identify as Aboriginal or Torres Strait Islander or have a disability or gender diversity, please contact the relevant inclusion teams.

We pay respect to the Traditional Custodians and First Peoples of NSW, and acknowledge their continued connection to their country and culture.