- Provide software support for internally developed products that interact with all database systems.
- To implement, design and improve processes relating to the administration of databases to ensure that they function correctly, perform optimally, preserve data and maintain a high level of availability.
- This role operates in the IT environment and has a strong client focus. Changes in the role occur with changes in client, organizational and legislative requirements.
What responsibilities will you have?
- Sets and maintains operational database standards on an ongoing basis.
- Enforces and improves database integrity and performance through the use of sound design principles and set down database design standards.
- Designs and enforces data security policies to eliminate unauthorized access to data on managed data systems in accordance with IT Services technical specifications and business requirements.
- Ensures that effective data redundancy; archiving, backup and recovery mechanisms are in place to prevent the loss of data.
- Sets up configurable pre-established jobs to automatically run on a daily basis, to monitor and maintain the operational databases.
- To keep abreast of technical developments of operational importance and to participate in developing or setting standards as directed.
- Assisting development teams with effective schema design to achieve optimum performance.
- Completes all project work and allocated tasks on time as per agreed schedule and communicates progress with all parties concerned.
- Takes on additional, unplanned projects as required by the business and works after hours where necessary.
- Completes technical documentation as required.
What skills & experience are we looking for?
- Excellent English written and verbal communication skills on it.
- Relevant Degree or Tertiary qualification.
- 2 or more years of Database experience.
- Experience working with AWS Cloud and/or AWS certification.
- Solid IT knowledge.
- Sound Relational Database Theory understanding.
- Basic report design and writing.
- Experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experience with Microsoft SQL Replication, Availability Groups, Mirroring & Log Shipping, and Service Broker.
- Experienced in Microsoft SQL Dynamic Management Views, functions, triggers and data transformations.
- Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
- Certification covering Microsoft SQL 2014/2019
- Some experience with Linux and Apache Nifi will be a plus
