SQL Developer

Trexin Consulting helps large, complex organizations turn strategy into results that hold up in the real world. With 20+ years of enterprise delivery, our senior practitioners work inside regulated industries, including healthcare, where security, accuracy, and accountability are non-negotiable. Trexin is seeking a SQL Developer to join a Client engagement with a healthcare technology organization in Puerto Rico. This is a 4 to 6 month contract, with extension possible, starting as soon as possible. The consultant will backfill a departing team member and own day-to-day SQL Server development: maintaining and tuning stored procedures, running ETL processes, and administering database security and permissions. The Client's senior SQL developers lead the more complex design work, and this role works alongside them. The work touches production environments that contain protected health information (PHI). Key Areas of Responsibility
• Write, modularize, and maintain T-SQL stored procedures, functions, and views that hold business logic in Microsoft SQL Server.
• Tune underperforming queries and procedures: read execution plans, rewrite inefficient logic, replace cursors and row-by-row processing with set-based logic, and use Common Table Expressions (CTEs) and indexing appropriately.
• Build, maintain, and troubleshoot SQL Server Integration Services (SSIS) packages and T-SQL scripts that move data between staging and production environments.
• Ingest large datasets efficiently using BCP (Bulk Copy Program) and BULK INSERT, including validation of loaded data and handling of load errors.
• Monitor scheduled jobs and ETL runs, resolve failures, and document root cause and fixes.
• Provision SQL logins and database users and assign them to standard roles such as db_datareader and db_datawriter.
• Grant and revoke explicit EXECUTE, SELECT, and UPDATE permissions on schemas, tables, and stored procedures to maintain the principle of least privilege, and support periodic access reviews.
• Follow change management, code review, and deployment controls for every production change, including testing in lower environments and documented rollback steps.
• Handle PHI in line with HIPAA and Client security policies, applying the minimum necessary standard to data access, queries, and extracts.
• Escalate complex design, architecture, and performance issues to the Client's senior SQL developers and collaborate on solutions.
• Keep clear documentation of procedures, packages, and permission changes to support continuity and handoff. Key Desired Skills, Experience and Knowledge
• 3+ years of hands-on Microsoft SQL Server (T-SQL) development in production environments.
• Strong experience writing and performance tuning stored procedures, including execution plan analysis and set-based rewrites.
• Hands-on experience building and maintaining SSIS packages.
• Experience loading large data volumes with BCP and BULK INSERT.
• Working knowledge of SQL Server security: logins, users, database roles, and schema and object permissions.
• Experience with SQL Server Agent jobs and source control (Git or Azure DevOps).
• Experience working with PHI or other regulated data, and working knowledge of HIPAA privacy and security requirements.
• Disciplined approach to production work: change control, testing, and careful, documented execution.
• Ability to ramp up quickly on an existing codebase and work independently with minimal oversight.
• Clear written and verbal communication in English; Spanish is a plus.
• Healthcare, pharmacy benefit, or health plan data experience is a plus.
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience. Trexin is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Trexin is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Trexin are based on business needs, job requirements, and individual qualifications. Trexin strictly prohibits and does not tolerate discrimination against employees, applicants, or any other covered persons because of race, color, religion, creed, national origin or ancestry, ethnicity, sex (including pregnancy, childbirth, or related medical conditions), gender (including gender nonconformity and status as a transgender individual), sexual orientation, age, physical or mental disability, citizenship, past, current, or prospective service in the uniformed services, genetic information, or any other characteristic protected under applicable federal, state, or local law. Trexin complies with the Americans with Disabilities Act (ADA), as amended by the ADA Amendments Act, and all applicable state or local law. Consistent with those requirements, Trexin will reasonably accommodate qualified individuals with a disability if such accommodation would allow the individual to perform the essential functions of the job, unless doing so would create an undue hardship. Trexin will also, where appropriate, provide reasonable accommodations for an employee's religious beliefs or practices. Trexin strictly prohibits discrimination against protected veterans, and Trexin utilizes affirmative action to recruit, hire, promote, and retain veterans. Trexin Consulting does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies in response to job postings. No fee will be paid to third parties who submit unsolicited candidates directly to our hiring managers or Recruiting Team. All candidates must be submitted via our Applicant Tracking System by approved Trexin Consulting vendors who have been expressly requested to make a submission by our Recruiting Team for a specific job opening. No placement fees will be paid to any firm unless such a request has been made by the Trexin Consulting Recruiting Team and such candidate was submitted to the Trexin Consulting Recruiting Team via our Applicant Tracking System.