11+ SQL tuning Jobs in Pune | SQL tuning Job openings in Pune

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.

1.   7 to 12-14 years of experience as a Software Developer.

2.   Experience in .Net technologies - C#, ASP.net is must.

3.   Experience in developing REST based APIs.

4.   Experience in building web user interface.

5.   Good to have experience in developing single page apps using modern JS framework.

6.   Skills in cross browser development.

7.   Understanding of Agile methodology.

8.   Excellent trouble shooting and communication skills.

9.   Knowledge of Azure will be an added advantage.

JOB DESCRIPTION -

1. Developing and implementing web-based applications using .Net technology and MS-SQL.
2. Developing front end with highly responsive user interface concept using React concept.
3. Identifying web-based user interaction.
4. Participate in requirement analysis.
5. Collaborate with internal teams and positive mindset to help and seek help.
6. Documentation of application development changes and updates.

TECHNICAL SKILLS

1. Expert in C#, ASP.Net, Web API, MS SQL Server.
2. Good to have experience in React and workflows such as Redux or Flux, MongoDB.
3. Knowledge of HTML, CSS and JavaScript.
4. Familiar with source control system (GIT, SVN).

About us:
Aeons ago (2015 :)), in the humble abode of Abhishek’s bachelor pad, our co-founders, Abhishek Ballabh & Sushil Mundada, set out to bring innovation into the world of admissions. Today, we are trusted with the admissions of over 300 educational institutions. Our team of 60 + team members (and growing!) are on a mission to help ExtraaEdge become the globally preferred Education Marketing Technology.

 The primary requirement for this role is:

• Sharp .NET & MVC framework knowledge & programming hands-on.

• Attention to Detail.

• Razor-sharp analytical & problem-solving skills.

• Experience in Agile methods & Test-Driven design.

Job Profile: 

• To be a part of the development initiatives at ExtraaEdge and work in a high-performance team.
• Minimum 0 to 2 years of development experience.
• Manage the backend services and controller changes when a new module is implemented.
• Manage the development roadmap in sync with the product roadmap.
• Suggest architectural changes & optimizations while fine-tuning the application.
• Being able to step into the shoes of the user/learner and identify the best design/coding strategies & frameworks.
• Interact with operations & sales to understand expectations.

Skills Required:

• 0 to 2 years of experience working on C#, .NET Core, .NET MVC.
• Proficient in Entity Framework, LINQ to Objects.
• Experienced in SQLServer, Database design, and understanding database queries.
• Advanced Database knowledge like Indexing, Stored Procedures.
• REST API design and implementation.
• Knowledge of Azure Cloud Management, WebApps & Deployments.
• Hands-on in writing Unit Tests.
• Familiarity with architecture styles/APIs (REST, RPC).
• Understanding of Agile methodologies.
• Excellent problem solving and communication skills.

Role- Software Development Engineer-2

As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward.

Top Skills

You write high quality, maintainable, and robust code, often in Java or C++ or C#

You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.

You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.

Roles & Responsibilities

You solve problems at their root, stepping back to understand the broader context.

You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.

You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.

You recognize and use design patterns to solve business problems.

You understand how operating systems work, perform and scale.

You continually align your work with Amazon’s business objectives and seek to deliver business value.

You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.

You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.

You communicate clearly with your team and with other groups and listen effectively.

Skills & Experience

Bachelors or Masters in Computer Science or relevant technical field.

Experience in software development and full product life-cycle.

Excellent programming skills in any object-oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.

Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.

Proficiency in SQL and data modeling.

• Bachelor’s Degree in Computer Science or equivalent
• 8-12 years’ of industry experience in programming web applications, mobile and/or large scale enterprise products
• Deep knowledge of C#, ASP, .NET, MVC, .Net core
• Deep knowledge and extensive experience working on Ruby or React and JavaScript, as required
• Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS
• Extended experience with SQL, relational and non-relational databases
• Experience in TFS and Visual Studio
• Hands on experience with SDLC and programming design patterns
• Experience with Agile methodology
• Skillful at reviewing new feature impact on an application and recognizing potential risks
• Uses time effectively and efficiently
• Quickly learns new technologies
• Detailed oriented, professional and possesses a positive work attitude
• Communicate professionally both verbally and in writing
• Effective time management skills
• Knowledge on UI technologies will be plus

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• Develops software solutions by studying information needs, conferring with users, studying systems flow, data usage, and work processes, investigating problem areas, following the software development lifecycle.
• Conducts systems analysis and makes recommendations to improve the system to achieve an outcome.
• Promotes internal best practices and coding conventions to write and execute tests for your own code, including creating comprehensive unit tests.
• Contributes to Technical Requirements Documents.
• Requests constructive feedback for designs early in the process.
• Communicates successfully with large teams and many stakeholders.
• Provides mentorship for Software Engineers and participates in interview panels to hire new Software Engineers.
• Assists in removing obstacles for the team to yield successful sprints.
• Performs peer code reviews to ensure quality of the codebase.
• Ability to decompose and delegate work to junior engineers.
• Updates job knowledge by studying state-of-the-art development tools, programming techniques and computing equipment; participating in educational opportunities, reading professional publications, maintaining personal networks, participating in professional organizations.
• Works effectively with multiple projects and features.
• All other duties as assigned.

• Bachelor’s Degree in Computer Science or equivalent.
• 2+ years of industry experience in programming web applications, mobile and/or large-scale enterprise products.
• Knowledge of C#, ASP, .NET, MVC.
• Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS.
• Hands-on experience with SQL and relational databases.
• Experience in TFS and Visual Studio.
• Familiar with SDLC and programming design patterns.
• Familiar with Agile methodology.
• Skillful at reviewing new feature impacts on an application and recognizing potential risks.
• Detailed oriented, professional and possesses a positive work attitude.
• Communicate professionally both verbally and in writing.
• Effective time management skills.