11+ SQL tuning Jobs in Pune | SQL tuning Job openings in Pune

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

Azure Chatbot Developer

Location :Bangalore / Mumbai / Pune

Job Description

Build and maintain bots on Azure platform. Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

a) 5 years of experience in software development with clear understanding of the project life cycle
b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
c) Hands on experience with Machine Learning based chat bots
d) Experience with Azure bot services like Text Analytics etc.
e)Strong database skills and hands-on experience on databases like SQL Server/Oracle

f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.

g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET

i) Knowledge of Python and NodeJS is a plus

j) Ability to design and optimize SQL Server 2008 stored procedures.

k) Experience with JQuery, CSS3, HTML5 or similar technologies.

l) Ability to adapt quickly to an existing, complex environment.

• Develop software solutions by studying information needs; conferring with users; studying systems flow, data usage and work processes; investigating problem areas; following the software development lifecycle
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Prepare and install solutions by determining and designing system specifications, standards and programming
• Improve operations by conducting systems analysis; recommending changes in policies and procedures
• Protect operations by keeping information confidential
• Provide information by collecting, analyzing, and summarizing development and service issues
• Accomplish engineering and organization mission by completing related results as needed
• First and foremost, developing software our users need
• Mentor junior and mid-level engineers
• Collaborate with team to brainstorm and create new products
• Grow engineering teams by interviewing, recruiting, and hiring
• Make informed decisions quickly and taking ownership of services and applications at scale
• Work collaboratively with others to achieve goals
• Be a persistent, creative problem ­solver
• Remain cool and effective in a crisis
• Stay on the leading edge of development practices
• Passionate about great technologies, especially open source
• Understand business needs and know how to create the tools to manage them

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

.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.

Responsibilities:

 The tool development also involves working with SQL queries and web front end

Designing, developing, and testing web applications with .Net HTML, CSS and other technologies

Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )

Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments

Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost

Maintains currency in technical skills and all relevant fixed income industry sector factors

May lead the work of others and provide ideas which help to enhance TFI software applications

Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development

ORM frameworks, particularly the Entity Framework

Must skills:

Hands- on in the following:

• Java 8/J2EE
• Spring boot
• Gradle/Maven
• REST API
• ORM- hibernate/ JPA
• Unit Testing and Integration Testing- Junit/ TestNG

Good to have:

Hands-on in the following:

• CI/CD pipeline deployment
• Messaging- ActiveMQ/RabbitMQ/MQ
• DB2
• Kafka
• NoSQL framework exposure

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable