Database Engineer at DT One

About The Role

Reporting to the Senior Manager - Infrastructure Operations, this role will be based in Nairobi, Kenya. The incumbent will be working closely with our Data Engineering, BI and RA teams to support current and new deployments and support the business move the platform and products forward. This position is required to be hands-on, while equipped with the necessary technical expertise.

You Will Be

• Passionate about Data, Database performance and the impact it has on business decisions
• Proud of your work but always believing the best is yet to come
• Able to take criticism positively and to learn from mistakes
• Able to self critique and analyze and be motivated to constantly improve and develop both professionally and personally
• High attention to detail
• See process, procedure and documentation as tools to support excellence
• Customer focused and understands the business we are operating in.

Key Role Responsibilities

• Responsible for installing and management of database engines.
• Mapping out the conceptual design for a planned database outline (database design and development)
• Responsible for configuring, monitoring and improving PostgreSQL databases.
• Performing query analysis to understand how teams are using the data and if system queries are optimal.
• Review and Optimize database queries to manage database optimal performance.
• Measure and optimize database performance.
• Run the production environment by monitoring availability and taking a holistic view of the database system health
• Improve reliability, quality, and time-to-market of our services.
• Implement automated tools to monitor query performance on the database (PgAnalyze, PgCluu)
• Controlling access permissions and privileged
• Implement database management best practices when managing the Databases.
• Maintaining data standards, including adherence to the data protection act
• Planning backup and recovery of database information and managing data replication.
• Developing managing and testing backup and recovery procedures by Ensuring storage, archiving, backup and recovery procedures and functioning correctly.
• Writing database documentation, including data standards, procedures and definition of the data dictionary (metadata)

Daily and Monthly Responsibilities

• Gather and analyze metrics from the database to assist in performance tuning and fault finding
• Partner with development teams to improve services through query analysis and optimization.
• Create sustainable systems and services through automation, DB optimization and uplifts

Essential Experience

• A Bachelor's degree in computer engineering or a related field.
• 5 or more years' field in technical efficiency experience in Postgres SQL DBA role.
• Strong experience as a Database Administrator / DBA including performance tuning and optimization
• Expert knowledge of database structure languages, such as PostgreSQL
• Experience of building and deploying PostgreSQL clusters into production
• Experience with Process automation using Python Scripts
• Excellent proficiency in Linux systems administration
• Understanding of and experience with server-client computing and relational database environments.
• Experience with data management and data flowing techniques.
• Knowledge of reporting and query tools and practices.
• Experience of working with high availability, scalable environments
• A proactive approach to spotting problems, areas for improvement, and performance bottlenecks
• Collaborative with strong communications skills, comfortable liaising with the business to understand user needs
• Strong analysis and problem-solving skills

Desired Experience

• Knowledge of Data Security, Secure Coding, Encryption, Multi-tenancy, Scalability, and High Availability
• Experience with software development best practices - include handling and logging errors, monitoring the system, building fault-tolerant pipelines, understanding how to scale up, addressing continuous integration
• Knowledge in Technology Stacks (Cloud, Containers, Kubernetes etc).
• Working knowledge of ITIL / Cobit / Agile (certification an advantage).
• Solid understanding of payment industry and multi-channel commerce space
• Experience with, and preference for, leveraging open source solutions
• Experience with a mix of large enterprise customers as well as small, high-value customers