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 :

(ref : hirist.tech)