SENIOR DATABASE ADMINISTRATOR

Dar es Salaam - Tanzania

Monthly Salary: Not Disclosed

Experience Required: 5years

Posted on: 7 days ago

Vacancies: 1 Vacancy

Job Summary

KEY RESPONSIBILITIES:

Design and implement effective database solutions frameworks and models to store and retrieve Banks data.

Examine and identify database structural necessities by evaluating client operations applications and programming.

Prepare accurate database design and architecture reports for management and executive teams.

Assess database implementation procedures to ensure they comply with internal and external regulations.

Prepare accurate database design and architecture reports for management and executive teams.

Oversee the migration of data from legacy systems to new solutions.

Monitor the system performance by performing regular tests troubleshooting and integrating new features.

Recommend solutions to improve new and existing database systems.

Maintaining and enhancing the performance of existing database programs.

Monitoring databases and related systems to ensure optimized performance.

Gathering all salient information regarding the intended functions of each database.

Receiving requests pertaining to the layout appearance and special features of each database.

Designing and creating appropriate frameworks that are sufficiently large.

Configuring databases such that they are able to withstand attacks and the loss of information.

Formulating data dictionaries that are congruent with task specifications.

Creating technical documents that outline the purpose capacity and guidelines attached to each database.

Providing practical guidance on the use and migration of each database.

Writing new support programs and scripts to optimiZe data storage capacity.

Reviewing database and user reports as well as system information.

Performing debugging procedures on database scripts and programs as well as resolving conflicts.

Adhering to best practices in securely storing backing up and archiving data.

Documenting processes related to database design configuration and performance. Manage and perform database purging backups and recovery activities.

Maintain development test and production database environments.

Implement and maintain database security standards.

Provide 24/7 support when required.

Gathering all salient information regarding the intended functions of each Keeping abreast of developments and best practices in database engineering.

Requirements

QUALIFICATIONS:

Bachelors degree in engineering Telecoms Computer Science Computer Information Systems or related field of study.

Must have professional certifications in Databases OCA OCP in Oracle Database 11g or higher

Proficiency with SQL server and Oracle query scripting.

Expert Experience in operating Systems; Unix Linux Solaris and Windows.

Business understanding of systems in banking and specifically knowledge of the Core Banking Systems (Finacle 10)

Strong knowledge in administering Oracle and MS SQL Database Management Systems.

Good understanding of DevOps concepts and best practices

Good Knowledge in the following Microsoft software products: (LDAP Active Directory IIS DFS TCP/IP NFS SAN and Direct Attached Storage High Performance Networking).

In-depth understanding of VMware technologies including vSphere/ESX VMware View vCenter Site Recovery Manager running in enterprise environments.

A minimum of Five years experience in database engineering/administration.

Demonstrable experience as a Database Developer. ( Oracle MySQL Postgres MS SQL MongoDB)

Portfolio of previous developments is preferred. ( Oracle MySQL Postgres MS SQL MongoDB)

Experience with Cloud platforms (AWS Azure Google cloud)

Experience with Cloud data warehouses (Snowflake BigQuery Synapse Analytics Redshift)

Experience with Hadoop ecosystem (Spark Kafka HDFS HIVE HBase ...)

Knowledge Docker and orchestration platform (Kubernetes OpenShift AKS Gke...)

Experience with microservices apps deployment and maintenance.

Experience with NoSQL DBs (MongoDB Cassandra Neo4j)

Extensive experience with database technologies and architecture.

Sound knowledge of best practices in database engineering and data security.

Strong understanding of version control (git) branching & merging strategies and build setup

Programming and scripting abilities across a range of languages e.g. Ruby Java Go Python NodeJS Bash PowerShell etc

Continuous integration/continuous delivery tools - Jenkins/Jenkins Pipelines Gitlab CircleCI Sauce Labs and Nexus

Understanding of load balancers application gateways DNS virtual networks and firewalls in cloud environment

Fin-tech/Banking processes and application knowledge

KEY RESPONSIBILITIES: Design and implement effective database solutions frameworks and models to store and retrieve Banks data. Examine and identify database structural necessities by evaluating client operations applications and programming. Prepare accurate database design and architecture repor...