
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.


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


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

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


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.
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage

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
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:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- 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.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- 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).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- 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



