Jaspreet Singh Email & Phone Number

Social27, ChandigarhInstallation, configuration and upgrading of Microsoft SQL Server.Establish and maintain sound backup and recovery policies and procedures. Implement and maintain database security (create and maintain users and roles, assign privileges).Database tuning and performance monitoringUnderstanding basic Query flow (Conditions and ordering the result set).Good knowledge T-SQL Programming.Inserting data, Updating Data, Deleting Data and Fetching Data.Merging data (Joins and union).Aggregating Data, Navigating Hierarchical Data and Full Text searching.Creating View and working with Distributed Queries.Using stored procedures, functions, cursor, triggers. Implementing the Physical Database Schema (Creating Database, Creating Tables and DDL Triggers).Programming with T-SQL and Performing Bulk Operations (BCP).Knowledge of SSAS, SSIS (DTS), SSRS, Replication, Linked Servers, Maintenance Plans, SQL Azure working environment.Performed a multitude of team lead duties such as assigning work, reviewing

Technology - ASP.Net, VB.Net, SQL Server 2000Client - US ClientTeam Size - 10 Developers + 4 QASummary SonoWorld is a division of MedimageWorld a medical communications company headquartered; SonoWorld was conceived as a way to provide free and high-quality educational materials to ultrasound practitioners in developing countries around the world. The founders and staff are widely recognized for their contributions to clinical ultrasound, education, research, training and industry, and for their commitment to quality education. As the founders explored ways to accomplish this mission, it became apparent that there was a global need for a centralized resource for information as well as educational resources, and that this could best be accomplished by creating a new education-focused virtual community for physicians, sonographers and members of the industries that support them.RoleInstalled new SQL Server 2000. Performed all aspects of database administration, including backups and recovery. Designed and implemented table's designs. Wrote stored procedures, functions, triggers, cursors. Create users, roles and maintenance plans.

Mca, Copmuters

Bachelor, Information Technology

Masters, Computer Applications

Bsc(It), Computers

Education record