
MS SQL Server Developer
at creating value for our customers with innovative solutions
Work Location: Hyderabad
Experience:4 to 8 Years
Package:As per Market Standards
Notice Period:Immediate Joiners
Its a Full Time Opportunity with Our Client
Mandatory Skills:MS SQL Server Developer,T-SQL,Performance tuning,SSIS,DTS Migration & ETL Data Flows
Roles & Responsibilities:
--Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server in Production, Testing and Development.
--Experience in installation, configuration of MS SQL Server
--Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL --Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
--Knowledge of Relational Database Management systems.
--Experience in Database Backup, Recovery and Disaster Recovery procedures.
--Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
--Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
--Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
--Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimisation.
--Install and Configure SQL Server on Virtual Machines.
--Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data --Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
--Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.

Similar jobs

Job Description
- Job Title:- Jr. Dot Net Developer- Asp.net / MVC / .Net Core
- Location:- WFH(temporary), Timing:- 10am to 7pm
- Employee Strength:- 20
- Days:- 6 days working 2nd and 4th Sat holiday
- Experience: 1yr to 2yrs
- Industry: IT-Software / Software Services
- Functional Area: IT Software - Web Application Programming, Maintenance
- Role Category: Programming & Design
- Key Skills:- Asp.Net, MVC, .Net Core, C#, MSSQL Server
- Education- Tech/B.E./ B. Sc/ MCA/ M. Sc/ M. Tech
Experienced in
- Experience with *http://asp.net/">NETMVC/C# & database analysis, design and querying with SQL Server including Visual Studio 2019, Angular JS, C#.NET, http://asp.net/">ASP.NET, MVC, WCF Web Services...etc.
- Knowledge of Design Patterns
- Experience working with distributed items
- Expecting developer can work individually or in a team
- Experience with MVC, C#, SQL Server
- Experience with jQuery, HTML5, XML, JSON &CSS.


- Participate in requirements analysis and design
- Development of Web applications and RESTful APIs using C#, .NET Core, ASP.NET Core, .NET Framework 4.7, C#, ASP.NET MVC, LINQ, Entity Framework 6.0, EF Core
- Development of Microservices using Clean Architecture, CQRS, .NET Design Patterns, SOLID Principles and Object-oriented design & analysis (OOA & OOD)
- Development of Microservices using Microsoft Azure or AWS, Dockers and Kubernetes
- Write clean, scalable code using .NET programming languages (C#)
- Write Microsoft SQL queries and optimize both external and internal DB processes and procedures.
- Use automation tools, following CI/CD best practices in an established DevOps team.
- Write unit and integration tests using Moq
- Collaborate with internal teams to produce software design and architecture
- Develop documentation throughout the software development life cycle (SDLC)
- Serve as an expert on applications and provide technical support


Responsibilities
- Develop quality software and web applications
- Analyse and maintain existing software applications
- Create and maintain SQL databases, tables, views, stored procedures etc. (Microsoft SQL Server 2008+)
- Design highly scalable, testable code
- Discover and fix programming bugs
- Monitor and maintain application security and integrity
- Communicate project status and identify technical risks
- Evaluate and recommend appropriate technologies based on product needs and industry trends
Desired Skills:
- Develop quality software and web applications
- Excellent communication and organisational skills, must be a team player
- Excellent analytical skills
- Ability to work in a fast-paced environment
- Ability to stay focused and deliver on time and on budget
- An up-to-date, working knowledge of current, past, and projected trends in the industry
- Knowledge of AI Techniques such as Neural Network Programming would be an asset
- Knowledge of Steering Behaviors Programming Techniques would be an asset
Qualifications
- Strong knowledge in .NET platform (ASP .NET) and C#
- Strong knowledge of Microsoft SQL Server 2008+ and T-SQL language
- Proficient in MS Visual Studio and TFS, including application build/deployment
- Knowledge and experience with creating and consuming web services
Educational Requirements:
Bachelor's degree diploma in computer science or software engineering


Detailed JD:
Responsibilities:
- Interface with product owners and software architects to review and finalize requirements
- Participate in the full SDLC including analysis, design, development, testing, deployment, and support
of new features and applications
- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning,
and Requirement discussions)
- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders
- Provide innovative solutions to complex problems
- Design, develop and modify software applications/systems according to specifications
- Develop technical documentation including services, object, and data model
- Create high quality code and perform code reviews
- Create unit and integration tests to ensure the code quality and functionality
- Proactively learn and share knowledge of technology and compare advantages and disadvantages of
alternative solutions/technologies
- Identify areas needing process improvements and see them through to resolution
- Support and coach other Developers, provide technical guidance
- Help onboard new team members
Tech Stack:
C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Web API


- Write clean, scalable code using .NET programming languages
- Develop technical interfaces, specifications, and architecture
- Develop client displays and user interfaces
- Assist software personnel in handling project-related work and other requirements
- Coordinate with other software professionals and developers
- Familiarity with the.NET framework (Like DotNet Core, MVC), SQL Server, and design/architectural patterns.
- 2+ years of development experience using C# .NET
- Knowledge of at least one of the .NET languages (e.g. C#, .NET) and HTML5/CSS3
- Excellent troubleshooting and communication skills

- Strong knowledge of .NET web frameworkwith .Net 3.5/4.0 Version.
- Experience on web-based projects using NET, C# and MS-SQL Server, JavaScript.
- Strong understanding of object-oriented programming.
- Skill for writing reusable libraries.
- Familiar with various design and architectural patterns.
- Knowledge of concurrency patterns.
- Familiarity with Microsoft SQL Server.
- Experience with popular web application frameworks.
- Familiarity with Windows Presentation Framework.
- Knack for writing clean, readable, and easily maintainable code.
- Understanding of fundamental design principles for building a scalable application
- Experience creating database schemas that represent and support business processes.


As discussed, Please find the below details about our company
About TraviYo
TraviYo is established on 15th June 2016. The major mandate of the company is to provide technology solutions to Travel Agents, a hassle-free automated platform to Generate Business, Manage operations, and Track Transactions that would eventually help increase revenue generation. TraviYo is awarded by the start-up India program and funded by SIDBI ventures. The major mandate of the company is to provide service to Travel Agents, a hassle-free automated platform to Generate Business, Manage operations, and Track Transactions that would eventually help increase revenue generation. As an extension of this product, TraviYo provides a CMS-based dynamic website and Mobile APP for both android and iOS platforms.
Job Profile
· Develop and support for the project developed on MVC/ASP .Net, C#, and SQL Server.
· Understanding requirements and design the solution of complex problems using Microsoft Workflow
· Must be capable of on-time implementation and release for production
· Open to work on new technologies
· Can able to work individually and in a team
· Sound knowledge on SQL query optimization
Please go through the details and share your confirmation for the same.

Good understanding of MVC, C#, MS SQL Server, JS, Visual Studio 2017
Experience: Minimum 3 Year.
RoleSoftware Developer
Industry TypeIT-Software, Software Services
Functional AreaIT Software - Application Programming, Maintenance
Employment TypeFull Time, Permanent
Role CategoryProgramming & Design
Education
UG: B.Tech/B.E. in Any Specialization, B.Sc in Any Specialization, BCA in Computers
PG: Any Postgraduate in Any Specialization
Interested candidates Kindly apply
Job Types: Full-time, Contract, Walk-In
Job Types: Full-time, Walk-In

- - 2+ years experience in application support on Asp.Net and SQL
- - Should be able to debug production issues and bug fixes
- - Should be able to write queries for extracting data using joins
- - Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator
- - Provide daily status updates and time-sheets to on-site and offshore project
- - Ready to work in shifts
- - Knowledge Transfer / Training to stakeholders
Personal Attributes
- - Good communication skills
- - Highly committed and able to work independently and as a team
- - Positive attitude towards learning
- - Deadline orientated and escalate in advance in case of delays
- - Contribute towards improving quality, standardization and documentation for all
- changes & Support activity
- - Ability to remain calm in a fast-paced and highly pressure environment

Mandatory Requirement/ Preference:
- 4 years of experience for delivering enterprise solutions or products using full SDLC
- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework)
- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.
- Working with WEB API added advantage

