Database Administrator
Job Summary:
The Senior Database Administrator will work with the ICT team to assist in the architecture, design, build and maintain of Databases within IMT Tech Stack. We are looking for an innovative, tech-savvy Senior Database Administrator to create and maintain storage frameworks. To this end, the Database Administrator should elucidate the intended use of each database, proceed to design appropriate solutions, and then perform the rollout while ensuring high levels of data availability, security and integrity are attained.
To be successful as a Database Administrator, you should create robust solutions that are impervious to hacking and other security breaches. A top-notch Database Administrator will resolve all performance-related issues as they occur. You should also know how to examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.
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 optimise 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.
- Keeping abreast of developments and best practices in database engineering.
Educational Qualifications & Experience:
- 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.
Skillsets:
- 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
- Fintech/Banking processes and application knowledge
Other Preferred Qualifications:
- Ability to work independently with little supervision
- Strong interpersonal and communication skills - both written and oral. Comfortable communicating cross-functionally and across management levels in formal and informal settings
- Ability to work independently with little supervision
- Familiarity with designing network topologies within the context of a cloud providers (aws, azure, gcp).
- Good knowledge of microservice architecture
- Interest in security, authentication and authorization topics
- Excellent collaboration and communication skills.
- Telco/Fintech/Banking processes and application knowledge