Senior Database Developer - SQL Server

We are seeking a highly skilled Senior Database Developer specializing in Microsoft SQL Server and Transact-SQL to support a critical system consolidation initiative.

In this role, you will lead database engineering activities to merge two country-specific application forks into a unified codebase, operating within an existing PHP7 / Windows / IIS / SQL Server ecosystem.

You will focus on database design, business logic refactoring, data restructuring, and performance optimization, ensuring scalability, consistency, and high system performance.

Responsibilities

Database Architecture & Consolidation

• Analyze and reconcile database schemas, structures, and data models across multiple system versions.
• Design and implement database solutions to support a single consolidated platform.
• Ensure data consistency, integrity, and maintainability across environments.

Database Development

• Refactor, redesign, and consolidate complex business logic written in Transact-SQL stored procedures.
• Develop scalable database components including stored procedures, functions, triggers, and scripts.
• Improve database maintainability and reduce technical debt.

Data Migration & Transformation

• Design and execute data restructuring, transformation, and migration strategies.
• Perform data validation and reconciliation during migration activities.
• Support deployment and rollout with minimal operational disruption.

Performance Optimization

• Analyze and optimize SQL queries, indexing strategies, execution plans, and database performance.
• Identify performance bottlenecks and implement tuning solutions.
• Ensure database efficiency for high-volume production workloads.

Cross-functional Collaboration

• Collaborate closely with Developers, QA Engineers, and Technical Leads during development, integration, and testing phases.
• Support troubleshooting, root-cause analysis, and system stabilization.
• Produce technical documentation related to database design and migration processes.

Requirements

Technical Requirements

• Strong hands-on experience as a Database Engineer / Database Developer working with Microsoft SQL Server.
• Advanced expertise in Transact-SQL, including complex stored procedures and query optimization.
• Proven experience in data migration, database refactoring, or legacy system consolidation projects.
• Strong understanding of database design principles and relational data modeling.
• Experience optimizing performance in production-scale systems.
• Familiarity with PHP-based applications, Windows Server, and IIS environments is an advantage.

Soft Skills

• Strong analytical thinking and problem-solving capability.
• Ability to work independently in complex technical environments.
• Effective collaboration and communication skills.
• High attention to detail and ownership mindset.

Nice to Have

• Experience in large-scale system modernization or platform merging projects.
• Knowledge of CI/CD pipelines for database deployment.
• Experience working in Agile/Scrum teams.

What we offer

• Attractive and competitive performance-based compensation package.
• Generous year-end 13th-month bonus.
• Loyalty and annual dedication rewards.
• 12 annual leave days, 11 public holidays, 1 Christmas day off and 5 sick leave days.
• Flexible check-in time, 1-day remote work per week, and the freedom to work from any of our offices (Ho Chi Minh, Da Nang, Hue, or Ha Noi).
• Comprehensive healthcare package and annual health check-ups.
• Team-building allowance, Annual company trips, and Gathering Party every Thursday for a fun and connected workplace.
• Sports & hobby clubs with football, badminton, biking, running, chess, or music band groups.
• Continuous learning & development with exclusive technical & soft skills training, English classes, and technical clubs.
• Financial aid for marriage, newborns, and bereavement to support you through every stage of life.

BACK TO CAREERS