Job Description
The responsibility the database administration specialist is to create, ensure and maintain the performance, integrity and security and disaster recovery of databases. He/ she is involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. The specific duties and responsibility for the position include:
• Provide support to application development teams, including database design, database generation, coding, and database support (installation and testing of new versions of the database management system (DBMS), diagnose and troubleshoot database errors, tuning of database systems and monitoring of performance and management of database parameters in order to allow concurrent users access and provide fast responses to system users)
• Developing/maintaining Tables, Database links, Synonyms, Stored Procedures, Functions, Packages, Triggers, Cursors, Views, and Indexes
• Modeling tables, databases, solutions to customer problems and needs by contributing to the logical design of systems so that it can be translated into a specific data model and to the physical design of systems to meet system storage requirements
• Maintain data standards, including adherence to the Data Protection Policy
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Create and manage database reports, visualizations, and dashboards
• Plan and perform scheduled changes (patching, maintenance, deployment, decommission, configuration, performance tuning) for all hardware and software used to support the database infrastructure
• Create automation for repeating database tasks
• Control access permissions and privileges
• Develop, manage and test back-up and recovery plans and manage the security and disaster recovery aspects of a database
• Recommend and implement emerging database technologies
Minimum Qualifications
-
Advanced diploma in Software Engineering
3 Years of relevant experience
-
Advanced diploma in Computer Science
3 Years of relevant experience
-
Advanced diploma in Computer Engineering
3 Years of relevant experience
-
Advanced diploma in Information and Communication Technology
3 Years of relevant experience
-
Advanced diploma in Electronics and Telecommunication Engineering
3 Years of relevant experience
-
Bachelor’s Degree in Software Engineering
3 Years of relevant experience
-
Bachelor’s Degree in Computer Science
3 Years of relevant experience
-
Bachelor’s Degree in Computer Engineering
3 Years of relevant experience
-
Bachelor’s Degree in Information and Communication Technology
3 Years of relevant experience
-
Bachelor’s Degree in Electronics and Telecommunication Engineering
3 Years of relevant experience
-
Master’s Degree in Software Engineering
1 Year of relevant experience
-
Master’s Degree in Computer Science
1 Year of relevant experience
-
Master’s Degree in Computer Engineering
1 Year of relevant experience
-
Master’s Degree in Information and Communication Technology
1 Year of relevant experience
-
Master’s Degree in Electronics and Telecommunication Engineering
1 Year of relevant experience
Competency and Key Technical Skills
-
Integrity
-
Strong critical thinking skills and excellent problem solving skills.
-
Inclusiveness
-
Accountability
-
Communication
-
Teamwork
-
Client/citizen focus
-
Professionalism
-
Commitment to continuous learning
-
Database command of SQL and SQL server tools
-
Having working knowledge of JSP, Web services, XML, ASP, JSP, PHP
-
Understanding of relational and dimensional data modelling
-
Scripting skills including but not limited to PowerShell and Unix shell, bash scripting, JavaScript…
-
Extensive experience with database technologies including but not limited to (MySQL, MS SQL, PostgreSQL, Oracle, MongoDB, Maria DB). Relevant certificates in Database administration are highly advantageous
-
Experience with cloud services including but not limited to (AWS, Microsoft Azure, google cloud, IBM cloud, Oracle cloud…);
-
Resource management skills
-
Problem solving skills
-
Decision making skills
-
Time management skills
-
Risk management skills
-
Results oriented
-
Digital literacy skills
-
Fluency in Kinyarwanda, English and/or French. Knowledge of all is an added advantage
-
Analytical skills;
-
Knowledge of relational databases and Object Relational Mapping
-
proven working experience in database development and administration
