Trinetix is seeking a Middle level PL SQL Developer to support projects focused on healthcare data systems, and data-driven automation initiatives. This role requires a understanding of healthcare data, industry-standard data formats (e.g., 837/835), and the ability to analyze trends, identify process gaps, and help implement databases, datamarts and data storage, reporting solutions in healthcare operations.
Requirements
- 4+ years of hands-on experience in Oracle SQL and PL/SQL development
- 3 years of experience working with healthcare data and entities such as patient demographics, encounters, lab/test results, claims (professional & facility), and electronic health records (EHR/EMR).
- Hands-on experience with HIPAA-compliant data handling, PHI/PII data masking, and regulatory requirements in US healthcare.
- A good knowledge and experience working with Oracle or SQL Server is required
- Strong knowledge of Oracle SQL Developer IDE
- Proficiency in writing basic to moderately complex SQL and PL/SQL code, data querying (SQL) as well as reporting , data extractions etc.
- Database performance tuning and execution plan analysis
Responsibilities
- Lead design, development, optimization, and maintenance of complex PL/SQL programs, stored procedures, functions, packages, and triggers in Oracle (11g/12c/19c).
- Participate in data analysis, modeling, and database design discussions and support Design scalable backend database logic
- Translate business needs into technical solutions using SQL and PL/SQL, working closely with business analysts, solution architects, and QA teams
- Supports all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
- Develop and maintain ETL logic and data transformation pipelines using PL/SQL
- Tune and optimize existing PL/SQL code and database queries for performance improvement.
- Writing efficient and optimized queries, stored procedures, functions, triggers, and packages
Other
- Bachelor’s degree in Healthcare Informatics, Business, Data Science, or a related field.
- Oracle PL/SQL Developer certification (preferred)
- Strong communication and stakeholder engagement skills.
- Ability to navigate ambiguity and translate complex business needs into clear, actionable requirements.
- Collaborative, self-motivated, and solution-oriented.
