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

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

• 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

• • At least 3 to 5 years of experience in .Net.
  • The candidate should be a system thinker.
  • Strong knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3.
  • Enjoy Event-Driven Design Patterns and Event Sourcing.
  • Familiar with Document Store Databases (like Cosmos DB / Mongo DB).
  • Knowledge in Modular Architecture and Microservices.
  • Comfortable leading large technical projects.
  • Knowledge of any cloud services AWS, Azure, Google Cloud.
  • Good understanding of ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)).
  • Experience with architecture styles/APIs (REST, RPC).
  • Understanding of Agile methodologies.
  • Strive for continuous improvement and build continuous integration, continuous development, and constant deployment pipeline (CI/CD Pipeline).

• Bachelor’s Degree in Computer Science or Information Technology
  
  

• Excellent writing skills
• Proficient in Web use, Outlook and Microsoft Office
• Travel as needed

You will get while working with us

• Opportunity to work on highly distributed systems with micro-services architecture and big-data volumes
• Solve challenging real-world problems by leveraging OOP & functional programming concepts
• Opportunity to incubate an open source project
• Get to work with cutting edge technologies to name a few Kafka, Elasticsearch, Postgres, Scala
• Developing scalable, sustainable and reliable enterprise systems
• Hands-on experience of working with TDD and BDD
• Develop environment using practices such as Continuous Integration, Continuous Delivery
• Learning opportunity on how to turn complex business requirements into a working product

Roles & Responsibilities

• Requirement understanding & analysis by interacting with client
• Carry out architectural and design discussions with fellow team members and come up with right approach
• Understand system domain, user’s perspective of system and use-cases
• Understand patterns in existing code and effectively leverage and improvise it 
• Develop backend involving Java8 based functional programming and REST services
• Ensure best practices of code reviews, automated testing and CI
• Research new tools & technologies required for the projects
• Mentor fellow team members and bring their level up

Must have

• Strong hold on written/verbal communication
• Strong core Java fundamentals
• Strong Analytical & problem solving skills
• Proactive and inherent nature of working with ownership
• Passion of writing clean code
• Experience in designing relational data model from business requirements

Good to have

• Knowledge of functional programming (Scala or Java 8 lambda)
• Knowledge of NOSQL
• Working knowledge of linux & networking
• Performance optimisation - Optimise/refactor queries, code, stored procedures to take performance next level

Rules & Responsibilities:

Skills :

• 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