11+ SQL tuning Jobs in Bangalore (Bengaluru) | SQL tuning Job openings in Bangalore (Bengaluru)

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

Job Description – Senior .NET Developer (Angular/React)

Job Title: Senior .NET Developer (Angular/React)

Location: Hyderabad (Hybrid)

Job Summary: We are seeking a Senior .NET Developer with strong frontend expertise in Angular or React to join our dynamic team. The ideal candidate will have deep experience in .NET Core, C#, Web API, relational/non-relational databases, and cloud platforms (Azure/AWS) while also being skilled in modern frontend development. This role requires designing and developing scalable, high performance, and secure applications with a strong focus on frontend and backend integration.

Key Responsibilities:

 Develop, test, and maintain .NET Core applications and Web APIs.

 Build dynamic and responsive UI components using Angular or React.

 Ensure seamless frontend-backend integration with RESTful APIs.

 Design and implement scalable, secure, and high-performance applications.

 Work with relational (SQL Server, PostgreSQL, MySQL) and non-relational (MongoDB, DynamoDB) databases for efficient data management.

 Apply OOP principles, SOLID design, and software development best practices.

 Utilize Azure/AWS cloud services for deployment and management.  Ensure code quality through unit testing, debugging, and performance optimization.

 Implement and manage Git for version control.

 Collaborate with cross-functional teams to define, design, and deliver new features.

 Troubleshoot and resolve technical issues to maintain application stability.

Required Qualifications & Skills:

 4-8 years of hands-on experience in .NET development.

 Strong proficiency in .NET Core, C#, Web API.

 Must have experience with frontend technologies—Angular or React.  Solid understanding of RESTful services, microservices architecture, and SOA.

 Experience with relational and non-relational databases (SQL Server, PostgreSQL, MySQL, MongoDB, DynamoDB).

 Hands-on experience with cloud platforms (Azure/AWS) and DevOps practices.

 Strong debugging, problem-solving, and troubleshooting skills.

 Familiarity with CI/CD pipelines, Docker/Kubernetes is a plus.

 Bachelor's degree in computer science, Software Engineering, or a related field.

Job Description: As a .NET + Angular Developer, you will be responsible for developing and maintaining web applications using .NET technologies and Angular. You will work on a variety of projects, including the design and implementation of RESTful APIs, microservices, and front-end components. Your role will involve applying best practices in software development, including test-driven development (TDD) and automated unit testing, to ensure the delivery of high-quality software solutions.

Key Responsibilities:

• Develop and Maintain Applications: Design, develop, and maintain web applications using .NET, C#, ASP.NET, and Angular.
• RESTful API Development: Create and manage RESTful APIs to enable seamless integration between front-end and back-end systems.
• Microservices Architecture: Work on microservices-based architectures to enhance scalability and maintainability of applications.
• Automated Unit Testing: Implement automated unit tests to ensure code quality and reliability.
• Test-Driven Development (TDD): Apply TDD principles to write efficient and effective code.
• Database Management: Design and manage databases using MSSQL, ensuring data integrity and performance.
• Collaboration: Work closely with cross-functional teams, including front-end developers, UX/UI designers, and product managers, to deliver high-quality software solutions.
• Documentation: Maintain comprehensive documentation for code, APIs, and system architecture.

Required Skills and Qualifications:

• Proficiency in .NET Technologies: Strong experience with .NET, C#, and ASP.NET.
• Front-End Development: Expertise in Angular for building dynamic and responsive user interfaces.
• RESTful APIs: Experience designing and consuming RESTful APIs.
• Microservices: Knowledge of microservices architecture and implementation.
• Database Skills: Proficiency in MSSQL for database design and management.
• Automated Unit Testing: Experience with automated unit testing frameworks and tools.
• Test-Driven Development: Familiarity with TDD methodologies and best practices.
• Problem-Solving: Strong analytical and problem-solving skills with the ability to troubleshoot and resolve issues efficiently.
• Communication: Excellent verbal and written communication skills.

Preferred Qualifications:

• Experience with additional front-end frameworks or libraries.
• Knowledge of DevOps practices and tools.
• Familiarity with Agile methodologies.

What We Offer:

• Competitive salary and benefits package.
• Opportunities for professional growth and development.
• Collaborative and inclusive work environment.
• Flexible working hours and remote work options (if applicable).

• Java
• Spring Boot
• Database (Preferably Mysql)
• Multithreading
• Low Level design (Any Module)
• Github
• Leetcode
• data structure

Our client is a rapid growth stage Edtech start-up focused on solving the teacher shortage crisis in the US education system using technology by bringing teachers to the classrooms and giving them access to the right tools to teach students in a highly engaging manner.

They have a development center in Mumbai and they are looking to scale up the teams in Pune and Bangalore as well.

What does the role entail:

● Design, develop, and maintain software applications using .NET Core ,C#

● Write clean, maintainable, and efficient code

● Collaborate with cross-functional teams to analyze requirements, design solutions, and implement new features

● Develop and implement unit tests and integration tests to ensure software quality

● Troubleshoot and debug applications

● Participate in code reviews and provide constructive feedback to peers

Required Skills:

● B.E/B.Tech in computer science

● 1 - 3 years of experience

● Hands-on experience following skills

MS Technologies: NET CORE 7+, C#

Backend: MSSQL / MySQL /Postgres

● Preferred understanding of Cloud: Azure/AWS.

● Strong understanding of object-oriented programming, Design principles, data structures, and algorithms

● Worked in an Agile software development environment

Senior .NET Cloud (Azure) Practitioner

Job Description Experience: 5-12 years (approx.)

Education: B-Tech/MCA

Mandatory Skills

• Strong Restful API, Micro-services development experience using ASP.NET CORE Web APIs (C#);
• Must have exceptionally good software design and programming skills in .Net Core (.NET 3.X, .NET 6) Platform, C#, ASP.net MVC, ASP.net Web API (RESTful), Entity Framework & LINQ
• Good working knowledge on Azure Functions, Docker, and containers
• Expertise in Microsoft Azure Platform - Azure Functions, Application Gateway, API Management, Redis Cache, App Services, Azure Kubernetes, CosmosDB, Azure Search, Azure Service Bus, Function Apps, Azure Storage Accounts, Azure KeyVault, Azure Log Analytics, Azure Active Directory, Application Insights, Azure SQL Database, Azure IoT, Azure Event Hubs, Azure Data Factory, Virtual Networks and networking.
• Strong SQL Server expertise and familiarity with Azure Cosmos DB, Azure (Blob, Table, queue) storage, Azure SQL etc
• Experienced in Test-Driven Development, unit testing libraries, testing frameworks.
• Good knowledge of Object Oriented programming, including Design Patterns
• Cloud Architecture - Technical knowledge and implementation experience using common cloud architecture, enabling components, and deployment platforms.
• Excellent written and oral communication skills, along with the proven ability to work as a team with other disciplines outside of engineering are a must
• Solid analytical, problem-solving and troubleshooting skills

Desirable Skills:

• Certified Azure Solution Architect Expert
• https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-900-exam-preparation-microsoft-azure-fundamentals-524%2F&;data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760717910671%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TmO1fonUFFgb8LzUJHbL8IyOdQeUKdw6xHMM2asosiw%3D&reserved=0" target="_blank">Microsoft Certified: Azure – Fundamentals Exam AZ-900
• https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-104-exam-preparation-microsoft-azure-administrator-1-1332%2F&;data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EQPg%2FXxTdiYUCKCAvItXy6TY89udGTIehQ0m9irkGRk%3D&reserved=0" target="_blank">Microsoft Certified: Azure Administrator – Associate Exam AZ-104
• https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-204-exam-preparation-developing-solutions-for-microsoft-azure-1208%2F&;data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BnosXa4TdBUG4jrqP%2B0%2FOikDbQMBNqzuDpvGoUk0IE8%3D&reserved=0" target="_blank">Microsoft Certified: Azure Developer – Associate Exam AZ-204
• https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23devops-engineer&;data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NZyP%2F3Euh1SkHfB7896ovm0HDt0vA8UgfHUvTBN4SPM%3D&reserved=0" target="_blank">Microsoft Certified: DevOps Engineer Expert (AZ-400)
• https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23solutions-architect&;data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0infaLzjjPThGGkzwu50jJXikppcC8trnsLGtAoB7S4%3D&reserved=0" target="_blank">Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
• Good understanding of software architecture, scalability, resilience, performance;
• Working knowledge of automation tools such as Azure DevOps, Azure Pipeline or Jenkins or similar

Roles & Responsibilities

• Defining best practices & standards for usage of libraries, frameworks and other tools being used;
• Architecture, design, and implementation of software from development, delivery, and releases.
• Breakdown complex requirements into independent architectural components, modules, tasks and strategies and collaborate with peer leadership through the full software development lifecycle to deliver top quality, on time and within budget.
• Demonstrate excellent communications with stakeholders regarding delivery goals, objectives, deliverables, plans and status throughout the software development lifecycle.
• Should be able to work with various stakeholders (Architects/Product Owners/Leadership) as well as team - Lead/ Principal/ Individual Contributor for Web UI/ Front End Development;
• Should be able to work in an agile, dynamic team environment;

Job Description :

1.  Hands on experience in developing web Applications using http://asp.net/">ASP.NET core MVC and Azure SQL server.
2. Hands on experience in Web API development.
3. Should have experience in working with Azure containers to deploy applications.
4. Should be able to individually co-ordinate with client team and do delivery.
5. Good analytical and problem-solving skills.
6. Good oral and written communication skills.  
7. Ability to work independently / in a team with strong problem-solving skills.
8. Estimate work and plan delivery schedule including tasks, milestones and dependencies.
9. Ensure timely publishing of status report and quality metrics.
10. Should be able to quickly adapt work on new technologies based on project need.

Interview Mode: All rounds of interview will be conducted on Google meet and on boarding will be in Bangalore

Company Overview :

Data template is an IT company which design and develop digital experience and services used by people globally. We bring experiences from multiple domains to market from strategy to execution using our unique approach to transfer deep insight into impact. We help our clients to stay ahead of challenges and accelerate in their market.

Skill Requirements:

• At least 3 to 9 years experience of using .NET development
• Experience in using ASP.NET or .Net Core for developing Windows, Web applications
• A good understanding of WPF, WCF, XAML, MVVM, MVC, Design Patterns
• A good understanding of T-SQL, MS SQL
• A solid understanding of OOP principles
• A good understanding of N-tier and N-layered architecture
• Strong analytical skills
• Attention to detail
• Experience in working effectively as part of a team
• Good written and verbal communication skills
• Inter-personal skills
• A flexible approach and ability to adapt
• Ability to work under own initiative

About the opportunity

What you’ll be doing:

• You will contribute to all aspects of an agile software development life-cycle including design, architecture, development, documentation, testing and operations.
• You will build cutting-edge scalable systems by writing simple and efficient code.
• You will push your design and architecture limits for new product development.
• You will collaborate with product managers, and other key stakeholders within the MMT family to successfully execute projects.
• You will ensure compliance with build/release and configuration management process.

What you’ll bring to the table:

• You possess good understanding of Agile Methodology, Object Oriented Programming Concepts and Responsive Designs.
• You have hands-on experience on Java/ J2EE stack and have done development across multiple browsers/platforms delivering mind-boggling results.
• You thrive in complexity and jump at the opportunity to collaborate with colleagues to delivery projects within tight deadlines.
• If you have work experience in a product/start-up company, we’ll like you even more.

Our Purpose and Challenges

With over 47% market-share, MakeMyTrip is India’s first and biggest travel company. In fact, one in every four passengers at an airport is our customer. Driven by the desire to provide an exceptional travel experience for our customers, we have continuously stayed ahead of the curve by developing technology and products to meet the ever-changing demands of the rapidly evolving travel ecosystem.

We are currently solving multiple challenging problems, including -

• How to bring the next 100 million users to our platform?
• How to leverage customer insights to create a truly personalised experience for users?
• How to create a delightful experience for our users, to make travel synonymous to MMT?