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

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.

• Develop software solutions by studying information needs; conferring with users; studying systems flow, data usage and work processes; investigating problem areas; following the software development lifecycle
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Prepare and install solutions by determining and designing system specifications, standards and programming
• Improve operations by conducting systems analysis; recommending changes in policies and procedures
• Protect operations by keeping information confidential
• Provide information by collecting, analyzing, and summarizing development and service issues
• Accomplish engineering and organization mission by completing related results as needed
• First and foremost, developing software our users need
• Mentor junior and mid-level engineers
• Collaborate with team to brainstorm and create new products
• Grow engineering teams by interviewing, recruiting, and hiring
• Make informed decisions quickly and taking ownership of services and applications at scale
• Work collaboratively with others to achieve goals
• Be a persistent, creative problem ­solver
• Remain cool and effective in a crisis
• Stay on the leading edge of development practices
• Passionate about great technologies, especially open source
• Understand business needs and know how to create the tools to manage them

Job Title: Sr. Dot Net Full Stack Developer

Work Mode: Work from Office (Mon-Fri)

Experience: 4 to 10 years

Skills / Technical Experience Required

Must have competencies: .Net Core / .Net Framework, Angular / React, C#, SQL, REST API, Entity Framework Core

Additional competencies: HTM5, CSS3, Azure, Test Driven Development, No SQL DBs

Good to have competencies: TFS, GitHub, Agile methodologies, Figma

Keys Roles / Responsibilities / Abilities

•      Understanding the requirements for developing large modules and standalone applications in the project and adhering to the delivery schedule. 

•      The ability to Identify improvements to the existing application code and designs, increasing flexibility and reducing future effort and the ability to “pitch” these idea to team leaders and project sponsors as required. 

•      Work closely with the product owner or project sponsors to discuss the requirements, estimate development efforts and gain their acceptance of the solution. This will include working directly with the client where required. 

•      Mentoring of Developers and non-chargeable juniors in the team in achieving technical excellence in the delivery of the project. 

•      The ability to be involved in build and deployment activities and address build issues. 

•      Clearly explain and discuss technical points with both technical and non-technical staff.

Your benefits on joining Xperate

• Salary - Higher salary than industry standard.

• Annual Leave – 20 days excluding 10 public holidays. Medical/Sick leave is also provided.

• Life Insurance – 5L of default cover for you and your family.

• Accidental Cover – 20L of cover for each employee.

• Bonus Scheme – 100% based on company & individual performance.

• Latest Technology - Exposure to the latest technologies.

• Employee Development - Committed to the development, growth & well-being of our people

Regards,

Dipshikha Kulshrestha

• Bachelor’s Degree in Computer Science or equivalent
• 8-12 years’ of industry experience in programming web applications, mobile and/or large scale enterprise products
• Deep knowledge of C#, ASP, .NET, MVC, .Net core
• Deep knowledge and extensive experience working on Ruby or React and JavaScript, as required
• Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS
• Extended experience with SQL, relational and non-relational databases
• Experience in TFS and Visual Studio
• Hands on experience with SDLC and programming design patterns
• Experience with Agile methodology
• Skillful at reviewing new feature impact on an application and recognizing potential risks
• Uses time effectively and efficiently
• Quickly learns new technologies
• Detailed oriented, professional and possesses a positive work attitude
• Communicate professionally both verbally and in writing
• Effective time management skills
• Knowledge on UI technologies will be plus

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• Develops software solutions by studying information needs, conferring with users, studying systems flow, data usage, and work processes, investigating problem areas, following the software development lifecycle.
• Conducts systems analysis and makes recommendations to improve the system to achieve an outcome.
• Promotes internal best practices and coding conventions to write and execute tests for your own code, including creating comprehensive unit tests.
• Contributes to Technical Requirements Documents.
• Requests constructive feedback for designs early in the process.
• Communicates successfully with large teams and many stakeholders.
• Provides mentorship for Software Engineers and participates in interview panels to hire new Software Engineers.
• Assists in removing obstacles for the team to yield successful sprints.
• Performs peer code reviews to ensure quality of the codebase.
• Ability to decompose and delegate work to junior engineers.
• Updates job knowledge by studying state-of-the-art development tools, programming techniques and computing equipment; participating in educational opportunities, reading professional publications, maintaining personal networks, participating in professional organizations.
• Works effectively with multiple projects and features.
• All other duties as assigned.