General Summary
As a Graduate Trainee in Database Administration, you will play a crucial role in the administration and optimization of our database systems, particularly REDCap and other related systems. You will be responsible for ensuring the efficient management of data for clinical trials and observational studies through innovative use of REDCap functionalities.
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.