11+ SQL tuning Jobs in Ahmedabad | SQL tuning Job openings in Ahmedabad

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

1. Azure Integration Developer (Azure Functions, Azure LogicApp, Azure APIM)
   
   

Job Responsibilities:

• Technically sound in Dot Net technology. Good working knowledge & experience in Web API and SQL Server
• Should be able to carry out requirement analysis, design, coding unit testing and support to fix defects reported during QA, UAT phases and at GO Live times.
• Able to work alone or as part of a team with minimal or no supervision from Delivery leads.
• Good experience required in Azure stack of integration technology-Logic app, Azure Function, APIM and Application insights.

Must have skill

• Strong Web API development using ASP.Net Core, Logic app, azure functions, APIM

• Azure Functions
• Azure Logic App
• Azure APIM
• Azure ServiceBus

Desirable Skills

• Azure Event Grid/Hub
• Azure KeyVault
• Azure SQL – Knowledge on SQL query

Job Responsibilities: 

• Technically sound in Dot Net technology. Good working knowledge & experience in Web API and SQL Server
• Should be able to carry out requirement analysis, design, coding unit testing and support to fix defects reported during QA, UAT phases and at GO Live times.
• Able to work alone or as part of a team with minimal or no supervision from Delivery leads.
• Good experience required in Azure stack of integration technology-Logic app, Azure Function, APIM and Application insights.

Must have skill 

• Strong Web API development using ASP.Net Core, Logic app, azure functions, APIM
• Azure Functions
• Azure Logic App
• Azure APIM
• Azure ServiceBus

Desirable Skills 

• Azure Event Grid/Hub
• Azure KeyVault
• Azure SQL – Knowledge on SQL query

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

• Write clean, scalable code using .NET programming languages
• Develop technical interfaces, specifications, and architecture
• Develop client displays and user interfaces
• Assist software personnel in handling project-related work and other requirements
• Coordinate with other software professionals and developers
• Familiarity with the.NET framework (Like DotNet Core, MVC), SQL Server, and design/architectural patterns.
• 2+ years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, .NET) and HTML5/CSS3
• Excellent troubleshooting and communication skills

• Creating C#.NET windows Desktop (WPF) applications to meet project specifications
• Must have experience in windows UI
• Co-ordinating design, development, testing, debugging and implementation of .NET projects
• Database Interaction (MongoDB Server)
• Looking for professional who have experience with C#
• .Net, web Api & knowledge of web-based framework will be preferred.
• Good understanding on requirements gathering and detail orientation.
• Strong understanding on UI best practice and usability concepts.
• Hands on experience on user control and custom controls.

Mandatory Key Skills: C# , windows UI, Windows application development (WPF), strong windows UI development skills with usability understanding.

Required Experience, Skills and Qualifications

• 1+ years of experience using C#, windows UI
• Experience with Custom Windows UI component library will be preferred.
• Candidate with knowledge of, web-based framework will be preferred (plus point)
• Implementation of typical User-Interface module and business logic component in the project using C#
• Good communication skills are needed.

Keypoints to be noted:

Must have knowledge/experience of below:

C#

• Background worker and task(for running any process/task backend without interruoting/hanging UI)
• Utilize common/globalmethods
• Async/sync methods

WPF

• Create custom/user control(MUST)

• Familiarity with the http://asp.net/">ASP.NET framework, SQL Server and design.
• Hands on experience using C# .NET, MVC, Oops Concept, Jquery, Bootstrap.
• Knowledge of  .NET languages 
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Angular will be an advantage
• Able to work well in a team setting

Roles and Responsibilities

• Talented software developers to deliver high-quality web-based business applications
• Get a solid understanding of both the functional and technical specifications of the module \ task of the current assignment and have full consent before starting the development.
• Follow proper coding standards, application architecture guidelines and procedural guidelines as explained by the respective team lead.
• Maintain the time sheet on a daily basis clearly filling the actual effort against the estimated effort. And any unplanned activities, scope creeps, unaccomplished tasks or additional guidance requirements should be immediate brought to the notice of Team Lead/Project manager/ VP.
• Will be responsible for doing a thorough unit testing before and after their respective code components is being integrated into peer codes or main application.
• Post integration release they would be responsible for resolving the TFS issues being assigned to them.
• Demonstrated ability to adapt and learn new technologies.
• Provide recommendations for continuous improvement.

Desired Candidate Profile

• Minimum 2 Years of experience in .Net technologies
• Build new Web-based systems with C# .NET, ASP.NET
• Experience in Angular 2+, JQuery, Entity Framework are preferred
• Good experience in OOPS concepts, MVC Frame work, Web API, WCF / Remoting
• Strong experience in designing and working with scalable architectures
• The ability to quickly learn new concepts and software is necessary
• Having Experience in build, publish and deploying applications using various tools
• Should have experience of all aspects of Software Development Life Cycle or Agile
• Excellent problem solver, able to assimilate formation quickly
• Excellent communication skills, oral and written
• Technical expertise: Demonstrates knowledge and experience in .net development
• Strong team player; work effectively in groups; and help others to get the job done
• Decision making: ability to analyze, integrate, evaluate and make decisions
• Motivation: Establish and communicate vision. Demonstrate enthusiasm and excitement toward achieving project goals
• High quality standards: accuracy, proficient and thoroughness in unit testing
• Time Management: Completes work in a timely manner to meet production deadlines
• Organizational skills: Ability to establish priorities for projects to meet goals

Education among below

• Diploma
• BCA
• MCA
• B Eng
• M Eng
• B Tech
• M Tech
• E CE/IT