Database Specialist (SQL Developer / DBA)
Join TECHWORLD as a Database Specialist responsible for analyzing and optimizing ERP database performance, ensuring fast query response, stable data processing, and system reliability under high transaction volumes.
Role Overview
The Database Specialist is responsible for analyzing and optimizing database performance for ERP systems, ensuring efficient data processing, fast query response, and system stability under high transaction volumes.
This role is ideal for professionals with strong SQL Server expertise who enjoy diagnosing bottlenecks, tuning queries, improving indexing strategies, and supporting mission-critical enterprise systems.
Query Performance
Analyze slow-running queries and optimize complex SQL, views, and stored procedures used in ERP systems.
Index & Execution Plans
Perform index analysis, tune strategies, and review execution plans to identify performance bottlenecks.
Database Monitoring
Monitor CPU, memory, I/O, blocking, deadlocks, and database behavior under high transaction workloads.
ERP Optimization
Collaborate with Technical Consultants to optimize AX/D365 data access patterns and key business processes.
Key Responsibilities
- Analyze and identify slow-running queries impacting system performance.
- Review and optimize complex queries, views, and stored procedures used in AX/D365.
- Perform index analysis, creation, and tuning based on system workload.
- Analyze execution plans to identify bottlenecks and inefficiencies.
- Monitor database performance, including CPU, memory, I/O, blocking, and deadlocks.
- Support performance troubleshooting for key business processes such as posting, reporting, and batch jobs.
- Collaborate with Technical Consultants to optimize data access patterns from X++.
- Support database optimization for large data volumes and high transaction scenarios.
- Assist in performance testing and validation of optimization results.
Required Skills
- Strong expertise in Microsoft SQL Server.
- Deep understanding of query optimization, indexing strategies, and execution plans.
- Experience handling large-scale transactional databases.
- Familiarity with AX 2012 / D365 database structure is preferred.
- Experience with SQL Profiler, Query Store, and DMVs.
Preferred Skills
- Experience in ERP performance optimization projects.
- Understanding of high-volume retail or distribution systems.
- Experience resolving locking, blocking, and deadlock issues.
Ready to optimize enterprise data performance?
Send your CV to hr@twi.vn with the subject line:
Application for Database Specialist SQL Developer DBA - Your Name