Senior Database Developer - Data Modeling & DB Design Schema

• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)
• 5 years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Able to work well in a team setting

Envoy combines technology and global immigration services to offer the only immigration management platform that makes it seamless for companies to hire and manage an international workforce. We empower companies to acquire the best talent regardless of where they are in the world; helps mobilize employees around the world to take advantage of business opportunities; and enables the management of entire global workforces, providing a strategic, proactive view into workforce and financial forecasting and compliance. We are a fast-growing, award-winning technology company, a leader in our space, and are backed by some of the country’s leading venture capital and growth equity firms.

Our Engineering Team

We have a passionate product engineering team that works on complex technical challenges, employs creativity, and constantly learns a variety of frameworks, tools, and technologies. While we are dedicated to delivering excellent product, we also believe having fun along the way motivates us to pour our heart into what we do. Our team has mastered development and delivery process, allowing the team to focus on designing, architecting, and crafting masterpieces.

We are growing rapidly and expanding our team in India, join our product engineering team to be part of this exciting journey.

"Programming isn't about what you know; it's about what you can figure out.” - Chris Pine

Skills Required

• 8+ years of strong programming experience on .NET platform
• Expertise in C#, ASP.NET Web API / Typescript / Angular (or any front-end framework or passion to learn Angular)
• Hands on experience with SQL
• Azure experience is a plus but not a deal breaker
• Knowledge and experience with HTML, CSS, JavaScript (fundamental building blocks of web development)
• Experience designing high-level and low-level design of the system
• Experience with microservices architecture is a plus

Expectations

• Provide technical guidance to the team and take ownership of delivery
• Responsible to technically groom backlog items providing design, architecture, and implementation details
• Quality is the key driver to successful delivery, ensure highly testable and quality deliverables
• Leverage troubleshooting and analytical skills to analyze issues
• Experience with debugging, performance profiling and optimization

Envoy Global is an equal opportunity employer and will recruit, hire, train and promote into all job levels the most qualified applicants without regard to race, color, religion, sex, national origin, age, disability, ancestry, sexual orientation, gender identification, veteran status, pregnancy, or any other protected classification.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

Familiarity with the http://asp.net/">ASP.NET framework, SQL Server and Model-View-Controller (MVC) design pattern

Experience in writing database stored procedures

Good knowledge of REST / SOAP web services.

Understanding of Agile methodologies

Excellent troubleshooting and communication skills

Experience in GIT

• Work closely with Engineering and Product teams to provide platform features and components to support Ingenio’s business objectives.
• Participate in the design and development of the company’s e-commerce layer.
• Translate Product requirements into scalable technical solutions, write high-quality code, conduct unit testing, provide technical leadership, and communicate project status to team members and stakeholders.
• Influence technical debt by re-designing components and adopting new technologies 

What You'll Need To Be Successful

• 4 - 8 years of experience in software development.
• Expertise in C# and .NET framework.
• Expertise in developing services (SOAP-WCF and REST) and web development frameworks like ASP.NET MVC.
• Good knowledge of database concepts and Microsoft SQL Server.
• Solid foundation in computer science, with strong competencies in data structures, design patterns, concurrency, algorithms, and software design
• Research and evaluate new software, frameworks, and techniques to provide recommendations to the division.
• Design and develop robust and scalable software components.
• Strong analytical and troubleshooting skills.
• Bachelor's degree in Computer Science or a technical field.

• MSSQL, SSIS, Performance Tuning, Data modeling.
• Experience in No SQL tools is must
• Candidate should have exposure to write scripts in Python/Node JS/MongoDB or any other tool
• Maria DB/MYSQL, Mongo DB, Github, Jira
• Understand Requirements from client and on-site team.
• Participate in preparing design and data modelling.
• Comfortable with SQL Stored procedures and queries development.
• Comfortable with SQL Stored procedures and queries development.
• Manage SQL Server through multiple product lifecycle / environments, from development to critical production systems.
• Apply best in industry standard techniques for data modeling to ensure performance, integrate and requirement.
• Ability to analyze independently problems and resolve them on time.