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

The Senior Full Stack Developer assists in building both front-end and back-end for Web and Mobile applications. Senior Full Stack Developer delivers solutions using the latest architectural approaches such as Serverless/Microservices, Containerization, Cloud Technologies, Hybrid mobile frameworks and tools. 

What you will be doing:

 Provide hands-on development in the application development, unit test, and rollout of strategic web and Mobile initiatives. 

 Develop both front-end and back-end for web/mobile applications, working with a hybrid internal/vendor team, to support various lines of business and functional areas 

 Work with Business Owners and Business Analysis teams, to create business requirements. 

Document technical requirements and technical specifications for Web/Mobile applications (and related integrated solutions) and provide technical solutions to support those needs. 

Provide feedback (and approval) on technical designs and methods to support business requirements. 

Effectively communicate relevant project planning and status information to leadership/management. 

 Deliver engaging, informative, well-organized demos/presentations that are effectively tailored to the intended audience, as

needed. 

What we hope you bring to the role:

Additional Job Requirements

 Solid understanding of RDBMS & NoSQL databases. Experience with SQL Server Required.

 Expert in back-end development using .NET, C# or Python. Experience with .net required.

 Expert in front-end development using Angular, Ionic, HTML5, SCSS/CSS, Typescript,

JavaScript, Unit test framework - Jasmine, Jest, NgRx, RxJS, material design/Bootstrap. 

 Experience with Angular, HTML, CSS required

 Knowledge of front-

end code quality tools like ESLint, Prettier, SonarQube, RESTful API design and client

consumption, Micro-front-end Architecture, Angular SSR. 

 Knowledge of asyncio, Cosmos/Mongo DB, Redis/Distributed cache 

 Experience using PAAS and SAAS resources in Azure or GCP. Experience with Azure required.

 Knowledge of Kubernetes, Microservice/ Event driven architecture is a plus. 

 Experience using Azure DevOps /GIT based source control systems. 

 Knowledge of OAuth/OIDC, SAML, SSO is a plus. 

 Strong experience with building and maintaining a reusable component library. 

 Experience with maintaining and improving an existing codebase, focusing on improving

performance, scalability, and user experience. 

 Excellent problem-solving skills and critical thinker. 

 Excellent verbal and written communication skills to interact with staff and business

partners.

We are hiring Java Server Engineers to design and develop our core services and application platform. You will write the server-side code for all our web/mobile-based services. The focus will be on creating robust high volume applications, and at the same time have the ability to turn around quick prototypes.

Requirements:

• 2-4 years of commercial software development experience with a strong, system-wide background in Java/J2EE server development.
• BE or MS in Computer Science or equivalent.
• Experience developing database-driven, Internet-based, server applications is a must.
• Sound understanding of various design patterns and hands-on experience in Multithreading, Collections, and Concurrency are required.
• Experience with web services, and agile development methodologies desired.
• Experience with web application languages such as Ruby would be nice to have.
• Self-motivated: You can work with a minimum of supervision and be capable of strategically prioritizing multiple tasks in a proactive manner.
• Driven: You are a driven team player, collaborator, and relationship builder whose infectious can-do attitude inspires others and encourages great performance in a fast-moving environment.
• Entrepreneurial: You thrive in a fast-paced, changing environment and you're excited by the chance to play a large role.
• Passionate: You must be passionate about online collaboration and ensuring our clients are successful; we love seeing hunger and ambition.
• Thrive in a startup mentality with a whatever-it-take attitude.

About MangoApps

We have one goal and one goal only - To build tools that employees at workplaces across the globe use to be successful at work everyday. We have spent the last 10+ years building and redefining enterprise workplace software solutions. We are proud of the products we have built, the customers who have placed their trust in us and the industry recognition we have won for our products and people practices.

Exciting challenges lie ahead as we set stretch goals for ourselves, stand outside the box and continue to innovate the employee work experience for businesses across the globe. We are just getting started.

Come join us as we continue to scale!

Our Culture

There are jobs, and then there are once in a lifetime opportunities.If you thrive in a fast paced environment and want to be part of something BIG, MangoApps is the place for you.

If you looking for not just a "job" but the kind of work that adds up to something meaningful. This is the place for you. MangoApps has been described a lot of things, a fun place, an opportunity to make an impact, workplace with a flat hierarchy and good quality work, devoid of any office politics. A place where your work speaks for you. A place where you make some friends and a lot of memories.

You have to experience it to truly believe it. Too good to be true? But it is!

Did we mention the awards for -

• Great Places To Work 2023-24
• Most Innovative HR Practices,
• Fun at Work Award and the listing among
• Top 51 Dream Companies to Work for in India at the World HRD Congress 2019

Building a world-class product requires not just awesome technical skills but also intense commitment and the keeping-at-it ability. Qualities we look for in every Springster who comes on-board.

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.

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

Mandatory Skills:

1. Good Coding Skills
2. Hands on Experience on C#
3. Indexer
4. Object Oriented concepts using C#
5. Linq
6. Generics
7. Delegates
8. File IO
9. GAC concepts
10. MVC
11. Entity framework
12. .Net Core Concepts
13. Web-API
14. Sql Queries

Secondary Skills:

• Knowledge of Angular/React/Vue/Java Script/ Type Script
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills:

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Job Description:

Job Description: Java Full Stack Developer 

Skills 

Primary 

• Java, J2EE, Spring MVC 
• Hibernate or other ORM 
• Web technology and security, REST framework 
• Any one UI technology and ready to learn a new one. 
• Database knowledge (MySQL, Oracle, Postgres) 
• Unit testing frameworks 
• Version Control (Eg., Git) 

Good To Have 

• JQuery, XML, HTML5, AngularJS/Angular and other UI technology
• Shell Scripting 
• Python 

Key Responsibilities 

• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review
• Stay up-to-date on emerging technologies 

Requirements 

• 2 to 5 years of work experience as a Java Developer or similar role 
• BS/MS degree in Computer Science, Engineering or a related subject 
• Proven hands-on Software Development experience
• Proven working experience in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Object Oriented analysis and design using common design patterns. 
• Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management etc)
• Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Experience in developing web applications using at least one popular web framework
•  Experience with test-driven development

Job Benefits and Compensation 

• WebShar offers a very competitive salary depending on experience 
• 24 days paid vacation each year (CL, PL, SL), earned at a rate of 2 days per month. 
• MacBook Pro 
• Flexible time / and availability to work from home from time to time 
• Medical insurance 
• Team outing and lunches, 
• Reimbursement as per HR policies 

○ Internet reimbursement upto 1500 

○ Commutation reimbursement upto 6000 

○ ISD reimbursement

Greetings from Techspian Services Pvt Ltd.

Position: Software Developer
Experience: 3-6 yrs

Notice Period: Less than 30 days

Requirement:

• Minimum 3-6 Years of Experience in .Net Technology
• Technical expertise Must in such as. NET Framework, C#, VB. Net, MVC

• Understanding of SQL Server, Web Services, Entity Framework, Web API, RESTful services
• Excellent analytical and problem-solving skills
• Excellent Written and Communication skills
• Ability to work and prioritize multiple projects.
• Home office that provides the right ambiance to focus on work

Perks and Benefits
Health Insurance | Work Flexibility | Work From Home | Internet Reimbursement