MS SQL Server Developer at creating value for our customers with innovative solutions · Hyderabad · 4 - 8 years · ₹6L - ₹15L / yr · Posted 5 Aug 2021
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 (10)
Job Title : Perl Developer
Experience : 6+ Years
Engagement Type : C2C (Contract)
Location : Remote
Shift Timing : General Shift
Job Summary :
We are seeking an experienced Perl Developer with strong scripting and database expertise to support an application modernization initiative.
The role involves code conversion for compatibility between Sybase and MS SQL, ensuring performance, reliability, and maintainability of mission-critical systems.
You will work closely with the engineering team to enhance, migrate, and optimize codebases written primarily in Perl, with partial transitions toward Python for long-term sustainability.
Mandatory Skills :
Perl, Python, T-SQL, SQL Server, ADO, Git, Release Management, Monitoring Tools, Automation Tools, CI/CD, Sybase-to-MSSQL Code Conversion
Key Responsibilities :
- Analyze and convert existing application code from Sybase to MS SQL for compatibility and optimization.
- Maintain and enhance existing Perl scripts and applications.
- Where feasible, refactor or rewrite legacy components into Python for improved scalability.
- Collaborate with development and release teams to ensure seamless integration and deployment.
- Follow established Git/ADO version control and release management practices.
- (Optional) Contribute to monitoring, alerting, and automation improvements.
Required Skills :
- Strong Perl development experience (primary requirement).
- Proficiency in Python for code conversion and sustainability initiatives.
- Hands-on experience with T-SQL / SQL Server for database interaction and optimization.
- Familiarity with ADO/Git and standard release management workflows.
Nice to Have :
- Experience with monitoring and alerting tools.
- Familiarity with automation tools and CI/CD pipelines.
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
Lead Developer
Qualification:
Science / Engineering graduateResponsibility:
Requirements Gathering:
- ' Participate in requirement gathering JAD (Joint Application Development) sessions and support documentation where applicable (business functional Technical UI usability data compliance data migration NFR 3rd party tools & products).
- Raise queries and get query resolution on areas which are unclear ambiguous and which need more information to the Technology Lead.
Project Estimation:
- ' Understand how the estimation (effort size etc) is done at task level in the area of work concerned measure and report the actual effort against the estimated effort and ensure task progress reporting in C20 or any other applicable tool.
Capability Development:
- Become an expert in the core skill and develop additional skills.
Design & Analysis:
- ' Create the HL Design and detailed design document with the support of architects for the assigned scope.
- Review all deliverables created by the Developer.
- Study non functional requirements and design for NFR as required.
- Understand the interdependencies of the various components in work packages being developed.
- Create detailed design and assign to developer.
- provide input to the Project Manager / Technical Lead to create the project plan from a technical perspective.
- support development of proof of concept as designed by Designer / Solution Architect.
- initiate development environment setup.
- Provide demo to customer for early feedback.
- create quality check points for all deliverables.
Coding:
- ' Develop tier coding business layer coding interface development service development creation of stored procedures etc as applicable for the work package / project.
- CTS and customer specific coding standards guidelines and best practices.
- Understand the database concepts and write efficient queries.
- raise clarifications / issues / concerns regarding work output to the lead.
- Seek review from peer / technical lead periodically.
- participate in setup activities for required environment setup.
- deploy code build in testing environment.
- conduct peer review during design coding and testing.
- Complete documentation as per the scope.
- prepare guidelines and checklist for development and testing activities.
- Provide feedback to design team.
- share feedback with developers to check if code is as per requirements.
- Incorporate changes as per feedback.
- provide necessary and timely status updates to the Supervisor / Technical Lead.
- Highlight any potential risks to the leads.
- Update traceability matrix for the work package developed.
- mentor the Developers to help them solve technical difficulties in the course of coding.
- Follow the SCM policies set for project.
- raise clarifications / issues / concerns regarding work output to the lead on time.
- provide necessary and timely status updates to the Supervisor / Technical Lead.
- Proactively highlight any potential risks to the lead.
- provide support on process audit activities.
- adhere to process and tools (usage of cognizant 20 awareness of Quality Management System).
Testing:
- ' Develop comprehensive unit testing cases and unit test plans.
- conduct comprehensive unit testing.
- create unit test logs.
- Prepare and support in preparation of unit test strategy.
- plan document and data requirements.
- automate unit testing and contribute to automation of unit testing.
- Conduct peer review of unit test cases.
- perform developer integration testing by integrating the components.
- Review test cases as prepared by the Developer.
Defect Management:
- Participate in defect triage meetings.
- conduct RCA for defects identified.
- Rework on the code based on review comments from code review / defects raised in unit testing peer testing SIT UAT testing or any other relevant testing phases.
- Assist in transition of knowledge and to support organization with any defects raised post production as required.
Process Improvements and Adherence:
- Participate in innovation sessions.
- implement process improvements to reduce manual intervention (eg automation).
- support on process audit activities.
- Generate ideas to provide value add and share the same with the Technical Lead.
- Adhere to process and tools (usage of cognizant 20 awareness of Quality Management System IDE etc).
Knowledge Management:
- Contribute towards updating knowledge assets user manual online help document installation manual / scripts.
- Conduct knowledge transfer sessions for new joiners in the project team.
- conduct training through academy (if approved).
- Guide and mentor team junior members from a technical perspective to ensure quality delivery of the components.
- contribute / search / reuse all types of assets from repository.
People management:
- Engage with team.
- resolve / conflict management within team.
- conduct internal trainings for developers within team.
Must Have Skills
- WPF Performance Suite
- .Net Framework
- C++
Good To Have Skills
- C# Studio
- C#. Net Logger
- MS SQL Server
- .Net Programming-C# .Net
Primary Skills: Database Systems (SQL), Python Flask/Fast API/Django frameworks specifically
Requirements:
- Highly proficient in fundamentals of Python web development frameworks like Flask, Django and Fast API
- Demonstrated experience in developing APIs using Python frameworks
- Should have deep knowledge in PostgreSQL, MS SQL Server and other SQL based Databases
- Knowledge and proficiency in NoSQL is a bonus
What’s the job? Dot Net Developer
Where do I work? GyanMatrix
Experience 8-11 Yrs
Why are we here?
Mandatory skills
to have:
We are looking for a Dotnet Developer, who is motivated to combine the art of design
with the art of programming. Responsibilities will include implementing visual
elements and their behaviors with user interactions. You will work on Fullstack
developers to build all client-side logic. You will also be bridging the gap between the
visual elements and the server-side infrastructure, taking an active role on both sides,
and defining how the application looks and functions.
5+ years of experience in Classic ASP and JSP.
Should have 2+ years of experience in Tomcat Administration.
Should have 3 years of experience in SQL Server.
Good Coding and Designing Skills. Good Application Troubleshooting skills.
SQL Server 2019 – SQL Queries, procedures and functions.
Ability to interpret business requirements and translate into working software.
Web and UX proficiency.
- 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
- Designs, develops, modifies, debugs, and evaluates programs for functional areas
- Analyzes existing programs or formulates logic for new systems
- Devises logic procedures
- Prepare Flowcharting
- Performs coding and tests/debugs programs.
- Develops Conversion and System implementation plans
- Prepares and obtains approval of system and programming of documentation
- Recommends changes in development, maintenance, and system standards
- Train users in conversion and implementation of system
- Communicate with end users and understands the requirements in clearly.
Skills & Qualifications:
- Bachelor’s or master’s degree in engineering / MCA with 5+ years of solid software development experience using .Net environment using C#, VB.NET, ASP.NET, ADO.NET.
- Experience working with Manufacturing Execution System (Camstar) is a plus.
- Experience working with Web services and XML/ XSLT.
- In Depth knowledge of MS-SQL 2005/2008 including coding of SPs.
- Has a Solid background of Object-Oriented Analysis and Design and the use of UML views and diagrams.
- Has the ability to design and document software applications with minimal supervision.
- Experience in multi-platform software Development (DOS, Windows).
- Experience in developing software applications in a multi-tier architecture.
- Experience in presentation layer development using JavaScript, HTML, DHTML, Ajax and CSS.
- Experience in WCF / MVC is a plus.
- Experience is in Source Controls like SVN / TFS.
- Able to handle all phases of SDLC.
- 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.
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











