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. - 5 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.

Company Overview

CareStack is a complete cloud-based dental software solution for scheduling, clinical, billing, patient engagement, and reporting needs of dental offices of any size - whether it's a single location or a large multi-site DSO with hundreds of locations.

The company was founded in 2015 and the commercial launch was done in early 2018. Since then, more than 1000 offices have chosen CareStack as their single source of truth. This is the fastest growth till date in the dental practice management software market, dominated by 100 year old distribution companies.

More about CareStack

●    Rated by independent B2B software reviews and research analysts as the most modern, innovative and customer experience focussed company in the space with the fastest growth in the segment.

●    Important strategic go to market partnerships with dental industry leaders like Delta Dental, Darby Dental and several others.

●    Venture backed with over $60M raised from leading financial and strategic investors.

●    HQ'd in Orlando, FL with offices in Minnesota, Bangalore, Trivandrum and Cochin.

Role Overview

CareStack seeks to hire Software Development Engineer - 1 to build its next generation healthcare platform. You will be reporting to a Staff SDE in your business unit , to develop and release services and solutions for our platform, aligning with your business unit’s goals and objectives.

Key responsibilities

●    Technical Design

You can be a specialist in technology areas, but capable of creating complete designs to solve a specific problem that accomplishes a definitive product feature or enables a technical advancement.You should work with your lead to review your design and embrace the feedback

●    Process Definition/Adherence

You should deliver estimations, review test scenarios/cases created by QAs in your team, participate in sprint grooming and planning meetings. You must learn, practice and evangelize standard techniques for grooming, defining complexity of stories and estimation.

●    Code Quality

At Carestack we believe that your code reflects your character. Code for scale, produce maintainable reusable code. You must commit to clean coding, continuous refactoring to ensure a high level of code quality. Continuously learn, practice and evangelize coding patterns/best practices within and outside your team. You should ensure testability of team functional areas, facilitate integration testing, resolve deep rooted technical issues and proactively collaborate with team members in solving complex problems.

●    Team Player

You should proactively communicate to resolve dependencies within and outside the team. Understand organizations culture code and streamline conversations and activities that will further instill this code. Mentor and coach new additions to your team.

●    Value/Mission Alignment

Be a champion for CareStack within the Engineering team. Help drive workplace and cultural norms within your business unit that align with CareStack company values.

This role may be for you if you…

●    Have an insatiable itch to join and the courage to scale an early-stage technology company.

●    Have 2-4 years of experience in building modern day web platforms, using Microsoft technologies on the backend.

●    Can be a generalist or specialist with deep understanding of building software components that meet defined requirements, with good understanding of .NET Core/ASP.NET.

●    Are proficient in data structures and algorithms, and object oriented analysis and design of software systems.

●    Are a backend specialist with good understanding of event driven programming, distributed systems, caching/in-memory computing systems, data modeling for transactional systems.

●    Solid understanding of relational and non relational databases including warehouses.Preferably MySQL, MSSQL, Vertica and CosmosDB

●    Solid understanding of CI/CD patterns and IaC.

●    Expertise in building ETLs in both batch and streaming model.

●    Expertise in building and testing APIs and micro services

This role may not be for you if you…

●    Don’t have the itch to design solutions and write code and you don’t grab every other opportunity to review and write code.

●    Don’t have the fire in you to fight for your design suggestions and debate with logical data points

●    Don’t have the trait to be transactional in code reviews/design discussions, accept your mistakes and appreciate better ideas from your peers.

●    Haven’t developed the habit of doing objective conversations that are data driven.

Net Engineer:

Job Descriptions: Senior .NET Cloud (Azure) Practitioner

Job Description Experience: 8-12 years (approx.)

Notice period : 15-20 days max.

Location :Chennai(1^st preference),Bangalore and Hyderabad

Mandatory Skills

·       Strong Restful API, Micro-services development experience using ASP.NET CORE Web APIs (C#);

·       Must have exceptionally good software design and programming skills in .Net Core (.NET 3.X, .NET 6)  Platform, C#, ASP.net MVC, ASP.net Web API (RESTful), Entity Framework & LINQ

·       Good working knowledge on Azure Functions, Docker, and containers

·       Expertise in Microsoft Azure Platform - Azure Functions, Application Gateway, API Management, Redis Cache, App Services, Azure Kubernetes, CosmosDB, Azure Search, Azure Service Bus, Function Apps, Azure Storage Accounts, Azure KeyVault, Azure Log Analytics, Azure Active Directory, Application Insights, Azure SQL Database, Azure IoT, Azure Event Hubs, Azure Data Factory, Virtual Networks and networking.

·       Strong SQL Server expertise and familiarity with Azure Cosmos DB, Azure (Blob, Table, queue) storage, Azure SQL etc

·       Experienced in Test-Driven Development, unit testing libraries, testing frameworks.

·       Good knowledge of Object Oriented programming, including Design Patterns

• Cloud Architecture - Technical knowledge and implementation experience using common cloud architecture, enabling components, and deployment platforms.

·       Excellent written and oral communication skills, along with the proven ability to work as a team with other disciplines outside of engineering are a must

·       Solid analytical, problem-solving and troubleshooting skills

Desirable Skills:

·       Certified Azure Solution Architect Expert

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-900-exam-preparation-microsoft-azure-fundamentals-524%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=sjIg554Fzuhah%2BLm1FC7znr9WrbVWw8PuvmoYbeDDmc%3D&reserved=0" target="_blank">Microsoft Certified: Azure – Fundamentals Exam AZ-900

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-104-exam-preparation-microsoft-azure-administrator-1-1332%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=U%2Fusuw7eB2%2BOcqrLLaFhFLUiPXKxsOFiMogcbeXk83o%3D&reserved=0" target="_blank">Microsoft Certified: Azure Administrator – Associate Exam AZ-104

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-204-exam-preparation-developing-solutions-for-microsoft-azure-1208%2F&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8NS7FvcbCzFhLiXHXvBVqSyC3e3ffjDNYH95UiQh1eY%3D&reserved=0" target="_blank">Microsoft Certified: Azure Developer – Associate Exam AZ-204

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23devops-engineer&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=c69xXIJIf480QdSEQ8VuIpQZIK2YSm4iI2D6arpWKCU%3D&reserved=0" target="_blank">Microsoft Certified: DevOps Engineer Expert (AZ-400)

o   https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23solutions-architect&;data=05%7C01%7C%7Cb1b4eb5832414d395d6a08dac6664f6b%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638040439967432270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gnCQGt%2Bnu9MJNaLRde%2FuEve0K8V8EJpVmjAUTrJKSDE%3D&reserved=0" target="_blank">Microsoft Certified: Azure Solutions Architect Expert (AZ-305)

·       Good understanding of software architecture, scalability, resilience, performance;

·       Working knowledge of automation tools such as Azure DevOps, Azure Pipeline or Jenkins or similar

Roles & Responsibilities

·       Defining best practices & standards for usage of libraries, frameworks and other tools being used;

·       Architecture, design, and implementation of software from development, delivery, and releases.

·       Breakdown complex requirements into independent architectural components, modules, tasks and strategies and collaborate with peer leadership through the full software development lifecycle to deliver top quality, on time and within budget.

·       Demonstrate excellent communications with stakeholders regarding delivery goals, objectives, deliverables, plans and status throughout the software development lifecycle.

·       Should be able to work with various stakeholders (Architects/Product Owners/Leadership) as well as team -  Lead/ Principal/ Individual Contributor for Web UI/ Front End Development;

·       Should be able to work in an agile, dynamic team environment;

Minimum of 4+ years of experience in Java development

• Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
• Experience developing and deploying Java solutions to cloud
• Experience in Spring Boot and components of Spring framework
• Experience in a JavaScript framework such as Angular or React
• Experience in TDD using Junit or similar frameworks

·       Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.

·       Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.

·       Experience in SQL, Unix skills.

·       Good communication Skill

As a Software Engineer, you will participate in all aspects of software development (design, development, testing, maintenance, support) of the business’s applications. This is a hands-on development role responsible for design, implementation, and life cycle management of the product built/configured on the Huron platform.

You will also have the opportunity to work with one or more development teams that are responsible for web applications, able contribute to the design, implementation, and maintenance of applications and technologies owned by the assigned team, be delivering quality client and server-side code, markup, and CSS as needed, while adhering to best practices and standard. In addition, you’d be expected to attend all team meetings while making meaningful contributions and provide regular updates (via tools, meetings, communication, etc.) to the team lead of assigned teams.

You’ll be part of the Huron Higher Education team with opportunities to collaborate, learn and grow while impacting some of the most prestigious higher education and research institutions.

Let’s get to work – together.

• Apply Software Engineering competencies to design and develop software products.
• Solve complex technical problems with help from Lead Engineers
• Interact with key stakeholders from Product Management, Implementation and Support teams
• Develop in-depth knowledge of business processes facilitated by our software products.
• Create and execute a complete set of unit test cases.
• Interact and pair program with other Software engineers on the team to build high quality products.
• Troubleshoot deployment and resolve environmental issues in a timely manner across multiple projects.
• Work closely with the offshore development team to ensure quality standards are being met
• Be part of the scrum for dev team
• Support and update existing internal applications and services.
• Improve and implement modular, well-documented, responsive, and accessible JavaScript frontend components
• Authoring developer documentation and release notes
  
  
  

• Four-year technical degree in Computer Science, Information Technology or Information Systems or equivalent professional experience
• 3 + years of relevant experience
• Strong computer science skills and experience
• Highly proficient in .NetCore and Visual Studio
• Familiar with NextJS/React/TypeScript for front end development
• Unit testing experience with NUnit or other testing frameworks
• Familiarity in AWS Cloud Services like CloudFront, Cognito, Lambda, SNS, SES, Elastic Search, Event Bridge, S3, etc
• Familiarity with developing and using Rest API
• Familiarity with version control systems such as GIT required.
• Experience working with Postgres Aurora, DynamoDB, Elastic Cluster a plus
• Familiar in Linux
• Familiar with npm packages
• Authoring developer documentation and release notes
• Familiarity with agile development methodologies
• Ability to work independently or in a group with minimal supervision.
• Strong analytical thinking and problem-solving skills and demonstrated ability and experience in design for generality and abstraction.
• Experience is preferred in the following:
  • REST and developing RESTful APIs using the OpenAPI standard.
  • HTML 5, CSS, JavaScript, React
  • Aurora Postgress, DynamoDB
  • Developing microservices in Azure or AWS
  • Azure DevOps
  • .NET Core

Must have:

• Knowledge on design, development and deployment of applications based on CMS and Dot Net technology framework
• Strong Analytical, Logical Reasoning and Problem-Solving skills
• Strong in SDLC concepts, RDBMS concepts and SQL/PL-SQL, Data Structures
• Ability to effectively work with a highly technical and virtually located team

Good to have:

• Considerable knowledge in the following: Drupal, .NET MVC, PHP, CSS, Angular, jQuery, Microsoft SQL Server, MySQL, DevOps, Agile software development 
• Exposure to mobile application development using any one of the mobile development platforms (iOS, Android, Windows)

Soft skills:

• Ability to co-ordinate among various user groups and internally within the team. This is a critical skill
• Excellent communication skills, both written and oral
• Ability to multi-task and prioritize
• Deliver on commitments
• Self-Starter and willing to learn many new skills on the job
• Willing to work flexible hours as the job demands
• Excellent trouble shooting skills
• Ability to think through various business issues and come up with solid design solutions that will stand the test of time
• Good listening and influencing skills; a strong customer focus is a must

Job description

Do you want to work with high traffic OLTP and OLAP systems that provide real value to retailers? Want to build real web applications that work across multiple channels and devices? In this critical role, the right candidate should have an entrepreneurial mind-set, have experience working across an application stack and a strong background in developing complex web experiences that are rich, responsive and interactive. The individual should have exhibited good technical leadership skills and be a highly motivated individual.

Role & Responsibility

• Exhibit strong technical knowledge, leadership skills and independent execution.
• A keen eye for good experiences. Understanding the experience from a customer perspective.
• Drive design discussion of complex features and own development of these modules across the application stack.
• Ability to adapt to changing business and product needs.
• Experience evolving the design and operation scale as new features are added to the product
• Mentor junior developers and ensure quality code output (via code reads, reading references, etc.) from them.
• Co-ordinate with internal teams and external partners in ensuring we build the best solution on time for the customer. Constantly looking at ways to innovate and improve the product.
• 8+ years of experience in Java & J2EE based Web Technologies & Frameworks with a focus in either Service Oriented Architecture or APIs. 
• Experience in designing scalable solutions in a large-scale distributed environment.
• Strong knowledge of web technologies, common web frameworks, networking, SQL and database technologies
• Well versed in software engineering principles, frameworks and technologies
• Strong debugging / troubleshooting skills.
• Ability to propose and defend solutions.
• Ability to work closely with product management, customer support, and  other engineering teams to continuously evolve and innovate the enterprise-class Products.