SQL Database Developer

Job: SQL Database Developer

Location: Remote

• Specific duties and responsibilities will include but are not limited to the following:
• Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
• Work with end users to perform gap analysis, gather and document functional

requirements, and create necessary processes.

• Assist with project and time management including estimates and status reporting.
• Ability to plan, organize, review, and implement associated project milestones to completion.
• Process Development, Process Automation, and ETL Solutions.
• SQL stored procedure creation, advanced query design, debugging, and optimization (MS T-SQL).
• Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging, Rewriting and optimization of remaining SAS code and queries as needed.
• Data Pipeline and Reporting Development, Modification, Improvement, and Monitoring.
• Help format and automate data uploads into the Data Warehouse and Disease urveillance Systems like CDC SAMS / eHARS and the new Electronic Disease Surveillance System (EpiTrax).
• Parsing of multiple data formats including xml\\\, csv, SOAP, HL7.
• Assist with system, data and database migrations and related changes, testing, and validation.
• Help with eCR solutions including condition authoring, data import and utilization, process automation and troubleshooting, and data review, analysis, and reporting.
• Monitor production processing to ensure proper data flow and response times.
• Support related server, database, software upgrades, and new environment configuration.
• Ensure maximum system uptime for critical components to ensure business continuity.
• Advise the Team on best practice and techniques. Mentor team and staff on advanced topics.
• Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best standards.

Required Skills (rank in order of

Importance):

• 3+ Years of Experience with MS T- SQL (Stored Procedures, AdvancedQ ueries, 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 & Relational Databases.
• 1+ Year of Experience HL7 v 2.3.1 - 2.5.1 and ORU Messages.
• 3+ Years of Experience with XML.
• 3+ Years of Experience with MS SQL Server 2016+.
• 1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI, PII