Sam Sy

Develop, coordinate, and deployed a world wide effort to migrate over 1,000 databases which include DB2, SQL Server, Postgres, and Vertica Analytics. This effort put databases in regionalized data centers to discontinue world wide server/database maintenance and improved efficiency and productivity.

• Performed installation, upgrade, configuration and implementation of database software across various Platforms and Operating Systems
• Developed and implemented database backup, high availability, and disaster recovery plans and strategies by analyzing hardware available and application needs.
• Tasked to seek out a Data Warehouse solution for reporting/dashboards/analytics. Research and worked with senior management to POC several vendor solutions which ultimately led to developing a Vertica database system specific to analytics.
• Develop training materials. Coordinated and conducted training to onboard new DBAs.
• Coordinate database software changes through the life cycle. *Involves in improving SQL programming, provides performance monitoring and tuning recommendations.
• Analyzed database system issues and metrics, including performance of storage systems, CPU usage, high-cost SQL to provide recommendations to application owners, such as database reconfiguration and use of indexes.
• Developed, documented, and communicated DBMS standards to create alignment across all database administrators in company.
• Worked with cross-functional teams to support system and data needs and create database standards.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls
• Collaborated with cross-functional teams to define data requirements and improve database performance.
• Developed comprehensive security protocols to safeguard sensitive information against unauthorized access.
• Reduced system downtime, proactively monitoring databases and addressing potential issues before they escalated.
• Optimized storage utilization by implementing advanced compression techniques without compromising data accessibility or performance.
• Conducted performance tuning and troubleshooting of complex SQL queries for optimal system responsiveness.
• Resolved critical production issues by troubleshooting complex problems quickly and efficiently under tight deadlines.
• Conducted regular audits to identify areas of improvement in database management practices, leading to increased efficiency.

• Managed a team of 10+ support engineers. Conducted interviews, hiring, onboarding, training, and performance reviews.
• Served as a liaison between business product teams and IS departments by understanding business processes and systems implementation to plan and execute tactical customer logistics solutions and ensure timely delivery of products and freight to destination.
• Conduct extensive research on technical issues and write up enhancement and escalation requests to analysts and development. Assist EDI Development & EDI Analyst team with testing and performance analysis to ensure a smooth rollout and support handoff.

• Design, implement, and maintain end-to-end document capture and imaging workflows using Kofax tools (e.g., Kofax Capture, Kofax Transformation, Kofax TotalAgility).
• Configure capture profiles, scanners, and input channels (invoices, forms, letters, PDFs, faxes, emails) for optimal image quality and throughput.
• Create and tune OCR, ICR, barcode recognition, zonal OCR, intelligent character recognition, and data extraction rules to populate structured data fields.