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 6+ years of experience building global enterprise level systems Extensive experience developing complex distributed event-based microservices using C#/.Net Core Knowledge with containerisation (Docker, Kubernetes) Experience with cloud platforms (Azure, AWS) Exposure with distributed messaging / streaming platforms (Apache Kafka) Involvement building CI/CD pipelines (ideally Azure DevOps) Excellent knowledge of Relational Databases SQL and No-SQL databases

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 12 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 client facing 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. 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. 

• 5 + years of hands-on experience in .NET, Angular and related Web technologies.

• 2 - 3+ years of experience designing and supporting Azure environments, including IaaS and PaaS

• Past experience in cloud computing and technology systems, as well as experience in designing and transferring applications to the cloud.

• Proven experience in Continuous Integration (CI) and Continuous Delivery (CD) as well as DevOps principles to achieve SDLC goals of Global Banking Technology

• Hands on experience using the Azure/AWS administration portal.

• Knowledge of at least one other cloud hosting solution (e.g., Azure, Google, AWS, Helion Cloud).

• Good hands-on experience in SOA, XML, WSDL, XSD, WSDL XML schema and namespaces (J2EE and .NET), MS .NET Framework, C#, HTML, Javascript, Micro Services/ APIs, Messaging, Threading, IBM DB.

• Have experience on development of container applications.

• Good knowledge of IBM DB. Should be comfortable writing stored procedures and user defined functions.

• Strong business knowledge of wealth management industry.

• Component / business object modeling, services modeling.

• Experience in building high concurrency, low latency 247 availability applications.

• Strong programming skills with emphasis on writing efficient algorithms to handle large data sets and processing.

• Understanding of HTTP, IIS and how the browser works.

• Ability to coordinate with various teams to deliver projects successfully.

• Knowledge of UML design.

• Knowledge of source control (preferably Git) and continuous Integration tools.

• Have working Knowledge of DevOps and best practices. Understanding of Major DevOps Tools and implementation for Source Control, Continuous Integration, Configuration Management, Deployment Automation, containers & Orchestration

• Experience in working in Agile framework.

• Good written and verbal communication skills.

Skills Desired:

• Financial markets, payment solutions or Wealth Management previous experience

Educational Qualification:

• Bachelor’s degree in Engineering preferred from an accredited college/university

Responsibilities: 

• Ensure the quality of architecture and design of systems. 
• Functionally decompose complex problems into simple, straight-forward solutions. 
• Analyze and improve data quality and metrics. 
• Fully and completely understand system interdependencies and limitations. 
• Leverage knowledge of internal and industry in design decisions. 
• Assist in the career development of others, mentoring on advanced technical issues and helping managers guide the career growth of their team members. 
• Exert technical influence over multiple teams, increasing their productivity and effectiveness by sharing your deep knowledge and experience. 
• Skilled in translating high level abstract business requirements into software design, designing systems specifications, standards, and programming 
• Contribute to Architectural blueprints and Design for the software solutions 
• Mentor team on engineering best practices such as writing clean code, designing scalable, reliable and performant software solutions, set and ensure compliance to software quality standards etc. 
• Be a role model for the team with innovative thinking, passion for continuous learning and contributions to the project. 

Qualifications, Skills & Experiences 

• BE / B.Tech /M.Tech in Computer Science or a related field 
• Minimum 7+/5+ years of experience building large scalable systems 
• Minimum 2+ years of recent experience in building products on cloud is a plus 
• Knowledge of asynchronous programming and WebAPI development is required 
• Knowledge and awareness of cloud/ application security is must (OWASP at the minimum) 
• Strong knowledge in OOPS with C#, .Net(or Java) with SQL Server or any RDBMS 
• Strong experience in architecting and building multi-threaded, distributed systems. 
• Strong knowledge of data structures, algorithms, and designing for performance. 
• Ability to achieve stretch goals in a highly innovative and fast paced environment. 
• Extensive experience of mentoring junior engineers to success. 
• Experience with Microservices Architecture is a plus 
• Working knowledge of CI/CD pipelines and AWS/Azure cloud services is plus 
• Hands on experience of building products for unix systems in addition to windows is a plus 
• Excellent Communication