Application Support Engineer (sql/.net)

Job Description

Build and maintain bots on Azure platform.  Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

1. a) 5 years of experience in software development with clear understanding of the project life cycle
   b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
   c) Hands on experience with Machine Learning based chat bots
   d) Experience with Azure bot services like Text Analytics etc.
   e)Strong database skills and hands-on experience on databases like SQL Server/Oracle
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

• Write clean, scalable code using .NET programming languages.
• Developing the web based software using computer programming languages such as Asp.net, Sql Server, MVC, C# & Entity framework.
• Revise, update, re-factor and debug code.
• Participate as a team member in all phases of S/W lifecycle, including the analysis and design of S/W systems.
• Participate in integrated testing of product/ package.
• Deploying applications on client server.
• Making changes to existing web applications according to the feedback received from the end users or clients.
• Design and develop REST API’s using ASP.NET/C#.

• Strong knowledge of .NET web frameworkwith .Net 3.5/4.0 Version.
• Experience on web-based projects using NET, C# and MS-SQL Server, JavaScript.
• Strong understanding of object-oriented programming.
• Skill for writing reusable libraries.
• Familiar with various design and architectural patterns.
• Knowledge of concurrency patterns.
• Familiarity with Microsoft SQL Server.
• Experience with popular web application frameworks.
• Familiarity with Windows Presentation Framework.
• Knack for writing clean, readable, and easily maintainable code.
• Understanding of fundamental design principles for building a scalable application
• Experience creating database schemas that represent and support business processes.

* Minimum 2 year relevant experience in .Net or .Net core server-side programming as last

working relevant experience.

* Basic Engineering Knowledge – OOPS , Data Structure , memory management etc..

* Hands on experience in .Net, WCF (optional) and windows concept

* Hands on experience in SQL – basic are must to have

* Requirement analysis and design principle understanding is required

* Good in unit testing and debugging concepts

* Should be good in communication.

Mandatory skillset - SQL, REST API / GRPC

Job Location-Gurgaon (Hybrid)

Early joiners with a notice period of 15 days to 1 month will be preferred.

.Net core-3years experience, OOA, Coding, Web API, Rest API, any cloud, any DB

• Designs, codes, tests, debugs, and documents software according to systems quality standards, policies and procedures.
• Analyzes business needs and creates software solutions.
• Responsible for preparing design documentation.
• Prepares test data for unit, string, and parallel testing.
• Evaluates and recommends software and hardware solutions to meet user needs. Resolves customer issues with software solutions and responds to suggestions for improvements and enhancements.
• Works with business and development teams to clarify requirements to ensure testability. Drafts revise and maintain test plans, test cases, and automated test scripts.
• Executes test procedures according to software requirements specifications
• Logs defects and makes recommendations to address defects.
• Retests software corrections to ensure problems are resolved.

Key Responsibilities :

- Take on development of key modules in the application
- You will be responsible for day-to-day development tasks across the Software Development Life Cycle assigned to your team.
- Development of application framework components
- Allocation of development tasks to the team
- Code review on a regular basis and ensuring code quality and adherence to company coding standards.

Required Technical Skills :

Angular :

- Modules, components basic architecture
- Typescript in depth
- Reactive forms
- CRUD operations in paged tabular listing
- Validation and error handling in Angular
- Security concepts like JWT based authentication, oAuth with social platforms, route guards, role driven menu
- Server-side rendering (SSR) with Angular Universal
- PDF making and email sending using SSR
- Localization and internationalization

ASP.Net C# Web API :

- Controllers
- Models with validation attributes, custom validations
- Asynchronous programming
- Error handling and logging
- Server side UI table operations - sorting, searching, paging, page sizing
- Entity framework with database first approach, edmx designer 
-React JS, Angular JS

SQL Server :

- Tables, views, stored procedures, functions
- Optimizations - keys, indexes, partitions
- Working with XML/JSON data

HTML/CSS :

- JavaScript/jQuery, CSS 3.0/Less/SCSS,
- Bootstrap
- Responsive design

We are looking for some one with 3+ Years of experience  with Microsoft technologies including.NET, ASP.Net Core MVC, C#, MS SQL Server. WPF, WCF C#, ASP.NET, XML, XSL, scripting languages including JQuery/JavaScript and HTML. 

Good to have knowledge with SQL Server 2012, indexing and queries and SSIS/SSRS.

Has Implemented Ajax Controls in C# . Net Projects

Complete understanding of MS SQL Database. Data modelling to visualize database structure.

Writing queries use for front‐end applications (websites, desktop applications, Mobile App or cloud apps).

Good understanding of Reviewing query performance and optimizing code.

Designing and coding database tables to store the application’s data.

Creating database triggers, stored procedures & functions.

Creating table indexes to improve database performance.

Has experience in writing unit tests & performing unit tests on own codes.

Responsibilities:‐

• To be responsible for managing technology in projects and providing technical guidance / solutions for work completion.

• To develop and guide the team members in enhancing their technical capabilities and increasing productivity.

• To ensure process compliance in the assigned module and participate in technical discussions/review.

• To prepare and submit status reports for minimizing exposure and risks on the project.

• Experience working with MVC framework.

• Hands on experience on various design patterns

• Experience in Unit testing development.

• Good to have experience on Team foundation server and Agile Development.

• Oversee and review code as required.

• Drive implementation and address technical roadblocks that the team is facing.

• Experience with diagnosing performance and/or memory issues is a plus, including using relevant profiler tools.

• Oversee and assist during system testing, UAT and deployment.