- Develop Logical Model, Implement Physical Database
- Tuning and Optimization of T- SQL, Stored Procedures
- Manage multiple databases across multiple servers
- Log Shipping, Link heterogeneous database servers in SQL Server 2000
- Replication (Snapshot/Transactional/Merge) and DTS packages
- OLAP, Analysis Services using SQL Server 7.0/2000
- Create Trigger, Stored procedures and Cursors using T-SQL
- Configure SQL Server 2000 for security with Windows NT/Windows 2000
Advanced Server
- Export and Import data from Excel and flat files to SQL Server 2000
- Backup/Restore/ Disaster Recovery
- Trouble shoot WinNT/Windows 2000 server/SQL Server network problems
- Use Performance Monitor/Profiler to solve Dead Locks/Long running
queries
- Knowledge in ORACLE is an added advantage