Job Description

CIB Corporate Technology is a relatively new team that was conceived at the start of 2015. The team was formed to create new digital experiences for customers and has a portfolio of applications that range from native mobile applications for iOS and Android, to web-based portals and applications, to headless APIs.

More about the project:

Problem to solve

Solution/Deliverable

Attractive Tech exposure

With the rapid expansion of CIB Corporate Technology and online digital channels, there is a need to have dedicated DBAs embedded alongside the applications teams to increase MTTR, provide advanced level database optimisations, maintenance, best practices and standards, high availability, altering and recovery and adhering to security standards.

/ Responsibilities:

Install, configure, and maintain open-source databases, specifically PostgreSQL, and MongoDB.

Develop and implement database backup, recovery, and replication strategies.

Monitor database performance and optimize database queries to ensure fast and efficient data retrieval.

Troubleshoot and resolve database related issues.

Implement database security measures to protect sensitive data.

Develop and maintain database documentation, including data dictionaries and schema diagrams.

Collaborate with developers and other stakeholders to identify data storage requirements and provide guidance on data modelling and database design.

Stay up to date with new open-source database technologies and incorporate them into the organizations infrastructure as needed.

Understand the technical landscape and bank-wide architecture that is connected to or dependent on the business area supported to effectively design & deliver data solutions (architecture, pipeline etc.)

Translate / interpret the data architecture direction and associated business requirements & leverage expertise in analytical & creative problem solving to synthesize data solution designs (build a solution from its components) beyond the analysis of the problem

Participate in design thinking processes to successfully deliver data solution blueprints

Ensure designs & solutions support the technical organization principles of self-service, repeatability, testability, scalability & resilience

Inform & support the infrastructure build required for optimal extraction, transformation, and loading of data from a wide variety of data sources

Support the continuous optimization, improvement & automation of data processing, retrieval, storage & distribution processes

Ensure the quality assurance and testing of all data solutions aligned to the QA Engineering & broader architectural guidelines and standards of the organization

Meaningfully contribute to & ensure solutions align to the design & direction of the Group Architecture & in particular data standards, principles, preferences & practices. Short term deployment must align to strategic long-term delivery.

Coach & mentor other engineers

Conduct peer reviews, testing, problem solving within and across the broader team

Build data science team capability in the use of data solutions

Identify technical risks and mitigate these (pre, during & post deployment)

Update / Design all application documentation aligned to the organization technical standards and risk / governance frameworks

Create business cases & solution specifications for various governance processes (e.g., CTO, Architecture, and governance approval forums)

Participate in incident management & DR activity applying critical thinking, problem solving & technical expertise to get to the bottom of major incidents

Deliver on time & on budget (always)

Background and experience required:

Years of Experience

Industry Experience

Bachelor's degree in Computer Science, Information Systems, or a related field.

3+ years of experience as a DBA, with a focus on open-source databases.

Strong knowledge of database design, administration, and optimization techniques.

Experience with SQL and NoSQL databases.

Knowledge of database backup and recovery, database replication, and database security.

Strong scripting skills in languages such as Python, Perl, Bash, or PowerShell.

Familiarity with cloud-based database infrastructure, such as Amazon Web Services (AWS), Azure or Google Cloud Platform (GCP).

Strong analytical, problem-solving, and interpersonal skills.

Ability to work independently and as part of a team.

Excellent written and verbal communication skills.

Must-have Skills (Mandatory Skills):

Include minimum years of experience required per skill

3+ years of experience as a DBA, with a focus on open-source databases.

Database management tools

Database Query optimization

High Availability configuration

Disaster Recovery Planning

Monitoring and Alerts on infrastructure & Data change
working with database software to find ways to store, organize and manage data.

Maintenance and keeping databases up to date.
helping with database design and development
managing database access

Designing maintenance procedures and putting them into operation
managing database security/integrity and backup procedures. testing and modifying databases to ensure that they operate reliably.

Disaster Recovery plans and support.

Leverage state of the art relational and NoSQL databases as well integration and streaming platforms do deliver sustainable business specific data solutions.

Design data retrieval, storage & distribution solutions (and OR components thereof) including contributing to all phases of the development lifecycle e.g., design process.

Develop high quality data processing, retrieval, storage & distribution design in a test driven & domain driven / cross domain environment.

Build analytics tools that utilize the data pipeline by quickly producing well-organized, optimized, and documented source code & algorithms to deliver technical data solutions.

Beneficial Skills (Desired Skills):

Familiarity with cloud-based database infrastructure, such as Amazon Web Services (AWS), Azure or Google Cloud Platform (GCP).

CI/CD experience with Azure DevOps

Create & Maintain Sophisticated CI / CD Pipelines (authoring & supporting CI/CD pipelines in Jenkins, GitHub, Azure DevOps, or similar tools and deploy to multi-site environments supporting and managing your applications all the way to production)

Automate tasks through appropriate tools and scripting technologies e.g., Ansible, Chef

Big Data and Cloud technologies

Skill/Experience/Education

Mandatory Skills

Open-source databases. / Database management tools / Experience with SQL and NoSQL databases.

Desired Skills

Big Data and Cloud technologies

Skill

Experience with Open Source Databases 4-5 Years

3+ years of experience as a DBA, with a focus on open-source databases.

Experience with SQL and NoSQL databases. 4-5 Years

Strong scripting skills 4-5 Years

cloud-based database infrastructure experience

Imocha assessment will be triggered should the resource be shortlisted

ExecutivePlacements.com