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

Job Brief :

We are currently hiring a Ruby on Rails Developer to join our engineering team. In this role, you will be responsible for building API interfaces and backend infrastructure and collaborating with UI, connectivity and DevOps teams to come up with elegant solutions to complex problems.

Main Responsibilities of a Ruby on Rails Developer :

Your responsibilities will include :

• Writing effective and scalable Ruby codes
• Designing and implementing robust applications
• Debugging applications to ensure low latency and high-availability
• Integrating user-facing elements with server-side logic
• Integrating data storage solutions
• Contribute to all phases of the development lifecycle

Key Requirements :

• Degree in Computer Science, Engineering or a related field
• You have prior experience with Ruby on Rails
• Familiarity with front-end technologies, such as JavaScript, HTML5, and CSS3
• Solid knowledge of object-oriented programming and design
• Knowledge of ORM (Object Relational Mapper), RESTful
• Familiarity with various testing tools and ability to implement automated testing platforms and unit tests
• Good problem-solving skills

Job Responsibilities: 

• Technically sound in Dot Net technology. Good working knowledge & experience in Web API and SQL Server
• Should be able to carry out requirement analysis, design, coding unit testing and support to fix defects reported during QA, UAT phases and at GO Live times.
• Able to work alone or as part of a team with minimal or no supervision from Delivery leads.
• Good experience required in Azure stack of integration technology-Logic app, Azure Function, APIM and Application insights.

Must have skill 

• Strong Web API development using ASP.Net Core, Logic app, azure functions, APIM
• Azure Functions
• Azure Logic App
• Azure APIM
• Azure ServiceBus

Desirable Skills 

• Azure Event Grid/Hub
• Azure KeyVault
• Azure SQL – Knowledge on SQL query

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.

• To support and maintain existing Java code base, debug the application 
• To analyse user and business requirements and design and implement appropriate solutions 
• To design and code programs following in-house standards and good design principles 
• To ensure that all programs are documented to the company standards 
• To create unit test plans and perform unit testing of the programs
• To provide advice and guidance to other members of the team

• Hands on experience in designing and developing applications using Java EE platforms 
• Object Oriented analysis and design using common design patterns 
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate) 
• Experience in the Spring Framework 
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC) 
• Experience in RESTFul webservices
• Experience with test-driven development 
• Exposure to portal/mobility development - Desired
• Exposure to any of middleware solutions like MQ, Oracle fusion middleware(WebLogic), WebSphere, Open Source

All candidates applying should be familiar with the following:

C#, ASP.NET, Dot Net Core, Webforms, .NET framework, Web APIs, Javascript, HTML and SQL

Designation: Software Engineer or Sr. Software Engineer

You Should Be Able To Build And Maintain:

• Applications and services using C#
• Web applications using ASP.NET Web Forms
• APIs using ASP.NET Web API
• Responsive layouts with CSS and HTML using modern browser technologies
• Interactive web applications using Javascript
• Data Access Layers using ADO.NET
• Clean and testable code
• Datastores using MSSQL
• Source Code Management with Git and GitHub

Bonus Points For:

• Good understanding of Object-Oriented Methodologies, Algorithms, and data structures.
• Solid principles and design patterns
• Experience in working on cloud-native architecture or working with Cloud vendors such as Azure, AWS
• Understanding of tools like Swagger, Postman, etc
• Experience working on Open source software
• Experience working on consumer-facing products

Salary Range: Up to INR 12,00,000 per annum

(Depending on experience and skills) (Negotiable)

Immediate joining or less than 45 days notice period preferred

About Astrum Labs:

Astrum Labs is a product-based software company, providing integrated B2B applications in the field of logistics and financial technology. Within the logistics domain, our solutions focus on export documentation, advance license management, Exim trade, cargo tracing & tracking. Under the financial technology domain, our core competency lies in financial accounting software application, along with expense management, virtual payment instruments, and fractional/token-based payments. We strongly believe in providing our customers with applications that complement the existing ecosystem, improve productivity, and streamline businesses operations. We are growing at a rapid pace, and to support this growth, we are looking for truly dedicated, motivated, and super energetic individuals to join our team. Astrum is part of Softlink Global, one of the globally recognized and leading ERP providers in the logistics industry.

To know more, visit https://www.astrumlabs.co/">https://www.astrumlabs.co/ and https://softlinkglobal.com/">https://softlinkglobal.com/

At Astrum:

• We obsess over user experience and delight
• We are out there to provide the best logistics and financial technology software applications to small, medium, and large scale businesses
• We thrive on developing a culture of learning and continuous improvement, both for people and processes
• We invest in each other's growth
• We believe in complete transparency, open dialogue, and no hierarchies
• We make objective and data-driven decisions
• We believe in taking charge and getting it done
• We give a damn about our team's well-being and growth within the company
• We encourage experiments and creativity in Technology
• We want you to be able to lead your own team or a project once you are ready
• We want you to see our vision, and feel a part of our journey

We are committed to strengthening equality, diversity, and inclusion at our workplace through an enabling environment, supportive work-life policies for employees, and a culture that welcomes differences and creates a sense of belonging. We strive to create a work environment where all employees can develop and grow to achieve their full potential.

The Perks:

• A stage to feel proud of your work
• Platform to take up higher responsibilities
• A fun work-life balance
• A chance to become part of a high growth company, keeping that Unicorn tag within our sights

Hi ,

Greetings!!!

As discussed, sharing you the job description and company profile.

 Experience :
The candidate should have experience with design and development in Java. Experience in multithreading, algorithm, data-structure, database and collection is mandatory.

Required Skills :

• Core Java5.0 and above
  ·         Extensive experience in developing enterprise-scale n-tier applications for the financial domain. Should possess good architectural knowledge and be aware of enterprise application design patterns. 
  ·         Should have the ability to analyze, design, develop and test complex, low-latency client-facing applications.
  ·         Good development experience with RDBMS, preferably Sybase database
  ·         Good knowledge of multi-threading and high volume server side development
  ·         Experience in sales and trading platforms in investment banking/capital markets
  ·         Basic working knowledge of Unix/Linux. 
  ·         Strong written and oral communication skills. Should have the ability to express their design ideas and thoughts.

 Unix

Algorithms

Data Structures

OOPS Concepts

Database

Java Collections

Multi-threading

Design and architecture

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

About us:

Magicflare Software Services LLP is a technology services and consulting organization specializing in IT Services, Software Development, Outsourced Product Development and Test engineering services. Headquartered in Pune, India, Magicflare combines a passion for development, QA and testing, industry and process, client satisfaction and helping client to reach their business goals. Specialties Product Engineering Services, Software Development, Outsourced Product Development, QA and Test Automation, Core and Specialized Testing, Agile Practices and Consulting Services

Roles & Responsibilities:

• Interact with client and/or client coordinators/leads to understand the requirements
• Ensure successful delivery of the project by coordinating with all the stakeholders of the project
• Unit test the developed modules
• Troubleshoot complex problems and ability to fix them with efficiency
• Develop documentation throughout the software development life cycle (SDLC)
• Write clean, scalable code using .NET programming languages
• Analyze requirements and designing new functionality