What are the responsibilities and job description for the Senior SQL Database Developer / Project Lead position at HTC Global Services?
Job Title: Senior SQL Database Developer / Project Lead
Overview / Summary
Seeking a Senior SQL Database Developer / Project Lead to support the STD/HIV program area and related public health systems. This role will contribute to data migrations, data warehousing initiatives, data pipeline improvements, Electronic Case Reporting (eCR) solutions, and ongoing support of disease surveillance and laboratory systems. The position requires collaboration with technical teams, program staff, vendors, and stakeholders to design, develop, optimize, test, and support critical data processes and systems.
Key Responsibilities
- Support migration efforts related to Electronic Disease Surveillance Systems (EDSS).
- Participate in data warehousing, reporting, and data pipeline improvement initiatives.
- Gather and document functional requirements and perform gap analysis with end users.
- Create and maintain process documentation, data flows, and diagrams.
- Design, develop, automate, and optimize ETL processes.
- Develop and maintain SQL stored procedures, advanced queries, and reports.
- Perform query debugging, optimization, and performance improvements using MS T-SQL.
- Rewrite and optimize existing SAS solutions into SSIS packages and Power BI solutions.
- Develop, modify, monitor, and support data pipelines and reporting processes.
- Assist with formatting and automating data uploads into data warehouse and disease surveillance systems.
- Parse and process multiple data formats including XML, CSV, SOAP, and HL7.
- Support system, database, and data migrations, including testing and validation activities.
- Assist with eCR onboarding, data import, utilization, automation, troubleshooting, analysis, and reporting.
- Monitor production processing to ensure proper data flow and response times.
- Automate and support daily maintenance processes.
- Troubleshoot, debug, optimize, and resolve processing issues.
- Support server, database, software upgrades, and environment configuration activities.
- Ensure business continuity and maximum uptime for critical systems.
- Advise team members on database design, query optimization, automation, reporting, and best practices.
- Mentor team members and staff on advanced technical topics.
- Coordinate with managers, project managers, vendors, contractors, and technical teams on assignments and deliverables.
- Provide project estimates, status reporting, and progress updates.
- Ensure compliance with IT standards, security policies, procedures, and documentation requirements.
Required Qualifications
- 3 years of experience with MS T-SQL, including stored procedures, advanced queries, and optimization.
- 3 years of experience with ETL process development.
- 1 year of experience with SQL Server Integration Services (SSIS).
- 3 years of experience with report development.
- 3 years of experience with data warehousing and relational databases.
- 1 year of experience with HL7 v2.3.1 2.5.1 and ORU messages.
- 3 years of experience working with XML.
- 3 years of experience with Microsoft SQL Server 2016 .
- 1 year of experience with security and data classification related to CDC, HIPAA, CJIS, PHI, and PII.
- Ability to work independently with limited supervision while collaborating effectively with technical teams and stakeholders.
- Strong written, verbal, and interpersonal communication skills.
- Experience preparing technical documentation, specifications, data flows, and process diagrams.
- Ability to manage project tasks, estimates, status reporting, and milestone completion.
What Makes HTC A Great Place To Build Your Future
HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.
At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.
Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.
#LI-SK8 #LI-Remote #Hiring