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.

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

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

Job Description

Designation  :  ASP.Net Developer

Experience    :  2 to 4 Years

Technical Skill

• Asp.net
• C#
• MVC
• Ajax
• JQuery
• JavaScript
• HTML
• Bootstrap
• SQL
• Stored procedure sql server

Required Skill Set

• Good Experience in dynamic web page creation in ASP. Net .
• Ability to work individually, or in a team
• Excellent Problem solving skills with innovative and proactive approach
• Detailed oriented Broad experience with. NET Framework in developing web based applications
• Strong debugging skills, must be able to work independently with minimal guidance.
• Design, code, test, debug and document software according to the functional requirements.
• Experience in writing web applications using ASP.net MVC 4.0/4.5, Entity Framework, SQL Server 2008/12
• Experience in Java script, AJAX and JQuery
• Experience on Web API is preferred
• Sound knowledge of SQL Server 2008/12 relational database concepts, SQL simple/complex queries and writing stored procedures 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

Job Description: