Create and maintain all databases required for development, testing and production. • Database Designing. • Drawing ERD using Microsoft Visio. • Implementation of Stored Procedures, Functions, Triggers and Indexes. • Working on User Define Types. • Write and debug complex T-SQL code. • Working on Differential and Full Backups. • Reporting in SSRS. • Data Migration through SSIS. • Data Archiving and Auditing using CDC. • Query Optimization.