Manager, Database Administration

Key Responsibilities:

• Ensure high availability (24/7) of entire Database Infrastructure of the Bank through best practices and the appropriate collaboration with technical, business and third-party organizations.
  
• Install and configure Banks databases.
  
• Responsible for managing, troubleshooting and proactively updating database software assets to prevent downtime or zero-day exploits from occurring.
  
• Design, organize, modify, and support an organization’s database systems
  
• Quickly resolve any databases system failures and troubleshoots issues and outages.
  
• Upgrade database systems with new releases and models.
  
• Manage user accounts, credentials, permissions, access rights and storage allocations
  
• Secure databases system integrity from any breaches or viruses and play an essential role in risk-mitigation planning, including creating backup plans, safeguards for data, user security policies, and identity management.
  
• Develop and execute backup and recovery plan.
  
• Maintaining the asset inventory for the database systems.
  
• Responsible for the compliance of all the database related licenses. Ensure timely renewal of the same.
  
• To liaise with external suppliers and support agencies for the ongoing support and maintenance of relevant database hardware and software. Ensure timely processing of the invoices.
  
• Review vendor contracts and assist in negotiating with vendors for the purpose of providing the bank with cost-effective and reliable services.
  
• Monitor the system daily and respond immediately to security or usability concerns.
  
• Confirm success of DB Backup every day and note exceptions if any.
  
• Check on space availability in the database, if none, free up some space for day-to-day activities.
  
• Ensure database availability and optimal performance. Perform tuning whenever required.
  
• Establish and calculate optimum values for database parameters, using manuals and calculator.
  
• Specify users and user access levels for each segment of database.
  
• Review workflow charts developed by system architects/analyst to understand DB tasks system will perform, such as DML procedures.
  
• Work as part of a project team to coordinate database development and determine project scope and limitations.
  
• Develop reports as required by the business that includes CBK reports and ad hoc reports as required by the business.
  
• Continuously Review procedures for database management.
  
• Monitor database performance throughout the day, in case of any abnormality attend to it as soon as possible
  
• Test scripts/programs on databases on collaboration with system analyst before deployment, recommend and/or correct errors and make necessary modifications.
  
• Approve, schedule, plan, and supervise the installation and testing of new databases.
  
• Train users and answer questions in relation to DB technologies, operations and administration.
  
• Develop internal standards, procedures, manuals to guide the use and acquisition of DB software/Hardware and to protect vulnerable information.
  
• Put in place security measures to protect Bank’s Data by applying approved DB security standards.
  
• Report Database risk events and service exceptions.
  
• Research on emerging Database technologies and innovations to improve the Bank’s DB offerings in line with change management process.
  
• Participate in BCP strategies formulations and continuous reviews.
  
• Follow-up audit findings, propose remediation and ensure rectification or mitigation be carried out successfully.
  
• Ensure that all policies and guidelines are implemented according to audit recommendations/requirements.
  
• Prepare written materials (e.g. procedures, system level documentation, SOPs, reports, memos, letters, etc.) for the purpose of documenting activities, providing written reference, and/or conveying information.
  
• Provide leadership to other unit staff in ensuring services are delivered accurately and timely while adhering to laid out procedures and policies.
  
• Ensure compliance with bank and regulatory requirements during implementation of various related services for the bank.
  
• Be a core member for all IT project implementation groups, coordinating execution of bank related activities
  
• Perform change management risk reviews and post implementation reviews for all change requests.
  
• Proactively monitoring all the database servers and services to ensure compliance of all users and services, and in case of any discrepancy report immediately to the Head of IT Applications.
  
• Prepare and ensure that Risk Control Self-Assessment is conducted periodically for units.
  
• Conduct accurate and timely performance management for his/her team.
  
• Any Other duties assigned from time to time by the line Managers, Head IT Applications or Director-IT
  

Key Relationships

Direct Reports to this Position

• Assistant Manager, Database Administrator
  
• Officer, Database Administrator
  
• Database onsite vendor resources.
  

Customers of this Position

• All Departments in the Bank
  

Education, knowledge, skills and experience required for this role

• University degree in Computer Science / IT related field, however, a Master’s degree in IT would be an added advantage
  
• Expert DBA skills including extensive experience in implementing DB architecture using Oracle RAC, SQL. Oracle database Certifications
  
• Certifications required for this role:
  
• Oracle Database management Certifications.
  
• Microsoft Certified Solutions Engineer (MCSE)
  
• Microsoft Certified Systems Administrator (MCSA) and/or AIX Administrator
  
• Oracle Linux System Administrator (Oracle)
  
• Red Hat Certified System Administrator (RHCSA)
  
• Red Hat Certified Engineer (RHCE)
  
• VMware Certified Professional 6 & above - Data Center Virtualization
  
• A minimum of 6 years of proven experience as a System Administrator or similar role
  
• Experience with databases (MSSQL and Oracle), networks (LAN, WAN) and patch management
  
• Knowledge of system security and data backup/recovery
  
• Experience with various operating systems and platforms
  
• Experience with various storage (SAN) platforms
  
• Resourcefulness and problem-solving aptitude
  
• Excellent communication skills
  
• Issue management and problem resolution skills
  
• Knowledge of CIS standard is must.
  
• Fluency in spoken and written English
  
• Good integrity, positive attitude, helpful, high commitment, competence and motivation
  
• Proven experience as a System Administrator or similar role
  
• Knowledge of system security (e.g. intrusion detection systems) and data backup/recovery
  
• Familiarity with various operating systems and platforms
  
• VMWare / Kubernetes / Dockers administration – Should be aware of implementation, management as well as monitoring the data growth rate and utilization.
  
• Writing skills: Ability to efficiently produce concise, organized reports.
  
• Knowledge, insight, and understanding of business concepts, tools, and processes that are needed for making sound decisions in the context of the company's business; ability to apply this knowledge appropriately to diverse situations.
  
• Communication and interpersonal skills
  
• Strong troubleshooting skills and change management skills.
  
• Issue management and problem resolution skills