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 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 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. - 1 to 3 years.

Wissen Technology is hiring Java + Scala Developers with 1–3 years of experience. We are looking for candidates with strong hands-on skills in Java and Scala, good analytical abilities, and the capability to work in a dynamic environment.

Key Requirements:

• Experience in Java and Scala
• Strong understanding of core programming concepts
• Good problem-solving and debugging skills
• Must be available for immediate joining
• Should be open to face-to-face interviews in Bangalore or Mumbai

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 hassuccessfully 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.

Must Have Skills:

1.      Experience with the .NET framework and .NET Core technologies: C#

2.      Writing and consuming REST API/Web API in .Net framework, .Net Core

3.      Must have excellent knowledge in Azure hosting services

4.      Good knowledge of Trouble shooting, Azure Hosting, maintaining and performance tuning

5.      Knowledge of Frontend framework (React), If not then Angular, or Vuejs etc

6.      Excellent Aptitude, Attitude and Communication Skills

7.      Strong understanding of OOPS Concepts

8.      Strong knowledge of Unit Testing

9.      Excellent knowledge and working experience in Microservice Architecture

10.  RDBMS Concepts, MS-SQL Server

11.  Writing & Optimizing SQL Queries for best performance

12.  Able to manage release by mean of CI/CD pipeline to deploy applications in Azure

13.  Well versed of code review and code scanning tools

Good to have Skills:

1.      Knowledge of HTML, Bootstrap, CSS, Responsive Design

2.      Entity Framework/LINQ, MVC

3.      Strong understanding of current design patterns & best practices

4.      Knowledge of Agile methodology and JIRA

5.      Knowledge of Electron is a plus

Key Responsibilities:

1.      Work with Scrum Team to prioritize tasks and ensure deadlines are met

2.      Communicate and actively participate in client call and understand requirements

3.      Convert design and architecture to code using best practices

4.      Provide expert level knowledge and guidance on modern software engineering techniques and methodologies for code reviews

5.      Demonstrate expertise in a variety of software concepts (object-oriented design), practices (design patterns), and procedures (troubleshooting defects)

6.   Able to troubleshoot and debug the code, write code with best coding practice and perform unit & Integration testing

7.      Collaborate with the technical team to build and migrate applications in Azure

8.      Test and update application so that it can be used for cross web browsers

9.      Use and set-up CI/CD pipeline

• Core Java 5.0 and above
• Extensive experience in developing enterprise-scale n-tier applications for the financial domain.
• 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 client-facing applications.
• Good development experience with RDBMS, preferably Sybase database
• Good knowledge of multi-threading and high volume server side development
• Experience in sales and trading platforms in investment banking/capital markets
• Basic working knowledge of Unix/Linux.
• Strong written and oral communication skills.
• Should have the ability to express their design ideas and thoughts.

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.

Position: Sybase Developer

Location: Bangalore /Pune

Exp.Level: 8+ Yrs

Proven experience as a. Sybase Developer

Familiarity with Oracle, Sybase, Performance tuning and Optimization

Required Skills: Sybase, Performance tuning and Optimization

• Determine the appropriate approach for new software assignments
• Provide solutions to overcome complex problems using the latest technologies
• Developing high-quality and detailed designs, Identify, prioritize and execute tasks in the software development life cycle
• Proactively communicate with the client to get things done within the deadline.
• Develop tools and applications by producing clean, efficient code.
• Automate tasks through appropriate tools and scripting
• Provide high-level maintenance and update of an existing applications to improve functionality and process flow
• Oversee the maintenance of technical documentation of applications as architecture, code, and procedures

• 3+ Experience with RPA software (UiPath) (ONLY/MANDATORY)
• Experience in programming .NET (C# or VB), Java + Node.JS-based programming
• UiPath RPA Implementations and Working Knowledge: Studio, BOTs, Orchestrators, RE Framework and Three E2E Implementations as a Core RPA Developer.
• Skill with scripting languages such as VBA/VBS, Python, NodeJS and JavaScript
• Proficiency with Microsoft Power Platform, SQL and NoSQL database experiences
• Orchestrator configuration and component usage knowledge
• hands on experience of orchestrator queue and load distribution
• Proficiency with JIRA, Jenkins, Github, Artifactory and CI/CD development
• Excellent analytical and problem-solving skills, including business process expertise
• Experience developing design documents for automation processes

Job description:

Passion for building and delivering great software with a strong sense of ownership.

• Minimum of two years of experience in building web applications using ASP.NET MVC and .NET platform in general.
• Should have strong UI development skills using HTML, CSS/JavaScript frameworks.-

     Good understanding of IIS configuration

• Strong experience with Build and Release, Agile processes and Estimation/Planning-
  
  Exposure to New Relic or similar tools to optimize web application performance
  Strong expertise in SQL programming, with experience of writing & optimizing queries that access/process millions of records-
  Experience of architecting and designing web applications and servicesTeam TA,LeadSquared (ref:hirist.com)