DotNet Developer

Position Responsibilities :

The Database Architect is responsible for the design, optimization, and evolution of the database layer supporting enterprise applications in cloud environments. This role focuses on ensuring efficient data access patterns, scalable query workloads, and robust database architecture capable of supporting high-volume and high-concurrency systems.

This role goes beyond traditional database administration and requires deep technical expertise in SQL query optimization, database internals, and performance diagnostics. The Database Architect analyzes how applications interact with the database and guides improvements in schema design, data access patterns, and system scalability.

As a senior technical leader, the Database Architect helps define long-term strategies for scalable and efficient data architecture while working closely with engineering teams to promote best practices for database design and SQL development.

KEY RESPONSIBILITIES

Database Architecture & Optimization

• Design and evolve database architectures for scalable enterprise systems.
• Define efficient data access patterns that support high concurrency and large datasets.
• Improve schema design, indexing strategies, and query patterns.
• Ensure database designs support both transactional and data consumption workloads.

SQL Performance Engineering

• Analyze and optimize complex SQL queries and execution plans.
• Improve database performance through indexing strategies, statistics management, and query tuning.
• Investigate workload behaviour and recommend architectural improvements.

Data Access & Systems Thinking

• Provide guidance on scalable approaches for retrieving and delivering data for data-intensive application features.
• Recommend architectural strategies such as data aggregation, caching, or pre-computed datasets where appropriate.
• Apply systems thinking to improve how data is modeled, accessed, and delivered across the application.

Advanced Diagnostics

• Diagnose database behaviour using tools such as Query Store, Extended Events, and execution plan analysis.
• Analyze query performance, wait statistics, and workload patterns to identify optimization opportunities.

Collaboration & Technical Leadership

• Partner with engineering teams to guide scalable SQL development and data access practices.
• Participate in architecture and design discussions involving database interactions.
• Document best practices and architectural recommendations.

AI-Assisted Engineering

• Use AI-assisted tools to accelerate query analysis, diagnostics, and workload investigations.
• Validate AI-generated insights through empirical testing and database telemetry.

Qualifications :

TECHNICAL SKILLS & EXPERTISE

Database & SQL Server (Required)

• Advanced SQL Server performance tuning, including query optimization, execution plan analysis, and index design
• Strong experience diagnosing and resolving deadlocks using Extended Events and deadlock graphs
• Deep understanding of locking, blocking, and transaction behaviour, including wait statistics and lock escalation
• Experience optimizing stored procedures, including mitigation of parameter sniffing and plan cache management
• Strong knowledge of indexing strategies, including covering indexes and filtered indexes
• Solid understanding of statistics, cardinality estimation, and query optimizer behaviour

Performance Analysis Tools (Required)

• Experience using SQL Server Profiler and Extended Events for workload diagnostics
• Advanced execution plan analysis using SSMS or Azure Data Studio
• Familiarity with SET STATISTICS IO/TIME for query performance evaluation
• Strong experience using Query Store to analyse query performance and plan behaviour
• Ability to diagnose issues through wait statistics and blocking chain analysis

Enterprise Application Data Architecture

• Strong understanding of database design within multi-tier enterprise applications
• Experience optimizing database workloads supporting high-concurrency systems and large datasets
• Understanding how application query patterns influence database performance
• Familiarity working with application platforms such as .NET, APIs, or modern web frameworks

Cloud & Enterprise Database Environments

• Experience working with cloud-hosted database environments
• Understanding of scalability considerations in enterprise systems
• Experience analyzing and optimizing database workloads in production environments

QUALIFICATIONS

• 8+ years of experience working with enterprise database systems
• Proven expertise in SQL performance tuning and database workload optimization
• Strong experience in analysing execution plans and database performance behaviour
• Experience collaborating with engineering teams on data architecture and query design
• Strong analytical and problem-solving skills

AI-FIRST MINDSET REQUIREMENT

We value engineers who view AI as a productivity multiplier. The ideal candidate actively leverages AI tools to accelerate diagnostics, analyze database workloads, and uncover optimization opportunities while applying strong engineering judgment to validate results

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.

Exp-Min Year

Location Kolkata-On site & Remote

Sal-Nego

JD

Hands on design and in depth development experience in Microsoft NET

·        technologies including C#, ASP NET MVC, Web API, Entity Framework and LINQ

·        knowledge of MS SQL Server 2014 above

·        Experience with version control systems GIT

·        Experience creating and consuming web services including REST JSON

·        Skills (Technical / Specialist Skills)

·        Proficiency in .NET Development with .NET Framework 4.5 or later, Asp.net MVC,

·        C#, Web API, LINQ, Entity Framework, SQL Server 2014 or above, jQuery.

Software Languages: Advanced knowledge of JavaScript, C#, ASP.Net and SQL Server.

Job Responsibilities:

• Gain a clear understanding of customers' businesses and requirements;
• Plan execution methodology and identify fulfillment plan to address the requirements;
• Full lifecycle application development
• Designing, coding and debugging applications.
• Software analysis, code analysis, requirements analysis, software review, identification of code metrics, system risk analysis, software reliability analysis
• Support, maintain and document software functionality
• Programming analytical skill with highly logical and analytical approach
• Manage documentation by working with other teams and consolidating all required types of reports for future use and test case scenarios.
• Ability to visualize data, concepts and work flows to create diagrams, charts and illustrations to supplement documentation.
• Maintain quality service by establishing and enforcing organization standards.
• Maintain professional and technical knowledge by benchmarking state-of-the-art practices.
• Timely reporting to provide visibility of performance to goal.
• Be data driven and flexible to changes with a natural passion for problem solving.
• Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.

Key Skills required: 

• 4+ years of rich experience in the software development with advanced knowledge of JavaScript, C#, ASP.Net and SQL Server.
• A self-starter with the ability to work independently and as part of a team.
• Ability to work well in a results oriented environment with firm deadlines;
• Ability to perform multiple tasks effectively while being results-driven and patient
• Able to work both independently and as part of a team
• High degree of attention to detail and trustworthiness
• Strong analytical skills
• Capable of making timely, independent decisions
• Excellent oral, written and interpersonal communications skill
• Ability to think outside the box and generate and implement new ideas.
• Natural interest in team building and leadership with coaching/training skills.
• Excellent organizational skills

What you need to have:

ROLES & RESPONSIBILITIES:
*

• To develop, design, test, maintain and support custom mobile and web applications
• To collect the software requirement by the customer and develop the application as per their requirement
• Evaluate and research the products and technologies related to software
• To design and develop the activities and procedures related to activities and maintenance
• To write the high-quality code to meet customer requirement
• To design, develop and implement the critical application for .Net environment