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

Microsoft Azure Data Integration Engineer

Job Description: 

Microsoft Azure Data Integration Developer who will design and build cutting-edge user experiences for our client’s consumer-facing desktop application. The Senior Software Developer will work closely with product owners, UX designers, front-end, and back-end developers to help build the next-generation platform. 

Key Skills:

• 3+ years of experience in an enterprise or consumer software development environment using C# and designing and supporting Azure environments
• Expert level programming skills in creating MVC and Microservices architecture
• Experience with modern frameworks and design patterns like .Net core
• Strong knowledge of C# language
• Hands-on experience using the Azure administration portal and iPaaS
• Demonstrable experience deploying enterprise workloads to Azure
• Hands-on experience in Azure function apps, app service, logic apps and storage, Azure Key vault integration, and Azure Sql database.
• Solid understanding of object-oriented programming.
• Experience developing user interfaces and customizing UI controls/components

·      Microsoft Azure Certification, Business Continuity, or Disaster Recovery planning experience is a plus

Responsibilities:

• Architect, design & build a modern web application for consumers
• Explore configuring hybrid connectivity between on-premises environments and Azure, and how to monitor network performance to comply with service-level agreements.
• Collaborate with UI/UX teams to deliver high-performing and easy-to-use applications
• Participate in code reviews with staff as necessary to ensure a high-quality, performant product
• Develop a deep understanding of client goals and objectives, and articulate how your solutions address their needs
• Unit testing/test-driven development
• Integration testing
• Deploying Azure VMs (Windows Server) in a highly available environment
• Regularly reviewing existing systems and making recommendations for improvements.
• Maintenance
• Post-deployment production support and troubleshooting

Technical Expertise and Familiarity:

• Cloud Technologies: Azure, iPaaS
• Microsoft: .NET Core, ASP.NET, MVC, C#
• Frameworks/Technologies: MVC, Microservices, Web Services, REST API, Java Script, JQuery, CSS, Testing Frameworks
• IDEs: Visual Studio, VS Code
• Databases: MS SQL Server, Azure SQL
• Familiarity with Agile software development methodologies.
• Advanced knowledge of using Git source control system.
• Azure, AWS, and GCP certifications preferred.

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

• Participate in requirements analysis
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Develop documentation throughout the software development life cycle (SDLC)
• Serve as an expert on applications and provide technical support.

• Requirements

  • Proven experience as a .NET Developer or Application Developer
  • Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
  • Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
  • Familiarity with architecture styles/APIs (REST, RPC)
  • Understanding of Agile methodologies
  • Excellent troubleshooting and communication skills

Job Description: Java Full Stack Developer 

Skills 

Primary 

• Java, J2EE, Spring MVC 
• Hibernate or other ORM 
• Web technology and security, REST framework 
• Any one UI technology and ready to learn a new one. 
• Database knowledge (MySQL, Oracle, Postgres) 
• Unit testing frameworks 
• Version Control (Eg., Git) 

Good To Have 

• JQuery, XML, HTML5, AngularJS/Angular and other UI technology
• Shell Scripting 
• Python 

Key Responsibilities 

• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review
• Stay up-to-date on emerging technologies 

Requirements 

• 2 to 5 years of work experience as a Java Developer or similar role 
• BS/MS degree in Computer Science, Engineering or a related subject 
• Proven hands-on Software Development experience
• Proven working experience in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Object Oriented analysis and design using common design patterns. 
• Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management etc)
• Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Experience in developing web applications using at least one popular web framework
•  Experience with test-driven development

Job Benefits and Compensation 

• WebShar offers a very competitive salary depending on experience 
• 24 days paid vacation each year (CL, PL, SL), earned at a rate of 2 days per month. 
• MacBook Pro 
• Flexible time / and availability to work from home from time to time 
• Medical insurance 
• Team outing and lunches, 
• Reimbursement as per HR policies 

○ Internet reimbursement upto 1500 

○ Commutation reimbursement upto 6000 

○ ISD reimbursement

YOUR RESPONSIBILITIES

• Development and unit testing of web applications including back-end (microservices), maintenance & level 3 support of the same
• Assist Project Managers, Business Analysts, and Tech Lead in project planning (provide estimates, risk analysis, requirements analysis, technical options)
• Software Architecture
• Involvement in full life cycle of projects (including requirement analysis and system design, development and support if required)
• Support and work collaboratively with teams across areas of design, development, quality assurance and operations
• Commit your knowledge and experience into team success
• A small amount of travel (when needed) to work with other offices
• Attend meetings to discuss and demonstrate solutions at both technical and business level

 REQUIRED SKILLS AND EXPERIENCE                                                                                                           

• 5+ years web application development experience
• 3+ years developing with Python
• 3+ years developing with C# and .NET Framework 4.x
• Experience with ASP.NET MVC, ASP.NET WebAPI 2, LINQ, and WCF
• Dependency Injection and other common ASP.NET MVC design patterns
• Experience with API design and development using REST
• Experience with performance optimization
• Experience integrating security best practices into the SDLC
• Experience with object-oriented programming (OOP) and OOP patterns
• Experience with Git
• 1+ years of Agile development experience
• Experience manipulating and working with data in a variety of forms: csv, xml, json, structured and unstructured                                                                                                
• Experience with SQL database schema design and querying. Microsoft SQL Server and PostGreSQL are used and preferred.

DESIRABLE SKILLS AND EXPERIENCE                                           

• Knowledge of JIRA, Bamboo, Confluence, or BitBucket is a plus.
• Experience with a JavaScript MVVM library such as Web Components, knockout.js, Angular, React, etc. is a plus (Web Components and knockout.js are used and preferred)
• Experience with HTML5/CSS3/JavaScript/ and AJAX is a plus
• SPA (Single Page Application) design and implementation is a plus
• Experience with any ORM such as Entity Framework or NHibernate is a plus (NHibernate is preferred)
• Experience with TypeScript is a plus
• Experience with MS Build is a plus
• Experience with CI/CD is a plus
• Experience with Object Mapping Frameworks (AutoMapper, etc) is a plus
• Understanding of OOD, DDD and TDD is a plus
• AWS-based development is a plus
• Knowledge of Flask is a plus.

PERSONAL SKILLS

• Clever personality
• Strong spirit skills set: conflict resistant, self -motivated, result-oriented, responsible, honest, “open”, courageous

Job description:

Job Title/Designation/Position: Dotnet Developer / Sr. Dotnet Developer

Total Experience: 4-8 years

Relevant Experience: 4-8 years

Job Location: Pune/Hyderabad/Bangalore & Hyderabad

Skills/Qualifications:

Primary Skills (Must have):

• C# with good understanding of OOPS, design patterns and multi-threading
• ASP.Net MVC, WEBAPI, RESTful services, JavaScript, jQuery
• .Net Framework
• Advanced knowledge of Microsoft SQL Server
• Knowledge of Unit Testing and Automated tests (nUnit)
• Knowledge of SQL Server/Oracle database and able to write Store-Procedures
• Strong analytical and problem-solving skills

•         Good analytical skills along with Excellent written and verbal communication skills in English

• Bachelor’s Degree in Engineering /Technology / MCA

Secondary Skills (Nice to have):

• HTML5
• CSS3
• Node JS

Roles and responsibilities

• • Develop well-designed, performant and scalable microservices
  • Write reusable, testable, and efficient code that follow software development best practices
  • Integrate data storage solutions including databases, key-value stores, blob stores, etc.
  • Expose business functionality to frontend/mobile applications and partner systems through secure and scalable APIs.
  • Build integrations with 3rd party applications through apis’ to ingest and process data
  • Ensure security and data protection aspects within the applications
  • Contribute to devops by building CD/CI pipelines to automate releases
  • Ensure high performance and availability of distributed systems and applications
  • Interact directly with client project team members and operational staff to support live customer deployments and production issues.

• 4+ years of experience in developing applications using Scala and related technologies.
• Thorough understanding of multithreading concepts and async execution using Actor model.
• Thorough understanding of Play framework, GraphQL and GRPC technologies.
• Experience in using DAL and ORM (Object Relational Mapper) libraries for data access.
• Experiencing in developing and hosting APIs and integration with external applications.
• Experience in building data models and repositories using relational and NoSql databases.
• Knowledge of JIRA, Bitbucket and agile methodologies.
• Good to have knowledge of AWS services like Lambda, dynamodb, kinesis and others.
• Understanding of fundamental design principles behind a scalable application.
• Familiarity with event-driven programming and distributed architectures.
• Strong unit test and debugging skills
• Affinity for learning and applying new technologies and solving new problems
• Effective organizational skills with strong attention to detail
• Experience in working with docker is a plus
• Comfortable in working with Unix/Linux environment
• Strong communication skills — both written and verbal