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

Detailed JD

Requirements and Skills

• Actively participate in Agile ceremonies (Standups, Refinements, Retrospectives, Planning, and Requirement discussions)
• Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders
•  Provide innovative solutions to complex problems
• Design, develop and modify software applications/systems according to specifications
•  Develop technical documentation including services, object, and data model
• Create high-quality code and perform code reviews
•  Create unit and integration tests to ensure the code quality and functionality
•  Proactively learn and share knowledge of technology and compare the advantages and disadvantages of alternative solutions/technologies
• Help onboard new team members.

 

Job description

The .NET Lead/Arch position will be responsible for architecture, development, maintenance, and support of all development applications regardless of size. This individual must maintain effective customer relationships; as well as effective communication and coordination with various other technology groups. The Senior Architect is expected to be able to architect, analyze, design, code, test, and implement large projects and troubleshoot any Enterprise Development production system. This position is also expected to have the ability to do cross-discipline work with networks, servers, and infrastructure and be able to understand how they affect development projects.

Key Responsibilities and Duties:·

Analyze new requirements and provide impact analysis addressing technical design and identifying individual tasks
· Architect, design and implement solutions for requirements.
· Setting up CI/CD pipelines and Continuous integration & delivery of the application to Dev/Test/PROD environments.
· Design and coding of new facilities.
· Communication of technical details that impact the fulfillment of requirements.
· Iterative development of software with responsiveness to constructive feedback.
· Provide application support against agreed service levels including the implementation of bug fixes
· Develop and maintain code to a high standard within IT development and maintenance projects.
· Troubleshoot and problem-solve support issues as they arise and as directed by the project manager and technical architect.
· Code reviews of the work of peers in the group.
· Perform unit testing of work.
· Write documentation and comment code as required.
· Ensure code is properly version-controlled.
· Supervise and mentor junior staff

 

Mandatory Skills:

10+ years complete SDLC experience.
C#.Net MVC/ Core.
Web Services / WCF Service /WebAPI
SQL (MSSQL)
Version Control
JavaScript, JQuery, AJAX, HTML, CSS, XML, XSLT, JSON

 

Preferred Skills:

Atlassian Suite (Jira)
CI/CD
Docker

 

Optional Skills:

HTML/CSS/JavaScript
Angular

 

KINDLY REVERT WITH YOUR UPDATED RESUME

THANK YOU

We are Hiring Windows Developers

 

Experience : 4+years

 

Primary Skills : Experience with MVVM,WPF,XAML,C# .net

 

Job Code : "PR1009"

 

Location : Pan India

 

 

NP- Immediate to 15 days

 

#Windows #wpf #winforms #mvvm #C#

 

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

About the Role

In this role, you'll work on design, implementation, and test for Dremio's system internals. If you want to be part of a fast-moving, fun, and accomplished team, we'd love to hear from you.

Responsibilities & ownership

• Own design, implementation, testing, and support of next-generation features related to scalability, reliability, robustness, usability, security, and performance of the product.
• Capable of working Individually and collaboratively with other engineers.
• Collaborate with support and field resources to make sure that customers are successful with Dremio

Requirements

• Fluency in Java and/or C++ with 3 to 5+ years of experience developing production level software
• Strong foundation in data structures, algorithms, multi-threaded and asynchronous patterns and their applications towards developing scalable systems
• Experience developing scalable distributed systems and deploying, scaling, and managing microservices
• Experience with  containers and kubernetes for orchestration and container management in private and public clouds (AWS, Azure, Google Cloud) a plus
• Excellent communication skills and affinity for collaboration and teamwork
• Interested in and motivated to be  part of a fast-moving startup with a fun and accomplished team
• Startup experience a plus
• B.S. or M.S in Computer Science or a related technical field or equivalent practical experience

Location-      Bangalore
Experience-   3-5years
Required skills- At least 2 to 4 years of professional experience in programming 
(including scripting /coding), SQL and relational databases, and application
development
Primary skills-   
         Experience with RPA technologies - UiPath
         Experience with Process Analysis, Design, and Implementation, Business and Technical
requirements, Problem-Solving, and System(s) Testing, including UAT and Bug fixes
         Should be able to Prioritise and manage Multiple Portfolios
         Basic understanding of Lean Six Sigma process methodologies

Note: Should come from c#, .Net development background
 
Secondary skills-
         Good interpersonal, written and Excellent communication skills
         Should have strong analytical skills and problem solving

skills                                              
 
Responsibilities-
         The Process Designer is responsible for understanding the current process.
         He/she makes sure that the people working on the RPA project are in sync.
         He/she also monitors the changes that happen after implementing the feedback during
development or testing phase while keeping the project specifications intact.

Systems EngineerAbout Intellicar Telematics Pvt LtdIntellicar Telematics Private Limited is a vehicular telematics organization founded in 2015 with the vision of connecting businesses and customers to their vehicles in a meaningful way. We provide vehicle owners with the ability to connect and diagnose vehicles remotely in real-time. Our team consists of individuals with an in-depth knowledge and understanding in automotive engineering, driver analytics and information technology. By leveraging our expertise in the automotive domain, we have created solutions to reduce operational and maintenance costs of large fleets, and ensure safety at all times.Solutions :- Enterprise Fleet Management, GPS Tracking- Remote engine diagnostics, Driver behavior & training- Technology Integration : GIS, GPS, GPRS, OBD, WEB, Accelerometer, RFID, On-board Storage.Intellicar's team of accomplished automotive Engineers, hardware manufacturers, Software Developers and Data Scientists have developed the best solutions to track vehicles and drivers, and ensure optimum performance, utilization and safety at all times.We cater to the needs of our clients across various industries such as: Self drive cars, Taxi cab rentals, Taxi cab aggregators, Logistics, Driver training, Bike Rentals, Construction, ecommerce, armored trucks, Manufacturing, dealership and more. Desired skills as a developer :- Education: BE/B.Tech in Computer Science or related field.- 4+ years of experience with scalable distributed systems applications and building scalable multi-threaded server applications.- Strong programming skills in Java or Scala on Linux or a Unix based OS.- Understanding of distributed systems like Hadoop, Spark, Cassandra, Kafka.- Good understanding of HTTP, SQL, Database internals.- Good understanding of Internet and how it works- Create new features from scratch, enhance existing features and optimize existing functionality, from conception and design through testing and deployment.- Work on projects that make our network more stable, faster, and secure.- Work with our development QA and system QA teams to come up with regression tests that cover new changes to our software

ROLES AND RESPONSIBILITIES: Develop our core web application using service-oriented architecture exposing APIs for internal and external clients. Implement architecture and design patterns to help ensure that systems scale. Establish processes and best practices around development standards. Review product requirements in order to give development estimates and product feedback. Apply technical expertise to challenging architecture and design problems. SKILLS / COMPETENCIES: 4+ years experience in developing enterprise-grade web applications. Experience with software design patterns like MVC, MVVM, etc. Experience working with .NET Core, MVC, Web API and Entity Framework. Strong knowledge of Web Standards and Technologies like HTML, CSS, JavaScript and Angular is an added advantage. Experience building applications using service-oriented architecture, web services and APIs. Knowledge of SQL, database design and LINQ. Hands-on experience on Microsoft Azure is an added advantage. Experience working in an Agile environment (SCRUM certification a major plus). Proponent of continuous integration, unit testing (mandatory) and automation. Strong English communication skills, both written and spoken. Ability to work and communicate clearly and efficiently with team members.

Lead/Architect with minimum 8 years of experience on hands-on .NET development and 5 years of experience of design/develop architecture and frameworks for products using ASP.NET(MVC), .NET, C#. Design, develop, testing and troubleshooting application architecture using ASP.NET MVC, C#, JavaScript and SQL Server. Good experience in angular.js with ASP.NET MVC. Should be able to manage the team and delivery with minimal supervision. ASP.Net MVC, C#. with hands on design patterns and design principles exp. Experience in designing and developing web applications using HTML5, Angular JS, JavaScript, Bootstrap, Responsive Design. Expert and strong advocate of code refactoring techniques and writing clean code. Adoption of industry best practices and always being on the lookout. Provide architecture guidance to the team working on products with strong focus on solution architecture, architecture artifacts, performance, scaling and security. Knowledge of professional software engineering practices such as Agile and SCRUM for the full software development life cycle, including coding standards, code reviews, code repositories, TDD, unit testing, and build processes. Desired Skills Experience in eCommerce and payment gateway integration. Experience in designing & developing cross Platform applications iOS/Android/Using Xamarin etc. Experience in building web application using NodeJS. Hands on experience in build and test automation systems. Company Profile: - Advayas Tech Solutions Pvt Ltd. is a subsidiary company of renown Electrical Turnkey Project company Advayas Technology and Projects Pvt Ltd. It is widespread Pan India company involved in Govt. Power Sector and Private Industrial and Commercial Domain. Advayas Tech Solutions is company with a group of innovative and resourceful IT experts formed with the focus of delivering customized, end-to-end IT solutions. As technology providers, we enable you to store, collect, access, and use the vast and ever-growing body of digital information suited to customer requirements with the help of integrated technologies. Headquartered in Pune with offices in Bangalore, Mumbai and having business development operations in the US and Europe, Advayas Tech Solutions is that one stop IT solutions partner.