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

Key Responsibilities:

• Design, develop, and maintain scalable and high-performance applications using .NET technologies.
• Collaborate with business analysts and stakeholders to gather and analyze requirements.
• Write clean, maintainable, and efficient code following best practices and coding standards.
• Troubleshoot, debug, and optimize existing applications to improve performance and user experience.
• Participate in code reviews and provide constructive feedback to team members.
• Stay updated with the latest industry trends and technologies related to .NET development.
• Contribute to the development of technical documentation and user manuals.
• Assist in the deployment and maintenance of applications in production environments.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5 to 8 years of experience in .NET development, including ASP.NET, C#, and SQL Server.
• Strong understanding of object-oriented programming principles and design patterns.
• Experience with API-based integrations (REST, SOAP).
• Experience with front-end technologies such as HTML, CSS, JavaScript, and frameworks like Angular or React is a plus.
• Familiarity with version control systems, preferably Git.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills, with the ability to work effectively in a team environment.

Preferred Skills:

• Experience with cloud platforms such as Azure or AWS.
• Knowledge of Agile development methodologies.

Company Description: Bits in Glass

• Industry Leader:
• Bits in Glass (BIG) has been in business for more than 20 years. In 2021 Bits in Glass joined hands with Crochet Technologies, forming a larger organization under the Bits In Glass brand to better serve customers across the globe.
• Offices across three locations in India: Pune, Hyderabad & Chandigarh.
• Specialized Pega partner since 2017, delivering Pega solutions with deep industry expertise and experience.
• Proudly ranked among the top 30 Pega partners, Bits In Glass has been one of the very few sponsors of the annual PegaWorld event.
• Elite Appian partner since 2008, delivering Appian solutions with deep industry expertise and experience.
• Operating in the United States, Canada, United Kingdom, and India.
• Dedicated global Pega CoE to support our customers and internal dev teams.
• Employee Benefits:
• Career Growth: Opportunities for career advancement and professional development.
• Challenging Projects: Work on innovative, cutting-edge projects that make a global impact. 
• Global Exposure: Collaborate with international teams and clients to broaden your professional network.
• Flexible Work Arrangements: Support for work-life balance through flexible working conditions.
• Comprehensive Benefits: Competitive compensation packages and comprehensive benefits including health insurance, and paid time off.
• Learning Opportunities- Great opportunity to upskill yourself and work on new technologies like AI-enabled Pega solutions, Data engineering, Integration, cloud migration etc.
• Company Culture:
• Collaborative Environment: Emphasizes teamwork, innovation, and knowledge sharing.
• Inclusive Workplace: Values diversity and fosters an inclusive environment where all ideas are respected.
• Continuous Learning: Encourages professional development through ongoing learning opportunities and certifications.
• Core Values:
• Integrity: Commitment to ethical practices and transparency in all business dealings.
• Excellence: Strive for the highest standards in everything we do.
• Client-Centric Approach: Focus on delivering the best solutions tailored to client needs.

• Develop 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
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Prepare and install solutions by determining and designing system specifications, standards and programming
• Improve operations by conducting systems analysis; recommending changes in policies and procedures
• Protect operations by keeping information confidential
• Provide information by collecting, analyzing, and summarizing development and service issues
• Accomplish engineering and organization mission by completing related results as needed
• First and foremost, developing software our users need
• Mentor junior and mid-level engineers
• Collaborate with team to brainstorm and create new products
• Grow engineering teams by interviewing, recruiting, and hiring
• Make informed decisions quickly and taking ownership of services and applications at scale
• Work collaboratively with others to achieve goals
• Be a persistent, creative problem ­solver
• Remain cool and effective in a crisis
• Stay on the leading edge of development practices
• Passionate about great technologies, especially open source
• Understand business needs and know how to create the tools to manage them

ESSENTIAL EXPERIENCE 

1.   3.5 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 PAPIs.

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. 

Responsibilities

• Determines technical feasibility of medium to low complexity features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.

• Exercises judgment in prioritizing tasks and selecting methods and techniques for obtaining solutions.

• Create a low-level design of modules of a software application through proper documentation and diagrams.

• Develops software solutions by studying requirements, clarifying customer/user needs, analyzing data and processes, and following established software development practices and processes.

• Develops proof of concepts for technical evaluation and early customer feedback.

• Updates and shares knowledge by studying state-of-the-art development tools, programming techniques, and computing technology; reading professional publications.

• Networks with internal and external personnel in their area of expertise.

Requirements

• B.Tech/B.S. or M.Tech/M.S. in Computer Science, IT or related field.

• 3-5 years of experience

Visit us on :

Mandatory Skills

• Should be proficient in the following areas of .NET (.NET 4.5 or above, .NET Core)

• Expert in C# and ASP.NET

• Knowledge of JavaScript/TypeScript is a plus

• Development of Windows and Web services

• Parallel and Asynchronous programming

• Unit testing, Linq, ORM

• Debugging/troubleshooting in .Net

• Should be proficient in SQL Server 2012 and above in the following areas

• T-SQL Stored Procedures

• Transaction in SQL

• Should have the following design skills

• Expert in OOPs

• Proficiency in Design Patterns

• Proficiency in Unit testing Patterns

• Understanding of Algorithms and Data structures.

• Experience on Requirement/Design/Code Review & Inspections

• Excellent problem-solving and analytical skills.

Desirable Skills

• Hands-on experience with using Git (handling branching and merging), any DevOps pipeline

• Experience with Agile methodologies

YOUR RESPONSIBILITIES

• Development and unit testing of web applications including back-end (microservices), maintenance & level 3 support of the same
• Assist Project Managers, Business Analysts, and Tech Lead in project planning (provide estimates, risk analysis, requirements analysis, technical options)
• Software Architecture
• Involvement in full life cycle of projects (including requirement analysis and system design, development and support if required)
• Support and work collaboratively with teams across areas of design, development, quality assurance and operations
• Commit your knowledge and experience into team success
• A small amount of travel (when needed) to work with other offices
• Attend meetings to discuss and demonstrate solutions at both technical and business level

 REQUIRED SKILLS AND EXPERIENCE                                                                                                           

• 5+ years web application development experience
• 3+ years developing with Python
• 3+ years developing with C# and .NET Framework 4.x
• Experience with ASP.NET MVC, ASP.NET WebAPI 2, LINQ, and WCF
• Dependency Injection and other common ASP.NET MVC design patterns
• Experience with API design and development using REST
• Experience with performance optimization
• Experience integrating security best practices into the SDLC
• Experience with object-oriented programming (OOP) and OOP patterns
• Experience with Git
• 1+ years of Agile development experience
• Experience manipulating and working with data in a variety of forms: csv, xml, json, structured and unstructured                                                                                                
• Experience with SQL database schema design and querying. Microsoft SQL Server and PostGreSQL are used and preferred.

DESIRABLE SKILLS AND EXPERIENCE                                           

• Knowledge of JIRA, Bamboo, Confluence, or BitBucket is a plus.
• Experience with a JavaScript MVVM library such as Web Components, knockout.js, Angular, React, etc. is a plus (Web Components and knockout.js are used and preferred)
• Experience with HTML5/CSS3/JavaScript/ and AJAX is a plus
• SPA (Single Page Application) design and implementation is a plus
• Experience with any ORM such as Entity Framework or NHibernate is a plus (NHibernate is preferred)
• Experience with TypeScript is a plus
• Experience with MS Build is a plus
• Experience with CI/CD is a plus
• Experience with Object Mapping Frameworks (AutoMapper, etc) is a plus
• Understanding of OOD, DDD and TDD is a plus
• AWS-based development is a plus
• Knowledge of Flask is a plus.

PERSONAL SKILLS

• Clever personality
• Strong spirit skills set: conflict resistant, self -motivated, result-oriented, responsible, honest, “open”, courageous