Trinetix
Trinetix is seeking a technical‑savvy 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 reporting solutions in healthcare operations.
Core 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 clinical, billing, RCM, 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, performance tuning, and execution plan analysis.
Assist with impact analysis of any changes made to database objects.
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).
Lead peer reviews of SQL and PL/SQL code and provide technical mentorship to junior developers.
Support data quality, lineage, and governance efforts across clinical and financial systems.
Write efficient and optimized queries, stored procedures, functions, triggers, and packages.
Requirements
7+ years of hands‑on experience in Oracle SQL and PL/SQL development.
Strong experience with Oracle or SQL Server.
Proficiency with Oracle SQL Developer IDE.
Good knowledge of physical database design.
Ability to perform Oracle/SQL Server recovery scenarios and OS performance monitoring.
Skills in database monitoring tools.
Experience with cross‑database replication (e.g., Golden Gate) preferred.
Proficient writing basic to moderately complex SQL and PL/SQL, data querying, reporting, and data extraction.
Experience with other database technologies (SQL Server, PostgreSQL, MySQL).
Experience with data analysis and troubleshooting.
Experience working with relational data models and normalized schemas.
Understanding of HIPAA and healthcare data privacy and compliance regulations.
Nice‑to‑Haves
Experience with code migration, database changes, and data lifecycle stages.
Exposure to clinical domains such as encounters, long‑term care, renal care, chronic disease management, patient analytics, population health, medication management, or clinical quality reporting.
Familiarity with ETL tools (Oracle Data Integrator, Informatica, etc.).
Knowledge of data warehousing and star/snowflake schemas and HL7/FHIR standards.
Experience with cloud databases (Oracle Cloud, Azure SQL, AWS RDS).
Familiarity with version control (JIRA, Git, Confluence).
Bachelor’s degree in Healthcare Informatics, Business, Data Science, or related field.
Oracle PL/SQL Developer certification preferred.
Soft Skills
Strong communication and stakeholder engagement.
Ability to navigate ambiguity and translate complex business needs into clear, actionable requirements.
Collaborative, self‑motivated, and solution‑oriented.
Benefits
Contribute to meaningful projects that improve healthcare financial operations and data quality.
Work alongside healthcare experts, engineers, and innovators in a dynamic, agile environment.
Be part of a mission‑driven team focused on modernizing healthcare data ecosystems.
Opportunities for growth, leadership, and cross‑functional collaboration.
What We Offer
Continuous learning and career growth opportunities.
Flexible working hours.
Inclusive and supportive culture.
About Us Established in 2011, Trinetix is a dynamic tech service provider supporting enterprise clients around the world. Headquartered in Nashville, Tennessee, we have a global team of over 1,000 professionals and delivery centers across Europe, the United States, and Argentina. We partner with leading global brands, delivering innovative digital solutions across Fintech, Professional Services, Logistics, Healthcare, and Agriculture. Our operations are driven by a strong business vision, a people‑first culture, and a commitment to responsible growth. We actively give back to the community through various CSR activities and adhere to international principles for sustainable development and business ethics.
#J-18808-Ljbffr
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 reporting solutions in healthcare operations.
Core 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 clinical, billing, RCM, 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, performance tuning, and execution plan analysis.
Assist with impact analysis of any changes made to database objects.
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).
Lead peer reviews of SQL and PL/SQL code and provide technical mentorship to junior developers.
Support data quality, lineage, and governance efforts across clinical and financial systems.
Write efficient and optimized queries, stored procedures, functions, triggers, and packages.
Requirements
7+ years of hands‑on experience in Oracle SQL and PL/SQL development.
Strong experience with Oracle or SQL Server.
Proficiency with Oracle SQL Developer IDE.
Good knowledge of physical database design.
Ability to perform Oracle/SQL Server recovery scenarios and OS performance monitoring.
Skills in database monitoring tools.
Experience with cross‑database replication (e.g., Golden Gate) preferred.
Proficient writing basic to moderately complex SQL and PL/SQL, data querying, reporting, and data extraction.
Experience with other database technologies (SQL Server, PostgreSQL, MySQL).
Experience with data analysis and troubleshooting.
Experience working with relational data models and normalized schemas.
Understanding of HIPAA and healthcare data privacy and compliance regulations.
Nice‑to‑Haves
Experience with code migration, database changes, and data lifecycle stages.
Exposure to clinical domains such as encounters, long‑term care, renal care, chronic disease management, patient analytics, population health, medication management, or clinical quality reporting.
Familiarity with ETL tools (Oracle Data Integrator, Informatica, etc.).
Knowledge of data warehousing and star/snowflake schemas and HL7/FHIR standards.
Experience with cloud databases (Oracle Cloud, Azure SQL, AWS RDS).
Familiarity with version control (JIRA, Git, Confluence).
Bachelor’s degree in Healthcare Informatics, Business, Data Science, or related field.
Oracle PL/SQL Developer certification preferred.
Soft Skills
Strong communication and stakeholder engagement.
Ability to navigate ambiguity and translate complex business needs into clear, actionable requirements.
Collaborative, self‑motivated, and solution‑oriented.
Benefits
Contribute to meaningful projects that improve healthcare financial operations and data quality.
Work alongside healthcare experts, engineers, and innovators in a dynamic, agile environment.
Be part of a mission‑driven team focused on modernizing healthcare data ecosystems.
Opportunities for growth, leadership, and cross‑functional collaboration.
What We Offer
Continuous learning and career growth opportunities.
Flexible working hours.
Inclusive and supportive culture.
About Us Established in 2011, Trinetix is a dynamic tech service provider supporting enterprise clients around the world. Headquartered in Nashville, Tennessee, we have a global team of over 1,000 professionals and delivery centers across Europe, the United States, and Argentina. We partner with leading global brands, delivering innovative digital solutions across Fintech, Professional Services, Logistics, Healthcare, and Agriculture. Our operations are driven by a strong business vision, a people‑first culture, and a commitment to responsible growth. We actively give back to the community through various CSR activities and adhere to international principles for sustainable development and business ethics.
#J-18808-Ljbffr