11+ SQL tuning Jobs in Ahmedabad | SQL tuning Job openings in Ahmedabad

Primary Responsibilities

• Architect and drive complex software performance improvement projects that mitigate the performance challenges of the product and establish new guidelines for future product features
• Work with the development team, and database administrators to analyze performance bottlenecks, make recommendations to address performance concerns, and co-design performance into new feature development
• Efficiently working with various profiling and monitoring tools to identify performance and concurrency bottlenecks, propose and implement optimizations to improve cloud product
• Review end-user usage patterns and customer logged performance defects and enhance performance test coverage based on gaps identified.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures and with other downstream systems
• Troubleshoot issues experienced by users and propose solutions

Basic Qualifications

• 8+ years of experience in implementing and driving software performance engineering projects and solutions. Advanced level experience with concurrency, multithreading, and distributed system architectures
• Experience analyzing performance bottlenecks with application code interfacing with databases using ORM Frameworks, cache layers, data storage, servers, networking, and database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of relational database internals (locking, consistency, replication, serialization, failover, recovery)
• Comfortable with Windows, SQL Server, .NET Framework/Core, GIT, Nuget, SPA, Modern UI Frameworks, ORM Framework NHibernate in terms of both tools and application development
• Passionate about finding software performance bottlenecks and optimizing code to produce a better customer experience
• Experience with APM (Application Performance Monitoring), RUM (Real User Monitoring), and other Dev tools used for Performance monitoring and analysis
• Experience with performance bottleneck analysis, system design for scaling

We are Hiring a ASP.NET MVC/Core Professional, for Ahmedabad Location (Onsite/Hybrid)

Apply here : https://prishusoft.com/jobs/aspnet-mvccore-professional

Experience Level:

• Looking for professionals with 4 to 5 years of experience in web application development using ASP.NET technologies.

Key Responsibilities:

• Develop, maintain, and enhance web applications using ASP.NET MVC and ASP.NET Core.
• Write clean, scalable, and efficient code following best practices and coding standards.
• Design and implement RESTful APIs with ASP.NET Web API.
• Collaborate closely with front-end developers and UI/UX designers to deliver a seamless user experience.
• Work with MSSQL databases, writing complex T-SQL queries, stored procedures, and ensuring data integrity.
• Participate in code reviews, contribute to architectural discussions, and help improve overall application performance.

Technical Skills & Expertise:

• Proficiency in ASP.NET MVC with at least 1 years of hands-on project experience.
• Solid working knowledge of ASP.NET Core to build modern web applications.
• Strong programming skills in C#, JavaScript, and HTML.
• Comfortable working with .NET Framework versions 4.5 and above.
• Experience building and consuming ASP.NET Web APIs.
• Hands-on experience with MSSQL, including TSQL, complex queries, indexing, and optimization.

Soft Skills & Communication:

• Ability to clearly communicate ideas and technical concepts in both verbal and written form.
• Collaborative mindset with a focus on team success and a willingness to share knowledge.

Preferred (Bonus) Skills:

• Experience with Angular (or similar frameworks like React, Vue) to build dynamic, responsive front-end applications.
• Experience with unit testing frameworks (like Jasmine, Karma for Angular) is a plus.
• Understanding of DevOps practices and CI/CD integration within testing pipelines.
• Familiarity with TypeScript for structured, scalable JavaScript development.

Build your career with us.

1. Azure Integration Developer (Azure Functions, Azure LogicApp, Azure APIM)
   
   

Job Responsibilities:

• Technically sound in Dot Net technology. Good working knowledge & experience in Web API and SQL Server
• Should be able to carry out requirement analysis, design, coding unit testing and support to fix defects reported during QA, UAT phases and at GO Live times.
• Able to work alone or as part of a team with minimal or no supervision from Delivery leads.
• Good experience required in Azure stack of integration technology-Logic app, Azure Function, APIM and Application insights.

Must have skill

• Strong Web API development using ASP.Net Core, Logic app, azure functions, APIM

• Azure Functions
• Azure Logic App
• Azure APIM
• Azure ServiceBus

Desirable Skills

• Azure Event Grid/Hub
• Azure KeyVault
• Azure SQL – Knowledge on SQL query

Technical Lead - .NET

Responsibilities:

• Develop and deliver technical systems
• Maintain adherence to architectural standards/principles, global product-specific guidelines, usability design standards, etc.
• Participate in the development and review of documents to comply with SDLC methodologies [e.g., Engineering Work Breakdown Structure (WBS), estimation, Solution Design Document (SDD) and Software Architecture Documents (SAD)]
• Provide support and documentation to assist in sustaining the project during the transition to production where necessary
• Adhere to Application Engineering methodologies, standards, code reviews
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate
• Identify potential points of contention for missed activities and notify project leadership of situation and remediation plan
• Minimize technical exposure and risk on projects
• Provide technical guidance to development team members
• Technical deliverables (i.e., code and documentation) on projects assigned
• Translate detailed Requirements and Design and Solution Architecture deliverables into detailed design specifications
• Maintain effective and consistent communication within the team, with peers, the leadership team, and the peers in other IT groups
• Proactively raise issues to Technical and Group Leads when necessary
• Produce high-quality application engineering deliverables in accordance with the project timeline
• Build and unit test a project to detailed design specifications
• Provide thought leadership and technical guidance to engineering staff
• Review of code completed
• Review performance of developers
• Proactively anticipate project issues before they occur; define the problem; identify possible causes; work with the team to identify solutions; select and implement the most appropriate solution
• Apply judgment in implementing Application Engineering methodologies, processes, and practices to specific requirements of projects/programs which may include product design engineering, information security, code maintainability and reliability

Requirements:

Must Have:

• Bachelor’s OR master’s degree in a technical field and/or equivalent work experience
• At least 3 years acting a senior architecture / technical lead role in a comparable organization
• Significant experience of deploying large, enterprise-wide implementations to significant user volumes
• At least 5 years of hands-on experience leading a team of developers - defining work breakdown structures/tasks, assigning the teamwork items, monitoring, and ensuring quality and adherence to standards etc.
• At least 8 years of relevant hands-on work experience building, integrating, and delivering enterprise-wide web and windows applications using Microsoft and other technologies for large organizations on complex projects
• 8+ years of ASP.Net MVC, ASP.Net experience
• 8+ years of experience of working with applications that have a SQL Server backend
• 5+ years of experience with Object-Relational Mappers such as Entity Framework, ADO.NET, Dapper
• Expert level knowledge of .NET Web API is required. .NET Core knowledge is preferred, but Web API experience with legacy .NET is ok
• 5+ years of experience with GIT
• 3+ years of experience of Azure Devops
• In-depth knowledge of object-oriented analysis and design (OOAD) principles, and familiarity with many design patterns for Software applications.
• Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities, deployment and performance related activities, documentation, support, and training/mentoring
• Excellent communication skills, verbal and written

Nice to have:

• Ideally experience working with SSRS, SSIS
• Experience with MongoDB or another document database would be a plus
• Knowledge and experience with working on N-Tier applications.
• Demonstrated ability to build strong working relationships
• Experience working on projects following Agile methodologies would be ideal
• Experience working with Azure or other cloud providers would be ideal
• Ability to work within diverse, global, virtual teams.
• Proven ability to thrive under pressure
• Some experience with design and prototyping tools and diagramming is desired

Primary Role

• Analysis and Design activities as required by project
• Software development as per project schedule
• Troubleshooting and Debugging as required for bug fixing
• Source code version maintenance in version control software
• Prepare and execute unit test cases
• Unit testing of the application to ensure quality release to QA
• Adherence of coding standards while performing development
• Impact analysis of any changes requested by client
• Daily status reporting / progress updates / timesheets

Secondary Role

• Prepare project specific documentation as required by project
• UAT / Implementation support as required by project
• Client interaction and communication as required by project
• Code review and peer testing as required by the project
• Mentor junior developers on the project as required by project

Job Description:

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

• • At least 3 to 5 years of experience in .Net.
  • The candidate should be a system thinker.
  • Strong knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3.
  • Enjoy Event-Driven Design Patterns and Event Sourcing.
  • Familiar with Document Store Databases (like Cosmos DB / Mongo DB).
  • Knowledge in Modular Architecture and Microservices.
  • Comfortable leading large technical projects.
  • Knowledge of any cloud services AWS, Azure, Google Cloud.
  • Good understanding of ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)).
  • Experience with architecture styles/APIs (REST, RPC).
  • Understanding of Agile methodologies.
  • Strive for continuous improvement and build continuous integration, continuous development, and constant deployment pipeline (CI/CD Pipeline).

• Bachelor’s Degree in Computer Science or Information Technology
  
  

• Excellent writing skills
• Proficient in Web use, Outlook and Microsoft Office
• Travel as needed

Rules & Responsibilities:

Skills :

• Familiarity with the http://asp.net/">ASP.NET framework, SQL Server and design.
• Hands on experience using C# .NET, MVC, Oops Concept, Jquery, Bootstrap.
• Knowledge of  .NET languages 
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Angular will be an advantage
• Able to work well in a team setting