Database Administrator

Job Purpose

To execute the design and tuning of database and to successfully manage and maintain the consistency, availability and security of data required for business needs and projects. Also, to ensure timely and accurate archiving and backup of all available data and immediate retrieval and disaster recovery to avoid disruptions in operations and ensure business continuity.

Key Result Responsibilities

1.    Contributes to developing and implementing data & recovery strategy, policies, and procedures that ensure the consistency, availability, security and recovery of data as per agreed standards and regulatory requirements.

2.    Collaborates with line managers to identify the sources for all data in line with business requirements and security measures to ensure adequacy and compliance of these sources with agreed standards and regulations and to mitigate risks that may arise.

3.    Ensures all data of ISA and its clients are properly managed, tuned, secured and maintained in form of database as per agreed measures and adopted procedures including those hosted within ISA data centers and/or externally hosted or with cloud service providers.

4.    Utilizes available tools and methodologies to monitor the availability and performance of database on daily basis. Categorizes information and communication systems by service tiers and ensures data availability/accessibility is committed to in relation to the tiers.

5.    Ensures all data is archived, protected, and retrievable as per policy, regulations and clients’ requirements and within agreed SLAs; manages the back-up process regularly as per adopted procedures and set measures.

6.    Participates in the design and implementation of data recovery action plan in collaboration with other line managers and in alignment with business continuity plans ensuring cost-effectiveness and agreement with business objectives. 

7.    Ensures successful migration of database to the cloud within agreed timeframes.

8.    Collaborates with the line managers and different teams and utilizes various tools and available resources to ensure recovery/retrieval and back-up procedures and measures are timely and successfully implemented in case of incidents and disasters.

9.    Co-ordinates with Product, Development and Project Management teams on the design and testing of recovery procedures and contingency plans to address exposure to risk and ensures that agreed levels of continuity are maintained. 

10.    Collaborates with the Governance team to ensure adherence to agreed security measures/regulations and audit requirements in data centers.

Key Result Responsibilities-Continued

Qualifications (Academic, training, languages)

Bachelor’s degree in computer engineering/Information Technology/Computer Science/ or equivalent.
-    Database certification (Oracle, MS SQL, IBM DB2), Big Data technologies and related.
-    SQL Knowledge is essential.
-    Fluent in English Languag

Work Experience

5+ years of experience in IT environment in any industry handling a similar role in data base management.
-    Minimum 3 years’ experience in MySQL database administration required.
-    5+ years of experience in data modeling and architecture.
-    Hands-on experience with relational SQL and NoSQL databases.
-    Deep knowledge of database approaches and pro-tips.
-    5+ years building scalable data pipelines and ETL.
-    Experience with Spark and Hadoop a plus.
-    Experience with Cassandra or Redis will be highly desirable.
-    World-class SQL skills.
-    Must be expert in MySQL Database Administration,