SQL Developer II

Required Application Materials

A single PDF or Word document containing a resume, letter of interest, and a list of the names and contact information for three (3) professional references is required to apply.

Important Instructions:

When prompted to upload your “resume”, upload your combined documents as one file.

• Please do not upload documents to “Cover Letter” or “References”.

If the required application materials were not uploaded at the “resume” prompt, please withdraw your application, and re-apply to upload your combined documents as one file.

Job Summary

The SQL Developer II will play a key role in supporting the Institute for Health Innovation, Data Science, and Research (IHI-DSR) by designing, developing, and analyzing advanced database solutions. This position involves evaluating existing workflows, procedures, technologies, and data sources to identify opportunities for increased efficiency, cost reduction, and enhanced stakeholder support—including researchers, faculty, and students. The developer will create automated queries and functions to streamline operations and ensure data is effectively stored, retrieved, and manipulated to meet the institute’s evolving needs. This role also includes managing the Microsoft Azure Fabric environment and ensuring the security of clinical data in collaboration with the IT security team. Occasional evening work may be required.

Major Responsibilities/Duties/Critical Tasks

• Design, code, and test reports, queries, processes, and programs according to technical specifications.
• Maintain the overall health of supported databases and database systems, including high availability, backup, space allocation, security protocols, integrity, security, and efficiency.
• Manage and maintain the Microsoft Azure Fabric environment, including deployment, monitoring, scaling, and troubleshooting of cloud-based database solutions.
• Oversee the security and integrity of clinical data, ensuring compliance with institutional, state, and federal regulations (e.g., HIPAA), in collaboration with the IT security team.
• Work with users and other IT staff to perform troubleshooting as needed.
• Acquire, integrate, and extract data from existing internal and/or external data sources as required to meet regulatory, institution, and user needs.
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• Serve as lead for various projects and assignments with functional staff and other departments, analysts, and developers.
• Provide on-going technical support for the department.
• Facilitate updates and upgrades for vendor software.
• Required maintain knowledge on current on future pertinent technologies.
• Identify and research new features that can be used in development or for functional staff.
• Other duties as assigned.

Required Education/Experience

• Bachelor's degree with an emphasis in data science, computer science or informatics.
• Four (4) years of related experience.
• May accept a combination of education and experience.

Preferred Education/Experience

• Master’s degree with an emphasis in data science, computer science or informatics.
• Experience in healthcare systems, focused on technical and analytic development.
• Experience leading project development, and/or scripting languages.
• Experience with cloud-based solutions like Azure SQL Database and Azure Fabric.
• Experience with clinical data management and security.

Preferred Certifications/Licenses

• Microsoft Certified: Azure Database Administrator Associate or similar.
• SQL certified.
• Epic certified

Accompanying Knowledge, Skills, Abilities and Competencies

• Advanced understanding of relational databases.
• Proficient understanding of new Microsoft systems infrastructure.
• Demonstrated experience and advanced skills using a variety of software, database and data analysis tools.
• Advanced skills in writing queries and scripts using common tools such as SAS, R, SQL Developer, SQL Server Reporting Services (SSRS) or similar tools.
• Comprehensive understanding of indexing, normalization, and relational database principles.
• Ability to learn and work with multiple programming languages while researching technical solutions and solving coding challenges.
• Extensive customer service skills, both in person and over the phone.
• Strong analytical, critical and problem-solving skills to identify and resolve issues efficiently.
• Detail-oriented with the ability to manage multiple responsibilities effectively with a demonstrated record of completing assignments.
• Excellent oral and written communication skills with the ability to communicate complex information to an audience in an understandable manner.
• Respond flexibly and positively in all circumstances, working calmly under pressure.

About The University of Texas at Tyler and UT Tyler Health Science Center

The University of Texas at Tyler is part of the prestigious University of Texas System that includes 14 institutions located throughout the state. Founded in 1971, UT Tyler today enrolls 10,000 students and consists of six colleges.

Designated an R2 research institution by the Carnegie Classification of Institutions of Higher Education, UT Tyler supports our surrounding region through innovation intended to uplift communities, spearhead sustainability initiatives, preserve ecosystems and support entrepreneurship. UT Tyler has the highest Carnegie classification in East Texas.

Providing exceptional patient care, comprehensive education and innovative research, The University of Texas at Tyler Health Science Center and UT Health East Texas combine to serve as the university medical center for Northeast Texas and beyond.

For more information, please visit https://www.uttyler.edu/about.

Additional Information

The retirement plan for this position is Teacher Retirement System of Texas (TRS), subject to the position being at least 20 hours per week and at least 135 days in length.

This position is security-sensitive and subject to Texas Education Code Section 51.215, which authorizes the employer to obtain criminal history record information. Applicants selected must be able to show proof of eligibility to work in the United States by time of hire.

For more information regarding benefits offered by UT Tyler, please visit https://www.uttyler.edu/offices/human-resources/employees/benefits.

Clinical Position Requirements

Clinical positions may be required to complete a pre-employment health screening, following a contingent job offer, to determine whether they possess the physical capabilities needed to safely fulfill the specific demands of the position. Additionally, clinical positions require compliance with the University’s Vaccine Preventable Disease Policy.

EEO Statement

The University of Texas at Tyler is an Equal Employment Opportunity Employer.