← Titan DMS
Senior Database Developer - SQL Server
Titan DMS · Hồ Chí Minh
Ứng tuyển tại trang chính thức ↗
Loại hình
Toàn thời gian
Hình thức
Tại văn phòng
Cấp bậc
Nhân viên
Ngành nghề
CNTT - Phần mềm
Mức lương
Thương lượng
Địa điểm
Quận 11, Hồ Chí Minh, Hồ Chí Minh
Tổng quan
- 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.
Quyền lợi
Chế độ thưởngChăm sóc sức khỏe
Tóm tắt thông tin từ tin tuyển dụng chính thức. Xem bản gốc ↗
Quan tâm đến vị trí này?
Bạn sẽ được chuyển đến trang ứng tuyển chính thức của nhà tuyển dụng.
Ứng tuyển tại trang chính thức ↗
Đây là doanh nghiệp của bạn?
Nhận quản lý trang, yêu cầu chỉnh sửa hoặc gỡ bỏ
→