SQL / SSRS / .NET Core Expert

We're building a large scale learning & collaboration SaaS product with customers in Asia, Middle East and Africa and looking for an expert SQL Developer who's also specialized in .NET Core to join our fast growing team in Ho Chi Minh City and help drive our analytics and reporting modules.

You'll work closely with the front-end team and other back-end developers to build out the API, add new reports to our SSRS library and write complex SQL queries.

If you've had 3+ years of experience working with SQL, motivated by user happiness and ready for an exciting new set of challenges we'd love to hear from you:

You need to be a master of SQL, with expert level TSQL. Your job initially will be to help to automate complex functions based on a timed schedule, for example sending reminders to students to complete their assignments every week or to assign tasks to students after they've completed a course.

So you need to be able to translate business logic into a series of SQL queries and then automate that based on a schedule (e.g. weekly, daily, monthly, ad-hoc).

Also you need to be able to write detailed SQL reports. For example a report showing all the students who have attended training over the past 3 months, and merge data from their assessments, the mentor reports, marks from the teacher etc to create one single report which contains 10 to 20 different datasets.

Lastly you should be able to build and maintain our .NET Core API. We use Dapper as the ORM. There are around 2000 end points so it's a very big API and you should be comfortable working at scale.

Bonus: If you've had experience setting up CDN servers and DevOps like Jenkins and can help automate our builds and deployments that'll be great.

Here's a quick summary:

• TSQL: Write complex SQL queries which are optimized for speed. Work with Scalar and Table Functions and know best practices to handle data at scale.
• SSRS: End to end experience setting up an SSRS server and writing complex reports.
• .NET Core API: You should be able to maintain, debug and expand our .NET Core API
• Dev Ops: Set up automated deployment pipelines for our front-end and back-end deployments
• CDN and Caching: Set up CDN caches to improve performance especially for images for videos
• SignalR: You should have deep experience with real-time APIs
• 3rd Party Integrations and SSO

We're focused on building products that customers love using, and to do that we need to make sure you love working at Avnon so that you can focus and do your best work - so you'll have a high quality work environment, excellent management, new MacBook Air or Dell XPS (you can choose) with dual monitor setup and a clear understanding of what your job needs to focus on.

We'll support you with training, growth opportunities, gym and lunch budget, opportunity to practice and enhance your English speaking skills, trips to our office in Singapore if you reach manager level and exposure to the latest technologies and interesting challenges.