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

Designation – Nodejs Developer

Experience – Min 3+ Yrs

Location: Ahmedabad ( WFO)

We are seeking a highly skilled Senior Node.js Developer with expertise in SQL and MongoDB to join our dynamic team.

As a key member of our development team, you will be responsible for managing the interchange of data between the server and users, as well as developing server-side logic. Your primary focus will be on the development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end. Additionally, your experience with both SQL and NoSQL databases will be crucial in defining and maintaining our data storage solutions.

Responsibilities:

 Develop and maintain server-side applications using Node.js.

 Design and implement RESTful APIs for seamless integration with front-end applications.

 Collaborate with front-end developers to integrate user-facing elements with server-side logic.

 Optimize applications for maximum speed and scalability.

 Implement security and data protection measures.

 Design and maintain database schemas for both SQL (e.g., MySQL, PostgreSQL) and NoSQL (e.g., MongoDB) databases.

 Manage and mentor junior developers, providing technical guidance and support.

 Stay updated with emerging technologies and industry best practices.

Requirements:

 Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent work experience.

 Minimum 4 years of experience in Node.js development.

 Proficiency in JavaScript/TypeScript and frameworks such as Express.js.

 Strong understanding of asynchronous programming and event-driven architecture.

 Experience with SQL databases (e.g., MySQL, PostgreSQL) and proficiency in writing complex SQL queries.

 Experience with NoSQL databases (e.g., MongoDB) and familiarity with their query languages.

 Familiarity with ORM libraries (e.g., Sequelize, Mongoose) for database interaction.

 Knowledge of version control systems (e.g., Git).

 Understanding of CI/CD pipelines and deployment processes.

 Excellent communication and teamwork skills.

 Ability to lead and mentor a team of developers.

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

Looking for talented ASP.NET MVC/Core Developers with a passion for building robust, scalable, and high-performing web applications.

Click Here to Apply : https://prishusoft.com/jobs/junior-aspnet-mvccore-professional

Experience Level

• 1–2 years of professional experience in web application development using ASP.NET MVC and ASP.NET Core.

Key Responsibilities

• Develop, maintain, and enhance web applications using ASP.NET MVC and ASP.NET Core.
• Write clean, scalable, and maintainable code following best practices.
• Design, develop, and integrate RESTful APIs with ASP.NET Web API.
• Collaborate with front-end developers and UI/UX designers to deliver exceptional user experiences.
• Work with MSSQL databases, including writing complex T-SQL queries, stored procedures, and optimizing performance.
• Participate in code reviews and contribute to technical discussions, architecture decisions, and performance improvements.

Technical Skills & Expertise

• Strong proficiency in ASP.NET MVC with at least 1 years of project experience.
• Good working knowledge of ASP.NET Core for modern application development.
• Solid skills in C#, JavaScript, and HTML.
• Experience with .NET Framework 4.5+.
• Hands-on experience with ASP.NET Web API development and consumption.
• Expertise in MSSQL (T-SQL, indexing, performance tuning).

Soft Skills

• Strong verbal and written communication skills.
• Collaborative team player with a willingness to share knowledge and contribute to team success.

Preferred / Bonus Skills

• Experience with Angular, React, or Vue.js for dynamic front-end development.
• Exposure to unit testing frameworks (e.g., Jasmine, Karma) for front-end applications.
• Understanding of DevOps practices and CI/CD pipelines.
• Familiarity with TypeScript for scalable JavaScript development.

Work Mode: Full-time On-site / Hybrid (Ahmedabad)

Key Responsibilities:

1. Software Development:

- Design, develop, and maintain robust, scalable, and high-performance applications using the .NET framework.

- Implement and test software components to meet project requirements.

- Collaborate with other team members to understand business needs and translate them into technical specifications.

2. Review and Optimization:

- Conduct code reviews to ensure code quality, best practices, and adherence to coding standards.

- Identify and implement performance optimizations to enhance the overall efficiency of the applications.

3. Troubleshooting and Debugging:

- Investigate and resolve software defects and issues in a timely manner.

- Perform debugging and troubleshooting activities to identify and fix software bugs.

4. Documentation:

- Create and maintain technical documentation for software components, processes, and procedures.

- Provide clear and comprehensive documentation to assist other team members and stakeholders.

5. Collaboration:

- Work closely with cross-functional teams, including product managers, designers, and QA engineers, to deliver high-quality software solutions.

- Participate in Agile/Scrum development processes and contribute to sprint planning, daily stand-ups, and retrospectives.

Qualifications:

- Bachelor's degree in Computer Science, Information Technology, or related field.

- Proven experience as a .NET Developer or Software Developer.

- Strong proficiency in C# and the .NET framework.

- Experience with ASP.NET MVC, Web API, and other relevant technologies.

- Knowledge of front-end technologies such as HTML, CSS, and JavaScript.

- Familiarity with database systems, particularly SQL Server.

- Understanding of software development best practices, design patterns, and architecture.

- Excellent problem-solving and debugging skills.

- Strong communication and collaboration skills.

Preferred Skills:

- Experience with cloud platforms, such as Azure or AWS.

- Knowledge of DevOps practices and tools.

- Familiarity with containerization and orchestration technologies (Docker, Kubernetes).

- Experience with agile development methodologies.

Benefits:

- Competitive salary

- 5 days working

- Professional development opportunities

- Flexible work schedule

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