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

• 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

Job Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

Azure Chatbot Developer

Location :Bangalore / Mumbai / Pune

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

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

f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.

g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET

i) Knowledge of Python and NodeJS is a plus

j) Ability to design and optimize SQL Server 2008 stored procedures.

k) Experience with JQuery, CSS3, HTML5 or similar technologies.

l) Ability to adapt quickly to an existing, complex environment.

Experience 2- 6 years within SW development

Excellent C/C++ and object-oriented programming skills

Excellent design analysis skills, including experience with software modeling,

Excellent on Linux for CLI or SNMP management related layer for L2 or L3 switches

Experience in telecom is a plus

Flexible, innovative, and driven

Structured and thorough with analytical and troubleshooting skills

Highly motivated team player

Agile way of working

Profile Summary: The Software Engineer - Full Stack is responsible for software development as a member of a project team. He/she works closely with subject matter experts, business analysts, quality analysts, and others to design, develop, and test software solutions to business problems.

Responsibilities:

• Solve problems of considerable scope and complexity.
• Designing, coding (at least 80%), debugging and optimizing both frontend and backend components as well as internal tools, such as configuration management and development/test environments.
• Help select and incorporate new tools and methods.
• Work closely with project, application, and enterprise architects to develop solutions.
• Drive the continuous evolution of best practices within the development team.
• Identify and recommend where increased automation, performance enhancements, application enhancements and quality enhancements may be incorporated.
• Balance customer and business needs to design, develop, test, and deliver against timelines.
• Contribute to architecture and code design, estimates, code reviews, and documentation to ensure top quality software.
• Keeps current with emerging technologies and technological developments within the industry.
• Monitors and evaluates competitive applications and products.
• Reviews current practices relevant to the solution of assigned projects.
• Remains flexible and responsive to changing priorities and multiple, concurrent responsibilities.
• Be a talent multiplier that motivates the team around them to excel and perform well.
• Other duties as assigned.

Requirements:

• Bachelor's Degree - Computer Science, Management Information Systems, or related field.
• 3-5 years of software development experience.
• Experience in lieu of education: Two years of experience for every year of formal education required. Application development experience using. NET, C#, . NET Core, SQL Server, CSS, and other web development technologies.

Job description:

Job Title/Designation/Position: Dotnet Developer / Sr. Dotnet Developer

Total Experience: 4-8 years

Relevant Experience: 4-8 years

Job Location: Pune/Hyderabad/Bangalore & Hyderabad

Skills/Qualifications:

Primary Skills (Must have):

• C# with good understanding of OOPS, design patterns and multi-threading
• ASP.Net MVC, WEBAPI, RESTful services, JavaScript, jQuery
• .Net Framework
• Advanced knowledge of Microsoft SQL Server
• Knowledge of Unit Testing and Automated tests (nUnit)
• Knowledge of SQL Server/Oracle database and able to write Store-Procedures
• Strong analytical and problem-solving skills

•         Good analytical skills along with Excellent written and verbal communication skills in English

• Bachelor’s Degree in Engineering /Technology / MCA

Secondary Skills (Nice to have):

• HTML5
• CSS3
• Node JS