Systems Specialist_D

Requirements

• 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.
  

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.