Senior Database Performance Engineer

JOB DESCRIPTION:

Responsibilities

As a Database Performance Engineer at NSC, you will have the opportunity to work remotely, with fixed working hours from 7AM to 4PM Vietnam time (the rest is flexible). 

We are looking for a Senior Database Performance Engineer with deep expertise in MySQL/InnoDB and JPA/Hibernate optimization to lead performance improvements for our Business API.

At this level, you are expected to independently diagnose complex performance bottlenecks, design scalable database strategies, and drive cross-team optimizations that significantly improve latency, throughput, and concurrency handling. You will serve as the go-to expert for query optimization, transaction design, and ORM performance tuning in high-load production environments.

Your impact will be measured by measurable performance gains (P95/P99 latency reduction, improved throughput, reduced lock contention) and long-term database scalability improvements.

Main responsibilities:

• Lead deep-dive investigations using EXPLAIN ANALYZE, Performance Schema, Slow Query Logs, and profiling tools.
• Analyze complex execution plans and identify inefficiencies in joins, indexing, temporary tables, and filesorts.
• Drive root-cause analysis for long-running queries and system bottlenecks.

• Partner with senior Java engineers to optimize:
• @Entity mappings
• Fetch strategies (JOIN FETCH vs Lazy)
• N+1 query patterns
• Batch processing (@Batchsize, bulk operations)
• Review and refactor inefficient ORM-generated SQL.
• Establish best practices for JPA/Hibernate performance.

• Diagnose and resolve:
• InnoDB lock waits
• Deadlocks
• Long-running transactions
• Optimize transaction boundaries and isolation levels for high concurrency.
• Implement strategies to minimize row-level locking contention.

• Design scalable indexing strategies based on workload patterns.
• Recommend and implement schema refactoring to support growth.
• Balance read/write performance trade-offs under heavy traffic.

• Define database performance standards and KPIs:
• P95/P99 latency
• Transaction throughput

Interested in remote work opportunities in Development & Programming? Discover Development & Programming Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.

• Lock wait time
• Deadlock frequency
• Contribute to observability strategy and proactive performance monitoring.
• Mentor developers on database performance best practices.

JOB REQUIREMENTS:

Skills & Qualifications:

• 5+ years of experience working with MySQL in production environments.
• Proven track record of resolving complex performance issues in high-concurrency systems.
• Strong experience working with Java-based systems using JPA/Hibernate.

• Advanced knowledge of:
• InnoDB storage engine internals
• MVCC and transaction isolation levels
• Buffer pool mechanics
• Locking and concurrency behavior
• Strong experience troubleshooting lock contention and deadlocks.

• Expert-level SQL optimization skills.
• Strong ability to interpret execution plans beyond surface-level indexing.
• Deep understanding of:
• Join algorithms
• Access paths
• Temporary table usage
• Filesort behavior

• Strong understanding of:
• Lazy vs Eager fetching trade-offs
• JOIN FETCH optimization
• Batch fetching
• Transaction scoping
• Ability to connect application-layer design decisions with database performance impact.

Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.

• Strong analytical thinking and structured problem-solving.
• Ability to work independently and take technical ownership.
• Effective collaboration with backend engineering teams.

Nice-to-Have Experience

• Experience in high-traffic, distributed or microservices architectures.
• Familiarity with APM and observability tools.
• JVM performance tuning knowledge.
• Experience contributing to database performance standards or internal best practices.

WHY YOU WILL LOVE WORKING WITH US:

Compensation and Benefits 

• Competitive salary of  upto 2500 USD/month. 
• Remote work arrangement, allowing for flexibility and comfort. 
• Chance to enhance English language skills through interaction with native speakers.
• Attractive Benefits: social insurance... 
• Opportunity to work within a professional and multicultural environment.
• Enhance English skills daily with global team 
• Assistance and support through all aspects of the onboarding process

Personal Growth

• Company Team Building Trip every year.
• Training sponsorship programs
• Professional and dynamic working environment. 
• Mental health support at work
• English classes for professionals

Health care and Annual paid leave 

• Social insurance (optional)
• Unemployment Insurance 
• Vacation Leave: 12 days per year 
• Medical Leave: 8 days per year