The Management Sciences for Health (MSH), a global health nonprofit organization, uses proven approaches developed over 40 years to help leaders, health managers, and communities in developing nations build stronger health systems for greater health impact. We work to save lives by closing the gap between knowledge and action in public health.
We are recruiting to fill the position below:
Job Title: Database Administrator
Reference ID: R2397 Location: Abuja
Employment Type: Full Time
The Database Administrator (DBA) is responsible for providing database management, operations, and services to the organization, globally, to support all our platforms.
She/he will coordinate the design, development, and deployment of a data warehouse for Management Sciences for Health (MSH).
They will work closely with other individuals to identify MSH and project information needs from the data warehouse to ensure that business intelligence functionality supports these requirements.
In addition, the DBA may be asked to provide technical support for other projects, based on their skills and experience.
Consolidation and Analysis of Existing Databases (30%):
Create a list of all databases associated with platforms
Identify owners for each database (vendor, MSH office, center, etc.)
Analyze database specifications, backup files, indexes, etc., and determine how performance can be improved.
Determine where these databases should be hosted
Determine access/account structures and permissions.
Guidelines, Standards, and Processes (20%):
Define and document database guidelines, standards, and processes
Document backup and recovery, mirroring, and replication guidelines
Document account/permission structures for each database
Respond to technical queries as needed
Works closely with supporting network, server, and disk storage teams to facilitate managed balanced systems utilizing mirroring and availability groups as necessary
Proactively develop and implement policies and procedures to improve the overall effectiveness and integrity of the company's databases and platforms.
Data Warehousing (15%):
Perform technical assessments and recommend design/process changes for operationalizing the data warehousing and business intelligence infrastructure
Train users in analytical processing of data warehouse information in line with business information requirements.
Design, implement and document routine, periodic, and emergency data warehouse maintenance plans including backup, disaster recovery, fail-safe strategies, scale-up plans, optimization, security, and data warehouse administration.
Actively participate in the design and implementation of transition plans for data warehouse operations, maintenance, and user support.
Execute special projects or other related duties as may be assigned from time to time, depending on experience and skills.
Technical Support (25%):
Write SQL Queries, Stored Procedures to support product development as needed
Provide technical support as needed.
Participate in IS and MSH meetings to provide regular status updates and keep up to date with organization and other group activities.
Other duties as assigned.
Bachelor’s Degree in Computer Science.
At least 6 six years of relevant experience with physical and logical database design, development, implementation, monitoring and administration of large SQL environments, including replication and security of databases.
Extensive experience with MS SQL Server (tables, triggers, unions, joins, complex queries, and stored procedures) and MySQL (must be able to write high-quality SQL scripts.
Knowledge and Skills:
In-depth knowledge and understanding of RDBMS architecture and data warehousing concepts
Excellent understanding of database installation, configuration, partitioning, performance tuning, analysis, and optimization of databases
Must be able to manage and maintain database account, permissions, and database security at all levels
High experience of testing and implementing backup and recovery of databases