• Job Type: Fixed Term Contract
• Category:
• Location: Wellington – Wairarapa
• Date Advertised: 12-JAN-21
• Job Reference: NZ/28283
• Job Title: Database Developer
• Business Unit:
• Division:
• Summary:

Royal New Zealand Police College
Fixed term until 31st March 2023
Police Employee, $73,498 – $99,438
Job Req: 28283

About the role: 

We are seeking two junior/intermediate level Database Developers (DBA), to be part of a new team responsible for all aspects of database development relating to Police systems that provide mission critical functionality to the Police front-line.

These systems all use DB2 databases as their data repository. You will have high levels of motivation and be passionate about the importance of good data management and its role in providing software solutions that support the front-line.

 Key aspects of the role will be to:
 

• Translate business requirements to the physical database design
• Design and develop the objects required for the physical database design (tables, columns, indexes, relationships etc.)
• Design and develop database routines (triggers, functions and procedures) to support the application requirements
• Implement security policies across all database objects
• Communicate with developers, analysts and testers to ensure the database design supports the user interface and business rules
• Manage multiple development/test environments and migration of database versions from one environment to another
• Manage and monitor replication software between multiple databases

What you’ll bring:

Being part of the Police whānau is about being our best to ensure our communities are safe and feel safe. Our Core Competencies provide a shared understanding of the behaviours, leadership and technical competence required for success at each level of Police.

Whilst we are looking for skills, knowledge and experience relevant to the role, we also place high importance on your state of mind, the alignment of your values with ours, your ability to contribute to and build high performing teams, and the way that you lead yourself or others.

Above all we are looking for someone with a willingness to learn, take on new challenges, be flexible and has a real can-do attitude.

This is a dynamic position and the successful applicant will need to be able to demonstrate the following:
 

• A strong interest in database design, implementation and performance for large scale, mission critical applications
• Ability to analyse complex technical issues and work with other team members to provide solutions
• Willingness to work with multiple application development project teams and as a team member of the database development team
• Good communication skills with both technical and non-technical colleagues.
• Desire to learn new technical skills and develop high expertise and knowledge in the use of the database software used by NZ Police (DB2)
• Knowledge of database design principles and the SQL language from prior experience in an academic or professional setting

This role is set at Individual Contributor level, this means your key purpose is “to deliver or enable others to deliver Our Business”.

We will ask you questions based on “How we will deliver Our Business – Core Competencies” and the appropriate role level.

For more information on Our Core Competencies, please copy and paste this URL:  https://www.police.govt.nz/sites/default/files/publications/core-competencies-how-we-will-deliver-our-business.pdf These questions will be unique and specific to the role, focusing on the aspects the hiring manager believes are most important for that position at the time.

For more information on Our Values, please copy and paste this URL: https://www.police.govt.nz/sites/default/files/publications/nzp-our-values.pdf

To view the position description for this role please copy and paste this link into a new browser: https://www.police.govt.nz/sites/default/files/pd/01-2021/developer.pdf

About us 

Our mission is to be the safest country by delivering services that ensure New Zealand communities are confident, safe and secure.

Working Flexibly

Your wellbeing inside and outside of work is important to us. We’re open to discussing flexible working options that work for both you and the business.

For more information on the above, please copy and paste this URL: https://www.police.govt.nz/careers

How to apply

If this position sounds like you, click apply now. You will be required to submit an application form and a CV. Before confirmation of hire, pre-employment checks will be undertaken. For further information on the application process, please copy and paste this URL: https://www.police.govt.nz/careers

If you have any questions about this vacancy, please contact heather.eachus@police.govt.nz

Applications for this position close 5:00pm Tuesday, 26th January 2021