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

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.

• 5 + years of hands-on experience in .NET, Angular and related Web technologies.

• 2 - 3+ years of experience designing and supporting Azure environments, including IaaS and PaaS

• Past experience in cloud computing and technology systems, as well as experience in designing and transferring applications to the cloud.

• Proven experience in Continuous Integration (CI) and Continuous Delivery (CD) as well as DevOps principles to achieve SDLC goals of Global Banking Technology

• Hands on experience using the Azure/AWS administration portal.

• Knowledge of at least one other cloud hosting solution (e.g., Azure, Google, AWS, Helion Cloud).

• Good hands-on experience in SOA, XML, WSDL, XSD, WSDL XML schema and namespaces (J2EE and .NET), MS .NET Framework, C#, HTML, Javascript, Micro Services/ APIs, Messaging, Threading, IBM DB.

• Have experience on development of container applications.

• Good knowledge of IBM DB. Should be comfortable writing stored procedures and user defined functions.

• Strong business knowledge of wealth management industry.

• Component / business object modeling, services modeling.

• Experience in building high concurrency, low latency 247 availability applications.

• Strong programming skills with emphasis on writing efficient algorithms to handle large data sets and processing.

• Understanding of HTTP, IIS and how the browser works.

• Ability to coordinate with various teams to deliver projects successfully.

• Knowledge of UML design.

• Knowledge of source control (preferably Git) and continuous Integration tools.

• Have working Knowledge of DevOps and best practices. Understanding of Major DevOps Tools and implementation for Source Control, Continuous Integration, Configuration Management, Deployment Automation, containers & Orchestration

• Experience in working in Agile framework.

• Good written and verbal communication skills.

Skills Desired:

• Financial markets, payment solutions or Wealth Management previous experience

Educational Qualification:

• Bachelor’s degree in Engineering preferred from an accredited college/university

Java

Mandatory:

1. Strong expertize in Java/J2EE(4-7 years of experience)
2. Strong  expertize in Microservices, SpringBoot
3. Java including multithreading and concurrency

Preferred skills :

1. Experience in  Virtualization, SDN, NFV, Yang, Netconf
2. Good Knowledge on Networking
3. Multithreading and concurrency