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

Job Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

JioTesseract, a digital arm of Reliance Industries, is India's leading and largest AR/VR organization with the mission to democratize mixed reality for India and the world. We make products at the cross of hardware, software, content and services with focus on making India the leader in spatial computing. We specialize in creating solutions in AR, VR and AI, with some of our notable products such as JioGlass, JioDive, 360 Streaming, Metaverse, AR/VR headsets for consumers and enterprise space.

Mon-Fri, In office role with excellent perks and benefits!

Key Responsibilities:

1. Design, develop, and maintain backend services and APIs using Node.js or Python, or Java.

2. Build and implement scalable and robust microservices and integrate API gateways.

3. Develop and optimize NoSQL database structures and queries (e.g., MongoDB, DynamoDB).

4. Implement real-time data pipelines using Kafka.

5. Collaborate with front-end developers to ensure seamless integration of backend services.

6. Write clean, reusable, and efficient code following best practices, including design patterns.

7. Troubleshoot, debug, and enhance existing systems for improved performance.

Mandatory Skills:

1. Proficiency in at least one backend technology: Node.js or Python, or Java.

2. Strong experience in:

i. Microservices architecture,

ii. API gateways,

iii. NoSQL databases (e.g., MongoDB, DynamoDB),

iv. Kafka

v. Data structures (e.g., arrays, linked lists, trees).

3. Frameworks:

i. If Java : Spring framework for backend development.

ii. If Python: FastAPI/Django frameworks for AI applications.

iii. If Node: Express.js for Node.js development.

Good to Have Skills:

1. Experience with Kubernetes for container orchestration.

2. Familiarity with in-memory databases like Redis or Memcached.

3. Frontend skills: Basic knowledge of HTML, CSS, JavaScript, or frameworks like React.js.

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

• Develop client projects using Asp.net core 3.1 and above, MySQL Database, Azure Functions, CosmosDB, C#.
• Communicate with external clients on a regular basis regarding progress, challenges, timelines and results of client projects
• Gather technical requirements as needed
• Create and update, design and functional documents
• Identify and troubleshoot issues as needed
• Perform a new development as required
• Implement project applications according to specifications
• Research technical issues and provide recommendations to enhance client websites
• Work both independently and as part of a team to create reliable and high-performing Web Applications
• Unit test code to ensure quality

• Develop client projects using Asp.net core 3.1 and above, MySQL Database, Azure Functions, CosmosDB, C#.
• Communicate with external clients on a regular basis regarding progress, challenges, timelines and results of client projects
• Gather technical requirements as needed
• Create and update, design and functional documents
• Identify and troubleshoot issues as needed
• Perform a new development as required
• Implement project applications according to specifications
• Research technical issues and provide recommendations to enhance client websites
• Work both independently and as part of a team to create reliable and high-performing Web Applications
• Unit test code to ensure quality

Senior Dotnet Developer

About the Company:

TransformHub is a An ISO 27001 certified Company adhering to a Gold standard in Information Security. It is multi-award-winning Global Digital Solutions company providing a full suite of digital transformation & product engineering services to enterprises, product companies & new-age start-ups. We have our presence in Singapore, USA, Canada, Middle East, UK and India. Our mission is to become a preferred partner to enterprises for growth and innovation in the digital age. TransformHub combines Strategy, Experience, and Technology at every stage of the engagement model to build human-centered digital platforms & channels. Our expertise lies around the 6 building blocks for Digitization - Product Engineering, Mobility, Enterprise Integrations, Data & Analytics, Cloud & DevOps, Intelligent Automation. With a large and ever-growing team of digitally ready consultants, the company helps its clients to grow and stay ahead of their competition. TransformHub has been featured into leading magazines like IndustryWired and CIOReview as Top 10 Digital Transformation Providers.

Responsibilities 

• Develop new applications or make enhancements to existing applications. 
• Analyze user requests and assist with design activities. 
• Collaborate with Client and translate business requirements into well-designed technical solutions. 
• Develop components based on business and/or application requirements. 
• Manage and assist with the completion of specific projects. This includes the development of web applications and web services. 
• Support applications and provide upgrades and maintenance as needed. 
• Assist software personnel in handling project related work and other requirements 
• Create and maintain documentation for application coding and project development. 
   

   Requirements  

• Familiarity with the .NET framework, C#, SQL Server database and design/architectural patterns 
• 5+ years of experience in .NET Technology Stack 
• Experience in designing databases with Microsoft SQL Server and building Web APIs 
• Excellent troubleshooting and communication skills 
• Experience working in an Agile environment (e.g. Scrum, Kanban) required. 
• Good knowledge of modern software design principles, concepts, and practices. 

Greetings from Amazon...!                                       

It is our pleasure in personally inviting you to apply job with Amazon Development Centre India (ADCI). At Amazon we are inclined to hire people with passion for technology and you happened to be one of the shortlisted candidates. Our business is committed to recognizing potential and creating teams that embrace innovation.

Please find the Eligible criteria and requirements:

Job title                             :             SDE – II (Software Development Engineer)
Role Opportunity            :             Permanent/Full Time/FTE/Regular

Work Location                 :             Hyderabad/Bangalore/ Gurgaon

Must Have

• Strong Exposure to Data Structures, Algorithms, Coding, System Design (LLD, HLD, OOAD), Distributed systems, problem solving skills, Architecture (MVC/Microservices), logical thinking.

Amazon (ADCI) - If you are looking for an opportunity to solve deep technical problems and build innovative solutions in a fast paced environment working with smart, passionate software developers, this might be the role for you. Amazon’s transportation systems get millions of packages to customers worldwide faster and cheaper while providing world class customer experience – from checkout to shipment tracking to delivery. Our software systems include services that handle thousands or requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers worldwide, manage business rules for millions of unique products, and improve experience for millions of online shoppers. With rapid expansion into new geographies, innovations in supply chain, delivery models and customer experience, increasingly complex transportation network, ever expanding selection of products and growing number of shipments worldwide, we have an opportunity to build software that scales the business, leads the industry through innovation and delights millions of customers worldwide.

As an SDE, you will develop a deep understanding of our business, work closely with development teams and own the architecture and end-to-end delivery of software components.

About Amazon India:

Amazon teams in India work on complex business challenges to innovate and create efficient solutions that enable various Amazon businesses, including Amazon websites across the world as well as support Payments, Transportation, and Digital products and services like the Kindle family of tablets, e-readers and the store. We are proud to have some of the finest talent and strong leaders with proven experience working to make Amazon the Earth’s most customer-centric company.

We made our foray into the Indian market with the launch of Junglee.com, enabling retailers in India to advertise their products to millions of Indian shoppers and drive targeted traffic to their stores. In June 2013, we launched http://www.amazon.in">www.amazon.in for shoppers in India. With http://www.amazon.in">www.amazon.in, we endeavor to give customers more of what they want – low prices, vast selection, fast and reliable delivery, and a trusted and convenient online shopping experience. In just over a year of launching our India operations, we have expanded our offering to over 18 million products across 36 departments and 100s of categories! Our philosophy of working backwards from the customers is what drives our growth and success.

We will continue to strive to become a trusted and meaningful sales and logistics channel for retailers of all sizes across India and a fast, reliable and convenient online shopping destination for consumers. For us, it is always “Day 1” and we are committed to aggressively invest over the long-term and relentlessly focus on raising the bar for customer experience in India. Amazon India offers opportunities where you can dive right in, work with smart people on challenging problems and make an impact that contributes to the lives of millions. Join us so you can - Work Hard, Have Fun and Make History.

Basic Qualifications:

• 3+ years’ experience building successful production software systems
• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field)
• The ability to take convert raw requirements into good design while exploring technical feasibility tradeoffs
• Expertise in System design (design patterns, LLD, HLD, Solid principle, OOAD, Distributed systems etc..), Architecture (MVC/Micro services).
• Good understanding of at least some of the modern programming languages (Java) and open-source technologies (C++, Python, Scala, C#, PHP, Ruby etc..)
• Excellence in technical communication
• Has experience in mentoring other software developers

Preferred Qualifications:

• BS/MS in Computer Science or equivalent
• Experience developing service oriented architectures and an understanding of design for scalability, performance and reliability
• Demonstrated ability to mentor other software developers to maintain architectural vision and software quality
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment
• Expertise in delivering high-quality, innovative application
• Strong desire to build, sense of ownership, urgency, and drive
• Strong organizational and problem solving skills with great attention to detail
• Ability to triage issues, react well to changes, work with teams and ability to multi-task on multiple products and projects.
• Experience building highly scalable, high availability services
• The ideal candidate will be a visionary leader, builder and operator.
• He/she should have experience leading or contributing to multiple simultaneous product development efforts and initiatives.
• He/she needs to balance technical leadership with strong business judgment to make the right decisions about technology choices.
• He/she needs to be constantly striving for simplicity, and at the same time demonstrate significant creativity, innovation and judgment
• Proficiency in, at least, one modern programming language.
• Experience in SQL or Non-SQL database.
• Strong sense of ownership, urgency, and drive.
• Demonstrated leadership abilities in an engineering environment in driving operational excellence and best practices.
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
• Excellent communication, collaboration, reporting, analytical and problem solving skills.

Good to Have:

• Knowledge of professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Experience with enterprise-wide systems
• Experience influencing software engineers best practices within your team
• Hands-on expertise in many disparate technologies, typically ranging from front-end user interfaces through to back-end systems and all points in between
• Strong written and verbal communication skills preferred

Key Points to remember:

• Strong knowledge of the Software Development Life Cycle methodology
• Technical design, development and implementation decisions on the use of technology in area(s) of specialization.
• Write or modify programming code to suit customer's needs.
• Unit test to assure meets requirements, including integration test as needed.
• Ability to understand and analyze issues and uses judgment to make decisions.
• Strong problem solving & troubleshooting skills
• Strong communication skills
• Responsible for self-development according to professional development plan