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

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

1. 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
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C# / VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

Job Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

Our client is a rapid growth stage Edtech start-up focused on solving the teacher shortage crisis in the US education system using technology by bringing teachers to the classrooms and giving them access to the right tools to teach students in a highly engaging manner.

They have a development center in Mumbai and they are looking to scale up the teams in Pune and Bangalore as well.

What does the role entail:

● Design, develop, and maintain software applications using .NET Core ,C#

● Write clean, maintainable, and efficient code

● Collaborate with cross-functional teams to analyze requirements, design solutions, and implement new features

● Develop and implement unit tests and integration tests to ensure software quality

● Troubleshoot and debug applications

● Participate in code reviews and provide constructive feedback to peers

Required Skills:

● B.E/B.Tech in computer science

● 1 - 3 years of experience

● Hands-on experience following skills

MS Technologies: NET CORE 7+, C#

Backend: MSSQL / MySQL /Postgres

● Preferred understanding of Cloud: Azure/AWS.

● Strong understanding of object-oriented programming, Design principles, data structures, and algorithms

● Worked in an Agile software development environment

Hi,

We are hiring for the position of Java Tech Lead. Please find below the details for the same.

A passionate developer who has a strong working knowledge of OOPS and functional programming

principles. Standard Definitions and abbreviations don't entice us that much.

Key skills:

• Strong Java and J2EE background with 5-7 years of experience.

• Strong working experience in Multi-Threading, Exception Management and the Use of Collections.

• Sound knowledge of working with application aspects i.e., Caching, Asynchronous APIs, Logging etc.

• Experience with web application frameworks like Spring Boot or Dropwizard.

• Unit Testing is an everyday affair and hence demands very good unit testing skills using tools like Junit & TestNG.

• Understanding of relational databases, RESTful services, and build tools like Maven & Gradle

• Knows what and when to mock and has used frameworks like Mockito/Power Mock.

• Understanding of message queues such as ActiveMQ, Kafka, and RabbitMQ.

•  Version Control is treated as important as programming skills. Fluent with version control tools like Git and Bitbucket.

• Exposure to Agile/Scrum, TDD not in theory but in practice.

•  Experience with Continuous Integration, Continuous Deployment, Static Code Analysis, Jenkins and SonarQube.

•  Willingness to take ownership of the technical solution and ensure technical expectations of deliverables are met.

• Strong communication skills along with the ability to articulate technical designs and concepts.

• Exposure to cloud and containerization would be a plus.

• Hands-on experience in application development in an enterprise setup.

• Have a good understanding of Distributed Application Architecture.

Senior Dotnet Developer

About the Company:

TransformHub is a An ISO 27001 certified Company adhering to a Gold standard in Information Security. It is multi-award-winning Global Digital Solutions company providing a full suite of digital transformation & product engineering services to enterprises, product companies & new-age start-ups. We have our presence in Singapore, USA, Canada, Middle East, UK and India. Our mission is to become a preferred partner to enterprises for growth and innovation in the digital age. TransformHub combines Strategy, Experience, and Technology at every stage of the engagement model to build human-centered digital platforms & channels. Our expertise lies around the 6 building blocks for Digitization - Product Engineering, Mobility, Enterprise Integrations, Data & Analytics, Cloud & DevOps, Intelligent Automation. With a large and ever-growing team of digitally ready consultants, the company helps its clients to grow and stay ahead of their competition. TransformHub has been featured into leading magazines like IndustryWired and CIOReview as Top 10 Digital Transformation Providers.

Responsibilities 

• Develop new applications or make enhancements to existing applications. 
• Analyze user requests and assist with design activities. 
• Collaborate with Client and translate business requirements into well-designed technical solutions. 
• Develop components based on business and/or application requirements. 
• Manage and assist with the completion of specific projects. This includes the development of web applications and web services. 
• Support applications and provide upgrades and maintenance as needed. 
• Assist software personnel in handling project related work and other requirements 
• Create and maintain documentation for application coding and project development. 
   

   Requirements  

• Familiarity with the .NET framework, C#, SQL Server database and design/architectural patterns 
• 5+ years of experience in .NET Technology Stack 
• Experience in designing databases with Microsoft SQL Server and building Web APIs 
• Excellent troubleshooting and communication skills 
• Experience working in an Agile environment (e.g. Scrum, Kanban) required. 
• Good knowledge of modern software design principles, concepts, and practices. 

WhiteSnow Software Consultancy Pvt Ltd, Pune

Job Description Document

Joining: Jan 2021

Designation: .Net Developer

Job Brief: We are looking for a Windows Applications Developer who possesses a passion for pushing mobile technologies to the limits. Who will design and code functional programs and applications.

Roles and Responsibility:

• Programmer to develop stand-alone Windows application
• Focus on development of software life cycle.
• Bug fixing and improving application performance
• Design and build advanced applications for the Windows platform
• Collaborate with cross-functional teams to define, design, and ship new features
• Coordinate efforts with other developers, plan high level architecture for solutions, code software to spec, track and resolve software defects.
• Understanding client requirements and how they translate to new application features
• Collaborating with development team and other IT staff to set specifications for new applications
• Write high quality source code to program complete applications within deadlines
• Perform unit and integration testing before launch
• Conduct functional and non-functional testing
• Troubleshoot and debug applications
• Evaluate existing applications to reprogram, update and add new features
• Develop technical documents and handbooks to accurately represent application design and code
• In-depth knowledge in basic frameworks to create user interfaces faster and easier.

Requirements:

• Proven experience of 1 to 5 years as windows application developer
• C#, .NET Core, .NET Web API, JSON, XML. Knowledge of WMI classes
• Should be expertise in Windows Phone and Windows 8/8.1 development.
• In-depth knowledge of programming for diverse operating systems and platforms using development tools
• Have published at least one original Windows app
• Excellent understanding of software design and programming principles.
• A https://resources.workable.com/team-player-interview-questions">team player with excellent communication skills
• Analytical thinking and problem-solving capability
• Great attention to detail and time-management skills
• BSc/BA/BE/Btech. in computer science or relevant field; MSc/MA will be appreciated
• Certified application developer is a plus

Key Skills: C#, .Net core, Web API, Angular (Added advantage)

Job Description Form:

• Name of company: WhiteSnow Software Consultancy Pvt Ltd
• Website of the Company: https://whitesnow.com/">https://whitesnow.com
• Address of the Company: 3rd & 4th Floor, Serene Tower, Pakharbaug Society, Bavdhan, Pune, Maharashtra 411021.

       Landmark: lane between Wadapav cafe and Krushna sweets

• Name of the Talent Acquisition Head : Dhanashri Lokhande
• Nature of Job: Full time
• Location/s of Work: Bavdhan, Pune
• Branches considered: Electronics and Telecommunication, Electronics, Computer, Information Technology, BCA, MCA
• Eligibility Criteria:  No criteria [Live ATKT Considered : No]
• Salary Offer p.a.: 3.00L p.a to 5.00L p.a
• Bond: No
• Selection Process:-

Interview process:   1. Brain test.

1. Technical interview

Skill Requirements:

• At least 3 to 9 years experience of using .NET development
• Experience in using ASP.NET or .Net Core for developing Windows, Web applications
• A good understanding of WPF, WCF, XAML, MVVM, MVC, Design Patterns
• A good understanding of T-SQL, MS SQL
• A solid understanding of OOP principles
• A good understanding of N-tier and N-layered architecture
• Strong analytical skills
• Attention to detail
• Experience in working effectively as part of a team
• Good written and verbal communication skills
• Inter-personal skills
• A flexible approach and ability to adapt
• Ability to work under own initiative