SQL Database Developer

What will you do in this role:

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
Surveillance 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
• Help to perform and automate daily maintenance processes
• Debug, troubleshoot, and optimize new and existing processes.
• Resolve processing issues.
• 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 standard