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.

Minimum 7-12 Years of Core Java Programming with Collections Framework, Concurrent Programming, Multi-threading (Good knowledge in Executor service, Forkjoin pool and other threading concepts)

·        Good knowledge of the JVM with an understanding of performance and memory optimization.

·        Extensive and expert programming experience in JAVA programming language (strong OO skills preferred).

·        Excellent knowledge on collections like, Array List, Vector, LinkedList, Hashmap, HashTable, HashSet is mandate.

·        Exercised exemplary development practices including design specification, coding standards, unit testing, and code-reviews.

·        Expert level understanding of Object Oriented Concepts and Data Structures

·        Good experience in Database (Sybase, Oracle or SQL Server) like indexing (clustered, non clustered), hashing, segmenting, data types like clob / blob, views (materialized), replication, constraints,            functions, triggers, procedures etc.

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

● Participate in code reviews and provide constructive feedback to peers

● Lead requirements/tasks and guide/mentor junior software engineers in the development process and help them grow their technical skills

Required Skills:

● B.E/B.Tech in computer science

● 4 - 7 years of experience

● Hands-on experience following skills

MS Technologies: NET CORE 5+, C#

Backend : MSSQL/MySQL/Postgres 

● Good understanding of Cloud technologies like Azure/AWS.

● Strong understanding of Design Principles, Design patterns and Microservices Architecture.

● Excellent problem-solving, critical thinking, and communication skills

● Must understand full stack development frameworks including knowledge of building scalable APIs, interfaces, software components, schema design, availability, and latency preferably in a cloud environment.

● Worked in fast-paced environment product startup/startup-like culture in an Agile software development environment

Job Description:

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

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

Greetings from Techspian Services Pvt Ltd.

Position: Software Developer
Experience: 3-6 yrs

Notice Period: Less than 30 days

Requirement:

• Minimum 3-6 Years of Experience in .Net Technology
• Technical expertise Must in such as. NET Framework, C#, VB. Net, MVC

• Understanding of SQL Server, Web Services, Entity Framework, Web API, RESTful services
• Excellent analytical and problem-solving skills
• Excellent Written and Communication skills
• Ability to work and prioritize multiple projects.
• Home office that provides the right ambiance to focus on work

Perks and Benefits
Health Insurance | Work Flexibility | Work From Home | Internet Reimbursement

Job Title: Odoo Developer
Job Type: Full Time
Job Location: India- Bangalore/Pune
Reporting To: Manager ERP Solutions/Director Cloud Engineering
Work Hours: 9 hours (Indian Shift)

Main Duties and Responsibilities:

The candidate will be responsible for interacting with internal and external customers, gather requirements, map it to the system design solution if required, discuss it with Functional consultant and deploy/implement it and post implementation support.

Qualifications:

BSc Computer Science, Electronics, MSc/MCA, PGDCA or any equivalent degree

Experience – 1- 3 Years

Skills:

Functional Skills:

• Good understanding of ERP Process and system
• Candidates should have hands-on experience in implementing Odoo Sh preferably, Odoo Online, Enterprise, Odoo Community Edition or experience in implementing any other ERP Software.
• Good Knowledge on the following: Purchase Process (Procure 2 Pay), Sales Process(Order 2 Cash), CRM , Accounting, Manufacturing

Technical Skills:

• Must knowledge on core Python programming concepts, Django framework, JavaScripts
• Good knowledge on SQL, PostgreSQL
• Good knowledge on ORM methods, Xml, Jquery/JS
• Good to have knowledge on Odoo Framework, Installing Odoo, Customize modules, create modules.

Personal Qualities and Behavior traits:

1- Be a good team worker demonstrating loyalty and commitment to the organization and team members.

  
2- Good organizational skills and excellent attention to details Interact with individuals to provide needed information

• Good written and verbal communication skills.
• Aptitude for learning new concepts, technologies and understanding them to utilize in a customer facing/service environment.
• Should be able to work in a team environment and independently.
  
  Performance Goals
  1- Able to handle multiple assignments simultaneously.
  2- Ensures timely response to client and internal peers.

• Bachelor’s Degree in Computer Science or equivalent.
• 2+ years of industry experience in programming web applications, mobile and/or large-scale enterprise products.
• Knowledge of C#, ASP, .NET, MVC.
• Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS.
• Hands-on experience with SQL and relational databases.
• Experience in TFS and Visual Studio.
• Familiar with SDLC and programming design patterns.
• Familiar with Agile methodology.
• Skillful at reviewing new feature impacts on an application and recognizing potential risks.
• Detailed oriented, professional and possesses a positive work attitude.
• Communicate professionally both verbally and in writing.
• Effective time management skills.