IMS, Individual Media Service GmbH
- POS system for selling music tracks, ringtones and printing digital photos via kiosks and connected terminals
- Database design, administration, performance tuning, stored procedures, triggers, functions
- Evaluated a schema comparison tool
- Introduced version control and change management for database development
- Developed batch and SQL scripts using osql, isql, bcp to create/alter structures and load data
- Designed and operated software modules to dynamically update top lists based on sales and release dates
- Used SQL Server Agent for daily tasks
- Operating systems: Windows XP, SUSE Linux 9.0
- Database: MS SQL Server 2000
- Languages: SQL, Transact-SQL, batch scripts
- Tools: Enterprise Manager, Query Analyzer, Import & Export, bcp, isql, osql, ssh, PuTTY, vim, gvim, CVS, Tortoise CVS, Apex SQL Diff, NetOp, VNC