👨🏻‍💻 postech.work

Full Stack Developer (Specialisation in SQL Management and Perfromance Tuning)

Solution Details Pte. Ltd. • 🌐 Remote

Remote Posted 1 day, 12 hours ago

Job Description

Job Summary

We are looking for a Full Stack Developer with strong expertise in both front-end and back-end development, and a deep understanding of SQL database performance tuning and optimization. The ideal candidate will be adept at building robust, scalable applications while playing a critical role in diagnosing and resolving backend database bottlenecks. Exposure to Microsoft Azure is preferred but not the central focus.

Key ResponsibilitiesPrimary Focus – Full Stack Development \& Database Optimization (80%)

Design, build, and maintain full-stack web applications using modern frameworks and best practices.

Optimize relational database performance, with a focus on:

Query tuning and indexing

Execution plan analysis

Stored procedure optimization

Partitioning, caching, and load balancing strategies

Monitor, analyze, and troubleshoot SQL Server or similar RDBMS environments for latency and resource issues.

Refactor and enhance legacy database structures and backend codebases to improve efficiency and scalability.

Collaborate with DevOps and QA to implement automated testing and performance profiling.

Ensure backend data integrity, concurrency, and consistency across application layers.

Secondary Focus – Azure Cloud (20%)

Utilize Azure SQL Database, App Services, or Azure Functions where appropriate for scalable cloud deployment.

Implement basic monitoring and diagnostics via Azure Monitor, Log Analytics, or Application Insights.

Collaborate on simple infrastructure tasks (e.g., setting up cloud DBs, deploying apps) using Azure tools.

Required Skills \& ExperienceTechnical Proficiency

Strong backend development skills in C# (.NET Core), Node.js, Python, or Java.

Front-end experience with frameworks like React, Angular, or Vue.js.

Advanced SQL proficiency (T-SQL, PL/SQL) with a solid understanding of performance tuning.

Experience with SQL Server, PostgreSQL, or MySQL in production environments.

Familiar with tools like SQL Server Profiler, Query Store, EXPLAIN plans, and Database Engine Tuning Advisor.

Basic experience with Azure SQL, cloud storage, and deploying services in Azure.

Soft Skills

Strong analytical and debugging skills.

Clear communication with both technical and non-technical team members.

Collaborative, proactive, and comfortable in agile environments.

Preferred Qualifications

Bachelor's degree in Computer Science, Engineering, or a related field.

3+ years in full stack development roles with significant database work.

Performance optimization certifications or Microsoft SQL Server certification (plus).

Experience modernizing legacy systems and improving backend performance.

Work Environment

Agile teams, CI/CD workflows, Git-based version control.

Tech stack may include .NET, React, SQL Server, Azure DevOps, etc.

Support for remote work and flexible hours.

Encouragement of innovation and continuous improvement.

Job Types: Full-time, Permanent

Pay: $3,642.12 - $5,000.00 per month

Benefits:

Parental leave

Professional development

Work Location: In person

Get job updates in your inbox

Subscribe to our newsletter and stay updated with the best job opportunities.