Responsibility:

• The creation and upkeep of SSIS packages

• Proficiency in writing complex SQL queries and stored procedures for SQL Server databases.

• Implementing database changes during release cycles

• Conducting scheduled maintenance and supporting release deployment activities, even during after-hours and weekends

• Assisting developers in query optimization and schema refinement

• Automating regular processes, tracking issues, and documenting changes

• Developing and maintaining technical design documentation

• Configuring and managing database servers and processes

• Monitoring system health and performance

• Identifying the need for upgrades or replacements of hardware and software.

Qualifications:

• Key knowledges: DBA, SQL Server, SSIS, SSAS, ETL, T-SQL quer

• Advanced expertise in SQL Server query and index optimization

• Minimum of 3 years of experience as a DBA in Database Support

• At least 3 years of experience collaborating with business owners, developers, and team members.

• Familiarity with High Availability, Always On, Mirroring, and Replication technologies would be a plus.

• Experience in developing/maintaining ETL processes using SSIS, preferably utilizing Change Data Capture or Change Tracking.

• Prefer in freight forwarding industry experience.