Database Administrator
Job Purpose:
This role is responsible
for development of databases in the environment in accordance to the set
standards to meet business objectives. Work includes a broad range of complex
technical or professional activities, in a variety of contexts. Investigates, defines
and resolves complex issues.
Description:
Reports to: Software Development
Manager
Direct Reports: None
Key Responsibilities
Administer
database management system support activities for operational database systems.
2. Gather requirements, design-build, and implement study databases and data
collection tools
Evaluate
potential solutions, and demonstrate, install and commission selected products.
Translate
object and data models into appropriate database schemas within design
constraints.
Integrate
data across applications and DBMSs.
Set
data constraints and perform data cleanup to ensure data quality.
Facilitate
database development and implementation processes;
Liaise
with developers on development project requirements and implement physical
database structures.
Develop
basic knowledge of database concepts, object and data modelling techniques and
design principles.
Assesses
proposed changes to objects and data structures and implement changes in
physical databases.
Interpret
installation standards to meet project needs and produces database components
as required; 
Ensure
data security by controlling data access through user authentication and
connecting applications.
Develop,
manage and test back-up and recovery plans.
Capacity
planning by projecting resource utilization;
Monitor
performance and manage parameters to provide fast responses to front-end users;
Conduct
database backup, storage and archiving; and
Writing
database documentation, including data standards, procedures and definitions
for the data dictionary (metadata).
Improve
and document the technical processes around application support (using
Confluence)
Financial Responsibility: None
Minimum Requirements
Bachelor’s
degree computer science or in related specialization of study
Minimum
3 years’ experience in database management in environments with Opensource SQL
database (MySQL/Maria DB, PostgreSQL).
Experience
in with different database environments and integrating them with web and
mobile applications
Familiarity
with architecture styles/APIs (REST, RPC)
Knowledge
and experience working with agile methodologies.
Familiarity
with secure coding standards.
Experience
in patching, upgrades, Database hardening, password management and
vulnerability management
Desirable
At
least one DBA certification e.g., OCA, MYSQL, MCSA
Experience
in Electronic Data Collection systems such e.g., Redcap, ODK, Open Clinica
Experience
in working in a research institution and support for clinical applications.
Experience
in supporting Microsoft Navision for end users.
Experience
in working with SharePoint, power BI, power automate and power apps.
Competencies:
Demonstrate
high levels of integrity
Analytical
and problem-solving skills
Ability
to multi-task and stay organized in a dynamic work environment
Ability
to provide adhoc support to different database environments
Strong
interpersonal and communications skills, both in writing and oral
Logical
diagnostic skills and ability to exercise good judgement in the resolution of
problems
Ability
to learn new programming languages quickly.
Ability
to write, edit, and debug computer programs to achieve desired output.
Strong
understanding of the software development cycle.
Good
presentation skills;
How To Apply
