Must haves :
- Strong proficiency in C# MVC Python and JavaScript
- Extensive experience with SQL Server designing stored procedures queries indexing and performance tuning
- Ability to create reports using SQL Server Reporting Services or equivalent.
Responsibilities :
Required to translate technical systems specifications into working tested applications. This includes developing detailed programming specifications writing and / or generating code compiling data-driven programs maintaining and conducting unit tests.Resolves and troubleshoots technical problems which arise during the use and operation of software packages including technical assistance in implementation conversion and migrations.Basic Skills :
Expertise in the complete software development cycle using Agile methodologies. The responsibility ranges from understanding requirements (User Stories) and application design to coding debugging and deployment using Azure DevOps pipelines.Strong problem-solving and communication skills with a proven ability to work in team environments and meet project plan timelinesFull Stack Skills :Proficient with both front end and back-end development including any associated areas such as database design / management and DevOpsExtensive knowledge in SQL Server to help in writing complex stored procedures and queries. Also reverse engineering and optimizing queries to fine tune the database performance.Knowledge and experience with programming Web applications using C#Knowledge and experience in application development methodologiesDesired Skills :
Implement Azure PaaS services such as Azure Functions App Services Logic Apps Storage Key Vault and Azure SQL DatabaseStay updated on new Microsoft technologies cloud innovations and industry best practicesDemonstrated ability to write clean and maintainable code in PythonRequired Experience / Evaluation Criteria :
Technical Evidence of direct project working experience with the following technologies or close equivalents : 30 Points
C# 4.8 or later MVCEntity Framework & Web FormsJavaScript / jQuery HTML CSS BootstrapTechnical Evidence of direct project working experience with the following technologies : 30 Points
SQL Server and database development techniquesWriting advance level stored procedures / SQL queriesTechnical Evidence of direct project working experience with the following technologies or close equivalents : 1 0 Points
Azure Cloud technologies (App Services Managed Instance Functions API Management)Azure DevOps build CI / CD workflows and GITTechnical Evidence of direct project working experience with the following technology or close equivalents : 15 Points
SQL Server Reporting Service : building new or maintaining existing ReportsPython programmingSoftProcess Evidence of direct project working experience that demonstrates the following skills : 15 Points
Practical knowledge of iterative development (such as Agile)Collaboration skills to analyze information and available documentation and build a common understanding of the target state of the system.Practical knowledge creating technical design documents deployment guides and configuration guides where applicableRequirements
Deliverables
Supporting eClaims expansion project
Build SQL scripts that would be migrating data from legacy database to new multitenant database using the mapping provided.Validation and data massaging would be part of the scripts.Optimize existing complex queries to use modern SQL commandsBuild tabular SSRS reports and SQL stored proceduresCreate MVC pages to support the web application using the Entity frameworkProviding developmental support to the Provincial Genomics data platform
Writing high quality code in Python and SQL ServerProvide technical documentation and support to fix security vulnerabilitiesProvide technical input during vendor evaluation phaseMust Haves :
8 years experience Strong proficiency in C# MVC Python and JavaScript8 years Extensive experience with SQL Server designing stored procedures queries indexing and performance tuningNice to Have :
Ability to create reports using SQL Server Reporting Services or equivalent.Key Skills
Spring,.NET,C / C++,Go,React,OOP,C#,AWS,Data Structures,Software Development,Java,Distributed Systems
Employment Type : Full Time
Experience : years
Vacancy : 1
Monthly Salary Salary : 101 - 101