11+ SQL tuning Jobs in Bangalore (Bengaluru) | SQL tuning Job openings in Bangalore (Bengaluru)

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: Java Developer

Location: Bengaluru - Hybrid

Mode: Full Time

Job Description: We are looking for a talented and motivated Software Engineer with expertise in both Windows and Linux operating systems and solid experience in Java technologies. The ideal candidate should be proficient in data structures and algorithms, as well as frameworks like Spring MVC, Spring Boot, and Hibernate. Hands-on experience working with MySQL databases is also essential for this role.

Responsibilities:

● Design, develop, test, and maintain software applications using Java technologies.

● Implement robust solutions using Spring MVC, Spring Boot, and Hibernate frameworks.

● Develop and optimize database operations with MySQL.

● Analyze and solve complex problems by applying knowledge of data structures and algorithms.

● Work with both Windows and Linux environments to develop and deploy solutions.

● Collaborate with cross-functional teams to deliver high-quality products on time.

● Ensure application security, performance, and scalability.

● Maintain thorough documentation of technical solutions and processes.

● Debug, troubleshoot, and upgrade legacy systems when required.

Requirements:

● Operating Systems: Expertise in Windows and Linux environments.

● Programming Languages & Technologies: Strong knowledge of Java (Core Java, Java 8+).

● Frameworks: Proficiency in Spring MVC, Spring Boot, and Hibernate. ● Algorithms and Data Structures: Good understanding and practical application of DSA concepts.

● Databases: Experience with MySQL – writing queries, stored procedures, and performance tuning.

● Version Control Systems: Experience with tools like Git.

● Deployment: Knowledge of CI/CD pipelines and tools such as Jenkins, Docker (optional)

• Programming Language: Python (Strong knowledge)
• Concurrency & Parallelism: Multithreading, Multiprocessing, AsyncIO, ThreadPoolExecutor, Future, concurrent.futures
• Memory Management: Reference Counting, Global Interpreter Lock (GIL)
• Distributed Computing: Dask, Apache Spark (Preferred)
• Data Processing: NumPy
• Inter-Service Communication: GRPC, REST API
• Containerization & Orchestration: Docker, Kubernetes
• Software Development Practices: Code Optimization, Debugging, Performance Tuning
• Communication & Problem-Solving: Technical Documentation, Team Collaboration, Asking for Clarity When Needed

Skills And Expertise

• Python, 
• Multithreading, 
• Multiprocessing, 
• Dask, Apache Spark, 
• NumPy, 
• REST API, 
• Docker, 
• Kubernetes, 
• Code Optimization

Detailed JD: 

Responsibilities:

- Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support

of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning,

and Requirement discussions)

- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders

- Provide innovative solutions to complex problems

- Design, develop and modify software applications/systems according to specifications

- Develop technical documentation including services, object, and data model

- Create high quality code and perform code reviews

- Create unit and integration tests to ensure the code quality and functionality

- Proactively learn and share knowledge of technology and compare advantages and disadvantages of

alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Tech Stack:

C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Web API

·      4+ years of experience as a Python Developer.

·      Good Understanding of Object-Oriented Concepts and Solid principles.

·      Good Understanding in Programming and analytical skills.

·      Should have hands on experience in AWS Cloud Service like S3, Lambda functions Knowledge. (Must Have)

·      Should have experience Working with large datasets (Must Have)

·      Proficient in using NumPy, Pandas. (Must Have)

·      Should have hands on experience on Mysql (Must Have)

·      Should have experience in debugging Python applications (Must have)

·      Knowledge of working on Flask.

·      Knowledge of object-relational mapping (ORM).

·      Able to integrate multiple data sources and databases into one system

·      Proficient understanding of code versioning tools such as Git, SVN

·      Strong at problem-solving and logical abilities

·      Sound knowledge of Front-end technologies like HTML5, CSS3, and JavaScript 

·      Strong commitment and desire to learn and grow.

Required Skills/Qualifications: 

∙         B.Tech/MCA in Comput

Required Skills/Qualifications: 

Any Backend Technology is acceptable

∙         B.Tech/MCA in Computer Science or equivalent with 1-3 years’ experience with server-side web application development.

∙         Extensive development experience using LAMP or MEAN stack, RESTful web services or Node.js, HTML and CSS.

∙         Good understanding of Data structures and Relational Databases like MySQL or NoSQL Databases like MongoDB.

∙         Experience working with services in AWS such as EC2, RDS, and ELBs and have knowledge of VPCs.

∙         Experience with server side and client side MVC frameworks, Kafka Ansilble,Jenkins.

∙         Exposure to Continuous Integration (CI) and Continuous Deployment (CD), automated testing and agile development methods.

∙         Understanding of Version Management Tools like GitHub.

er Science or equivalent with 1-3 years’ experience with server-side web application development.

∙         Extensive development experience using LAMP or MEAN stack, RESTful web services or Node.js, HTML and CSS.

∙         Good understanding of Data structures and Relational Databases like MySQL or NoSQL Databases like MongoDB.

∙         Experience working with services in AWS such as EC2, RDS, and ELBs and have knowledge of VPCs.

∙         Experience with server side and client side MVC frameworks, Kafka Ansilble,Jenkins.

∙         Exposure to Continuous Integration (CI) and Continuous Deployment (CD), automated testing and agile development methods.

∙         Understanding of Version Management Tools like GitHub.

.Net core-3years experience, OOA, Coding, Web API, Rest API, any cloud, any DB

• Designs, codes, tests, debugs, and documents software according to systems quality standards, policies and procedures.
• Analyzes business needs and creates software solutions.
• Responsible for preparing design documentation.
• Prepares test data for unit, string, and parallel testing.
• Evaluates and recommends software and hardware solutions to meet user needs. Resolves customer issues with software solutions and responds to suggestions for improvements and enhancements.
• Works with business and development teams to clarify requirements to ensure testability. Drafts revise and maintain test plans, test cases, and automated test scripts.
• Executes test procedures according to software requirements specifications
• Logs defects and makes recommendations to address defects.
• Retests software corrections to ensure problems are resolved.

• 4-7 years of experience working on .Net Technologies ( Core , C# )

• Write clean, scalable code using .NET programming languages
• Development, maintenance and production support of existing products
• Understand business requirement and come up with design and solution.
• Remain up to date with the terminology, concepts and best practices for coding web and mobile apps

• Strong knowledge of .NET Technologies such as Dot Net Core, C#
• Experience in building API Programming REST-based services and/or applications with Event-Driven Microservices Architecture
• Good understanding of Design Patterns and Principles
• Working knowledge of Relational Database, SQL, and ORM technologies (Entity Framework Core, Hibernate) with extensive DB experience in writing SQL and NoSQL queries, SQL statements / SQL Injection, and Change Data Capture (CDC)
• Experience in test-driven development with experience in writing effective unit testing using XUnit
• Clear understanding on CI/CD pipeline [QA/UAT/PROD environments]
• Experience with using GitHub , VSTS for Source control.
• Demonstrated problem solving, analytic, and troubleshooting skills
• Ability to multi-task and manage time effectively