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.
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.