Database Administrator

Key Responsibilities

• REDCap Administration: Regularly update REDCap to the latest stable version, manage project approvals, create user accounts, enable necessary modules, and provide general administrative support.
• Database Design and Setup: Assist in designing and developing REDCap data dictionaries that align with the IDI data harmonization strategy. Support data managers with queries related to data dictionary development.
• REDCap Mobile Setup: Facilitate offline data collection by setting up mobile devices and training data collection teams on using REDCap mobile.
• Data Warehouse Development: Develop and maintain the integration of various REDCap projects into a data warehouse.
• Automation: Automate REDCap procedures, query generation, and report visualization using reporting services and PowerBI.
• Database Maintenance: Monitor database performance, troubleshoot issues, and apply updates or patches as necessary.
• Backup and Recovery: Develop and implement backup strategies to ensure data integrity and recovery in case of hardware failures or data corruption.
• Security Management: Enforce security protocols to protect sensitive data, including managing user access and encryption.
• Performance Tuning: Optimize database performance through query tuning, indexing, and efficient database storage management.
• Data Integrity: Ensure data accuracy and consistency through validation rules and routine data queries for research teams.
• Data Harmonization: Use the OMOP Common Data Model to harmonize REDCap data, ensuring it is Findable, Accessible, Interoperable, and Reusable (FAIR). Support standardization efforts, especially for existing REDCap data.
• Support and Training: Assist data managers and research staff with REDCap challenges and provide training on new features and innovative usage of REDCap.
• SOP Development: Write Standard Operating Procedures (SOPs) for data security, backup and recovery, data standardization, de-identification, and data transfer.

Academic Qualification

• Recent graduate or pending graduation with a Bachelor’s degree in Computer Science, Information Technology, or a related field.
• A minimum CGPA of 4.0 is required.

Person Specification

Skills and Qualifications

• Recent graduate or pending graduation with a Bachelor’s degree in Computer Science, Information Technology, or a related field.
• A minimum CGPA of 4.0 is required.
• Basic knowledge of SQL and database management systems (DBMS) such as MySQL or SQL Server.
• Familiarity with REDCap or similar EDC systems.
• Programming knowledge in SQL, R or Python is an added advantage.

Technical Skills:

• Basic understanding of database concepts and proficiency in SQL programming.
• Familiarity with database management systems (DBMS) such as MySQL or SQL Server.
• Exposure to REDCap or similar Electronic Data Capture (EDC) systems is advantageous.
• Knowledge of programming languages such as SQL, R or Python is a plus.

Core Competencies:

• Strong problem-solving skills with meticulous attention to detail.
• Excellent verbal and written communication skills.
• Demonstrated leadership experience, even at a minimal level, is added advantage.
• Proven ability to work effectively in a collaborative team environment and engage with diverse stakeholders.
• Eagerness to learn new technologies and adapt to evolving technical environments.

CLICK HERE TO APPLY