Database Administrator

**JOB DESCRIPTION DETAILS**

**Job Title**:Database Administrator

**Work Location**:Johannesburg

**More about the Area & Team**:
**More about the project**:
**Job Description / Responsibilities**:

- Install, configure, and maintain open-source databases, such as PostgreSQL, MySQL, MariaDB 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 modeling 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 in order 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).
- Create business cases & solution specifications for various governance processes (e.g., CTO, Architecture, and governance approval forums).
- Deliver on time & on budget (always).

**Background and experience required**:

- 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)**:

- 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 No-SQL 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 de