Surinder Mohan

Freelance Database Expert & Database Designer

Location:Toronto, Ontario, Canada
2 Skills
Surinder Mohan
13, Montreal St 416-831-6905
Brampton, Ontario L6X 0Z1

A position in SQL Server Database Administration/Developer

• Over Eight year experience in IT as Database Administration and Business Intelligence Development in MS SQL Server 2012/2008/2005
• Involved in migrating and upgrading SQL Server 2000 to SQL Server 2005/2008/2012
• Experience in high availability such as mirroring, log shipping, replication and clustering
• Skilled and Experienced in Server performance tuning using SQL Server 2005’s Dynamic Management View and performance counters in SQL SERVER 2012/2008/2005
• Good experience in Coding and Improving Efficiency of Rebuild index, Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in maintaining the security for databases (creating logins for users, roles, assigning permissions to them.
• Good Experience in Database Backup, Recovery and Restoring as daily activities.
• Expertise in SQL Server Integration Services (SSIS), SQL Server reporting Services(SSRS)
• OLAP experience Including Analysis Services, Business Intelligence
• Experience in extracting and transforming data using SSIS, DTS Import/Export Bulk Insert, BCP and DTS Packages.
• 24X7 Database Support experience.

Microsoft Certified Technology Specialist (MCST)
Oracle Certified Training From Humber College


Databases MS SQL Server 2008/2005, MS SQL Server 2000/7.0, Sybase
Programming .Net, Visual Basic 6.0, C, C#, C++, Java, COBOL
DBA Database Administrator of MS SQL Server 2008/2005/2000
Data Warehousing SSIS/SSAS/SSRS, Cognos 8.0, Informatics, Crystal Report
Data Mining SAS
Operating System Window 2003/2000 Advanced Server, NT & window 9x, UNIX.
Other Software IIS, Microsoft Transaction Server, VBScripts, HTML
Tools SQL DB Access, Performance Monitor, Backup Utility, SQL Lite- Speed, MS-Visio 2000
Network Topologies: TCP/IP, DNS, DHCP, FTP, SMTP


Senior Database Administrator/Data Analyst
Public Health Ontario May 2012 to Till Date
• Involved in installation and configuration of SQL Server 2012/2008R2/2008/2005 in Windows environment.
• Involved in data modeling for the SQL Server and for individual databases.

• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Managing the use of disk space memory and connections.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installation of replication server configuration and monitoring the replication between two sites implemented Transactional Replication.
• Managing the clustering environment.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Transferred data (ETL) to Data ware house Environment using SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Expertise in creating and supporting in OLAP Cubes.
• Expertise in SQL Server Analysis Services.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
• Did trouble shooting of Client connections, viewing error log and applications.
• Designed coded and tested several T-SQL Programs.
• Created SSIS Packages for uploading various formats of files and databases to MS SQL.

Jameson Bank, Toronto, Canada April 2011- Dec 2011
• Designed SSIS Packages for importing and Exporting data migration and conversion
• Experience in Creating and maintaining reports in SSRS using RB 2.0 and Visual Studio
• Develop reports based on pre-defined requirements
• Develop stored procedures using MSSQL Server 2008
• Create solutions to facilitate data analysis and ad hoc reporting
• Creating data cubes for data analysis in SSAS
• Create dashboard functionality for executives, directors, and managers with drill-down capabilities
• Responsible for Backup and Recovery. Monitored the server for tuning and memory Management
• Created an automated SSIS package which will call many packages based upon several conditions
• Day to day administration of the SQL Servers (Backup and Restores, Scheduled jobs, Database Tuning, Query Tuning, Performance Monitoring).
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored procedures, Triggers
• Responsible for creating and updating report in MS-ACCESS and MS-EXCEL

SQL Server Database Administrator/Business Intelligence
Envision Financial System, Irvine, CA, USA Jan 2009 – Feb 2010
• Installed and maintained MS SQL Server 2005 on Windows 2003 Server Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster
• Migrated SQL Server 2000 to SQL Server 2005/2008
• Used Erwin and UML for physical and logical data modeling.
• Configured and maintained database mirroring/log shipping, clustering, replication for high availability
• Extensively worked on Dynamic Management Views and Dynamic Management Functions
• Utilized Expertise in creating and supporting in OLAP Cubes in SSAS
• Generated and managed reports using SQL Server 2005 Reporting Services
• Transferred data (ETL) to Data warehouse Environment using SSIS
• Dropped and recreated indexes on tables for performance improvements. Used Index Tuning Wizard for tuning of indexes
• Scheduled the backups for Databases and Transaction log, performed restoration operations and suggested backup strategies
• Traced long running queries and deadlocks using SQL Profiler
• Managed use of disk space, memory and connections
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Maintained the database consistency with DBCC at regular intervals
SQL Server Database Administrator/Business Intelligence
Combined Insurance, Glenview, IL, USA April 2008 -Dec 2008
• Maintained logins and roles and managed Day to Day user maintenance
• Managed the migration of SQL Server 2000 database to SQL Server 2005
• Ensured availability and performance of databases that supported the system
• Scheduled and monitored all maintenance activities including database consistency checks and index de-fragmentation
• Created Jobs to Automate and scheduled database administrative tasks
• Analyzed and tuned long running slow queries to optimize application and system performance
• Developed OLAP cubes using SSAS and Calculate the metrics that were revealed in the functional Analysis
• Developed Report using SQL Server Reporting Services(SSRS)
Corporate trainer / Database Administrator
S.S.C Net Pvt Ltd, New Delhi, India Sep 2002- June 2006
• Prepared and delivered lecture to undergraduate students, average class size: 60-70 students
• Maintained a teaching assignment for each module
• Taught various IT course: Data Structures, Programming languages, RDBMS, Operating Systems, and Software Engineering etc. for Bachelor Degree students
• Maintained the student data in the college.
• Handled day to day activities using SQL Server and tools such as backup and Recovery.
• Wrote T-SQL Queries for retrieval of data.

Master in IT and Strategy Management 2006-2008
Dublin Institute of Technology, Dublin, Ireland
Advanced Diploma in computer Application 2000-2002
Indira Gandhi National University, Delhi, India
Certificate in Computing 1999-2000
Indira Gandhi National University, Delhi, India
Diploma in Computing 1998-1999
NIIT, New Delhi, India
Bachelor in Mathematics 1995 –1998
Punjab University Chandigarh
Skills (2) Rating
Database Design