Position Purpose:
This position involves researching, evaluating and daily operational administration of database management systems. The DBMSs to support would involve a combination of MySQL, Postgres, DB2, MongoDB amongst other similar systems. The deployment of these systems is both on premise in our datacenter as well in AWS and AZURE cloud platforms. In addition to executing daily operational support of these databases, engaging with developers to gain an understanding of their requirements and propose solutions will also be an important component. Candidate does not have to know all these systems, but must be experienced in some of these.
Qualifications:
- Grade 12
- IT-related qualification
- Industry Certification Desirable
Experience:
- 5+ years managing MySQL databases
- Experience in administering one or more DBMS such as MySQL, PostgreSQL, DB2 and MongoDB. (Expert level in one of these is essential.)
- AWS and AZURE cloud platforms experience
Job objectives:
To research, evaluate and recommend DBMS products
- Evaluate and compare strengths and weaknesses of DBMS products
- Produce documentation to be used in solution architecture decision making
- Rank ease of setup and management effort required for each product
- Rank monitoring and alerting capabilities for each product
To assist Development Teams in designing and optimizing systems:
Review database designs and make recommendations to address shortcomings.
Perform proactive monitoring and feedback to developers, highlighting queries that can be improved.
To carry out basic database administrative tasks:
- Check OS and Database logs.
- Do backups and restores as requested.
- Do regular disaster recovery trials.
- Profile server resource usage, optimize and tweak as necessary Resolve incidents.
- Automate maintenance tasks through appropriate scripting language.
- Monitor capacity to prevent unplanned outages.
- Grant permission to servers and databases in conjunction with standards as per SECURITY team.
- Design HIGH AVAILABILITY architecture.
To ensure information security and regulatory compliance:
- Ensuring system security meets regulatory compliance.
- Manage server security remediation activities which will include conducting vulnerability scans, patching and implementing DBMS specific features.
- Will work very closely with SECURITY and APPLICATION teams.
Knowledge & Skills:
- 4+ Years General understanding of database management concepts.
- 4+ Years Proficiency with installing, configuring, administering, using and benchmarking DBMS solutions.
- 3+ Years Basic familiarity with Linux operating system
- 2+ Years Some experience engineering and/or administering NoSQL infrastructure
- 2+ Years Proficiency with one or more Apache Software Foundation Big Data & Database projects such as Cassandra, Hadoop, HBase, MongoDB
- 4+ Years Knowledgeable in designing, developing & amp; documenting use cases.
- 2+ Years Proficiency with some of the common developer tool sets such as Java, XML, JSON, REST, Shell, Perl and etc.