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

 

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

Mesu Solutions is backed up with a specialized industry base and technical domain matrix. Like Healthcare IT is where we can contribute additionally by being aware of the Healthcare IT needs like MU Stage1 and Stage 2 Compliance, and many more. We work on a diverse spectrum of IT Languages and Technology Platforms to be able to build solutions that are effective and not just huge. Integration with the Infrastructural abilities of the Organization is one of the most precise and soft aspect of handling any Customer Requirement. At Mesu Solutions, we train our team to intently listen to the actual requirement of the Customer, Design and Develop solutions and then implement it completely, even by going that extra mile too. About Job:- VB 6 & .Net (VB / ASP/C#) knowledge is Compulsory Required. 1-3 Years Experience Required in Development field.

Software Development Engineer – SDE 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.

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

Greetings from Techspian Services Pvt Ltd.

Position: Software Developer
Experience: 3-6 yrs

Notice Period: Less than 30 days

Requirement:

• Minimum 3-6 Years of Experience in .Net Technology
• Technical expertise Must in such as. NET Framework, C#, VB. Net, MVC

• Understanding of SQL Server, Web Services, Entity Framework, Web API, RESTful services
• Excellent analytical and problem-solving skills
• Excellent Written and Communication skills
• Ability to work and prioritize multiple projects.
• Home office that provides the right ambiance to focus on work

Perks and Benefits
Health Insurance | Work Flexibility | Work From Home | Internet Reimbursement

Hiring For Dotnet Developer!!
Salary: Best in Industry
No constraint for right candidate.
Exp: 2 years to 5 years

Work with developers to design algorithms and flowcharts Prepare GUI dummy screens for proposed Software development using Excel VBA. (To Give a overview how the software buttons and flow of information should happen) Coordination with Software Developer team to explain the criteria Produce clean, efficient code based on specifications Integrate software components and third-party programs Verify and deploy programs and systems Troubleshoot, debug and upgrade existing software Gather and evaluate user feedback Recommend and execute improvements Create technical documentation for reference and reporting Proven experience as a Software Developer, Software Engineer or similar role Familiarity with development methodologies Experience with software design and development in a test-driven environment Knowledge of coding languages (e.g. C#, C++) and frameworks/systems Ability to learn new languages and technologies Excellent communication skills Resourcefulness and troubleshooting aptitude Attention to detail Sound technical knowledge, thorough knowledge of all related codes and section details is desired. Thorough Knowledge of Design of Components of Residential / Commercial Structures is Desired. Accuracy In Following The Process & Jobs Is Required. Experience in Interaction with International Client Will Be Preferred

Great Opportunity to work on windows application development!! If you are tech savy with hands on experience in WPF/winforms and WCF, send your profile to [email protected] Please note the job location is Kharadi and there is a special joining bonus for all those who can join in 2 weeks’ time.