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.
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs
.NET
C#|
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 |
.NETC#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
.NETC#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
.NETTechnical 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
.NETC#
jQuery- 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.
.NET
Javascript- 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.
Java
Go Programming (Golang)C#
Ruby on Rails (ROR)
NodeJS (Node.js)The database market is massive (the IDC estimates it to be $119B+ by 2025!) and MongoDB is at the head of its disruption. The MongoDB community is transforming industries and empowering developers to build amazing apps that people use every day. We are the leading modern data platform and the first database provider to IPO in over 20 years. Join our team and be at the forefront of innovation and creativity.
MongoDB is expanding our global team of consulting engineers to further our ongoing plans for worldwide growth!
MongoDB Professional Services works with customers of all shapes and sizes in all verticals, from tier-1 banks to small web startups, on a variety of interesting use cases from e-commerce platforms to trading systems to social media applications. Solve interesting problems, gain incredible cross-stack experience, work with the best and brightest people in the business, network with industry leaders, and see new places - all in a day’s work!
MongoDB consulting exists to support the development of our customers’ vision, accelerate customers’ time to value, and drive a multitude of customer adoption scenarios - from building new solutions to modernizing legacy applications or migrating to the cloud. Our consulting solutions ensure that organizations get the best out of MongoDB.
Be one of the recognized experts in this rapidly growing field in a high-growth software company successfully challenging the status quo of the database industry.
Shift Timing
You will get an opportunity to work with Global customers (APAC, EMEA, and North America) So this would require you to work in monthly rotational shifts.
This role can be based out of our Gurugram/Bangalore Office or remotely in the India region.
Candidate Profile
We’re looking for a highly technical individual, with strong problem-solving and communication skills, and is comfortable working closely with customers.
Our ideal candidate will have
- Excellent analytical, diagnostic skills, and problem-solving skills
- High motivation for a role that combines deep technical and customer-management dimensions
- Confidence speaking and presenting in a collaborative customer setting
- 4+ years of software development/consulting/support experience, preferably in a number of distinct industries/verticals
- Familiarity with enterprise-scale software architectures, application development methodologies, and software deployment and operations
- Competence in at least one of the following languages (in no particular order): Java, C#, Python, Node.js (JavaScript), Ruby, Go.
- Experience with databases such as MongoDB, Oracle, MS SQL Server, PostgreSQL
- Familiarity with Linux diagnostics and tuning; Windows tuning knowledge is a plus
- Should have the strong capability with, minimally, both English and any local language - as necessary
Position Expectations
As a core member of the MongoDB Professional Services team, you will
- Contribute to helping migrate customers from self-hosted MongoDB on-prem/cloud to Atlas
- Contribute to customer implementations at any or all phases of the application lifecycle: portfolio assessment, application planning, and design, deployment architectures, development and build, integration and release configuration, system testing, production operations, application optimization, and best practices adoption
- Work as part of a wider delivery team comprising fellow consulting engineers, project managers, and account teams
- Cultivate your individual MongoDB reputation as a trusted advisor to guide MongoDB and our customers into the future
- Partner with Product and Engineering teams to influence the direction of the MongoDB product roadmap
Success Measures
As a Consulting Engineer, you will be successful in this role when you can execute the following
- Become a field expert in “everything MongoDB”
- Communicate complex technical proposals simply and convincingly to a wide range of audiences
- Gain a reputation as a trusted advisor with your clients, large and small
- Ensure your client’s success with their MongoDB endeavors
- Maintain the required level of billable utilization
- Influence MongoDB product development by contributing experience from the field
- Successfully communicate the product roadmap to external clients
- Constantly work on improving yourself, our products and our team
Do you know, Why MongoDB is a fantastic place to work and build your career?
- Top NoSQL database in the world
- Largest Ecosystem and the fastest growing database in the world
- Close to 26,800 customers in more than 100 countries and over 175+ million downloads
- Sequoia Capital and a number of other Top VC firms have invested in MongoDB. Sequoia Capital calls us out as one of their flagship portfolios; Sequoia has also invested in Apple, Google, Youtube, and WhatsApp
- 9-figure revenue company, with very high double-digit growth rates
- Be a part of the company that’s reinventing the database, focused on innovation and speed
- Enjoy a fun, inspiring culture that is engineering focused
- Work with talented people around the globe
- Learn, contribute, and make an impact on the product and community
Life at MongoDB
Our India office culture
- 300+ people, with teams in Sales, Engineering, HR, Finance, IT & Marketing
- Regular group outings and opportunities to get to know your colleagues
- Employee affinity groups
Our Benefits
- Competitive salary and equity
- Comprehensive Health cover, dental cover, travel insurance & Life Insurance.
- Free lunch twice per week and a fully stocked kitchen with healthy and sweet treats in office.
- Macbooks are company standard
- 26 weeks Maternity & 20 Paternity leave to spend time with new arrivals
let’s check out the below link to know more about the role and Flex Consulting Team in India:
https://www.mongodb.com/blog/post/meet-our-growing-flex-consulting-team
To drive the personal growth and business impact of our employees, we’re committed to developing a supportive and enriching culture for everyone. From employee affinity groups to fertility assistance and a generous parental leave policy, we value our employees’ wellbeing and want to support them along every step of their professional and personal journeys.https://www.mongodb.com/blog/channel/culture"> Learn more about what it’s like to work at MongoDB, and help us make an impact on the world!
MongoDB is committed to providing any necessary accommodations for individuals with disabilities within our application and interview process. To request an accommodation due to a disability, please inform your recruiter.
MongoDB is an equal opportunities employer.
.NETGood 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
.NET- - 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
C#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
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon