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

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.

Job Description

Build and maintain bots on Azure platform.  Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

1. a) 5 years of experience in software development with clear understanding of the project life cycle
   b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
   c) Hands on experience with Machine Learning based chat bots
   d) Experience with Azure bot services like Text Analytics etc.
   e)Strong database skills and hands-on experience on databases like SQL Server/Oracle
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.

You should have at least 7 years of C# coding experience.

should be well versed in following standard coding practices.

understand design and implement functionalities within timelines

should be able to implement common design patterns as and when required.

Around 4 years of experience in creating and implementing Web-based applications using

C#, ASP.net, Web API, MVC, Micro Services, JavaScript and SQL Server.

Familiarity or exposure to CI / CD, Dev Ops such as Dockers, containers, Azure, Pipeline is

highly recommended

Ability to work in an Agile, fast-paced environment, and learn rapidly.

Bachelor degree in computer science, computer engineering or similar.

Familiar with object-oriented development, design patterns and specifically in .NET

Framework (C#) with a strong background in web-based development and service-oriented

Architecture.

Expert in HTML, CSS, JavaScript, JQuery, JSON.

Writing clean, readable, and easily maintainable code.

Must have knowledge of project/task management tools like Jira,

Familiarity with Version Control like Bitbucket, Git etc.

Understanding of UI, cross-browser compatibility and web standards.

Build features and applications with responsive design

Good English communication skills, written and spoken.

Able to work with minimum supervision as well as perform under pressure and meet

Deadlines.

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.

Responsibilities

• Determines technical feasibility of medium to low complexity features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.

• Exercises judgment in prioritizing tasks and selecting methods and techniques for obtaining solutions.

• Create a low-level design of modules of a software application through proper documentation and diagrams.

• Develops software solutions by studying requirements, clarifying customer/user needs, analyzing data and processes, and following established software development practices and processes.

• Develops proof of concepts for technical evaluation and early customer feedback.

• Updates and shares knowledge by studying state-of-the-art development tools, programming techniques, and computing technology; reading professional publications.

• Networks with internal and external personnel in their area of expertise.

Requirements

• B.Tech/B.S. or M.Tech/M.S. in Computer Science, IT or related field.

• 3-5 years of experience

Visit us on :

Mandatory Skills

• Should be proficient in the following areas of .NET (.NET 4.5 or above, .NET Core)

• Expert in C# and ASP.NET

• Knowledge of JavaScript/TypeScript is a plus

• Development of Windows and Web services

• Parallel and Asynchronous programming

• Unit testing, Linq, ORM

• Debugging/troubleshooting in .Net

• Should be proficient in SQL Server 2012 and above in the following areas

• T-SQL Stored Procedures

• Transaction in SQL

• Should have the following design skills

• Expert in OOPs

• Proficiency in Design Patterns

• Proficiency in Unit testing Patterns

• Understanding of Algorithms and Data structures.

• Experience on Requirement/Design/Code Review & Inspections

• Excellent problem-solving and analytical skills.

Desirable Skills

• Hands-on experience with using Git (handling branching and merging), any DevOps pipeline

• Experience with Agile methodologies

Technical Skills:

1. Must have skills:

• MVC, .Net C# 4.0, 4.5, .Net Core 3.1
• ASP .Net & ASP .Net Core
• Angular
• HTML, CSS, & JavaScript
• Database - SQL Server – 12/13/14/15

C# Developer @ Pune

Primary Skills : C#.Net, Microservices or JavaScript Framework

Requiements:
Required Knowledge/Skills, Education, and Experience
· Bachelor’s degree in Computer Science
· 3+ years professional experience in software development building production software systems
· Solid Computer Science fundamentals in object-oriented design, data structures, algorithms, and problem solving
· Proficiency in a modern programming language, preferably in C#
· Knowledge of Web based technologies or JavaScript frameworks
· Ability to work well with a team in a fast paced, dynamic, agile development environment
· Excellent written and verbal communication skills
Preferred Knowledge/Skills, Education, and Experience
· Knowledge of professional software engineering best practices
· Knowledge of Cloud Platforms (AWS, Azure, Google)
· Strong time management skills and the ability to be self-directed
· Experience with service-oriented architecture and web application/services development
· Experience with Object Oriented modern JavaScript Frameworks (Angular JS, Ember JS, Dojo, etc.)
· Experience with UI/UX design for complex workflows and/or for technical end users / domain experts
· Experience building complex, scalable, high-performance software systems that have been successfully delivered to customers
· Active on Github or StackOverflow
· Comfortable with the Linux command line and Git
· Sharp analytical abilities and proven design skills
· Experience with distributed computing and enterprise-wide systems
· Experience in communicating with users, other technical teams, and senior management to collect requirements, describe software product features, technical designs, and product strategy
· Experience leading and mentoring junior software engineers, and make them more effective, product software engineers
· Understanding of microservice development and best practices
Job Description:
Responsibilities
The person in this role will be developing software in the Innovation and Research team. The software development activity could be prototype code, researching an emerging technology, developing applications and microservices, testing harnesses, DevOps pipeline steps, and cloud development technology. The person in this role will be on an Agile Scrum team, and will participate a daily scrum meeting, updating story tasks, and providing daily updates to the team.
Additional responsibilities include:
· Documenting design, testing, or story details for a proposed implementation of a software feature or service
· Reporting out research findings to the broader team or organization
· Implementing software ideas
· Writing stories for software implementations
· Writing test code for validating software implementations
· Developing DevOps pipeline steps and/or DevOps tooling
· Agile Scrum activities (daily scrum, updating stories and tasks, sprint reviews)
· Research into a new software technology