11+ SQL tuning Jobs in Pune | SQL tuning Job openings in Pune

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

Role: .NET Developer

Exp: 5-7 Years

CTC: up to 15 LPA

Required Qualifications:

• 5+ years of professional software development experience.
• Post-secondary degree in computer science, software engineering or related discipline, or equivalent working experience.
• Development of distributed applications with Microsoft technologies: C# .NET/Core, SQL Server, Entity Framework.
• Deep expertise with microservices architectures and design patterns.
• Cloud Native AWS experience with services such as Lambda, SQS, RDS/Aurora, S3, Lex, and Polly.
• Mastery of both Windows and Linux environments and their use in the development and management of complex distributed systems architectures.
• Git source code repository and continuous integration tools.
• Proficient with debugging and profiling distributed systems.

As a C++ developer working in front office electronic trading, your role involves developing and maintaining software solutions for trading systems used in financial markets. Here are some key aspects of your responsibilities:

C++ Programming: Mastery of the C++ programming language is essential, as most trading systems are built using C++ due to its performance and efficiency.

Electronic Trading Systems: You'll work with electronic trading systems that execute trades automatically based on predefined algorithms or user instructions. Understanding order execution, order management, and market data processing is crucial.

Multithreading: Multithreading is vital in electronic trading systems to handle concurrent tasks efficiently. You'll need to design, implement, and debug multithreaded applications to ensure optimal performance and reliability.

Low-Latency Systems: Electronic trading often requires low-latency systems to execute trades swiftly. You'll optimize code and algorithms to minimize latency and ensure timely order execution.

Algorithmic Trading: Knowledge of algorithmic trading strategies and implementing them in software is advantageous. This includes understanding mathematical models, statistical analysis, and risk management.

Networking: Understanding network protocols and communication is necessary for connecting trading systems to exchanges, brokers, and other financial institutions. This involves working with TCP/IP, UDP, and messaging protocols like FIX (Financial Information Exchange).

Risk Management: You'll implement risk controls and safeguards in trading systems to prevent erroneous trades or mitigate risks associated with market volatility.

Testing and Debugging: Thorough testing and debugging are crucial to ensure the reliability and stability of trading systems. You'll write automated tests, perform manual testing, and debug issues to maintain system integrity.

Performance Optimization: Continuously optimizing the performance of trading systems is essential to handle increasing trading volumes and maintain competitiveness. This involves profiling code, identifying bottlenecks, and applying optimizations.

Regulatory Compliance: Adhering to regulatory requirements and standards in the financial industry is critical. You'll ensure that trading systems comply with regulations such as MiFID II, Dodd-Frank, and others applicable to electronic trading.

Collaboration: Working closely with traders, quants, risk managers, and other stakeholders to understand requirements and implement solutions that meet business needs.

Documentation: Maintaining clear and comprehensive documentation for code, algorithms, and system architecture is important for knowledge sharing and compliance purposes.

Overall, being a C++ developer in front office electronic trading requires a strong technical foundation, attention to detail, and the ability to work effectively in a fast-paced and demanding environment.

Technical Skill Set:

1. ASP. NET Development – Strong expertise in C#, ASP.NET, WPF, and solid understanding of SOLID principles, API development, and databases.

2. Cloud Technologies – Hands-on experience with AWS, Azure, or Google Cloud.

3. Software Development & Architecture – Proficiency in SDLC, Agile, Scrum, and DevOps frameworks.

4. Project Planning & Management – Experience in task allocation, tracking, estimations, and deliverables management.

5. Repository & Version Control – Familiarity with Git, SVN, or similar tools, along with basic networking concepts.

6. Product Lifecycle Management – Knowledge of requirement analysis, documentation, testing, and release management.

7. Project Planning Tools – Experience with tools like Microsoft Project Plan, JIRA, Redmine, or HP ALM/Quality Centre.

Leadership & Soft Skills:

1. Team Leadership – Ability to guide, mentor, and manage a team while ensuring high-quality deliverables within tight deadlines.

2. Client Engagement & Requirement Gathering – Skilled in collaborating with stakeholders to enhance and refine project requirements.

3. Strong Communication & Problem-Solving – Effective at handling challenges, making decisions, and ensuring smooth project execution.

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

● Participate in code reviews and provide constructive feedback to peers

● Lead requirements/tasks and guide/mentor junior software engineers in the development process and help them grow their technical skills

Required Skills:

● B.E/B.Tech in computer science

● 4 - 7 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.

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

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

● 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 fast-paced environment product startup/startup-like culture in an Agile software development environment

Job Description:

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

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

• Hand on experience on .NET core
• Experience in C#
• Looking for experience into No Sql.

• 3+ years of building sophisticated, world-class, highly reliable multi-tenant software systems that have stood the test of time.
• From being highly proficient to being an expert in at least one OOPS language, SOLID principles, and design patterns, C#, Dotnet core, WebAPI, NoSQL.
• Experience with microservices architecture OR distributed systems.
• Strong analytical and problem-solving skills.
• Ability to work independently.