Database Administrator Specialist

Reference Number: R-15975032

NBC is the oldest serving bank in Tanzania with over five decades of experience. We offer a range of retail, business, corporate and investment banking, wealth management products and services.

Job Summary

The Database Administrator Specialist role is responsible for the timely delivery, support, and implementation of complex enterprise Database systems as part of Bank’s strategy. The Candidate through effective communication with stakeholders and ability to support, direct towards successful delivery of Business Goals; will work hand in hand with Business teams to support key strategic priorities which includes but not limited:

• Support all Existing and Future Projects for all environments (Production, Disaster Recovery, UAT & SIT) Database Infrastructure needs (Oracle, SQL, PostGRE, MySQL Databases)
• Core Banking Database Upgrades
• Support Oracle, Microsoft SQL, PostGreSQL and MySQL Databases
• All Databases Data Migrations, Validations and Quality Projects & Requirements
• Support Technology transformation through team Capacity building
• Business Products, Audit and Processes enhancements
• BAU support including Batch runs, reports and fixes deployments.

Job Description

Database Operations and Application Support (75%)

• Work hand in hand with our Technology Application Support, Business and Management teams in daily execution of BAU and Strategic support activities/requirements for enhanced delivery.
• Support the scoped key Projects and engagements timely delivery seamlessly to ensure Business value and Bank objectives are met.
• Support ongoing Projects and further streamline Business processes and Products to ensure best practices at enhanced competitiveness.
• Provide progressive Weekly/Monthly assessments and recommendation reports on the Databases performance, Infrastructure requirements and enhancements.
• Be actively involved in enhancing Business Products intelligence strategy, Best practices with Product Setups, charges, enhanced Business processes etc. to ensure income leakages and unaccounted losses/income are realized and mitigation effectiveness continually improved.
• Perform assessments for Core Banking System upgrades and lay the foundations for a seamless transitions upgrade; in readiness to fully support the Core Banking system upgrade end to end.
• Support End of Day, End of Month and End of Year Batch runs; handling all issues/incidents arising.
• Collaborates on the initial hardware requirements, installation and configuration of a new/upgrade existing Oracle, SQL, and Postgres Server etc.
• Efficiently importing large volumes of data that have been extracted from multiple systems into a data warehouse environment.
• Create backup and recovery plans and procedures based on industry best practices, then make sure that the necessary steps are followed (develop, manage and test back-up and recovery plans).
• Establish the needs of users and monitor user access and security.
• Monitor performance and manage parameters in order to provide fast responses to front-end Applications performance tune database queries.
• Install and test new versions of the database management system (DBMS).
• Creation of databases and manage schema objects (tables, indexes, views etc.).
• Control migration and changes of all schema objects.
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitor application related jobs and data replication activities.
• Maintain data standards, including adherence to the Data Protection Policies.
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Control access permissions and privileges.
• Ensure that storage and archiving procedures are functioning correctly upholding proactive carry out capacity planning.
• Work closely with project managers, Vendors, and other stakeholders in addressing issues/incidents/problems for prompt issues resolutions.
• Perform general technical troubleshooting and give consultation to development teams.
• Writing disaster recovery plans to uphold DR recovery and resilience tests engagements for Business Continuity assessments etc.
• Work as part of a team and provide 24x7 support when required.

Security control and Compliance (25%)

• Define and monitor user access and permissions based on principle of least privilege.
• Enforce data protection policies, standards, and audit controls.
• Maintain adherence to internal security protocols and external regulatory compliance.
• Develop, document, and test backup and recovery strategies aligned with industry best practices.
• Write and maintain disaster recovery (DR) plans and participate in resilience and business continuity testing.
• Ensure DR readiness for all mission-critical databases and applications.
• Provide weekly and monthly assessments of database performance and infrastructure requirements.

Accountability: Manage Career Development

• Proactively identify personal development areas and training needs
• Meet training objectives as set out in personal training and development plan
• Complete all mandatory training assigned

Education and Experience Required

• BSc. In Computer Science, Engineering or related field with informatics as core.
• Evidence Proficient expertise with supporting Oracle Flexcube Core Banking Database at 99.9% availability
• Oracle, SQL, PostGRE, MySQL Databases Certified.
• Knowledge of banking/branch operations.
• Good understanding of ITIL processes and associated concepts.
• High degree of commercial awareness with sound understanding of key contractual obligations and risks to maximize benefits.
• Strong customer liaison and relationship management skills.
• Excellent communication and presentation experience.
• Must be able to work under pressure, take clear ownership of issues and projects and drive to ensure a successful closure for the customer, peers and IT Production.
• Financial management – budget preparation and managing to budget.
• Experience of financial services preferred.
• At least 5 years in IT Database Infrastructure and operations role.

Knowledge, Skills and Competences Required

• Knowledge on the trending banking software and technologies in the market.
• Excellent written and oral communication
• Aggressive Problem-solving skills and follow through; Pragmatic and thorough
• Familiarity with Agile development methodologies.
• Experience with varieties of databases and object-relational Mapping (ORM) frameworks.
• Must be a self-starter and have the ability to work independently with little supervision.
• Business Processes Improvement and Management

Qualifications

Bachelors Degrees and Advanced Diplomas - Information Technology, Experience in a similar environment