Vacancy title:
Database Engineer
Jobs at:
DT OneDeadline of this Job:
31 May 2022
Summary
Date Posted: Wednesday, May 18, 2022 , Base Salary: Not Disclosed
JOB DETAILS:
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
Work Hours: 8
Experience in Months: 60
Level of Education: Bachelor Degree
Job application procedure
Use the link below to apply.
https://dtone.bamboohr.com/jobs/view.php?id=321
All Jobs
Join a Focused Community on job search to uncover both advertised and non-advertised jobs that you may not be aware of. A jobs WhatsApp Group Community can ensure that you know the opportunities happening around you and a jobs Facebook Group Community provides an opportunity to discuss with employers who need to fill urgent position. Click the links to join. You can view previously sent Email Alerts here incase you missed them and Subscribe so that you never miss out.