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.

Job Title: Lead Java Developer

Location: Bangalore

Experience: 8-12 years (only)

Job Overview:

We are looking for a highly experienced Java / Backend Developer with a strong background in investment banking/trading/brokerages to join our team. The ideal candidate will have extensive experience in developing front office and middle office systems which require high availability, high reliability and low latency/high throughput performance profiles.

Skills & Qualifications:

• 8 to 12 years of experience in Java development, with at least 4 years in the investment banking/financial services domain.
• Strong knowledge of Java, Spring Framework, RESTful web services.
• Hands-on experience with AWS Cloud and related services. Knowledge of Kubernetes is a plus.
• Solid experience with Kafka and/or messaging protocols.
• Familiarity with SQL databases (e.g., Postgres/Oracle).
• Strong problem-solving skills and ability to work in a team.
• Ability to understand and work with distributed systems / microservices architecture.
• Solid written and verbal communication skills to interface with other technology and business stakeholders.

About this roleWe are seeking an experienced MongoDB Developer/DBA who will be

responsible for maintaining MongoDB databases while optimizing performance, security, and

the availability of MongoDB clusters. As a key member of our team, you’ll play a crucial role in

ensuring our data infrastructure runs smoothly.

You'll have the following responsibilities

 Maintain and Configure MongoDB Instances - Responsible for build, design, deploy,

maintain, and lead the MongoDB Atlas infrastructure. Keep clear documentation of the

database setup and architecture.

 Ownership of governance, defining and enforcing policies in MongoDB Atlas.Provide

consultancy in drawing the design and infrastructure (MongoDB Atlas) for use case.

 Service and Governance wrap will be in place to restrict over provisioning for server size,

number of clusters per project and scaling through MongoDB Atlas

 Gathering and documenting detailed business requirements applicable to the data

layer.Responsible for designing, configuring and managing MongoDB on Atlas.

 Design, develop, test, document, and deploy high-quality technical solutions on the

MongoDB Atlas platform based on industry best practices to solve business needs.

Resolves technical issues raised by the team and/or customer and manages escalations as

required.

 Migrate data from on-premise MongoDB and RDBMS to MongoDB AtlasCommunicate

and collaborate with other technical resources and customers in providing timely updates

on status of deliverables, shedding light on technical issues, and obtaining buy-in on

creative solutions.

 Write procedures for backup and disaster recovery.

You'll have the following skills & experience

 Excellent analytical, diagnostic skills, and problem-solving skills

 Should understand the Database concept and develop expertise in designing and

developing NoSQL databases such as MongoDB

 MongoDB query operation, import and export operation in database

 Experience in ETL methodology for performing Data Migration, Extraction,

Transformation, Data Profiling and Loading

 Migrating database by ETL, migrating database by manual process and designing,

development, implementation

 General networking skills, especially in the context of a public cloud (e.g. AWS – VPC,

subnets, routing tables, nat / internet gateways, dns, security groups)

 Experience using Terraform as an IaC tool for setting up infrastructure on AWS

CloudPerforming database backups and recovery

 Competence in at least one of the following languages (in no particular order): Java, C++,

C#, Python, Node.js (JavaScript), Ruby, Perl, Scala, Go

 Excellent communication skills, often being able to compromise but draw out risks and

constraints associated with solutions. Be able to work independently and collaborate with

other teams

 Proficiency in configuring schema and MongoDB data modeling.

 Strong understanding of SQL and NoSQL databases.

 Comfortable with MongoDB syntax.

 Experience with database security management.

 Performance Optimization - Ensure databases achieve maximum performance and

availability. Design effective indexing strategies.

Job description

Tech Stack: C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Confluence

Senior (Lead) .NET Developer Responsibilities: -

Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning, and Requirement’s 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 advantages and disadvantages of alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Job Type: Full-time

NET Profile 

DESIRED SKILLS

·         Experience in Microsoft technologies (Microsoft Dot Net, C#, http://asp.net/" target="_blank">ASP.NET, MVC, Microsoft SQL, .NET Core, Web API, WCF, Bootstrap, JavaScript, Angular JS, Web API, Web services, Rest API)

·         Design a complex architecture landscape involving API integrations.

·         Hands-on experience in ASP.Net, C#, MVC, WCF, Restful services, Web API, AngularJS, Entity Framework

·         Strong analytical & problem-solving skills

·         Must have excellent oral & email communication skills.

·         Strong analytical and problem-solving skills

·         Must have a positive attitude and a yearning to get things done and demonstrate ownership of deliverables.

NICE TO HAVE SKILLS

·         Knowledge in Microsoft Azure.

·         Good Command on Agile Development & Azure DevOps.

·         Knowledge in Angular / React / Node JS

·       Mainly they are looking for:

C#

http://asp.net/" target="_blank">ASP.NET MVC,

AJAX,

LINQ,

jQuery,

WebApi.