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

Company Description :

Simform is a product engineering company founded in 2010 that helps organizations ranging from startups to Fortune 500 companies and progressive enterprises. Their remote agile teams of engineers are focused on identifying and solving critical business challenges with proven technology practices such as DevOps, cloud-native development, and quality engineering services. Simform's mission is to solve complex software engineering problems and make organizations more competitive and agile.

Simform is a CMMI L-3, AWS Premier Partner, and Azure Solutions Partner. I think you'll be excited to know more about what we have to offer.

If you're open to learning more about Simform Solutions and the Senior Asp.net Developer position, kindly go through our company profile and job description for your reference.

Skills :

Experience: 4+ Years

Location: Ahmedabad, Gujarat

Mandatory skills: Dot net core, .Net framework, Angular/React, Unit testing, AWS/Azure/GCP, Microservices

Candidate should be flexible with night shifts.

Good-to-have skills: DevOps- Automation, Team leading.

Why Simform? Some of the perks and benefits of working at Simform are :

- Flat-hierarchical, friendly, engineering-oriented, and growth-focused culture.

- Flexible work timing, Leaves for life events, work from home

- Free health insurance

- Office facility with large, fully-equipped game-zone, in-office kitchen, affordable lunch service, and free snacks.

- Sponsorship for certifications/events, library service

Roles & Responsibilities:

• Develop complex web apps using a modern approach and engineering practices using asp.net and related technologies 
• Ability to understand business requirements and translate them into technical requirements
• Solve complex technical, scalability, or performance challenges
• Define and ensure compliance with software engineering standards across the engineering team.
• Requirement gathering and client communication.\
• Project analysis and planning
• Mentor small team of developers.

Requirements:



• Experience with Asp.Net MVC with Entity Framework.
• At least one year of experience with Asp.Net Core.
• Strong understanding of object-oriented programming (OOP), design patterns.
• Experience with SQL Server including SP, writing complex queries and DB optimization.
• Familiarity with Javascript, JQuery, and Typescript
• Knowledge front-end technology (AngularJS) is a plus
• Experience with common front-end development HTML, CSS etc.
• Expertise with code testing best practices like unit testing
• Basic hands-on experience of Azure, Azure SDK and AWS.
• Familiarity with code versioning tools such as Git, SVN

Technical Lead - .NET

Responsibilities:

• Develop and deliver technical systems
• Maintain adherence to architectural standards/principles, global product-specific guidelines, usability design standards, etc.
• Participate in the development and review of documents to comply with SDLC methodologies [e.g., Engineering Work Breakdown Structure (WBS), estimation, Solution Design Document (SDD) and Software Architecture Documents (SAD)]
• Provide support and documentation to assist in sustaining the project during the transition to production where necessary
• Adhere to Application Engineering methodologies, standards, code reviews
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate
• Identify potential points of contention for missed activities and notify project leadership of situation and remediation plan
• Minimize technical exposure and risk on projects
• Provide technical guidance to development team members
• Technical deliverables (i.e., code and documentation) on projects assigned
• Translate detailed Requirements and Design and Solution Architecture deliverables into detailed design specifications
• Maintain effective and consistent communication within the team, with peers, the leadership team, and the peers in other IT groups
• Proactively raise issues to Technical and Group Leads when necessary
• Produce high-quality application engineering deliverables in accordance with the project timeline
• Build and unit test a project to detailed design specifications
• Provide thought leadership and technical guidance to engineering staff
• Review of code completed
• Review performance of developers
• Proactively anticipate project issues before they occur; define the problem; identify possible causes; work with the team to identify solutions; select and implement the most appropriate solution
• Apply judgment in implementing Application Engineering methodologies, processes, and practices to specific requirements of projects/programs which may include product design engineering, information security, code maintainability and reliability

Requirements:

Must Have:

• Bachelor’s OR master’s degree in a technical field and/or equivalent work experience
• At least 3 years acting a senior architecture / technical lead role in a comparable organization
• Significant experience of deploying large, enterprise-wide implementations to significant user volumes
• At least 5 years of hands-on experience leading a team of developers - defining work breakdown structures/tasks, assigning the teamwork items, monitoring, and ensuring quality and adherence to standards etc.
• At least 8 years of relevant hands-on work experience building, integrating, and delivering enterprise-wide web and windows applications using Microsoft and other technologies for large organizations on complex projects
• 8+ years of ASP.Net MVC, ASP.Net experience
• 8+ years of experience of working with applications that have a SQL Server backend
• 5+ years of experience with Object-Relational Mappers such as Entity Framework, ADO.NET, Dapper
• Expert level knowledge of .NET Web API is required. .NET Core knowledge is preferred, but Web API experience with legacy .NET is ok
• 5+ years of experience with GIT
• 3+ years of experience of Azure Devops
• In-depth knowledge of object-oriented analysis and design (OOAD) principles, and familiarity with many design patterns for Software applications.
• Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities, deployment and performance related activities, documentation, support, and training/mentoring
• Excellent communication skills, verbal and written

Nice to have:

• Ideally experience working with SSRS, SSIS
• Experience with MongoDB or another document database would be a plus
• Knowledge and experience with working on N-Tier applications.
• Demonstrated ability to build strong working relationships
• Experience working on projects following Agile methodologies would be ideal
• Experience working with Azure or other cloud providers would be ideal
• Ability to work within diverse, global, virtual teams.
• Proven ability to thrive under pressure
• Some experience with design and prototyping tools and diagramming is desired

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

• • At least 3 to 5 years of experience in .Net.
  • The candidate should be a system thinker.
  • Strong knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3.
  • Enjoy Event-Driven Design Patterns and Event Sourcing.
  • Familiar with Document Store Databases (like Cosmos DB / Mongo DB).
  • Knowledge in Modular Architecture and Microservices.
  • Comfortable leading large technical projects.
  • Knowledge of any cloud services AWS, Azure, Google Cloud.
  • Good understanding of ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)).
  • Experience with architecture styles/APIs (REST, RPC).
  • Understanding of Agile methodologies.
  • Strive for continuous improvement and build continuous integration, continuous development, and constant deployment pipeline (CI/CD Pipeline).

• Bachelor’s Degree in Computer Science or Information Technology
  
  

• Excellent writing skills
• Proficient in Web use, Outlook and Microsoft Office
• Travel as needed

You will get while working with us

• Opportunity to work on highly distributed systems with micro-services architecture and big-data volumes
• Solve challenging real-world problems by leveraging OOP & functional programming concepts
• Opportunity to incubate an open source project
• Get to work with cutting edge technologies to name a few Kafka, Elasticsearch, Postgres, Scala
• Developing scalable, sustainable and reliable enterprise systems
• Hands-on experience of working with TDD and BDD
• Develop environment using practices such as Continuous Integration, Continuous Delivery
• Learning opportunity on how to turn complex business requirements into a working product

Roles & Responsibilities

• Requirement understanding & analysis by interacting with client
• Carry out architectural and design discussions with fellow team members and come up with right approach
• Understand system domain, user’s perspective of system and use-cases
• Understand patterns in existing code and effectively leverage and improvise it 
• Develop backend involving Java8 based functional programming and REST services
• Ensure best practices of code reviews, automated testing and CI
• Research new tools & technologies required for the projects
• Mentor fellow team members and bring their level up

Must have

• Strong hold on written/verbal communication
• Strong core Java fundamentals
• Strong Analytical & problem solving skills
• Proactive and inherent nature of working with ownership
• Passion of writing clean code
• Experience in designing relational data model from business requirements

Good to have

• Knowledge of functional programming (Scala or Java 8 lambda)
• Knowledge of NOSQL
• Working knowledge of linux & networking
• Performance optimisation - Optimise/refactor queries, code, stored procedures to take performance next level

Job Description

Responsibilities: -

• To understand the specifications and programmed it.
• To articulate unit test case and unit test the programmer
• Producing clean, efficient code based on specifications.
• Verify and deploy programs and systems.
• Gather and evaluate user feedback.
• Recommend and execute improvements.

Job Requirement: -

• Experience in Microsoft ASP, C#, SQL server, and github.
• Experience with software design and development in a test-driven environment.
• Experience with databases.
• Ability to learn new languages and technologies.
• Good communication skills.

Who can Apply: -

Education: -No bar

Experience: -Good to have:- BFSI domain and professional certification

We are looking for a senior .NET Core professionals with 2+ years of development experience, who thrive on challenges and desires to make a real difference in the business world.

You are required to have skills in the following areas:

• 2 to 4 years of experience in. NET Core  development.
• Knowledge and Hands-on experience of at least 2 years on ASP.Net, C#, MS SQL Server, Restful, C# 3.5/4.0, MVC
• Desirable Skills: Excellent written and verbal communication skills. Excellent analytical and troubleshooting abilities.
• Solid understanding of best practices in web application development.
• Exceptional attention to detail and design.

• Job Title:- Microsoft Tech Developer
• Job Location:- CG Road, Ahmedabad(Mobile and flexible), WFH is available, sometime you have to come attend business meetings
• Desired Skills:- ASP.Net, C#, Database Design, MySQL, MSSQL, Bootstrap, SQL Server

Job Description

Responsibilities:-

• To understand the specifications and programmed it.
• To articulate unit test case and unit test the programmer
• Producing clean, efficient code based on specifications.
• Verify and deploy programs and systems.
• Gather and evaluate user feedback.
• Recommend and execute improvements.

Job Requirement:-

• Experience in Microsoft ASP, C#, SQL server, and github.
• Experience with software design and development in a test-driven environment.
• Experience with databases.
• Ability to learn new languages and technologies.
• Good communication skills.

Who can Apply:-

Education:- No bar

Experience:- Good to have:-BFSI domain and professional certification