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

Job Title: Java Developer

Java Developer – Job Description Wissen Technology is now hiring for a Java Developer - Bangalore with hands-on experience in Core Java, algorithms, data structures, multithreading and SQL. We are solving complex technical problems in the industry and need talented software engineers to join our mission and be a part of a global software development team. A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high-end technical consulting.

 Required Skills: • Exp. - 4 to 14 years.

• Experience in Core Java and Spring Boot.

• Extensive experience in developing enterprise-scale applications and systems. 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 clientfacing applications.

• Good development experience with RDBMS.

 • Good knowledge of multi-threading and high-performance server-side development.

• Basic working knowledge of Unix/Linux.

• Excellent problem solving and coding skills.

• Strong interpersonal, communication and analytical skills.

• Should have the ability to express their design ideas and thoughts.

• Minimum 4+ years of years

• Experience in designing, developing, and maintain backend services using C# 12 and .NET 8 or .NET 9

• Experience in building and operating cloud native and serverless applications on AWS

• Experience in developing and integrating services using AWS lambda, API Gateway , dynamo DB, Eventbridge, CloudWatch, SQS, SNS, Kinesis, Secret Manager, S3 storage, server architectural models etc.

Experience in integrating services using AWS SDK

• Should be cognizant of the OMS paradigms including Inventory Management, Inventory publish, supply feed processing, control mechanisms, ATP publish, Order Orchestration, workflow set up and customizations, integrations with tax, AVS, payment engines, sourcing algorithms and managing reservations with back orders, schedule mechanisms, flash sales management etc.

• Should have a decent End to End knowledge of various Commerce subsystems which include Storefront, Core Commerce back end, Post Purchase processing, OMS, Store / Warehouse Management processes, Supply Chain and Logistic processes. This is to ascertain candidates knowhow on the overall Retail landscape of any customer.

• Strong knowledge in Querying in Oracle DB and SQL Server

• Able to read, write and manage PLSQL procedures in oracle.

• Strong debugging, performance tuning and problem solving skills

• Experience with event driven and micro services architectures

Looking for Java Developer for Gurugram and Bangalore Location with 5+ years of experience win Java + Microservices , Multithreading , Spring boot , Kafka and any MQ Series

Required Skillset

• Experience in Core Java 1.8 and above, Data Structures, OOPS, Multithreading, Algorithms, Collections, System Design, Unix/Linux. • Possess good architectural knowledge and be aware of enterprise application design patterns. • Should be able to analyze, design, develop and test complex, low-latency client-facing applications. • Good development experience with RDBMS. • Good knowledge of multi-threading and high-volume server-side development. • Basic working knowledge of Unix/Linux. • Excellent problem solving and coding skills in Java. • Strong interpersonal, communication and analytical skills. • Should be able to express their design ideas and thoughts.

Job Brief-

• Understand product requirements and come up with solution approaches. • Build and enhance large scale domain centric applications. • Deploy high quality deliverables into production adhering to the security, compliance and SDLC guidelines.

Sizzle is an exciting new startup that’s changing the world of gaming.  At Sizzle, we’re building AI to automate gaming highlights, directly from Twitch and YouTube streams. We’re looking for a superstar Python expert to help develop and deploy our AI pipeline. The main task will be deploying models and algorithms developed by our AI team, and keeping the daily production pipeline running. Our pipeline is centered around several microservices, all written in Python, that coordinate their actions through a database. We’re looking for developers with deep experience in Python including profiling and improving the performance of production code, multiprocessing / multithreading, and managing a pipeline that is constantly running. AI/ML experience is a plus, but not necessary. AWS / docker / CI/CD practices are also a plus. If you are a gamer or streamer, or enjoy watching video games and streams, that is also definitely a plus :-)

You will be responsible for:

• Building Python scripts to deploy our AI components into pipeline and production
• Developing logic to ensure multiple different AI components work together seamlessly through a microservices architecture
• Managing our daily pipeline on both on-premise servers and AWS
• Working closely with the AI engineering, backend and frontend teams

You should have the following qualities:

• Deep expertise in Python including:
• Multiprocessing / multithreaded applications
• Class-based inheritance and modules
• DB integration including pymongo and sqlalchemy (we have MongoDB and PostgreSQL databases on our backend)
• Understanding Python performance bottlenecks, and how to profile and improve the performance of production code including:
• Optimal multithreading / multiprocessing strategies
• Memory bottlenecks and other bottlenecks encountered with large datasets and use of numpy / opencv / image processing
• Experience in creating soft real-time processing tasks is a plus
• Expertise in Docker-based virtualization including:
• Creating & maintaining custom Docker images
• Deployment of Docker images on cloud and on-premise services
• Experience with maintaining cloud applications in AWS environments
• Experience in deploying machine learning algorithms into production (e.g. PyTorch, tensorflow, opencv, etc) is a plus
• Experience with image processing in python is a plus (e.g. openCV, Pillow, etc)
• Experience with running Nvidia GPU / CUDA-based tasks is a plus (Nvidia Triton, MLFlow)
• Knowledge of video file formats (mp4, mov, avi, etc.), encoding, compression, and using ffmpeg to perform common video processing tasks is a plus.
• Excited about working in a fast-changing startup environment
• Willingness to learn rapidly on the job, try different things, and deliver results
• Ideally a gamer or someone interested in watching gaming content online

Seniority: We are looking for a mid to senior level engineer

Salary: Will be commensurate with experience. 

Who Should Apply:

If you have the right experience, regardless of your seniority, please apply.

Work Experience:  4 years to 8 years

About Sizzle

Sizzle is building AI to automate gaming highlights, directly from Twitch and YouTube videos. Sizzle works with thousands of gaming streamers to automatically create highlights and social content for them. Sizzle is available at www.sizzle.gg. 

Greetings from Amazon...!                                       

It is our pleasure in personally inviting you to apply job with Amazon Development Centre India (ADCI). At Amazon we are inclined to hire people with passion for technology and you happened to be one of the shortlisted candidates. Our business is committed to recognizing potential and creating teams that embrace innovation.

Please find the Eligible criteria and requirements:

Job title                             :             SDE – II (Software Development Engineer)
Role Opportunity            :             Permanent/Full Time/FTE/Regular

Work Location                 :             Hyderabad/Bangalore/ Gurgaon

Must Have

• Strong Exposure to Data Structures, Algorithms, Coding, System Design (LLD, HLD, OOAD), Distributed systems, problem solving skills, Architecture (MVC/Microservices), logical thinking.

Amazon (ADCI) - If you are looking for an opportunity to solve deep technical problems and build innovative solutions in a fast paced environment working with smart, passionate software developers, this might be the role for you. Amazon’s transportation systems get millions of packages to customers worldwide faster and cheaper while providing world class customer experience – from checkout to shipment tracking to delivery. Our software systems include services that handle thousands or requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers worldwide, manage business rules for millions of unique products, and improve experience for millions of online shoppers. With rapid expansion into new geographies, innovations in supply chain, delivery models and customer experience, increasingly complex transportation network, ever expanding selection of products and growing number of shipments worldwide, we have an opportunity to build software that scales the business, leads the industry through innovation and delights millions of customers worldwide.

As an SDE, you will develop a deep understanding of our business, work closely with development teams and own the architecture and end-to-end delivery of software components.

About Amazon India:

Amazon teams in India work on complex business challenges to innovate and create efficient solutions that enable various Amazon businesses, including Amazon websites across the world as well as support Payments, Transportation, and Digital products and services like the Kindle family of tablets, e-readers and the store. We are proud to have some of the finest talent and strong leaders with proven experience working to make Amazon the Earth’s most customer-centric company.

We made our foray into the Indian market with the launch of Junglee.com, enabling retailers in India to advertise their products to millions of Indian shoppers and drive targeted traffic to their stores. In June 2013, we launched http://www.amazon.in">www.amazon.in for shoppers in India. With http://www.amazon.in">www.amazon.in, we endeavor to give customers more of what they want – low prices, vast selection, fast and reliable delivery, and a trusted and convenient online shopping experience. In just over a year of launching our India operations, we have expanded our offering to over 18 million products across 36 departments and 100s of categories! Our philosophy of working backwards from the customers is what drives our growth and success.

We will continue to strive to become a trusted and meaningful sales and logistics channel for retailers of all sizes across India and a fast, reliable and convenient online shopping destination for consumers. For us, it is always “Day 1” and we are committed to aggressively invest over the long-term and relentlessly focus on raising the bar for customer experience in India. Amazon India offers opportunities where you can dive right in, work with smart people on challenging problems and make an impact that contributes to the lives of millions. Join us so you can - Work Hard, Have Fun and Make History.

Basic Qualifications:

• 3+ years’ experience building successful production software systems
• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field)
• The ability to take convert raw requirements into good design while exploring technical feasibility tradeoffs
• Expertise in System design (design patterns, LLD, HLD, Solid principle, OOAD, Distributed systems etc..), Architecture (MVC/Micro services).
• Good understanding of at least some of the modern programming languages (Java) and open-source technologies (C++, Python, Scala, C#, PHP, Ruby etc..)
• Excellence in technical communication
• Has experience in mentoring other software developers

Preferred Qualifications:

• BS/MS in Computer Science or equivalent
• Experience developing service oriented architectures and an understanding of design for scalability, performance and reliability
• Demonstrated ability to mentor other software developers to maintain architectural vision and software quality
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment
• Expertise in delivering high-quality, innovative application
• Strong desire to build, sense of ownership, urgency, and drive
• Strong organizational and problem solving skills with great attention to detail
• Ability to triage issues, react well to changes, work with teams and ability to multi-task on multiple products and projects.
• Experience building highly scalable, high availability services
• The ideal candidate will be a visionary leader, builder and operator.
• He/she should have experience leading or contributing to multiple simultaneous product development efforts and initiatives.
• He/she needs to balance technical leadership with strong business judgment to make the right decisions about technology choices.
• He/she needs to be constantly striving for simplicity, and at the same time demonstrate significant creativity, innovation and judgment
• Proficiency in, at least, one modern programming language.
• Experience in SQL or Non-SQL database.
• Strong sense of ownership, urgency, and drive.
• Demonstrated leadership abilities in an engineering environment in driving operational excellence and best practices.
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
• Excellent communication, collaboration, reporting, analytical and problem solving skills.

Good to Have:

• Knowledge of professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Experience with enterprise-wide systems
• Experience influencing software engineers best practices within your team
• Hands-on expertise in many disparate technologies, typically ranging from front-end user interfaces through to back-end systems and all points in between
• Strong written and verbal communication skills preferred

Key Points to remember:

• Strong knowledge of the Software Development Life Cycle methodology
• Technical design, development and implementation decisions on the use of technology in area(s) of specialization.
• Write or modify programming code to suit customer's needs.
• Unit test to assure meets requirements, including integration test as needed.
• Ability to understand and analyze issues and uses judgment to make decisions.
• Strong problem solving & troubleshooting skills
• Strong communication skills
• Responsible for self-development according to professional development plan

• Strong experience in C# programming.
• Good knowledge in designing classes and components using the OOPs paradigm.
• Fair knowledge of GoF Design Patterns.
• Good experience in applications developed using both .NET Framework and .NET Core
• Proficiency in using third-party tools like DevExpress/Infragistics.
• Solid understanding of Web application development using ASP.NET MVC framework and ASP.NET Core
• Strong experience in developing RESTful APIs using both ASP.NET Web API and ASP.NET Core Web API.
• Must have knowledge in developing ASP.NET WebForms.
• Decent exposure in developing Windows Applications/WPF applications.
• Professional, precise communication skills
• Work experience writing Unit tests
• Work experience in applying the best practices of Web Application development
• Working experience in an Agile team especially with SCRUM
• Good to have experience in JavaScript frameworks, primarily on Angular and React
• Good to have experience in JSON, AJAX, JavaScript, HTML5, CSS, and XML Following Skills will be an added advantage
• Experience developing Windows Forms Applications
• Knowledge of using third-party tools like DevExpress
• Experience in Angular front-end framework

• Should be self-motivated and a quick learner with a problem-solving mind-set
• Attention to detail and follow-through to achieve good quality and meet deadlines.
• Ability to work effectively in a team as well as in an individual environment
• Should have excellent written and verbal communication skills

Job Summary:

– We are looking for a kick ass software engineer with exceptional skills in data structures, algorithms, core java, and distributed systems. If you think you have it in you to deliver on aggressive timelines, have the hunger for growth, don’t like giving excuses, contribute to product features, be hands-on and deliver a world-class product, then we want to hear from you.

This is a predominantly back-end engineering role.

– You are a rockstar engineer with proven capabilities working on SaaS product and a passion for writing exception code.

– You are hungry for an opportunity to join a start-up and become a member of core platform team driving the company forward.

– You will be responsible for the delivery of product features as a part of the platform engineering team.

– You will be hands-on working on key features of the product.

– You will be responsible for design of back-end architectural changes and product features.

– You will have plenty of opportunity to learn and implement ideas to build products in efficient and cohesive manner.

– Understand the product mission, goals, and tasks and execute with the team to achieve them.

– Understand the design and architecture and build modules in accordance with it or recommend and make the necessary changes that adds more stability to our product.

Eligibility:

– 4+ years of experience with hands-on experience in Core Java/Kotlin

– 2+ years of experience as a technical architect with responsibility for core features 

– 4+ years of working experience in cloud-based systems

– 2+ years of experience working on distributed systems

– 2+ years of experience working on Kafka and Zookeeper

– Experience working on RxJava/ Reactive Programming

– Adept on design patterns and distributed systems

– Excellent verbal and written communication

– Proficient in building REST APIs to interact with relational and non-relational data sources

– Proficient in SQL and RDBMS

– Hands on experience in code and system optimization

– Experience in working with NoSQL databases is a plus