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

As a C++ developer working in front office electronic trading, your role involves developing and maintaining software solutions for trading systems used in financial markets. Here are some key aspects of your responsibilities:

C++ Programming: Mastery of the C++ programming language is essential, as most trading systems are built using C++ due to its performance and efficiency.

Electronic Trading Systems: You'll work with electronic trading systems that execute trades automatically based on predefined algorithms or user instructions. Understanding order execution, order management, and market data processing is crucial.

Multithreading: Multithreading is vital in electronic trading systems to handle concurrent tasks efficiently. You'll need to design, implement, and debug multithreaded applications to ensure optimal performance and reliability.

Low-Latency Systems: Electronic trading often requires low-latency systems to execute trades swiftly. You'll optimize code and algorithms to minimize latency and ensure timely order execution.

Algorithmic Trading: Knowledge of algorithmic trading strategies and implementing them in software is advantageous. This includes understanding mathematical models, statistical analysis, and risk management.

Networking: Understanding network protocols and communication is necessary for connecting trading systems to exchanges, brokers, and other financial institutions. This involves working with TCP/IP, UDP, and messaging protocols like FIX (Financial Information Exchange).

Risk Management: You'll implement risk controls and safeguards in trading systems to prevent erroneous trades or mitigate risks associated with market volatility.

Testing and Debugging: Thorough testing and debugging are crucial to ensure the reliability and stability of trading systems. You'll write automated tests, perform manual testing, and debug issues to maintain system integrity.

Performance Optimization: Continuously optimizing the performance of trading systems is essential to handle increasing trading volumes and maintain competitiveness. This involves profiling code, identifying bottlenecks, and applying optimizations.

Regulatory Compliance: Adhering to regulatory requirements and standards in the financial industry is critical. You'll ensure that trading systems comply with regulations such as MiFID II, Dodd-Frank, and others applicable to electronic trading.

Collaboration: Working closely with traders, quants, risk managers, and other stakeholders to understand requirements and implement solutions that meet business needs.

Documentation: Maintaining clear and comprehensive documentation for code, algorithms, and system architecture is important for knowledge sharing and compliance purposes.

Overall, being a C++ developer in front office electronic trading requires a strong technical foundation, attention to detail, and the ability to work effectively in a fast-paced and demanding environment.

We are Hiring ASP.NET MVC/Core Developers

Click Here to Apply : https://prishusoft.com/jobs/junior-aspnet-mvccore-professional

Experience Level

• 1–2 years of professional experience in web application development using ASP.NET MVC and ASP.NET Core.

Key Responsibilities

• Develop, maintain, and enhance web applications using ASP.NET MVC and ASP.NET Core.
• Write clean, scalable, and maintainable code following best practices.
• Design, develop, and integrate RESTful APIs with ASP.NET Web API.
• Collaborate with front-end developers and UI/UX designers to deliver exceptional user experiences.
• Work with MSSQL databases, including writing complex T-SQL queries, stored procedures, and optimizing performance.
• Participate in code reviews and contribute to technical discussions, architecture decisions, and performance improvements.

Technical Skills & Expertise

• Strong proficiency in ASP.NET MVC with at least 1 years of project experience.
• Good working knowledge of ASP.NET Core for modern application development.
• Solid skills in C#, JavaScript, and HTML.
• Experience with .NET Framework 4.5+.
• Hands-on experience with ASP.NET Web API development and consumption.
• Expertise in MSSQL (T-SQL, indexing, performance tuning).

Soft Skills

• Strong verbal and written communication skills.
• Collaborative team player with a willingness to share knowledge and contribute to team success.

Preferred / Bonus Skills

• Experience with Angular, React, or Vue.js for dynamic front-end development.
• Exposure to unit testing frameworks (e.g., Jasmine, Karma) for front-end applications.
• Understanding of DevOps practices and CI/CD pipelines.
• Familiarity with TypeScript for scalable JavaScript development.

Work Mode: Full-time On-site / Hybrid (Ahmedabad)

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

Primary Role

• Analysis and Design activities as required by project
• Software development as per project schedule
• Troubleshooting and Debugging as required for bug fixing
• Source code version maintenance in version control software
• Prepare and execute unit test cases
• Unit testing of the application to ensure quality release to QA
• Adherence of coding standards while performing development
• Impact analysis of any changes requested by client
• Daily status reporting / progress updates / timesheets

Secondary Role

• Prepare project specific documentation as required by project
• UAT / Implementation support as required by project
• Client interaction and communication as required by project
• Code review and peer testing as required by the project
• Mentor junior developers on the project as required by project

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.

• 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

About the Company

InnKey is an integrated Hotel ERP on Cloud. We help mid-upscale Hotel Chains run their entire operations on a single platform completely on cloud. We cater to all the departments of a hotel ranging from Reservations and Front Desk to Housekeeping and Maintenance to Point of Sale and Banquets and Conferencing to Material Management and Purchasing to Financial Accounting and MIS.

Our entire solution is on Cloud making it accessible anytime and anywhere which completely changes the operational landscape for any Hotel Chain.

We aim to become a single point solution for every Hotel Chain whether they have 10 or 1000 hotels. Our goal is to help our customers streamline their operations, increase their topline and maximize their bottomline.

What You’ll Do:

• You’ll work with others to build new product features from start to finish: through conception, research, implementation and maintenance
• Ability to ship code that allows for high availability and good performance are a must in a mission critical software like ours
• Contribute to all phases of software development
• Be adaptable to work in a fast-paced environment

What We Are Looking For:

• Thoughtful problem-solving: For you, problem-solving starts with a clear and accurate understanding of the context. You can decompose tricky problems and work towards a clean solution, by yourself or with teammates. You're comfortable asking for help when you get stuck.
• Shipping quality user interfaces: You can work with others to build and maintain quality user interfaces for a big audience, using Web technologies like HTML, CSS, JavaScript, and a modern UI framework like Angular. If you've experienced the technical challenges of rapid growth, that's a plus.
• Familiarity with the backend: You understand how parts of a system fit together—from the user interface to the data model. Experienced candidates should be familiar with relational database systems like MS SQL and backend technologies like .NET
• Pragmatic and business-oriented: You care about the business impact of what you're building, and you prioritize projects accordingly. You're not just going after cool stuff—you understand the balance between craft, speed, and the bottom line.
• Team player: You understand when work is better, together. You enjoy collaborating cross-functionally to accomplish shared goals, and you care about learning, growing, and helping others to do the same.