IT Database Administrator at AB Microfinance Bank

Job Description

• Assisting in database design
• 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 frontend users;

Necessary Experience and Knowledge

• Minimum B.Sc / HND in Computer Science or related discipline with cognate experience
• At least two 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
• Strong analytical and organizational skills
• Eye for detail and accuracy
• The ability to work quickly, under pressure and to deadlines
• 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
• Fluent English, both in writing and orally