ORACLE Database Administrator - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 30-07-2019 6:37:12 AM
24-09-2019 6:37:12 AM
ORACLE Database Administrator. Cape Town. Rneg. Join online casino technology and services company with branches in Malta, London, Gibraltar and Cape Town.

We are looking for a database specialist to help us grow and improve systems. Currently running on Oracle hosted on AWS (RDS) but will be moving to PostgreSQL. Also looking to expand the system to many more services and many more databases.

Looking after production Oracle databases (for approximately the first 12 months)
Helping migrate from Oracle to PostgreSQL with minimum downtime
Looking after the production PostgreSQL databases
Working in a DevOps environment and being actively involved in the software development process
Working to improve and automate our testing, deployment and monitoring processes
Understanding how our processes work and how that translates into the data we have
Working with business managers to extract required data/reports
Diagnosing and helping fix production issues
Being available to help fix things out of hours (hopefully very infrequently)
Not being phased by the strange variety of things that need doing in a small growing company
Being proactive and not just waiting to be told the next thing to do
Finding better ways that we can get things done
Requirements: -

At least 5 years’ experience administering Oracle databases – installation, configuration, backups, monitoring etc.
Excellent PL/SQL coding experience
A good knowledge of SQL performance tuning
Experience of migrating production databases while minimizing downtime
Some experience in Linux server administration
At least a little experience in PostgreSQL with the desire to learn more
A proactive approach to improving databases as part of a DevOps culture
The ability to turn business questions into well-performing database queries
Good interpersonal skills and a great team attitude
The ability to quickly learn new things and adapt
Advantageous: -

Familiarity with administration of PostgreSQL databases
Familiarity with PAAS environments such as AWS
Experience using automated configuration/deployment tools such as Chef, Puppet, Ansible or Docker
Experience of migrating schemas, data and PL/SQL from Oracle to PostgreSQL
Experience of system security at network, OS and database level
"How we approach things:

A small company, can-do ethos
We focus on getting stuff done, not on process or management hierarchy
Working remotely (from the Cape Town office) but communicating regularly
A flexible working schedule"