Job Overview:
Manage company OLTP and OLAP servers. Responsibilities include maintaining the current database systems, supporting the design and implementation of changes to the databases, establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management systems. The successful applicant will be involved in managing client enquiries and face-to-face client’s activities.
Main Tasks and Accountabilities
1. Data Insight / Data Mining
2. Recoverability - Creating and testing Backups
3. Integrity – Verify data integrity
4. Security - Defining and/or implementing access controls to the data. Updates and upgrades
5. Availability - Ensuring maximum uptime
6. Performance - Ensuring maximum performance given budgetary constraints
7. Development and testing support - Assist programmers and to efficiently utilise the database
Experience/Knowledge/Qualification required
8. Over 5 years of professional experience developing SQL software
9. Advanced PL/SQL or similar
10. Good experience SQL skills (experience with PostgreSQL / Greenplum is a plus)
11. AWS (EC2, RDS, CloudWatch…)
12. Linux (shell, crons...), Ansible / Terraform, replication, pgWatch
13. Python is a plus
14. Computer Science degree or related
Character and Personal Qualities
15. Enjoy working in a team
16. Willingness to accept challenges
17. Ability and desire to work with complex, integrated solutions
18. Good problem solving skills with attention to details
19. “Think outside the box” & “Can do” attitude
20. Ability to work independently and with limited oversight