SENIOR DATABASE ADMINISTRATOR
Summary
Senior Database Administrator in Dar es Salaam who designs, secures, migrates, tunes and provides 24/7 support for a bank's databases, maintaining dev/test/prod environments and backups. Core tech: Oracle and MS SQL Server, plus cloud platforms, big data tooling, Docker/Kubernetes and DevOps/CI-CD practices.
KEY RESPONSIBILITIES:
● Design and implement effective database solutions, frameworks and
models to store and retrieve Bank’s 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:
● Bachelor’s 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