onsite
Database Programmer - NCCT CTMC Informatics - aah
Software Engineer
Develop and maintain high‑performance database solutions for NCCT CTMC Informatics, focusing on Oracle environments, complex SQL/PLSQL programming, data modeling, and ETL processes to support clinical and research data workflows.
About the role
Key Responsibilities
- Design, develop, and optimize Oracle database schemas, tables, indexes, and stored procedures to meet application and reporting requirements.
- Write, test, and maintain complex SQL and PL/SQL code, including functions, packages, and triggers.
- Implement and manage ETL pipelines to extract, transform, and load clinical and research data from multiple sources.
- Collaborate with data analysts, scientists, and software engineers to ensure data integrity, performance, and security.
- Perform database performance tuning, troubleshooting, and capacity planning.
- Document database designs, code standards, and operational procedures.
Requirements
- Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent experience.
- 3+ years of hands‑on experience with Oracle databases and advanced SQL/PLSQL development.
- Proficiency in data modeling techniques and tools (e.g., ERwin, PowerDesigner).
- Experience building and maintaining ETL workflows using tools such as Informatica, SSIS, or custom scripts.
- Strong problem‑solving skills, attention to detail, and ability to work collaboratively in a multidisciplinary team.