Database DeveloperRoyal New Zealand Police College Fulltime, Permanent Police Employee, $ 73,498 - $99,438
Job Req: 28283About 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 databasesWhat 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 settingThis 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.pdfTo 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.pdfAbout usOur mission is to be the safest country by delivering services that ensure New Zealand communities are confident, safe and secure.Working FlexiblyYour 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 applyIf 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/careersIf you have any questions about this vacancy, please contact **********plications for this position close 5:00pm Tuesday, 26th January 2021
