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.

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.

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 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

• • 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

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