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

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.

Required Skills (Technical Competency):

• Solid understanding of Object-Oriented Design and Programming.
• Hands-on experience in Software development in C# [Desktop Applications].
• Strong expertise in OOPS, basic design skills.
• Experience in C#, Winforms is must,
• Knowledge in PRISM, MVVM, LinQ.
• Expertise in multi-threaded programming.
• Strong logical and analytical skills.
• Experience of software development process.
• Expertise in development, testing and debugging skills.
• Knowledge of design patterns and its usage and tools like Visio.
• Experience in UML, SOLID.
• Experience in unit testing frameworks like NUnit.
• Expertise in troubleshooting bugs and finding solutions.
• Strong abstraction, analytical and problem-solving skills.
• Working with multisite teams, Quality conscious and Process Oriented.

Your Responsibilities:

• Write maintainable/scalable/efficient code.

• Design and architect technical solutions for the business problems of a very large e-commerce portal.

• Work in a cross-functional team, collaborating with peers during the entire SDLC.

• Follow coding standards, unit-testing, code reviews etc.

• Follow release cycles and commitment to deadlines.

Desired Skills and Experience:

• Experience level of 3 to 12 years of experience in very large scale applications.

• Strong problem solving skills, data structures and algorithms.

• Experience with distributed systems handling large amounts of data.

• Excellent coding skills in Java/J2EE.

• Very good understanding of Web Technologies.

• Very good understanding of any RDBMS and/or messaging.

• B Tech/BE in Computer Science or equivalent from a reputed college.

Skill sets :

Core Java

Multithreading

Spring

Collections

Kafka

No SQL experience / Mongo / Cassandra ( nice to have )

Location: preferably Bangalore / open to Mumbai on review 

Experience: 7-10 yrs

Open positions: 2

Notice period: Immediate - 30 days 

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable

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

Job description:

Job Title/Designation/Position: Dotnet Developer / Sr. Dotnet Developer

Total Experience: 4-8 years

Relevant Experience: 4-8 years

Job Location: Pune/Hyderabad/Bangalore & Hyderabad

Skills/Qualifications:

Primary Skills (Must have):

• C# with good understanding of OOPS, design patterns and multi-threading
• ASP.Net MVC, WEBAPI, RESTful services, JavaScript, jQuery
• .Net Framework
• Advanced knowledge of Microsoft SQL Server
• Knowledge of Unit Testing and Automated tests (nUnit)
• Knowledge of SQL Server/Oracle database and able to write Store-Procedures
• Strong analytical and problem-solving skills

•         Good analytical skills along with Excellent written and verbal communication skills in English

• Bachelor’s Degree in Engineering /Technology / MCA

Secondary Skills (Nice to have):

• HTML5
• CSS3
• Node JS

• Having experience in Hospitality/Travel/Internet/Online/Start-up/IT/Logistic/Courier/Cargo/ Transportation would be preferable.

Technical Skills to work with http://asp.net/">ASP.NET Web Forms(2) & MVC(1), Win Forms, WCF/Web API, C#, JavaScript & JQuery, Stored Procedures (SQL Server/MySQL), HTML, CSS, IIS

1. Ability tounderstand requirements by reading Business Requirement Documents(BRD), Functional Requirement Documents(FSD)
2. Capability to visualize and document functional requirements into technical implementations using technical documentation and unit test cases
3. Ability to code technical implementations based approved technical designs
4. White box testing (unit test)
5. Ability to communicate regarding work related verbal and written
6. Other required soft skills to work in a team.
7. Ability to guide junior developers technically.