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

• Strong expertise in Java 8+, Spring Boot, REST APIs.
• Strong front-end experience with Angular 8+, TypeScript, HTML, CSS.
• Experience with SQL/NoSQL databases (MySQL, PostgreSQL, MongoDB, etc.).
• Hands-on with Git, Maven/Gradle, Jenkins, CI/CD.
• Knowledge of cloud platforms (AWS) is an added advantage.
• Experience with Agile/Scrum methodologies.
• Domain Expertise (ADDED): Proven experience working on Auto-Loan Management Systems (LMS), Vehicle Finance, or related banking/NBFC solutions.

Looking for Immediate joiners Bangalore location(3-9years)

Key responsibilities:

• Understand all requirements, Design, Develop and implement features, complying with engineering and regulatory standards and procedures for charging stations.
• Create multiple concepts, evaluate, and implement the optimal one.
• Develop and maintain product’s design integrity with good knowledge of software system architecture and design.
• Apply problem-solving techniques and guide team towards arriving at solutions.
• Work with cross functional team from Concept prototyping to Launch & thereafter.
• Guide team towards creation and handling of all design and development related processes and documents like, defining requirements, high level design, low level design, DFMEA, DF’X’, Interface sign off, RCA, etc.

Key requirements

• A Bachelor/ master’s degree in E&E/ECE engineering from premier institute
• 5 years+ product development experience on Linux based systems, with full lifecycle experience for atleast 2 industry deployed products.
• Software Design and Architecture experience on Linux platforms
• Interfacing with SaaS via network or REST APIs 
• Knowledge of CAN, RS485/Modbus protocols, Kafka, Distributed Messaging 
• C++ with STL, Linux system programming, scripting, network/sockets programming, strong in UDP/TCP networking, libcurl + HTTP(s)
• Knowledge of Bluetooth/BLE, Elastic Search + Logstash, Java performance tuning 
• Knowledge of security-based Threat Modelling Design & Mitigation, TLS/SSL, Docker + Docker networking, Python + node.js + WebSocket’s, HTML5, JavaScript. 
• Excellent communication, leadership, and problem-solving skills
• Ability to work in a fast-paced and dynamic environment.

• Programming Language: Python (Strong knowledge)
• Concurrency & Parallelism: Multithreading, Multiprocessing, AsyncIO, ThreadPoolExecutor, Future, concurrent.futures
• Memory Management: Reference Counting, Global Interpreter Lock (GIL)
• Distributed Computing: Dask, Apache Spark (Preferred)
• Data Processing: NumPy
• Inter-Service Communication: GRPC, REST API
• Containerization & Orchestration: Docker, Kubernetes
• Software Development Practices: Code Optimization, Debugging, Performance Tuning
• Communication & Problem-Solving: Technical Documentation, Team Collaboration, Asking for Clarity When Needed

Skills And Expertise

• Python, 
• Multithreading, 
• Multiprocessing, 
• Dask, Apache Spark, 
• NumPy, 
• REST API, 
• Docker, 
• Kubernetes, 
• Code Optimization

Around 4 years of experience in creating and implementing Web-based applications using

C#, ASP.net, Web API, MVC, Micro Services, JavaScript and SQL Server.

Familiarity or exposure to CI / CD, Dev Ops such as Dockers, containers, Azure, Pipeline is

highly recommended

Ability to work in an Agile, fast-paced environment, and learn rapidly.

Bachelor degree in computer science, computer engineering or similar.

Familiar with object-oriented development, design patterns and specifically in .NET

Framework (C#) with a strong background in web-based development and service-oriented

Architecture.

Expert in HTML, CSS, JavaScript, JQuery, JSON.

Writing clean, readable, and easily maintainable code.

Must have knowledge of project/task management tools like Jira,

Familiarity with Version Control like Bitbucket, Git etc.

Understanding of UI, cross-browser compatibility and web standards.

Build features and applications with responsive design

Good English communication skills, written and spoken.

Able to work with minimum supervision as well as perform under pressure and meet

Deadlines.

NET Profile 

DESIRED SKILLS

·         Experience in Microsoft technologies (Microsoft Dot Net, C#, http://asp.net/" target="_blank">ASP.NET, MVC, Microsoft SQL, .NET Core, Web API, WCF, Bootstrap, JavaScript, Angular JS, Web API, Web services, Rest API)

·         Design a complex architecture landscape involving API integrations.

·         Hands-on experience in ASP.Net, C#, MVC, WCF, Restful services, Web API, AngularJS, Entity Framework

·         Strong analytical & problem-solving skills

·         Must have excellent oral & email communication skills.

·         Strong analytical and problem-solving skills

·         Must have a positive attitude and a yearning to get things done and demonstrate ownership of deliverables.

NICE TO HAVE SKILLS

·         Knowledge in Microsoft Azure.

·         Good Command on Agile Development & Azure DevOps.

·         Knowledge in Angular / React / Node JS

·       Mainly they are looking for:

C#

http://asp.net/" target="_blank">ASP.NET MVC,

AJAX,

LINQ,

jQuery,

WebApi.