Middle PL SQL Developer

Trinetix; North Carolina; On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Continuous learning

Flexible working hours

Inclusive culture

Job summary

A tech service provider is seeking a Middle level PL SQL Developer to enhance healthcare data systems and automation solutions. Candidates should have over 4 years of Oracle SQL and PL/SQL experience, strong understanding of healthcare data, and familiarity with HIPAA compliance. This role involves designing and optimizing complex PL/SQL programs, collaborating with teams, and supporting database management in a dynamic and innovative environment.

Qualifications

• 4+ years of hands-on experience with Oracle SQL and PL/SQL.
• Experience with healthcare data and regulatory requirements.
• Strong knowledge of database technologies.
• Experience migrating code and database changes.

Responsibilities

• Lead design and development of complex PL/SQL programs.
• Participate in data analysis and database design discussions.
• Translate business needs into technical solutions.
• Support database object management and performance tuning.

Skills

Oracle SQL

PL/SQL

Healthcare Data Knowledge

Data Analysis

Data Performance Tuning

SQL Server

PostgreSQL

MySQL

HIPAA Compliance

Agile Methodologies

Education

Bachelor's degree in Healthcare Informatics or related field

Oracle PL/SQL Developer certification

Tools

Oracle SQL Developer IDE

JIRA

Git

Confluence

Job description

Job Description

Trinetix is seeking technical-savvy 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).

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.
• Experience with other database technologies (SQL Server, PostgreSQL, MySQL)
• Database performance tuning and execution plan analysis
• Experience with data analysis , database monitoring, and data troubleshooting

Nice‑to‑have

• Experience and knowledge in migrating code, database changes and data through the various stages of the development life cycle.
• Prior exposure to domains like encounters, long term care, renal care, chronic disease management, patient analytics, population health management, medication management, or clinical quality reporting datasets is preferred.
• Knowledge of Data Warehousing , relational databases and Star/Snowflake , 3NF schemas
• Experience with Operating System commands and scripting
• Knowledge of physical database design is preferred
• Exposure to HL7/FHIR data standards
• Experience working in healthcare payer/provider settings
• Familiarity with version control systems and tools like JIRA, Git, Confluence
• Agile/Scrum participation experience.
• Bachelor's degree in Healthcare Informatics, Business, Data Science, or a related field.
• Oracle PL/SQL Developer certification (preferred)

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 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
• Assists with impact analysis of any changes made to the database objects.
• 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.
• Participate in development sprints, documentation, and release management following agile practices
• Writing efficient and optimized queries, stored procedures, functions, triggers, and packages
• Support bug fixes, code enhancements, and troubleshooting production issues.
• Perform routine database object management (tables, indexes, views, etc).
• Prepare scripts and contribute to release management and deployment.

Soft Skills

• 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.

Why Join Us?

• 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.