Database Administrator at AB Microfinance Bank

Main Responsibilities

• Mapping out the conceptual design for a planned database;
• Refining the logical design so that it can be translated into a specific data model;
• Further refining the physical design to meet system storage requirements;
• Updating and amending existing databases
• Setting up and testing new database and data handling systems
• Monitoring database efficiency
• Sustaining the security and integrity of data
• Creating complex query definitions that allow data to be extracted
• Training colleagues in how to input and extract data
• Controlling access permissions and privileges;
• Developing, managing and testing back-up and recovery plans;
• Ensuring that storage and archiving procedures are functioning correctly;
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security;
• Establishing the needs of users and monitoring user access and security;
• Monitoring performance and managing parameters to provide fast responses to front- end users;
• Considering both back-end organization of data and front-end accessibility for end- users;
• Maintaining data standards, including adherence to the Data Protection Act;
• Writing database documentation including data standards, procedures and definitions for the data dictionary (Medata).
• Centralize and streamline processes related to report requests.
• Ensure quality reports and outstanding service delivery to business stakeholders.
• Support the reporting and dashboard infrastructure for the organization.

Necessary Experience and Requirements

• Minimum educational qualification of B.Sc Degree / HND qualification in Computer Science or any related field.
• At least four (4) years hands-on relevant professional experience in a similar role.
• Experience in developing logical and physical data models using data modeling tools.
• Good Knowledge Of Microsoft Excel (Formulas, Pivot tables, V-lookup) and Office.
• Good Knowledge of Relational Database Management Systems (RDMS).
• Efficient use of Microsoft SQL 2012, Strong SQL development, SQL analytics, tuning skills.
• Programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, parallel processing.
• Experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance.
• Ability to manage competing priorities, maintain attention to details and meet deadlines.
• Strong analytical and organizational skills.
• Up-to-date knowledge of technology and the Data Protection Act.
• Ability to work well in a fast paced environment, where the technology is constantly changing.
• Collaborative, consultative and customer-oriented approach.
• Reliable team player with excellent communication skills.