About the role
Requirements:
Computer Skills - Demonstrable skills required in the following areas:
- Five (5) plus years of experience with Database design, data mapping between cross-functional applications, and best practices for data pipelines.
- Five (5) plus years of experience in the development of database processes using functions, procedures, triggers, views in Oracle, MSSQL, PostgreSQL, and Unix shell scripting.
- Excellent knowledge of debugging, tuning and optimising performance of database queries.
- Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications.
- Strong experience in designing database objects using partitioning and sharding.
- Strong experience in maintaining data per the data retention policy
- Strong experience in data provisioning with masking and anonymisation for a lower environment.
- Strong ETL and data modelling experience.
- Strong proficiency in database interfacing and relational database management systems.
- Strong technical and analytical skills.