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.

Requirements

• Extensive and expert programming experience in at least one general programming language (e. g. Java, C, C++) & tech stack to write maintainable, scalable, unit-tested code.
• Experience with multi-threading and concurrency programming.
• Extensive experience in object-oriented design skills, knowledge of design patterns, and a huge passion and ability to design intuitive modules and class-level interfaces.
• Excellent coding skills - should be able to convert the design into code fluently.
• Knowledge of Test Driven Development. Good understanding of databases (e. g. MySQL) and NoSQL (e. g. HBase, Elasticsearch, Aerospike etc).
• Strong desire to solve complex and interesting real-world problems.
• Experience with full life cycle development in any programming language on a Linux platform. Go-getter attitude that reflects in energy and intent behind assigned tasks.
• Worked in a startup-like environment with high levels of ownership and commitment.
• BTech, MTech or Ph. D. in Computer Science or related technical discipline (or equivalent).
• Experience in building highly scalable business applications, which involve implementing large complex business flows and dealing with huge amounts of data.
• 3+ years of experience in the art of writing code and solving problems on a large scale.
• An open communicator who shares thoughts and opinions frequently listens intently and takes constructive feedback

•  Development using .net core
•  Requirement understanding and getting on client calls
•  Work closely with the nearshore developer
•  Perform code reviews and unit testing as planned
•  Participate in peer reviews.

•  Strong knowledge on C#, .net core 5 and Entity Framework
•  Knowledge on PostgreSQL
•  Web API, building Microsoft .NET-based web or Enterprise applications
•  Experience in building and consuming Asp.NET MVC & Web API or REST API  using 
• jQuery, JSON, AJAX, Asp.net Web Services.

•  Knowledge on Docker and Kubernetes
•  Knowledge on AutoMapper

Job Role: We are seeking a skilled Java Developer to contribute to the development and enhancement renowned banking application, which supports automatic reconciliation and unified data reporting for their clients. This role involves working on high-impact enhancements, data pipeline integration, and platform modernization. The ideal candidate will be a quick learner, self-motivated, and able to ramp up quickly in a fast-paced environment. 

Key Responsibilities:

 Design, develop, and maintain Java-based applications using Java 17 and Spring Boot.

 Implement and manage message routing using Apache Camel.

 Develop and monitor data pipelines using Kafka.

 Support and enhance existing cloud-native applications.

 Work with OpenShift Container Platform (OCP 4) for container orchestration and deployments.

 Utilize Jenkins for CI/CD pipeline automation and management.

 Collaborate with cross-functional teams to integrate multiple data sources into a unified reporting platform.

 Participate in code reviews, unit testing, and performance tuning.

 Troubleshoot and resolve production issues in collaboration with operations teams.

 Document development processes and system configurations.

Required Skills:

 Strong proficiency in Java 17 and Spring Boot frameworks.

 Hands-on experience with Apache Camel for message routing and transformation.

 Solid experience in Kafka development and monitoring tools.

 Good understanding of cloud pipeline architectures and deployment strategies.

 Experience working with OpenShift (OCP 4).

 Familiarity with Jenkins for CI/CD and automated deployments.

 Understanding of cloud deployment platforms (AWS, Azure, or GCP preferred).

 Strong analytical and debugging skills.

 Ability to learn quickly and adapt to evolving project requirements.

Nice to Have:

 Experience in financial services or transaction reporting platforms.

 Familiarity with microservices architecture and containerization best practices.

 Knowledge of monitoring tools (e.g., Prometheus, Grafana).

• 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

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