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 for ASP.NET MVC/Core Developer.

Experience Range: 1-3 years

Role and Qualifications:

• Essential: Proficiency in ASP.NET MVC & ASP.NET Core, with a minimum of 1 year of hands-on experience

• Familiarity with .NET framework versions starting from .NET 4.5 and onwards

• Strong grasp of C#, JavaScript, TSQL, HTML, ASP.NET MVC, ASP.NET Core, ASP.NET Web API, and MSSQL

• Effective verbal and written communication skills

• Even candidates with foundational knowledge are encouraged, including freshers

If you're an ASP.NET developer ready to contribute your skills within a dynamic environment, we're excited to welcome you, regardless of where you're located. 

Your expertise will be valued as we navigate the latest technologies and celebrate a culture of excellence.

Feel free to reach out and explore this opportunity further

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

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.

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

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 Roles & Responsiblities:

• 4+ years of experience in .NET Core, C#, EF Core, SQL Server, Rest API, MVC, Webform
• Good to have exposure in Azure & Azure DevOps
• Strong Experience in Micro Services Architecture.
• Cloud Azure
• Azure Kubernetes
• Knowledge of Docker is advantageous
• SOLID Principles
• Good to have exp in SonarCloud
• Should have team leading experience

 Job Description: