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

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 2 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.

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

-Designing, developing, and maintaining both the front-end and back-end of web applications.

-Integrating Payment Gateway, POS & Loyalty systems (such as Freedom Pay, Card Connect, Auth.net, Square, Oracle, Olo, NCR, Clover, Deliverer, etc. if applicable).

-Having experience with Svelte and Azure Cosmos DB is a plus.

-Using .NET Core/MVC, MSSQL, Angular 8+, and Web API.

-Designing, building, and maintaining efficient and reusable C# code using design patterns.

-Building and consuming J SON-based ASP.NET Web API services.

-Executing patches and proactive remediation for Legacy Applications, including designing, developing, and testing web applications with .NET, HTML, CSS, and other technologies.

-May lead the work of others and provide ideas to enhance software applications.

-Applying software design and development principles such as SOLID, Domain-Driven Design, and Object-Oriented Development.

-Familiarity with ORM frameworks, particularly the Entity Framework.

-Participating in architectural meetings and analyzing technical requirements for .NET applications.

-Managing source code with Git, including Git Flow Workflow.

-Implementing enterprise application patterns.

-Paying attention to details and having excellent organizational skills.

-Possessing excellent communication and teamwork skills.

We are seeking a skilled and enthusiastic .NET Core Developer to join our dynamic team. As a .NET Core Developer, you will play a crucial role in designing, developing, and maintaining high-quality software solutions using the latest Microsoft technologies.

Role & Responsibilities:

• Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
• Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with internal team.
• Transform business and design needs into innovative products.
• Drive all projects to completion within deadlines.
• Perform thorough testing to find issues ahead of time.
• Engineering software needs more precise analysis & coding skillset 
• Enhance skillset by working with fortune 500 clients
• Interacting with internal team.  

Qualifications: 

• B.E in computer science or related fields.
• Hand on development experience with web & database technologies (MS SQL).
• Excellent programming & communication skills Strong problem solving, judgmental, and decision-making skills.
• Ability to work at the tactical and strategic levels of IT initiatives.
• Impressive hands-on experience in .Net technologies.
• Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery , HTML/CSS, .Net Core.
• Self-Motivated, flexible & Innovative.

Your duties include

• Database development using T-SQL on MS SQL Server
• API Development using ASP.Net WEB API and C#
• R & D for available solutions and 3rd party API integrations
• Comparative Analysis of different approaches and finding optimal solutions
• Supporting existing applications in SQL, ASP.NET WEB API, C#, Angular or TypeScript

SKILLS

• Should have hands-on Experience in .NET Core, Asp.Net, MVC, Entity Framework, SQL Server with Good Communication skills.
• Use Microsoft technologies: C#, ASP.NET, SQL, MVC, and Microsoft Workflow to develop technical solutions to complex problems that require the regular use of ingenuity and creativity
• Design, code, test, debug and document software according to the functional requirements
• Develop, maintain and support programs/tools for internal and external clients
• Analyse, diagnose and resolve errors related to their applications
• Help define project plans requiring software development and hardware installations
• Provide technical and project management expertise across multiple areas of application development
• Investigate operational or systematic problems and user queries as required.
• If the candidate has experience in MVC / Angular / Azure / Xamarin, it would be an added advantage.

Education

Bachelor’s or Master’s degree in Computer engineering or relevant field
Students working towards their degree and with sufficient experience will be considered.
Qualifications-BCA, BE/B.Tech(Information Science/Technology (IS/IT)), MCA, ME/M.Tech(Information Science/Technology)

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

• Write clean, scalable code using .NET programming languages
• Develop technical interfaces, specifications, and architecture
• Develop client displays and user interfaces
• Assist software personnel in handling project-related work and other requirements
• Coordinate with other software professionals and developers
• Familiarity with the.NET framework (Like DotNet Core, MVC), SQL Server, and design/architectural patterns.
• 2+ years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, .NET) and HTML5/CSS3
• Excellent troubleshooting and communication skills

We are looking for a senior .NET Core professionals with 2+ years of development experience, who thrive on challenges and desires to make a real difference in the business world.

You are required to have skills in the following areas:

• 2 to 4 years of experience in. NET Core  development.
• Knowledge and Hands-on experience of at least 2 years on ASP.Net, C#, MS SQL Server, Restful, C# 3.5/4.0, MVC
• Desirable Skills: Excellent written and verbal communication skills. Excellent analytical and troubleshooting abilities.
• Solid understanding of best practices in web application development.
• Exceptional attention to detail and design.

Job Description: