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.

Job Description:

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

• Bachelor’s Degree in Computer Science or equivalent
• 8-12 years’ of industry experience in programming web applications, mobile and/or large scale enterprise products
• Deep knowledge of C#, ASP, .NET, MVC, .Net core
• Deep knowledge and extensive experience working on Ruby or React and JavaScript, as required
• Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS
• Extended experience with SQL, relational and non-relational databases
• Experience in TFS and Visual Studio
• Hands on experience with SDLC and programming design patterns
• Experience with Agile methodology
• Skillful at reviewing new feature impact on an application and recognizing potential risks
• Uses time effectively and efficiently
• Quickly learns new technologies
• Detailed oriented, professional and possesses a positive work attitude
• Communicate professionally both verbally and in writing
• Effective time management skills
• Knowledge on UI technologies will be plus

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• Develops 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.
• Conducts systems analysis and makes recommendations to improve the system to achieve an outcome.
• Promotes internal best practices and coding conventions to write and execute tests for your own code, including creating comprehensive unit tests.
• Contributes to Technical Requirements Documents.
• Requests constructive feedback for designs early in the process.
• Communicates successfully with large teams and many stakeholders.
• Provides mentorship for Software Engineers and participates in interview panels to hire new Software Engineers.
• Assists in removing obstacles for the team to yield successful sprints.
• Performs peer code reviews to ensure quality of the codebase.
• Ability to decompose and delegate work to junior engineers.
• Updates job knowledge by studying state-of-the-art development tools, programming techniques and computing equipment; participating in educational opportunities, reading professional publications, maintaining personal networks, participating in professional organizations.
• Works effectively with multiple projects and features.
• All other duties as assigned.

Greetings from Amazon...!                                       

It is our pleasure in personally inviting you to apply job with Amazon Development Centre India (ADCI). At Amazon we are inclined to hire people with passion for technology and you happened to be one of the shortlisted candidates. Our business is committed to recognizing potential and creating teams that embrace innovation.

Please find the Eligible criteria and requirements:

Job title                             :             SDE – II (Software Development Engineer)
Role Opportunity            :             Permanent/Full Time/FTE/Regular

Work Location                 :             Hyderabad/Bangalore/ Gurgaon

Must Have

• Strong Exposure to Data Structures, Algorithms, Coding, System Design (LLD, HLD, OOAD), Distributed systems, problem solving skills, Architecture (MVC/Microservices), logical thinking.

Amazon (ADCI) - If you are looking for an opportunity to solve deep technical problems and build innovative solutions in a fast paced environment working with smart, passionate software developers, this might be the role for you. Amazon’s transportation systems get millions of packages to customers worldwide faster and cheaper while providing world class customer experience – from checkout to shipment tracking to delivery. Our software systems include services that handle thousands or requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers worldwide, manage business rules for millions of unique products, and improve experience for millions of online shoppers. With rapid expansion into new geographies, innovations in supply chain, delivery models and customer experience, increasingly complex transportation network, ever expanding selection of products and growing number of shipments worldwide, we have an opportunity to build software that scales the business, leads the industry through innovation and delights millions of customers worldwide.

As an SDE, you will develop a deep understanding of our business, work closely with development teams and own the architecture and end-to-end delivery of software components.

About Amazon India:

Amazon teams in India work on complex business challenges to innovate and create efficient solutions that enable various Amazon businesses, including Amazon websites across the world as well as support Payments, Transportation, and Digital products and services like the Kindle family of tablets, e-readers and the store. We are proud to have some of the finest talent and strong leaders with proven experience working to make Amazon the Earth’s most customer-centric company.

We made our foray into the Indian market with the launch of Junglee.com, enabling retailers in India to advertise their products to millions of Indian shoppers and drive targeted traffic to their stores. In June 2013, we launched http://www.amazon.in">www.amazon.in for shoppers in India. With http://www.amazon.in">www.amazon.in, we endeavor to give customers more of what they want – low prices, vast selection, fast and reliable delivery, and a trusted and convenient online shopping experience. In just over a year of launching our India operations, we have expanded our offering to over 18 million products across 36 departments and 100s of categories! Our philosophy of working backwards from the customers is what drives our growth and success.

We will continue to strive to become a trusted and meaningful sales and logistics channel for retailers of all sizes across India and a fast, reliable and convenient online shopping destination for consumers. For us, it is always “Day 1” and we are committed to aggressively invest over the long-term and relentlessly focus on raising the bar for customer experience in India. Amazon India offers opportunities where you can dive right in, work with smart people on challenging problems and make an impact that contributes to the lives of millions. Join us so you can - Work Hard, Have Fun and Make History.

Basic Qualifications:

• 3+ years’ experience building successful production software systems
• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field)
• The ability to take convert raw requirements into good design while exploring technical feasibility tradeoffs
• Expertise in System design (design patterns, LLD, HLD, Solid principle, OOAD, Distributed systems etc..), Architecture (MVC/Micro services).
• Good understanding of at least some of the modern programming languages (Java) and open-source technologies (C++, Python, Scala, C#, PHP, Ruby etc..)
• Excellence in technical communication
• Has experience in mentoring other software developers

Preferred Qualifications:

• BS/MS in Computer Science or equivalent
• Experience developing service oriented architectures and an understanding of design for scalability, performance and reliability
• Demonstrated ability to mentor other software developers to maintain architectural vision and software quality
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment
• Expertise in delivering high-quality, innovative application
• Strong desire to build, sense of ownership, urgency, and drive
• Strong organizational and problem solving skills with great attention to detail
• Ability to triage issues, react well to changes, work with teams and ability to multi-task on multiple products and projects.
• Experience building highly scalable, high availability services
• The ideal candidate will be a visionary leader, builder and operator.
• He/she should have experience leading or contributing to multiple simultaneous product development efforts and initiatives.
• He/she needs to balance technical leadership with strong business judgment to make the right decisions about technology choices.
• He/she needs to be constantly striving for simplicity, and at the same time demonstrate significant creativity, innovation and judgment
• Proficiency in, at least, one modern programming language.
• Experience in SQL or Non-SQL database.
• Strong sense of ownership, urgency, and drive.
• Demonstrated leadership abilities in an engineering environment in driving operational excellence and best practices.
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
• Excellent communication, collaboration, reporting, analytical and problem solving skills.

Good to Have:

• Knowledge of professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Experience with enterprise-wide systems
• Experience influencing software engineers best practices within your team
• Hands-on expertise in many disparate technologies, typically ranging from front-end user interfaces through to back-end systems and all points in between
• Strong written and verbal communication skills preferred

Key Points to remember:

• Strong knowledge of the Software Development Life Cycle methodology
• Technical design, development and implementation decisions on the use of technology in area(s) of specialization.
• Write or modify programming code to suit customer's needs.
• Unit test to assure meets requirements, including integration test as needed.
• Ability to understand and analyze issues and uses judgment to make decisions.
• Strong problem solving & troubleshooting skills
• Strong communication skills
• Responsible for self-development according to professional development plan

• 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