Trinetix is seeking a Senior PL SQL Developer to support projects focused on healthcare data systems, RCM (Revenue Cycle Management) processes, and data-driven automation initiatives. This role requires a deep understanding of claims data, industry-standard data formats (e.g., 837/835), and the broader healthcare data ecosystem. The ideal candidate is technology-sound, technically skilled, adaptable, and capable of working across systems to analyze trends, identify process gaps, and help implement databases, datamarts and data storage, reporting solutions in healthcare operations.
Requirements
- 7+ years of hands-on experience in Oracle SQL and PL/SQL development.
- A good knowledge and experience working with Oracle or SQL Server is required.
- Strong knowledge of Oracle SQL Developer IDE.
- Ability to proactively perform Oracle/SQL Server recovery scenarios and operating system performance monitoring.
- Good skills in various Database monitoring tools.
- Proficiency in writing basic to moderately complex SQL and PL/SQL code, data querying (SQL) as well as reporting, data extractions etc.
- Experience with other database technologies (SQL Server, PostgreSQL, MySQL).
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 and drive data analysis, modeling, and database design discussions aligned with business requirements in healthcare and claims management.
- Design scalable backend database logic (for e.g. for clinical, billing, RCM (Revenue Cycle Management), and patient data workflows).
- Demonstrate and leverage strong knowledge of Oracle SQL Developer IDE.
- Translate business needs into technical solutions using SQL and PL/SQL, working closely with business analysts, solution architects, and QA teams.
- Support all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, as well as Database Replication, Database performance tuning and execution plan analysis.
- Develop and maintain ETL logic and data transformation pipelines using PL/SQL or Oracle tools for data integration from various healthcare systems (e.g., EHR, Claims, RCM).
Other
- Understanding of HIPAA and healthcare data privacy and compliance regulations.
- 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.
- Experience and knowledge in migrating code, database changes and data through the various stages of the development life cycle.
