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.

Qualifications & Requirements:

• 4+ years of experience in C++ application development.
• Hands-on experience with C++11 or above.
• Strong knowledge of object-oriented programming and software design.
• Deep understanding of STL, multi-threading, socket programming, and data structures.
• Solid grasp of Linux development and debugging techniques.
• Proficient in using GCC, GDB, and Makefile.
• Familiarity with Valgrind and similar analysis tools.
• Experience with version control tools like Git.
• Experience writing and maintaining automated tests.
• Experience in capital markets/trading domain is a plus.

Skills:

• Strong problem-solving and analytical thinking.
• Clear and effective communication.
• Self-driven with the ability to work independently.
• Passionate about high-quality software and strong engineering practices.
• Comfortable working in a fast-paced, collaborative environment.

We are solving complex technical problems in the financial industry and need talented software engineers to join our mission and be a part of a global software development team.

A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high-end technical consulting.

Job Description: 

• Experience in Core Java, Spring Boot.

• Experience in microservices.

• Extensive experience in developing enterprise-scale systems for global organization. Should possess good architectural knowledge and be aware of enterprise application design patterns.

• Should be able to analyze, design, develop and test complex, low-latency client-facing applications.

• Good development experience with RDBMS in SQL Server, Postgres, Oracle or DB2

• Good knowledge of multi-threading

• Basic working knowledge of Unix/Linux

• Excellent problem solving and coding skills in Java

• Strong interpersonal, communication and analytical skills.

• Should be able to express their design ideas and thoughts.

About Wissen Technology:

Wissen Technology is a niche global consulting and solutions company that brings unparalleled domain expertise in Banking and Finance, Telecom and Startups. Wissen Technology is a part of Wissen Group and was established in the year 2015. Wissen has offices in the US, India, UK, Australia, Mexico, and Canada, with best-in-class infrastructure and development facilities. Wissen hassuccessfully delivered projects worth $1 Billion for more than 25 of the Fortune 500 companies. The Wissen Group overall includes more than 4000 highly skilled professionals.

Wissen Technology provides exceptional value in mission critical projects for its clients, through thought leadership, ownership, and assured on-time deliveries that are always ‘first time right’.

Our team consists of 1200+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world.

Wissen Technology offers an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.

We have been certified as a Great Place to Work® for two consecutive years (2020-2022) and voted as the Top 20 AI/ML vendor by CIO Insider.

Must Have Skills:

1.      Experience with the .NET framework and .NET Core technologies: C#

2.      Writing and consuming REST API/Web API in .Net framework, .Net Core

3.      Must have excellent knowledge in Azure hosting services

4.      Good knowledge of Trouble shooting, Azure Hosting, maintaining and performance tuning

5.      Knowledge of Frontend framework (React), If not then Angular, or Vuejs etc

6.      Excellent Aptitude, Attitude and Communication Skills

7.      Strong understanding of OOPS Concepts

8.      Strong knowledge of Unit Testing

9.      Excellent knowledge and working experience in Microservice Architecture

10.  RDBMS Concepts, MS-SQL Server

11.  Writing & Optimizing SQL Queries for best performance

12.  Able to manage release by mean of CI/CD pipeline to deploy applications in Azure

13.  Well versed of code review and code scanning tools

Good to have Skills:

1.      Knowledge of HTML, Bootstrap, CSS, Responsive Design

2.      Entity Framework/LINQ, MVC

3.      Strong understanding of current design patterns & best practices

4.      Knowledge of Agile methodology and JIRA

5.      Knowledge of Electron is a plus

Key Responsibilities:

1.      Work with Scrum Team to prioritize tasks and ensure deadlines are met

2.      Communicate and actively participate in client call and understand requirements

3.      Convert design and architecture to code using best practices

4.      Provide expert level knowledge and guidance on modern software engineering techniques and methodologies for code reviews

5.      Demonstrate expertise in a variety of software concepts (object-oriented design), practices (design patterns), and procedures (troubleshooting defects)

6.   Able to troubleshoot and debug the code, write code with best coding practice and perform unit & Integration testing

7.      Collaborate with the technical team to build and migrate applications in Azure

8.      Test and update application so that it can be used for cross web browsers

9.      Use and set-up CI/CD pipeline

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:

● Lead User Stories and guide senior/software engineers in the development process

● Understand architecture principles, design patterns and implement them from architectural artifacts.

● Provide effort estimation of assigned work and be able to complete as per the estimations and timelines

● Write clean, maintainable, and efficient code including unit tests and integration tests to ensure software quality

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

● Participate in design and code reviews

● Ability to resolve performance issues

● Mentor junior software engineers and help them grow their technical skills

Must Have Skills:

● B.E/B.Tech in computer science

● 8-11 years of experience

● Hands-on experience following skills

MS Technologies: NET CORE 5+, C#

Backend : MSSQL /MySQL/Postgres 

● Good understanding of Cloud technologies like Azure/AWS.

● Good understanding of Design Principles, Design patterns and Microservices Architecture.

● Excellent problem-solving, critical thinking, and communication skills

● Worked in an Agile software development environment

Must understand full stack development frameworks including knowledge of building scalable APIs, interfaces, software components, schema design, availability, and latency preferably in a cloud environment.

● Worked in a fast-paced environment preferably in a tech driven startup

● Understanding of different types of architectures.

• Bachelors degree in Computer Science, Software Engineering, or a related discipline
• Experience working in an IT environment
• Experience developing with C#, C++, or other object-oriented platforms
• 2+ years of web application development
• Skill for writing reusable libraries
• Hands-on experience in ASP.Net, MVC, Restful services, Web API
• Experience in .Net Web API
• Strong understanding of object-oriented programming
• Strong knowledge of C# programming
• Ability to troubleshoot problems independently. Good analytical and problem-solving skills
• Familiar with various design and architectural patterns
• Strong Knowledge in Microsoft SQL Server scripts and Stored procedures
• Exposure to Agile Software Development Life Cycle
• Experience implementing automated testing platforms and unit tests
• Proficient understanding of code versioning tools such as GIT
• Experience in Service-based architecture

• BS/MS in Computer Science or Engineering.
• 8+ years of experience in software development in an object-oriented language such as Java, .NET or Node.Js
• Exceptional design, coding, and problem-solving skills, with a bias for architecture at scale.
• Experience with HTML5, JavaScript, TypeScript, front-end technologies like AngularJS, Redux / React and upcoming web technologies.
• Real-world experience developing large scale commercial services with robust performance, resiliency, and telemetry, delivered both Online and OnPrem.
• Strong knowledge of computer science, algorithms, and design patterns.
• Ability to appreciate complex problems with a thorough design.