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
1. Excellent knowledge with proven implementation experience of C# and .Net framework (version 4.5 or higher) 2. Excellent knowledge with proven implementation experience of Transact SQL and SQL Server (2012 or higher) 3. Experience working within Agile projects and Scrum in particular 4. Excellent technical analysis and investigatory skills 5. Mandatory Investment Banking sector experience 6. Must be open to exploring the potential of and transitioning to alternative technology platforms to .NET 7. Excellent knowledge with proven implementation experience of Design Patterns and SOLID principles 8. Excellent communication skills and the confidence to challenge |
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
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.
- 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 analytical and Problem solving skills.
Strong knowledge of .NET web framework includes ASP.NET, ASP.NET MVC, .NET Core (Nice to have) , Web API, LINQ , HTML, JavaScript, jQuery, AJAX and CSS
Experience designing, developing, and deploying Web Services and Web apps on IIS.
Comprehensive understanding of object-oriented and service-oriented application development techniques and theories
Experience with debugging, performance profiling and optimization.
Experience with git source control
Familiarity with writing unit tests
Familiarity with micro services.
Ability to take a project from start to finish with or without supervision
Strong communication skills with both internal team members and external stakeholders
Good to have team handling experience
- 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.
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.
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
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