Sql Server Information Technology
Resume:
DALJIT SINGH SANDHU
Brampton, ON
L6W 3Y3
************@*****.**.**
SQL Database Administrator/Analyst
SUMMARY
• 8 years of experience of administrating Microsoft SQL Server
• Dealt with performance problems and monitored the database environment to optimize
performance
• Developed high-availability solutions including clustering and mirroring
• Planned database backup strategies and recovery models
• Scheduled jobs using SQL Server agent and validated the integrity of the databases
• Master’s Degree
• Microsoft Certified Technology Specialist in Business Intelligence
• Experienced with SSIS and SSRS designing packages
• Fast learner and self -motivated with the ability to work well independently or as a part of
team
TECHNICAL SKILLS
Software: Oracle 7i, 8i, 10g, SQL server 2008
Languages: SQL, PL/SQL, SQL server 2008, HTML
Databases: Oracle database, SQL server databases
Operating System: Server 2000, 2003, 2005, Windows 2003, 2007
Internet Tools: Email, FTP, Gopher, HTML, HTTP, TCP/IP, TELNET,
WWW
Network/Protocols/Communication: LAN, MAN, WAN, TCP/IP
EDUCATION
Master in Technology (IT): KSOU, India 2011
Master in Computer Applications: GJU, India 2006
Master in Science (Information Technology): GJU, India 2003
PG Diploma in Computer Applications: Punjabi University, India 2002
Bachelor in Science (Medical): Punjabi University, India. 2000
PROFESSIONAL CERTIFICATION
Microsoft Certified Technology Specialist Certification: SQL Server 2008, Business Intelligence
Development and Maintenance: 2011
DALJIT SINGH SANDHU Page No. 2
WORK HISTORY
Database Administrator
USER IN MIND, Toronto, ON Feb, 2014-till date
Database Administrator
SUSCET, INDIA 2009-2013
(Established in 1996 and imparting quality education to more than 7000 students in various
disciplines of Engineering, Management, Science and Technology)
• Created job schedules for weekly backups and On-Call DBA for emergency outages
• Independently developed SSIS project for a retain chain for sales and profit analysis
• Troubleshot T-SQL queries and scheduled job for automating backups and purging using
SQL agent
• Coordinated with the development team to design SSIS packages using BIDS
• Installed and configured SQL Server 2005, 2008 on Windows Server 2003. Migrated data
from SQL 2005 to 2008
• Organized technical meetings with project team and customers
• Provided advice on design and planning strategies
• Developed SSIS packages and imported data from flat files and processed into tables
using slow changing dimensions
• Developed stored procedures and wrote queries in MySQL, Oracle
• Defined relationship between dimensions and measures and deployed analysis services
projects
• Created maintenance plan for SQL Server 2005 and 2008
• Created reports for viewing in excel and PDF formats using SSRS
• Refreshed SQL Servers on request or in urgent needs
SQL Server Database Developer
SUSCET, India 2004-2009
(Established in 1996 and imparting quality education to more than 7000 students in various
disciplines of Engineering, Management, Science and Technology)
• Created tables and checked data consistency as an assistance to the DBA
• Assisted in development of In-House Intranet Database projects for student’s records and
campus activities
• Provided SQL training to engineering students
• Installed SQL Server 2005 and 2008 for testing purpose
• Worked with consultants for development of college database
• Resolved staff requests on data base and login issues
Contact this candidate