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

We are looking for "Sr.Software Engineer (API)" for Reputed Client @ Bangalore Permanent Role.

Experience: 5 - 7 Yrs

1.Roles & Responsibilities:

• Design, develop, and unit test applications in accordance with established standards.  

• Preparing reports, manuals and other documentation on the status, operation and maintenance of software.  

• Analyzing and resolving technical and application problems  

• Adhering to high-quality development principles while delivering solutions on-time and on-budget  

• Providing third-level support to business users.  

• Compliance of process and quality management standards  

• Understanding and implementation of SDLC process

2.Technical Skills:

Primary Skills

• 2+ years of experience in Web API, C#.Net, OOPS and Entity framework

• Minimum 1+ years of experience on Web Application development HTML, CSS, JavaScript/JQuery, Entity framework and Linq Queries

• Must have a good exposure on query writing and DB management for writing stored procedures/ user-defined functions

Secondary Skills

• Experience in analysing existing code and debugging.

• Should have a solid understanding of the SDLC processes (Design, Construction, Testing, Deployment)

• Proven experience of delivering on-time and with quality

• Should have good unit testing skills to review his own development and identify all the defects and get it fixed before releasing the code

Desired Skills

• Should have experience in developing ERP applications or Database Intensive Data Entry applications. 

• Been on a same role for a period of 2 years or more

• Hands on experience of configuration management and version maintenance

• Prior experience of working in the shipping domain

• Should be able to understand the Functional Specifications and Technical Specifications and develop the application as per the specification provided.

• Full stack developers with experience in Developing products with Angular and C# APIs, from ground-up will be a plus.

3.Abilty:

• Excellent Communication Skills

• Good conceptualization skills

• Strong Visualization ability

• Analytical ability

• Quality Oriented

• Problem solving

4.Educational Qualification:

BE/B-Tech/MCA/ M.Tech

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

• Determine the appropriate approach for new software assignments
• Provide solutions to overcome complex problems using the latest technologies
• Developing high-quality and detailed designs, Identify, prioritize and execute tasks in the software development life cycle
• Proactively communicate with the client to get things done within the deadline.
• Develop tools and applications by producing clean, efficient code.
• Automate tasks through appropriate tools and scripting
• Provide high-level maintenance and update of an existing applications to improve functionality and process flow
• Oversee the maintenance of technical documentation of applications as architecture, code, and procedures

• 3+ Experience with RPA software (UiPath) (ONLY/MANDATORY)
• Experience in programming .NET (C# or VB), Java + Node.JS-based programming
• UiPath RPA Implementations and Working Knowledge: Studio, BOTs, Orchestrators, RE Framework and Three E2E Implementations as a Core RPA Developer.
• Skill with scripting languages such as VBA/VBS, Python, NodeJS and JavaScript
• Proficiency with Microsoft Power Platform, SQL and NoSQL database experiences
• Orchestrator configuration and component usage knowledge
• hands on experience of orchestrator queue and load distribution
• Proficiency with JIRA, Jenkins, Github, Artifactory and CI/CD development
• Excellent analytical and problem-solving skills, including business process expertise
• Experience developing design documents for automation processes

Work Location:Mumbai,Gurgoan,Indore,Bangalore,Hyderabad

• J2EE
• Web services
• JSON
• JSP Servlet
• Exception handling
• Multithreading
• Rest API
• Microservices

The role of software engineer here is, to develop the application software that is being used on compactors and to do thorough software testing methodically. Expertise is needed on both embedded & application development.

• Expertise on Object oriented programming.
• Highly proficient in C# & C++. Expertise on .NET Framework, ASP.NET, JavaScript, HTML & CSS.
• Proficient in windows frameworks like WPF, WCF, etc for developing desktop applications.
• Knowledge on Microsoft Azure / other cloud technologies.
• Good knowledge on C programming and some exposure to embedded software development.
• Good at unit testing and testing frameworks like gmock, gtest, etc.
• Good at developing solutions in efficient way. Good at solving problems, quick grasper & solid analysis skills.
• Automating manual activities, drive the test automation strategy by architecting new solutions.
• Analyse test results and debug test failures in fast & efficient manner.
• Strong interpersonal & communication skills – written, verbal and presentation.

SENIOR SOFTWARE DEVELOPER (BACKEND DEVELOPMENT):

We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade web applications.
You will be part of a talented software team that works on mission-critical applications. Java developer roles and responsibilities include managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.

Responsibilities
• Java developer responsibilities include designing and developing high-volume, low-latency applications for mission-critical systems and delivering high-availability and performance
• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for
architectural review

Requirements
• BS/MS degree in Computer Science, Engineering or a related subject from renowned (IITs, NITs, BITS etc) colleges
• Excellent aptitude, algorithmic and puzzle solving skills
• Proven hands-on Software Development experience
• Proven working experience of 2+ years in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Object Oriented analysis and design using common design patterns.
• Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management, Multi-Threading etc)
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Experience in the Spring Framework
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT,
Spring MVC)
• Experience with agile development

YOUR RESPONSIBILITIES

• Development and unit testing of web applications including back-end (microservices), maintenance & level 3 support of the same
• Assist Project Managers, Business Analysts, and Tech Lead in project planning (provide estimates, risk analysis, requirements analysis, technical options)
• Software Architecture
• Involvement in full life cycle of projects (including requirement analysis and system design, development and support if required)
• Support and work collaboratively with teams across areas of design, development, quality assurance and operations
• Commit your knowledge and experience into team success
• A small amount of travel (when needed) to work with other offices
• Attend meetings to discuss and demonstrate solutions at both technical and business level

 REQUIRED SKILLS AND EXPERIENCE                                                                                                           

• 5+ years web application development experience
• 3+ years developing with Python
• 3+ years developing with C# and .NET Framework 4.x
• Experience with ASP.NET MVC, ASP.NET WebAPI 2, LINQ, and WCF
• Dependency Injection and other common ASP.NET MVC design patterns
• Experience with API design and development using REST
• Experience with performance optimization
• Experience integrating security best practices into the SDLC
• Experience with object-oriented programming (OOP) and OOP patterns
• Experience with Git
• 1+ years of Agile development experience
• Experience manipulating and working with data in a variety of forms: csv, xml, json, structured and unstructured                                                                                                
• Experience with SQL database schema design and querying. Microsoft SQL Server and PostGreSQL are used and preferred.

DESIRABLE SKILLS AND EXPERIENCE                                           

• Knowledge of JIRA, Bamboo, Confluence, or BitBucket is a plus.
• Experience with a JavaScript MVVM library such as Web Components, knockout.js, Angular, React, etc. is a plus (Web Components and knockout.js are used and preferred)
• Experience with HTML5/CSS3/JavaScript/ and AJAX is a plus
• SPA (Single Page Application) design and implementation is a plus
• Experience with any ORM such as Entity Framework or NHibernate is a plus (NHibernate is preferred)
• Experience with TypeScript is a plus
• Experience with MS Build is a plus
• Experience with CI/CD is a plus
• Experience with Object Mapping Frameworks (AutoMapper, etc) is a plus
• Understanding of OOD, DDD and TDD is a plus
• AWS-based development is a plus
• Knowledge of Flask is a plus.

PERSONAL SKILLS

• Clever personality
• Strong spirit skills set: conflict resistant, self -motivated, result-oriented, responsible, honest, “open”, courageous