Senior Database Developer - Data Modeling & DB Design Schema

Job Title : ASP.NET Developer

Experience : 4+ Years

Location : Noida

Work Mode : Hybrid (Ad-hoc office visits as required)

Job Summary :

We are seeking an experienced ASP.NET Developer with 4+ years of hands-on experience in developing web applications using Microsoft technologies.

The ideal candidate should possess strong expertise in C#, ASP.NET MVC/Core, SQL Server, REST APIs, JavaScript, jQuery, JSON, and XML, along with a solid understanding of OOP concepts and scalable application design.

Mandatory Skills :

• C#, ASP.NET MVC, ASP.NET Core
• SQL Server
• REST APIs/Web Services
• JavaScript, jQuery, JSON, XML
• Object-Oriented Programming (OOP)
• .NET Framework
• Version control tools (SVN preferred)

Required Skills :

• 4+ years’ experience in web development.
• Ability to fully code in C# / ASP.NET / SQL Server / Rest API / Web Services / JSON / jQuery / JavaScript / XML / ASP.NET MVC / ASP.NET Core.
• Knowledge of .NET web framework.
• Proficient in C# with a good knowledge of their ecosystems.
• Strong understanding of object-oriented programming.
• Knowledge of Microsoft SQL Server.
• Experience with popular web application frameworks.
• Understanding of fundamental design principles for building a scalable application.
• Basic understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds.
• Proficient understanding of code versioning tools such as SVN.

Note :

Candidates should be available to visit the office whenever required for meetings, KT sessions, or project discussions.

You should have at least 7 years of C# coding experience.

should be well versed in following standard coding practices.

understand design and implement functionalities within timelines

should be able to implement common design patterns as and when required.

• 2+ Years of proven development experience in developing applications in .net including development for web and desktop applications.

• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))

• The candidate should have strong analytical skills and an eye for detail.

• Applicants must exhibit self-motivation and a willingness to do what it takes to succeed

• Excellent troubleshooting and communication skills

Skills That Will Help You In The Role

Must-Have Skills: ASP.NET MVC, Web API, .Net Core, C#, VB.Net, WinForms, Entity Framework, LINQ, ADO.Net, SQL server/ MySQL

Good to Have:  AngularJS/Angular , cloud infra including Azure, AWS, mobile technologies, wpf 

Design, develop and deploy .NET applications with SQL Server as the back-end. Responsible for database design, database object development, performance optimization and advanced MySQL programming.

Job Description

- Build applications using .Net 4.0 VB.Net / Asp.Net / C# / SQL server.
- Ability to understand business requirement and convert them to applications.
- Ability to perform both as an individual and in a team and completing the given tasks on time.
- Experience Required: 2 - 3 years

Strong experience in ASP .NET, MVC, C#, WCF, SQL, WEB API,
Must have experience in application development
Able to work independently/ with limited guidance
Experience in complete SDLC Good communication skills

If interested, ase share your resume at pooja at webshree.com

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

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

• Utilize established development tools, guidelines and conventions including but not limited to ASP.NET, SQL Server, HTML, CSS, JavaScript, and C#/VB.NET
• Prepare and maintain code for various .Net applications and resolve any defects in systems.
• Prepare test-based applications for various .Net applications
• Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement

• Manage defect tracking system and resolve all issues and prepare update for systems
• Investigate and develop skills in new technologies
• Create technical specifications and test plans
• Monitor everyday activities of system and provide require support

• Required experience in .Net Core 2.2 and above, Web API, EF, AWS or Azure Cloud
• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Snaplogic (both ground and cloud plex ) or Biztalk ( basic administration , simple xlt translations, and Api management ) or any other similar tool
• Update to .net 50 and Microsoft CORE 30 general coding practices
• Visual Studio use for C#
• Shared library through Nugget
• Unit Test / Test driven methods (use of Xunit and MOCK )
• Concepts of “;” service threading, caching, injection, NTier and entity 
• GIT repository (Gitflow branching strategies )
• Azure DevOps pull requests, commitments and Task usage
• SQL artifact writing (sprocs, tables, triggers , indexes, FKs ,and PKs)
• SQL understanding of relational database models

• Should have good problem-solving abilities
• Should be able to troubleshoot issues and determine the cause of a plan’s success or failure
• Should keep up to date with changes in the market and technology that would affect
• Good interpersonal and communication skills
• Comfortable to work as per client requirements/time zones
• Should possess strong team handling experience