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

Designation – Nodejs Developer

Experience – Min 3+ Yrs

Location: Ahmedabad ( WFO)

We are seeking a highly skilled Senior Node.js Developer with expertise in SQL and MongoDB to join our dynamic team.

As a key member of our development team, you will be responsible for managing the interchange of data between the server and users, as well as developing server-side logic. Your primary focus will be on the development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end. Additionally, your experience with both SQL and NoSQL databases will be crucial in defining and maintaining our data storage solutions.

Responsibilities:

 Develop and maintain server-side applications using Node.js.

 Design and implement RESTful APIs for seamless integration with front-end applications.

 Collaborate with front-end developers to integrate user-facing elements with server-side logic.

 Optimize applications for maximum speed and scalability.

 Implement security and data protection measures.

 Design and maintain database schemas for both SQL (e.g., MySQL, PostgreSQL) and NoSQL (e.g., MongoDB) databases.

 Manage and mentor junior developers, providing technical guidance and support.

 Stay updated with emerging technologies and industry best practices.

Requirements:

 Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent work experience.

 Minimum 4 years of experience in Node.js development.

 Proficiency in JavaScript/TypeScript and frameworks such as Express.js.

 Strong understanding of asynchronous programming and event-driven architecture.

 Experience with SQL databases (e.g., MySQL, PostgreSQL) and proficiency in writing complex SQL queries.

 Experience with NoSQL databases (e.g., MongoDB) and familiarity with their query languages.

 Familiarity with ORM libraries (e.g., Sequelize, Mongoose) for database interaction.

 Knowledge of version control systems (e.g., Git).

 Understanding of CI/CD pipelines and deployment processes.

 Excellent communication and teamwork skills.

 Ability to lead and mentor a team of developers.

Company Description :

Simform is a product engineering company founded in 2010 that helps organizations ranging from startups to Fortune 500 companies and progressive enterprises. Their remote agile teams of engineers are focused on identifying and solving critical business challenges with proven technology practices such as DevOps, cloud-native development, and quality engineering services. Simform's mission is to solve complex software engineering problems and make organizations more competitive and agile.

Simform is a CMMI L-3, AWS Premier Partner, and Azure Solutions Partner. I think you'll be excited to know more about what we have to offer.

If you're open to learning more about Simform Solutions and the Senior Asp.net Developer position, kindly go through our company profile and job description for your reference.

Skills :

Experience: 4+ Years

Location: Ahmedabad, Gujarat

Mandatory skills: Dot net core, .Net framework, Angular/React, Unit testing, AWS/Azure/GCP, Microservices

Candidate should be flexible with night shifts.

Good-to-have skills: DevOps- Automation, Team leading.

Why Simform? Some of the perks and benefits of working at Simform are :

- Flat-hierarchical, friendly, engineering-oriented, and growth-focused culture.

- Flexible work timing, Leaves for life events, work from home

- Free health insurance

- Office facility with large, fully-equipped game-zone, in-office kitchen, affordable lunch service, and free snacks.

- Sponsorship for certifications/events, library service

Roles & Responsibilities:

• Develop complex web apps using a modern approach and engineering practices using asp.net and related technologies 
• Ability to understand business requirements and translate them into technical requirements
• Solve complex technical, scalability, or performance challenges
• Define and ensure compliance with software engineering standards across the engineering team.
• Requirement gathering and client communication.\
• Project analysis and planning
• Mentor small team of developers.

Requirements:



• Experience with Asp.Net MVC with Entity Framework.
• At least one year of experience with Asp.Net Core.
• Strong understanding of object-oriented programming (OOP), design patterns.
• Experience with SQL Server including SP, writing complex queries and DB optimization.
• Familiarity with Javascript, JQuery, and Typescript
• Knowledge front-end technology (AngularJS) is a plus
• Experience with common front-end development HTML, CSS etc.
• Expertise with code testing best practices like unit testing
• Basic hands-on experience of Azure, Azure SDK and AWS.
• Familiarity with code versioning tools such as Git, SVN

Profile: Software Developer

Experience: 5 +Years

Location - Ahmedabad

Key skills: .NET Core, Angular, MVC & MYSQL

KEY RESPONSIBILITIES

• Design, build, and maintain high-performance, reusable, and reliable code.
• Can work solely or as a team player for existing and upcoming projects.
• Ability to work independently and within a team
• Understanding of the Software Development Life cycle.
• Good understanding of object-oriented design principles
• 
  

SKILLS AND EXPERIENCE

• At least 5 yrs. of experience in Web application
• At least 5 yrs. of experience in MS SQL Server
• Expert in Angular, Web APIs
• Knowledge of object-oriented programming, SOLID principles, and design patterns
• Excellent problem-solving skills
• Must communicate in English effectively
• Analyze the existing codebase
• Design and implement solutions
• Collaborate with other developers to refactor and improve the efficiency of the code.
• Ensure that the software adheres to best practices in coding and architecture.
• Guide and mentor junior developers in performance optimization techniques.
• Should have understanding and experience of software development best practices/clean coding practices/clean coding practices
• Attention to detail and commitment to high-quality/error-free deliverables
• Conduct code reviews and provide feedback to ensure code quality and performance.
• Time Flexibility
• Stay up to date with the latest trends and technologies in software development and performance optimization.
• Familiar with Jira and Bitbucket
• Familiarity with cloud-native Dev Ops automation & building CI/CD pipelines

Your duties include

• Database development using T-SQL on MS SQL Server
• API Development using ASP.Net WEB API and C#
• R & D for available solutions and 3rd party API integrations
• Comparative Analysis of different approaches and finding optimal solutions
• Supporting existing applications in SQL, ASP.NET WEB API, C#, Angular or TypeScript

SKILLS

• Should have hands-on Experience in .NET Core, Asp.Net, MVC, Entity Framework, SQL Server with Good Communication skills.
• Use Microsoft technologies: C#, ASP.NET, SQL, MVC, and Microsoft Workflow to develop technical solutions to complex problems that require the regular use of ingenuity and creativity
• Design, code, test, debug and document software according to the functional requirements
• Develop, maintain and support programs/tools for internal and external clients
• Analyse, diagnose and resolve errors related to their applications
• Help define project plans requiring software development and hardware installations
• Provide technical and project management expertise across multiple areas of application development
• Investigate operational or systematic problems and user queries as required.
• If the candidate has experience in MVC / Angular / Azure / Xamarin, it would be an added advantage.

Education

Bachelor’s or Master’s degree in Computer engineering or relevant field
Students working towards their degree and with sufficient experience will be considered.
Qualifications-BCA, BE/B.Tech(Information Science/Technology (IS/IT)), MCA, ME/M.Tech(Information Science/Technology)

Job Roles & Responsiblities:

• 4+ years of experience in .NET Core, C#, EF Core, SQL Server, Rest API, MVC, Webform
• Good to have exposure in Azure & Azure DevOps
• Strong Experience in Micro Services Architecture.
• Cloud Azure
• Azure Kubernetes
• Knowledge of Docker is advantageous
• SOLID Principles
• Good to have exp in SonarCloud
• Should have team leading experience

JOB DUTIES & RESPONSIBILITIES:

• Lead and mentor developers thru coaching and sharing of knowledge
• Architecture design and Develop new functionality and critical business logic of software products
• Enhance existing applications and software products and design new product

SKILLS:

• Strong knowledge on software implementation best practices
• Strong knowledge of SQL Server and/or Oracle database including store procedure, trigger etc.
• Knowledge of security and vulnerability best practices to design secure web application
• Knowledge of web application architecture with horizontal and vertical scalability
• Experience of working with application with large dataset of millions or billions of row in database table
• Ability to adapt quickly to an existing, complex environment
• Ability to complete all phases of software development life cycle including analysis, design, development, testing and support
• Ability to develop large scale web/database applications
• Ability to work on multiple projects with multiple deadlines
• Ability to communicate clearly with business users and project manager
• Ability to innovate and provide functional applications with intuitive interfaces

We are looking for a senior .NET Core professionals with 2+ years of development experience, who thrive on challenges and desires to make a real difference in the business world.

You are required to have skills in the following areas:

• 2 to 4 years of experience in. NET Core  development.
• Knowledge and Hands-on experience of at least 2 years on ASP.Net, C#, MS SQL Server, Restful, C# 3.5/4.0, MVC
• Desirable Skills: Excellent written and verbal communication skills. Excellent analytical and troubleshooting abilities.
• Solid understanding of best practices in web application development.
• Exceptional attention to detail and design.

Rules & Responsibilities:

Technical Skills:

1. .Net– Net, C#, .Net core, MVC, Framework, Web API, Web Services, Micro Service and SQL
2. Azure – Azure Cloud, SaaS, PaaS, IaaS, Azure Relational, and No-SQL Database, Big Data Services

Responsibilities

• Good understanding of and experience in working on Microsoft Azure (IAAS/PAAS/SAAS)
• Ability to architect, design, and implement cloud-based solutions
• Proven track record of designing and implement the IoT-based solutions/Big Data solutions/applications to the Azure cloud platform.
• Experience in building .Net-based enterprise distributed solutions in Windows and Linux.
• Experience in using CI and CD tools. Jenkins/ Azure pipeline and Terraform. Experience in using another tooling such as Ansible, CloudFormation, etc.
• Good understanding of HA/DR Setups in Cloud
• Experience and working knowledge of Virtualization, Networking, Data Center, and Security
• Deep hands-on experience in the design, development, and deployment of business software at scale.
• Strong hands-on experience in Azure Cloud Platform
• Experience in Kubernetes, Docker, and other cloud deployment, container technologies
• Experience / knowledge of other cloud offerings (e.g. AWS, GCP) will be added advantage
• Experience with monitoring tools like Prometheus, Grafana, Datadog, etc.

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