Allianz - Database Administrator - System Design

Description:

- Install and configure database systems and associated objects, patches and upgrades in response to evolving user requirements or new projects and initiatives.

- Manage the development, testing and support of database environments.

- Conduct all aspects of capacity planning, performance monitoring, reporting and tuning of relational databases to optimise operations and mitigate risk of business disruption.

- Perform backup and recovery of relevant databases on a periodic basis in line with business continuity and contingency plan.

- Liaise with application users to confirm requirements.

- Contribute to the development of policies and procedures governing Allianz database operations and related issues.

- Undertake migration of data between nonproduction environments and production applications, employing effective segregation of duties.

- Implement and audit database security and ensure that data in all environments complies with Allianz Australia Security standards and other regulatory requirements, including but not limited to privacy requirements.

- Experience in implementation and running of PostgreSQL and DB2 on Linux.

- Demonstrated evidence of technical proficiency with Postgres and exposure to Comvault backup solution.

- Exposure to Database on Cloud, either Azure or AWS.

- Exposure to data migrations and knowledge of replication software.

- Experience applying CI/CD automation within the database managed environment.

- Comprehensive knowledge of relational database design, data modeling, performance monitoring and tuning.

- Demonstrated experience in use of associated Database programming languages such as PL/SQL, and SQL.

- Highly developed 'first principles' problem-solving skills, combined with a curious and creative mind-set.

- Proven analytical and critical thinking capability to interpret a range of data, identify patterns, trends and links that inform judgements and solutions.

- Demonstrated evidence of technical proficiency in the use of Windows Clustering, Windows Shell Scripting and Unix Korn Shell Scripting.

- Excellent verbal and written communication skills.

- Willingness and flexibility to work outside of standard office hours, and on weekends as required.

Special Considerations:

- Experience in the insurance or financial services industry is highly desirable.

- Knowledge of the insurance lifecycle policy & claims is a plus.

- Familiarity with basic AI tools is considered an advantage.