MS SQL Server Developer

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 2^nd and 4^th 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

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

• 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.

• 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.

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

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.

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:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. 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.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. 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).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. 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

- 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

- 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