Database Administration Senior Specialist Zambia National Commercial Bank Plc

JOB PURPOSE

This function is responsible in the day to day activities in relation to the Information Technology Infrastructure and Networks through the delivery of robust Technology Architecture within the Database Management Systems to ensure that the Business Database Operations which include anything from initial Database Architecture Design to Database Administration in order to meet existing and future Strategic and Tactical requirements for the Bank to realize its Strategic Goals. It focuses on ensuring the delivery of all aspects of Database Architecture Design through Implementation, Administration, Monitoring, Optimization, Data Protection, Migration and Support.

The role oversees the enhancements and enforcement of all Information Technology Database Management Systems Design across the entire Bank and that the Business is aligned and adheres to Database Architecture Design Policies, Processes, Procedures and Internal Controls that will drive the entire Database Management Systems culture across the Division and the Business as a whole to assure compliance with applicable Regulatory and Legal requirements as well as Best Practices.

Under the supervision of the IT Infrastructure & Networks Head, the following are among the Job Key Responsibilities:

Database Administration:

• Oversee all aspects of Business Database Operations including Database Architecture Design through Implementation, Administration, Monitoring, Optimization, Data Protection, Migration and Support.
• Design, maintain and optimize Best Practices and Policies, Processes and Procedures related to Database Management Systems and related services.
• Ensure consistency and integrity of Company Data is maintained in line with set Policies, Procedures, Processes and Industry Standard Best Practice.
• Accountable for Monitoring and Control of licensing costs of Database Management Systems across the Enterprise.
• Plan and maintain upgrade road map of Vendor supported Database Management Systems.
• Facilitate, supervise and participate in the ongoing maintenance of the Database Management Systems.
• Develop and maintain a program of proactive System Administration, including but not limited to Database Software Updates, Patches and Fixes, System Enhancements, Log Monitoring, and System Hardening.
• Automation and Script routine operations; package automated processes for handoff to Team members for Implementation and Operation.
• Continuous and consistent Monitoring and Analysis of Performance/Tuning issues of Database instances.
• Create Strategies and provide recommendations for Technical optimization to Application Development Teams.
• Creation and Implementation of Database Security measures including Configuring and Monitoring User Access levels, Data Access history, and other related Security concerns.
• Maintain an up-to-date inventory of Database Management Systems.
• Ensure the Development, Recommendation and Documentation of Plans, Policies, Processes, Procedures and Checklists.
• Day to day Recommendation and Implementing of System and Technology Solutions and Improvements as well as Troubleshooting of Systems and Technology.
• Lead or participate in multiple Projects in accordance with Institutional and Departmental goals.
• Ensure day to day Maintenance of a thorough working knowledge of and adheres to Organization/Project Policies, Processes, Procedures and Regulations.
• Keeps immediate Supervisor well-informed of Activities, Results of efforts, and Problems identified/potential problems and recommends corrective actions to immediate Supervisor.
• Develop and maintain a Database Recovery Plan to include both a regular Backup Schedule and tested process for Device Configuration restoration.
• Stays abreast of Trends and Innovations in the field of Information Systems/Technology that could benefit the Organization; documents Findings/Rationale and recommendations to Supervisors.
• Ensure Implementation and compliance to regulatory requirements.
• Manage and provide Specialist Technical expertise to Information Technology and Business when required.
• Nurture and manage objective working relationships with various Stakeholders including End-users, Project Staff, Service Providers and Senior Staff members by providing input to the Business.
• Support Peers, Colleagues and Team across Information Technology functions through knowledge sharing.

Leadership and Staff Development:

• Agree targets with team members, monitor Performance and Performance Reviews for each team member as per stipulated guidelines.
• Ensure regular team sessions are held for target alignment and feedback.
• Coach and develop team members, building their skills and competencies to manage and maximize their effectiveness and performance and that of their teams.

Risk Management

• Ensure that all risks applicable to your area are identified, assessed, reported, captured in the risk register and eventually remediated.
• Ensure accurate and complete documentation and reporting of risk events within the stipulated time line.
• Ensure all emerging risks are reported and mitigating factors put in place.
• Participate in the annual review of procedure manuals where applicable.

Vendor Management:

• Prepare RFP’s, bid proposals, scope of work and other documentation for infrastructure projects and associated efforts.
• Accountable external Service Level Agreements with 3rd party Vendors/Service Providers.
• Research and make recommendations on hardware and software purchases and assist Procurement Management Tender Committee to ensure cost-effective purchasing decisions.
• Establish a Penalties System and imbed within the SLA to hold Vendors to be more accountable.

INTERNAL/EXTERNAL CONTACT

• External: Vendors, Consultants, Service Providers

• Internal: All internal Business Units

QUALIFICATIONS AND EXPERIENCE

• Grade 12 Certificate with Credit or above mandatory in Mathematics and English and any other three subjects
• Bachelor’s Degree in Computer Science, Computer Engineering or a related field
• Windows and Linux/Unix Administration Certification, Oracle Certified Professional (OCP), PostgreSQL Professional Certification, Microsoft Certified Solutions Associate Database Administration is required
• Prince 2, ITILv4, Cloud Certification is desired
• Zambia Qualifications Authority (Zaqa) Verification Certificate for Tertiary Qualifications
• Minimum Experience: 5 years working experience across function technologies.
• Exceptional knowledge of Service and Application Delivery, as well as successful Service Level Agreement accomplishments.
• Excellent knowledge of scripting, SQL queries, Oracle, Microsoft SQL Server, PostgreSQL, Backup and Recovery, Business Continuity, Disaster Recovery.

JOB CORE COMPETENCIES

• Analytical skills
• Attention to detail and accuracy
• Drive for results
• Accountability
• Technologically abreast.
• Research/ Information gathering skills
• Customer service orientation
• Collaboration and teamwork