SQL Developer

Hybrid / On-site (Bangalore)

What is the role?

Xoxoday is looking for a candidate who has a strong background in the design and implementation of scalable architecture and a good understanding of Algorithms, Data structures, and design patterns. Candidates must be ready to learn new tools, languages, and technologies. We are offering hybrid / remote options as well.

Basic Qualifications:

• At least 4 -7 years of experience as a software developer.
• At Least 3 years of experience in .net core C#, AWS stack, MS SQL Server, MVC, NodeJS experience is a plus
• Strong working knowledge in distributed event-driven messaging architecture/platform
• Strong knowledge in data access layer especially ability to work with stored procedure
• Established and stimulated software development standards and processes along with best practices for delivery of scalable and high-quality software.
• Production experience with AWS stack
• Fluent English speaker

Preferred Qualifications:l

• Experience working with OOP languages.
• Experience designing and developing Microservices and SOA.
• Experience working with AWS Kinesis, Lambda, SQS, S3, ElastiCache, ElasticSearch, Kubernetes, EventBridge, RDS, CloudWatch, APIGateway
• Experience designing and building high-performance scalable web services.
• Experience in REST API design and implementation.
• Experience in unit testing, test automation, and continuous delivery.
• Experience with stream-processing and message-broker software.

Nice to have:

• Experience working with distributed teams.
• Ability to work independently and as part of a team.
• Ability to work quickly toward tight deadlines, and make smart tradeoffs between speed, accuracy, and maintainability.
• Bachelor's or Master's degree in computer science (or equivalent professional experience).

A wholesome opportunity in a fast-paced environment that will enable you to juggle between concepts, yet maintain the quality of content, interact, and share your ideas and have loads of learning while at work. Work with a team of highly talented young professionals and enjoy the benefits of being at Xoxoday.

Xoxoday is a rapidly growing fintech SaaS firm that propels business growth while focusing on human motivation. Backed by Giift and Apis Partners Growth Fund II, Xoxoday offers a suite of three products - Plum, Empuls, and Compass. Xoxoday works with more than 2000 clients across 10+ countries and over 2.5 million users. Headquartered in Bengaluru, Xoxoday is a 300+ strong team with four global offices in San Francisco, Dublin, Singapore, New Delhi.

We look forward to connecting with you. As you may take time to review this opportunity, we will wait for a reasonable time of around 3-5 days before we screen the collected applications and start lining up job discussions with the hiring manager. We however assure you that we will attempt to maintain a reasonable time window for successfully closing this requirement. The candidates will be kept informed and updated on the feedback and application status.

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

Company Overview

CareStack is a complete cloud-based dental software solution for scheduling, clinical, billing, patient engagement, and reporting needs of dental offices of any size - whether it's a single location or a large multi-site DSO with hundreds of locations.

The company was founded in 2015 and the commercial launch was done in early 2018. Since then, more than 1000 offices have chosen CareStack as their single source of truth. This is the fastest growth till date in the dental practice management software market, dominated by 100 year old distribution companies.

More about CareStack

●    Rated by independent B2B software reviews and research analysts as the most modern, innovative and customer experience focussed company in the space with the fastest growth in the segment.

●    Important strategic go to market partnerships with dental industry leaders like Delta Dental, Darby Dental and several others.

●    Venture backed with over $60M raised from leading financial and strategic investors.

●    HQ'd in Orlando, FL with offices in Minnesota, Bangalore, Trivandrum and Cochin.

Role Overview

CareStack seeks to hire Software Development Engineer - 1 to build its next generation healthcare platform. You will be reporting to a Staff SDE in your business unit , to develop and release services and solutions for our platform, aligning with your business unit’s goals and objectives.

Key responsibilities

●    Technical Design

You can be a specialist in technology areas, but capable of creating complete designs to solve a specific problem that accomplishes a definitive product feature or enables a technical advancement.You should work with your lead to review your design and embrace the feedback

●    Process Definition/Adherence

You should deliver estimations, review test scenarios/cases created by QAs in your team, participate in sprint grooming and planning meetings. You must learn, practice and evangelize standard techniques for grooming, defining complexity of stories and estimation.

●    Code Quality

At Carestack we believe that your code reflects your character. Code for scale, produce maintainable reusable code. You must commit to clean coding, continuous refactoring to ensure a high level of code quality. Continuously learn, practice and evangelize coding patterns/best practices within and outside your team. You should ensure testability of team functional areas, facilitate integration testing, resolve deep rooted technical issues and proactively collaborate with team members in solving complex problems.

●    Team Player

You should proactively communicate to resolve dependencies within and outside the team. Understand organizations culture code and streamline conversations and activities that will further instill this code. Mentor and coach new additions to your team.

●    Value/Mission Alignment

Be a champion for CareStack within the Engineering team. Help drive workplace and cultural norms within your business unit that align with CareStack company values.

This role may be for you if you…

●    Have an insatiable itch to join and the courage to scale an early-stage technology company.

●    Have 2-4 years of experience in building modern day web platforms, using Microsoft technologies on the backend.

●    Can be a generalist or specialist with deep understanding of building software components that meet defined requirements, with good understanding of .NET Core/ASP.NET.

●    Are proficient in data structures and algorithms, and object oriented analysis and design of software systems.

●    Are a backend specialist with good understanding of event driven programming, distributed systems, caching/in-memory computing systems, data modeling for transactional systems.

●    Solid understanding of relational and non relational databases including warehouses.Preferably MySQL, MSSQL, Vertica and CosmosDB

●    Solid understanding of CI/CD patterns and IaC.

●    Expertise in building ETLs in both batch and streaming model.

●    Expertise in building and testing APIs and micro services

This role may not be for you if you…

●    Don’t have the itch to design solutions and write code and you don’t grab every other opportunity to review and write code.

●    Don’t have the fire in you to fight for your design suggestions and debate with logical data points

●    Don’t have the trait to be transactional in code reviews/design discussions, accept your mistakes and appreciate better ideas from your peers.

●    Haven’t developed the habit of doing objective conversations that are data driven.

• 5+ years of object-oriented software development of web applications
• 5+ years of C# in a .NET environment
• Preferable Experience in Cloud Technologies (AWS, AZURE)
• Experience with MS SQL stored procedures, database design and optimization
• Experience developing and utilizing web services
• Experience with high volume consumer oriented web sites
• Experience working in an Agile Scrum environment
• Experience with formal test procedures, release management
• Preferable Travel industry experience preferred, especially programming associated with GDS’s - SABRE, Farelogix, and Travelport
• Ability to distill complex business needs into functional requirements
• Excellent follow-up, verbal and written communication skills
• Excellent problem solving skills and an ability to make good decisions
• Team player with a professional attitude
• Ability to manage multiple tasks and maintain tight schedules
• Ability to work effectively with a geographically dispersed team in India

Strategic and Development Responsibilities

• Ability to "think outside the box"
• Ability to provide accurate and timely project estimates.

Pluses:

• Experience with Angular JS frameworks and Mobile Development.
• Experience with developing machine learning algorithms.
• Experience on projects that required localization/globalization
• Experience with MS SQL Reporting Services
• Knowledge of web farm configuration and best practices

Software Tools/Languages

Required:        MS Visual Studio, MS SQL Server Management Studio, IIS, AWS

C#, Web Services, MS SQL (stored procedures), Jenkins, DevOps Tools.

Education

Expereince: 3-5 years

Domain: SQL server/SSIS/Cloud technology

Good Knowledge in Creating new tables in database.

Using Triggers, trunket,delete,view,etc

We are looking for some one with 3+ Years of experience  with Microsoft technologies including.NET, ASP.Net Core MVC, C#, MS SQL Server. WPF, WCF C#, ASP.NET, XML, XSL, scripting languages including JQuery/JavaScript and HTML. 

Good to have knowledge with SQL Server 2012, indexing and queries and SSIS/SSRS.

Has Implemented Ajax Controls in C# . Net Projects

Complete understanding of MS SQL Database. Data modelling to visualize database structure.

Writing queries use for front‐end applications (websites, desktop applications, Mobile App or cloud apps).

Good understanding of Reviewing query performance and optimizing code.

Designing and coding database tables to store the application’s data.

Creating database triggers, stored procedures & functions.

Creating table indexes to improve database performance.

Has experience in writing unit tests & performing unit tests on own codes.

Responsibilities:‐

• To be responsible for managing technology in projects and providing technical guidance / solutions for work completion.

• To develop and guide the team members in enhancing their technical capabilities and increasing productivity.

• To ensure process compliance in the assigned module and participate in technical discussions/review.

• To prepare and submit status reports for minimizing exposure and risks on the project.

• Experience working with MVC framework.

• Hands on experience on various design patterns

• Experience in Unit testing development.

• Good to have experience on Team foundation server and Agile Development.

• Oversee and review code as required.

• Drive implementation and address technical roadblocks that the team is facing.

• Experience with diagnosing performance and/or memory issues is a plus, including using relevant profiler tools.

• Oversee and assist during system testing, UAT and deployment.