SENIOR DATABASE ADMINISTRATOR

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