What are the main 3-5 responsibilities:
1. Develop and maintain C#, EDI 834 formats using existing processes. Using BizTalk Server is a plus, but NOT LOOKING FOR A BIZTALK DEVELOPER!!
2. Optimizing the stored procedures, indexing and performance to enhance the database performance
3. Work closely with business users to identify, report and correct data centric issues.
4. Investigating Database bottlenecks: dead-lock resolution, data serialization issues – delayed writes, locks, columnar updates, etc.
5. Deployment of enhancements and modifications/releasesenvironments (Dev, QA, Prod)
What are the main 3-5 technologies:
1. C#
2. SQL Server
3. A simple user of BizTalk Server – Strongly preferred, but not mandatory
4. SSIS
5. PowerShell - preferred
What are the TOP 5 Critical Skills:
1. C#
2. SQL Server
3. Good communication and analytical skills
4. Experience with EDI is mandatory EDI 834 a huge plus
5. Must be able to work well alone and in a team-oriented, collaborative environment.
How you will contribute:
- Develop and maintain C#, applications that process electronic eligibility files (EDI 834)
- Optimizing the stored procedures, indexing and performance to enhance the database performance
- Focus on maintaining and enhancing data migration ETL’
- Investigating Database bottlenecks: dead-lock resolution, data serialization issues – delayed writes, locks, columnar updates, etc.
- Work closely with business users to identify, report and correct data centric issues.
- Deployment of enhancements and modifications/releases environments (Dev, QA, Prod)
What you will bring with you:
- Strong development experience with .NET Framework using C# and/or other programming languages - WCF, MVC and other design patterns, Object oriented programming, .NET core
- Strong experience with SQL Server and writing/optimizing SQL queries and stored procedures
- Experience on EDI 83X formats (EDI 834 is preferred)
- Should have knowledge and hands-on experience of SSIS. SSRS is a bonus.
- Not looking for a Biztalk developer but, working experience in configuring, developing and assisting BizTalk applications is preferred (BizTalk Server 2010 or higher; BRE and BizTalk 360 is a plus)
- Good grasp of Software Development Life Cycle
- Proven track record in delivering high-quality Database backend projects within tight deadlines.
- Excellent reasoning skills and resourcefulness
- Excellent communication skills
- Must be able to work well alone and in a team-oriented, collaborative environment.
- Hands on experience in Database finetuning, resolution of performance bottlenecks (using Profilers and similar tool suite)
- Working experience with data migration/integration (within the healthcare field, particularly dental health benefits administration is a plus).
- Ability to work in a fast-paced environment and deliver results with quick turnaround times.
- HIPAA, PHI, PII and Information security awareness, preferred.
- Working experience on US Healthcare medical insurance segment, Medicaid dental/vision benefits piece preferred.
- Experience with process automation preferred.
- Experience in scripting with PowerShell preferred.