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

Skills: C#.Net

Share

Roles and Responsibilities:

·   Lead the analyze, design create a solution and an architecture for a business feature or infra improvement.

·   Consulting low-level designs of development features.

Critical Skills to Possess:

Must Have:

·   B.Sc. / B.A. in Computer Science / Software Engineering or related field.

·   8+ years of hands-on experience in C# (.NET, .NET CORE) software development.

·   2+ years’ experience managing a team (of 3 members minimum).

·   Experience with MS-SQL and familiarity with stored procedures.

·   Experience with Rest API.

·   Experience with Angular.

·   Experience with Entity framework, Dependency injection.

Experience working in an AGILE environment.

Nice to Have:

·    Experience with known protocols and 3rd party software / interfaces.

·    Background in retail systems development.

·    Experience with DevExpress reporting components.

·    Experience in implementing software interfaces.

·    Experience with HTML5, CSS & JavaScript.

Job Description:

1. Experience in Core Java, Spring Boot.
2. Experience in microservices.
3. Extensive experience in developing enterprise-scale systems for global organization. Should possess good architectural knowledge and be aware of enterprise application design patterns.
4. Should be able to analyze, design, develop and test complex, low-latency client-facing applications.
5. Good development experience with RDBMS in SQL Server, Postgres, Oracle or DB2
6. Good knowledge of multi-threading
7. Basic working knowledge of Unix/Linux
8. Excellent problem solving and coding skills in Java
9. Strong interpersonal, communication and analytical skills.
10. Should be able to express their design ideas and thoughts.

About Wissen Technology:

Wissen Technology is a niche global consulting and solutions company that brings unparalleled domain expertise in Banking and Finance, Telecom and Startups. Wissen Technology is a part of Wissen Group and was established in the year 2015. Wissen has offices in the US, India, UK, Australia, Mexico, and Canada, with best-in class infrastructure and development facilities. Wissen has successfully delivered projects worth $1 Billion for more than 25 of the Fortune 500 companies. The Wissen Group overall includes more than 4000 highly skilled professionals.

Wissen Technology provides exceptional value in mission critical projects for its clients, through thought leadership, ownership, and assured on-time deliveries that are always ‘first time right’.

Our team consists of 1200+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world.

Wissen Technology offers an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.

We have been certified as a Great Place to Work® for two consecutive years (2020-2022) and voted as the Top 20 AI/ML vendor by CIO Insider.

Job Description:

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

• Ability to complete all phases of software development life cycle including analysis, design, functionality, testing and support 
• Ability to develop large scale web/database applications 
• Ability to work on multiple projects with multiple deadlines 
• Ability to communicate clearly with business users and project manager 
• Ability to innovate and provide functional applications with intuitive interfaces 
• Proven experience with Microsoft .NET technologies including, .Net Core, ASP.NET, ADO.NET 
• Strong in Jquery/javascrpit/CSS/Bootstrap
• Familiarity with architecture styles/APIs (REST, RPC)
• Knowledge of Design/architectural patterns (e.g. MVC)
• Understanding of Agile methodologies
• Excellent troubleshooting and communication skills
• Excellent documentation skills for Technical Documentation.