Type
Full-time
Work mode
On-site
Level
Staff
Industry
IT - Software
Salary
Thương lượng
Location
Quận 11, Hồ Chí Minh, Hồ Chí Minh
Overview
- Database Development
- Participate in solution design and development of database solutions.
- Develop and maintain Stored Procedures, Views, Functions, SQL scripts and database objects.
- Extract, analyse and mine data using SQL.
- Optimise complex SQL queries, Stored Procedures and Views.
- Participate in database code reviews and provide technical guidance to other developers.
- Assess the impact of change requests and develop appropriate database solutions.
- Production Data Support & Correction
- Investigate and resolve complex production data issues.
- Identify incorrect, missing, duplicated or inconsistent data and determine the root cause.
- Develop and execute safe data correction scripts in production.
- Assess the impact of data changes before implementation.
- Apply appropriate validation, backup and rollback strategies for production data changes.
- Validate corrected data and ensure the issue has been fully resolved.
- Document data corrections, root causes and preventative actions.
- Work with Development, Support, BA and other teams to resolve data-related production issues.
- Data Import, Migration & Conversion
- Develop and execute data import and migration solutions using:• SQL scripts
- SSIS
- Other appropriate data integration tools.
- Perform data mapping, transformation and validation.
- Develop repeatable and reliable data import processes.
- Accounting & ERP Data
- Good understanding of accounting concepts and ERP systems.
- Understand how financial and transactional data is represented within an ERP/DMS.
- Ability to investigate and resolve data discrepancies while considering their business and financial impact.
- Work with BA and other stakeholders to validate data corrections and ensure the expected business outcome.
- Database Performance
- Monitor and troubleshoot database performance issues.
- Analyse execution plans and query performance.
- Optimise SQL queries, Stored Procedures and database structures.
- Your Skills and Experience
- Essential
- 5+ years of strong SQL Server / SQL development experience.
- Strong T-SQL skills.
- Strong experience writing complex Stored Procedures and SQL scripts.
- Strong hands-on experience fixing and correcting data in production environments.
- Experience working with large and complex datasets.
- Good experience with SSIS.
- Experience with SQL Server Agent Jobs.
Benefits
BonusHealthcare
Summary of facts from the official posting. View original ↗
Interested in this role?
You'll be taken to the employer's official application page.
Apply on official site ↗
Is this your business?
Claim this page, request edits or removal
→