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 DESCRIPTION:

Location: mumbai, bangalore, pune

Mode of Work : 3 days from Office

DSA(Collections, Hash maps, trees, Linkedlist and Arrays, etc), Core Oops concepts(Multithreading, Multi Processing, Polymorphism, Inheritance etc) Annotations in Spring and Spring boot, Java 8 Vital features, database Optimization, Microsevices and Rest API

• Design, develop, and maintain low-latency, high-performance enterprise applications using Core Java (Java 5.0 and above).
• Implement and integrate APIs using Spring Framework and Apache CXF.
• Build microservices-based architecture for scalable and distributed systems.
• Collaborate with cross-functional teams for high/low-level design, development, and deployment of software solutions.
• Optimize performance through efficient multithreading, memory management, and algorithm design.
• Ensure best coding practices, conduct code reviews, and perform unit/integration testing.
• Work with RDBMS (preferably Sybase) for backend data integration.
• Analyze complex business problems and deliver innovative technology solutions in the financial/trading domain.
• Work in Unix/Linux environments for deployment and troubleshooting.

Required Skills & Experience:

• 3– 8 years of strong hands-on experience in Core Java, Spring boot, microservices, data structures.
• Deep understanding of Object-Oriented Programming (OOP), data structures, algorithms, and design patterns.
• Proven experience with Spring, CXF, and REST/SOAP web services.
• Solid understanding of microservices architecture and distributed systems.
• Experience working with Sybase or other relational databases.
• Expertise in multithreading, concurrency, and high-throughput server-side development.
• Exposure to capital markets, sales & trading platforms, or similar financial services applications.
• Good working knowledge of Unix/Linux environments.
• Experience in solution architecture and design documentation is a strong plus.
• Strong problem-solving skills, analytical thinking, and a proactive attitude.
• Excellent communication and interpersonal skills to work effectively with global teams.

Preferred Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
• Previous experience in investment banking, capital markets, or financial technology domains.

For more details:

Website: www.wissen.com

Wissen Thought leadership : https://www.wissen.com/articles/

LinkedIn: Wissen Technology

Job Title: .NET Developer

Experience: 3-5 Years

Location: Pune

Employment Type: Full-Time

About the Role:

We're looking for an experienced .NET Developer with 3-5 years of expertise to join our team in Pune. You'll be working on building scalable web applications using C#, .NET Core, and modern development practices.

What You'll Do:

• Develop and maintain web applications using C# and .NET Core (.NET 5+)
• Build RESTful APIs with ASP.NET Core Web API
• Design and optimize SQL Server databases with complex queries and stored procedures
• Implement OOP principles, Design Patterns, and SOLID principles
• Work with Entity Framework Core for data access
• Collaborate with teams using Agile/Scrum methodologies
• Perform code reviews and ensure code quality
• Manage code using Git version control

Required Skills:

Must-Have:

• Strong proficiency in C# and .NET Core (or .NET 5+) - 3-5 years
• Hands-on experience with ASP.NET Core Web API and RESTful services
• Expertise in SQL (T-SQL), stored procedures, and database design
• Experience with SQL Server is highly preferred
• Hands-on experience with Entity Framework Core
• Solid understanding of OOP, Design Patterns, and SOLID principles
• Experience with Git and Agile/Scrum methodologies

Good to Have:

• Front-end technologies (Angular, React)
• Microservices architecture
• Cloud platforms (Azure/AWS)
• CI/CD pipelines
• Unit testing frameworks

Qualifications:

• Bachelor's degree in Computer Science, IT, or related field
• 3-5 years of professional .NET development experience

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

● Troubleshoot and debug applications

● Participate in code reviews and provide constructive feedback to peers

Required Skills:

● B.E/B.Tech in computer science

● 1 - 3 years of experience

● Hands-on experience following skills

MS Technologies: NET CORE 7+, C#

Backend: MSSQL / MySQL /Postgres

● Preferred understanding of Cloud: Azure/AWS.

● Strong understanding of object-oriented programming, Design principles, data structures, and algorithms

● Worked in an Agile software development environment

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies