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.

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

Responsibilities

• Determines technical feasibility of medium to low complexity features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.

• Exercises judgment in prioritizing tasks and selecting methods and techniques for obtaining solutions.

• Create a low-level design of modules of a software application through proper documentation and diagrams.

• Develops software solutions by studying requirements, clarifying customer/user needs, analyzing data and processes, and following established software development practices and processes.

• Develops proof of concepts for technical evaluation and early customer feedback.

• Updates and shares knowledge by studying state-of-the-art development tools, programming techniques, and computing technology; reading professional publications.

• Networks with internal and external personnel in their area of expertise.

Requirements

• B.Tech/B.S. or M.Tech/M.S. in Computer Science, IT or related field.

• 3-5 years of experience

Visit us on :

Mandatory Skills

• Should be proficient in the following areas of .NET (.NET 4.5 or above, .NET Core)

• Expert in C# and ASP.NET

• Knowledge of JavaScript/TypeScript is a plus

• Development of Windows and Web services

• Parallel and Asynchronous programming

• Unit testing, Linq, ORM

• Debugging/troubleshooting in .Net

• Should be proficient in SQL Server 2012 and above in the following areas

• T-SQL Stored Procedures

• Transaction in SQL

• Should have the following design skills

• Expert in OOPs

• Proficiency in Design Patterns

• Proficiency in Unit testing Patterns

• Understanding of Algorithms and Data structures.

• Experience on Requirement/Design/Code Review & Inspections

• Excellent problem-solving and analytical skills.

Desirable Skills

• Hands-on experience with using Git (handling branching and merging), any DevOps pipeline

• Experience with Agile methodologies

As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward.

Top Skills

• You write high quality, maintainable, and robust code, often in Java or C++/C/Python/ROR/C#
• You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.
• You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.

Roles & Responsibilities

• You solve problems at their root, stepping back to understand the broader context.
• You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.
• You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.
• You recognize and use design patterns to solve business problems.
• You understand how operating systems work, perform and scale.
• You continually align your work with Amazon’s business objectives and seek to deliver business value.
• You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.
• You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.
• You communicate clearly with your team and with other groups and listen effectively.

Skills & Experience

• Bachelors or Masters in Computer Science or relevant technical field.
• Experience in software development and full product life-cycle.
• Excellent programming skills in any object oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.
• Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.
• Proficiency in SQL and data modeling.

• 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.

We are looking for motivated individuals who are keen to work on Cloud or Big Data services or have worked on Cloud and Big Data. If you want to work in a start-up culture and are ready for the challenge, then join us on our exciting journey.

Responsibilities:

• Design, code and debug cloud-native applications.
• Evaluate and identify new technologies for implementation
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
• Write well designed, testable, efficient code
• Develop software verification plans and quality assurance procedures
• Serve as a subject matter expert

• 5+ years of relevant experience in software development

• Deep understanding of public cloud infrastructure (AWS, Azure or Google)

• Experience with large scale distributed systems

• Ability to troubleshoot distributed systems

• Prior experience with data encryption, TLS/SSL is a strong plus

• Experience with Docker and Kubernetes is a plus

• Deep experience with Java

• Excellent communication (writing, conversation, presentation) skills, consensus building, Quick learner
  Good to have experience in Production support - Tier 4
  
  Experience with these technologies are a plus: AWS, Microsoft Azure, Google Cloud, Cloudera, Snowflake, Mongo DB, Oracle, Databricks, Datastax, Confluent