�ݺ�ߣ

1
Satwinder S. Khural
SQL Server DBA
Phone: 516-439-6799
Email: sql.ssk@gmail.com
31-17, 74 Street, East Elmhurst, NY-11370
More than 10 years of IT experience in Database Architecture, Administration, System Analysis,
Design, Development and Support of MS SQL Server also specialize in MS SQL Server
2008/2005/2000 in Production, Test, Development Environments.
 Experience in Database administration activities like Installation, Configuration, Backup &
Recovery, Database Security and Data Transformation Services.
 Expert in installation, upgrade and configuration of MS SQL Server 2008, 2005 & 2000.
 Experience in SQL database designing, architecture, Data Modeling using ERWIN 7.1 and Visio.
 Tested and Implemented Log shipping with SQL Server 2000/2005/2008.
 Successfully implemented Database Mirroring in SQL Server 2005, 2008 for high availability.
 Experience in implementing Snapshot, Transactional and Merge Replication models.
 Good experience in Installing, configuring and maintaining SQL Server Active/Active and
Active/Passive cluster.
 Implemented Data collector in SQL 2008.
 Implemented Change data Capture In SQL 2008.
 Implemented Resource governor in SQL 2008.
 Familiar with the new feature of SQL 2008.
 Experience in creating maintenance plans, Jobs and Sending Alerts using SQL Mail.
 Experience in installing Service Packs for SQL Server and OS.
 Good Knowledge in preparing and updating cost cutting and disaster recovery documentation.
 Developed backup and recovery strategies for production environment.
 Experience working with 24x7 Production support for 2008, 2005 and 2000 SQL Server.
 Good knowledge of Relational Database Management Systems (RDBMS).
 Experience in data normalization and de-normalization.
 Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis,
Design, Development and Implementation Experience in working with high transaction OLTP
systems in SQL Server 2000/2005/2008.
 T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures etc.
 Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and
Database Consistency Checks using DBCC Utilities.
 Involved in Performance tuning of Stored Procedure.
 Worked on partition table in SQL 2005/2008.
 Excellent in system tables, Dynamic Management Views and stored procedures using T-
SQL.
 Designed documents for Capacity Planning and System Maintenance for Production.
 Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
 Worked on DMVs, System tables and Stored Procedures for performance tuning.
 Handling Database designing and Query optimization.
 Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
 Extensively worked on Performance tuning of stored procedure.
 Creating stored procedures, functions, packages, triggers, according to business requirements.
 Experience in creating packages, Jobs, Sending Alerts using SQL Mail and custom extended
procedures like XP_SMTP_MAIL.
 Monitoring Event viewer, SQL Error logs and Log File for Software and hardware related errors.
 Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning
MS SQL Server Performance.
 Monitoring SQL Server logs to ensure the backup operations, batch commands, or other
scripts and processes have completed successfully.
Summary

2
 Creation and maintenance of Databases, creating Roles and managing user permissions.
 Good experience in resolving blocking and dead lock Issues.
 Experience in implementing Various RAID technologies.
 Experience in SQL Server Integration Services (SSIS).
 Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase,
Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server
Integration Services (SSIS).
 Migrated DTS Packages to SSIS Packages.
 Deployed SSIS Packages to MSDB and File system from development to Production environment.
 Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services,
(SSRS).
 Worked on Command prompt utilizes like OSQL, ISQL, SQLCMD, TABBLEDIFF.
 Experience in creating partition tables and partition views.
 Worked with Popular Third Party monitoring solutions like Idera, Fog-light.
 Management of users including creation/alteration, grant of system/db roles and
permissions on various database objects.
 Excellent communication skills.
 Good team player with strong analytical skills.
 Flexible, enthusiastic and project oriented team player with solid leadership skills to develop
creative solution for challenging client needs.
Languages C, C++, T-SQL, PL-SQL, Java script, VB script.
RDBMS MS SQL Server 2008, 2005, 2000 & 7.0, Oracle 9i & 10g.
Front End MS Visual Basic.
Technologies RAID, SAN
Operating Systems Windows 2008 R2/2000/2003 Server, Windows NT 4.0 /
3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.
Reporting Tools Microsoft Reporting services, SSRS
Other Tools Idera Diagnostic Manager, Erwin Data Modeler, MS Visio,
Red Gate, Fog light.
Quest Tools Spotlight, LiteSpeed, Discovery Wizard.
Hardware Compaq/HP Proliants 8000, 6500, 6000, 5000 Servers.
Version Control Tools Visual Source Safe 6.0, Source gear Vault.
 Microsoft SQL Server 2005 – Implementation and Maintenance.
 Microsoft SQL Server 2008 – Implementation and Maintenance.
 Bachelor of Engineering in 2003 from Punjab Techenical University, Punjab, Jallandhar,
India.
 Master of Engineering in 2008 from New York Institute of Technology, Old Westbury,
USA, NY.
TECHNICAL SKILLS
MICROSOFT CERTIFICATIONS:
Education:

3
Description: Broadridge Financial Solutions, Inc. is a US servicing company for the financial industry
founded in 2007 as a spin-off from Automatic Data Processing (ADP). The main fields of work are in
securities processing, clearing and investor communication. The main business of Broadridge is electronic
proxy voting.. I ensured that database is up and running all the time. I generated reports using Microsoft
reporting tools (SSRS) and also to transfer packages using ETL tools i.e. DTS/SSIS.
Responsibilities:
 Installed SQL Server 2014/2012/2008 with service packs in production and UAT environments,
Applied SQL Server 2014/2012/2008 patches on production & Upgraded SQL Server 20005 to
2012 & 2008 to 2014 using Side by Side strategy.
 Implemented Always On, Log Shipping between Production and DR Servers, Transactional
Replication, Database Mitrroring in SQL 2008 & Maintained and monitored SQL Server on 2
Node Active/Active and Active/Passive Clusters.
 Configured Linked Servers between DB2/MS Access and SQL Server 2012, Designed and created
user databases, tables, views, complex stored procedures and SQL joins and statements, Designed
Logical and Physical Database Designs using Erwin.
 Worked on T-SQL, DDL, DML and DCL Optimization and Tuning of Stored Procedures and T-
SQL queries.
 Created maintenance plans for performing Optimizations, Backups, Rebuilt and Reorganize
indexes, database backup and recovery procedures for production, QA and DEV servers.
 Used BCP and Bulk Insert for transferring data between various environments.
 Designed documents for cost cutting, management of Production Servers & Capacity Planning and
System Maintenance for Production.
 Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler &
Worked on DMVs, System tables and Stored Procedures for performance tuning and Used DBCC
commands for consistency checks to improve performance.
 Created new database objects, resolved backup and performance issues on regular basis.
 Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and
Database Mail & Tested SSIS in Production environment, Created, tested and Deployed SSIS
packages from system test and UAT to production Provided & 24x7 production support.
 Worked on backup tools like LiteSpeed, Red Gate, Idera SQL safe.
 Worked on Production support role including 24x7 support on rotaion basis, day to day change
management, managedassigned task to team members and activily worked on on new and
ongoing projects within the organization.
Environment: MS Windows 2012/2008 Enterprise Server, MS SQL Server 2014/2012/2008, Visual Studio
2005/2008, Idera SQL Doctor, ERWIN, Fog Light, Red Gate, SQL profiler , Idera Diagnostic Manager, SQL
Multiscript etc.
Description: Bio-Reference Laboratories, Inc. is an independent regional clinical laboratory servicing over
50 patient service centers in the greater New York metropolitan area. I ensured that database is up and
running all the time. I generated reports using Microsoft reporting tools (SSRS) and also to transfer
packages using ETL tools i.e. DTS/SSIS.
PROFESSIONAL EXPERIENCE
Broadridge Financial Solutions, Inc. June 2012 – Current
SQL Server DBA
BioReference Laboratories Inc., Elmwood park Aug 2011 – May 2012
SQL Server DBA

4
Responsibilities:
 Installed SQL Server 2008 with service packs in production and UAT environments, Applied SQL
Server 2005/2008 patches on production & Upgraded SQL Server 2000 to 2008 & 2005 to 2008
using Side by Side strategy.
 Implemented Log Shipping between Production and DR Servers, Transactional Replication,
Database Mitrroring in SQL 2008 & Maintained and monitored SQL Server on 2 Node
Active/Active and Active/Passive Clusters.
 Implemented CDC (Change data capture), Resource governor in SQL 2008.
 Configured Linked Servers between DB2 and SQL Server 2005, Designed and created user
databases, tables, views, complex stored procedures and SQL joins and statements, Designed
Logical and Physical Database Designs using Erwin.
 Worked on T-SQL, DDL, DML and DCL Optimization and Tuning of Stored Procedures and T-
SQL queries.
 Created maintenance plans for performing Optimizations, Backups, Rebuilt and Reorganize
indexes, database backup and recovery procedures for production, QA and DEV servers.
 Used BCP and Bulk Insert for transferring data between various environments.
 Designed documents for cost cutting, management of Production Servers & Capacity Planning and
System Maintenance for Production.
 Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler &
Worked on DMVs, System tables and Stored Procedures for performance tuning and Used DBCC
commands for consistency checks to improve performance.
 Created new database objects, resolved backup and performance issues on regular basis.
 Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and
Database Mail & Migrated and Tested DTS packages to SSIS in Production environment,
Created, tested and Deployed SSIS packages from system test and UAT to production Provided &
24x7 production support.
Environment: MS Windows 2008 Enterprise Server, MS SQL Server 2005/2008, Visual Studio 2005/2008,
IIS 6.0, ERWIN, Fog Light, Red Gate, SQL profiler , Idera Diagnostic Manager.
Description: Gates Corporation, is one of the largest non-tire rubber companies in the world. As a part of
my job I was involved in Server Migration (Consolidation), responsible for all deployment activities like
patches, upgrades, creating new database and maintaining the existing ones, generating reports using
Microsoft reporting tools (SSRS) and also to transfer packages using ETL tools i.e. DTS/SSIS, giving
permission to the users, manage Active directory and DNS, Createing high availabity solutions e.g: Log-
Shipping/Mirroring, Maintinging the Netbackup.
Responsibilities:
 Installation of SQL Server 2005 with latest Service Packs.
 Migration of SQL Server 2000 to SQL Server 2005 using side by side strategy.
 Designed new databases architecture according to Business requirements like logical design
and physical design.
 Handled Clustering between 3 Production Servers and performed daily backups and developed
Recovery procedures.
 Implemented Log Shipping in SQL 2005/2000.
 Implemented Transactional and Snapshot Replication in SQL 2005.
 Implemented Disaster Recovery Strategies.
 Involved in creation of database snapshot.
 Created partition tables using partition functions and partition scheme.
 Providing 24x7 supports to SQL application developers in implementing the applications on
Production server.
Gates Corporation, Denver July 2010 – July 2011
SQL Server DBA

5
 Migrated stored procedures from SQL 2000 to SQL 2005 to refer Dynamic Management Views
(DMV).
 Resolved locking and blocking issues.
 Created stored procedures, scripts, cursors for the Bulk application, tested them on the test
servers and moved them to production.
 Daily monitoring of the database performance and network issues.
 Performance tuning and optimization of procedures and queries.
 Rebuilding indexes (online and offline) on various tables.
 Connecting SQL servers remotely using Terminal services.
 Worked with SQL Server Profiler to generate traces.
 Monitored databases and alerts from Fog-light application.
 Creating backup strategies and scheduling them for execution.
 Created crystal reports and scheduled them as daily and monthly reports.
 Creating logins, users and assigning them permissions on demand.
 Helped Development Team in deploying and testing the application.
 Upgrading DTS Packages to SQL Server Integration Services (SSIS).
 Scheduled SSIS Jobs and Maintenance Plans.
 Create Packages and jobs to perform filtering operations and import the data on daily basis from
the Oracle DB to SQL server.
 Created and Migrated DTS packages from SQL Server 2000/2005 to SQL Server 2005/2008
Integration Services (SSIS).
 Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction,
transfer, and loading for different applications.
 Involved in moving SSIS packages between various environments including Development,
Test, System Test, UAT (User Acceptance Testing) and Production.
 Set up jobs to schedule SSIS packages using SQL Agent.
Environment: MS SQL server 2000 and 2005, Windows 2000, Enterprise Manager, SSMS, DTS, SQL
Profiler, SSIS, Crystal Enterprise, Foglight, Veritas backup solution.
Description: SkinStore is among the leading online beauty retailers worldwide. I was involved in
Upgrading from SQL server 2000 to SQL server 2005 and also design, install, maintaining database of
production environment while ensuring High data availability and creation of SSIS package for data
import/ Export.
Responsibilities:
 Involved in various stages like development, System Analysis and Design for new applications.
 Installed SQL server 2005/2000 with latest service pack.
 Extensively involved in Log shipping.
 Designing reports on daily basis using Performance Monitor.
 Performed Database backups.
 Successfully resolved deadlock issues by creating traces on objects using SQL Server
Profiler.
 Monitored SQL Server Error Logs and Application Logs.
 Created maintenance plans which included database integrity checks, rebuilding and
reorganizing indexes & updating statistics.
 Creating and maintaining logins, users, roles and granting privileges.
 Logical and physical database design modeling using Erwin.
 Configured Snapshot Replication (Creating Publishers, Distributors, Subscribers, publications,
and managing replication monitors).
 Prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structure.
 Performed analysis and design of the application.
 Provided assistance and mentoring staff for developing conceptual, logical and physical database
designs.
Skin Store, Gold River Jan 2009 – June 2010
SQL Server DBA

6
 Developed and coded applications in T-SQL.
 Involved in support, development, QA, UAT and knowledge transfer.
 Fine-tuned Stored Procedures to improve performance that was achieved by removing
unnecessary Cursors and Temporary Tables.
 Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
 Experienced in performance tuning using Windows perfmon and SQL profiler of SQL server.
 Worked on Linked Servers to run distributed queries between SQL server and other data sources
like excel using ODBC, OLE DB Drivers.
 Importing and exporting Database objects using DTS utility.
 Created database objects like tables, indexes, stored procedure, triggers, function and views.
 Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
 Database administrative jobs of Security, Backup/ Recovery, ODBC connections etc.
 Database testing, maintaining data and writing complex procedures.
Environment: SQL Server 2000, T-SQL, Windows Server, HTML 4.0, ActiveX, Erwin, Visio, Performance
Monitor, SQL Server Profiler.
Description:
They are today one of the largest engineering and consumer products company in the country having
varied interests from engineering to personal care products. Involved in the project to create and design
database system using stored procedure, functions and triggers. Migrating data using DTS Packages,
monitoring SQL Performance and configuring replication for disaster recovery
Responsibilities:
 Involved in various stages of Software Development Life Cycle like Design (Logical &
Physical), Development, Testing, Implementation and Maintenance.
 Actively involved in Normalization of database and assisted clients with physical database
modeling, data archiving strategies and disaster recovery planning.
 Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor
connections, locks and performance of SQL server.
 Creating tables, views, indexes, cursors, functions and stored procedures.
 Creating database models and designing logical and physical models of database using
Erwin.
 Creating logins, users, roles and granting privileges to them as required.
 Worked closely with the developer’s team and the end users while the system is being under
development phase.
 Gave training session to the end users for the new product such as using the product.
 Preparing the reports for the day-to-day as well as weekly/monthly purposes.
 Create joins and sub-queries for complex queries involving multiple tables.
 Involved in writing queries and optimizing the performance of the queries.
Environment: SQL Server 7.0/2000, T-SQL, Windows Server, HTML 4.0, VBScript, JavaScript, Access,
Windows XP and Windows 2000 Server IIS 4.0, ActiveX.
GODREJ Ltd., Mohali, India July 2003– Aug 2006
SQL Server DBA

�ݺ�ߣ

Satwinder SQL.SSK_Brd_2015

Recommended

More Related Content

What's hot (20)

Similar to Satwinder SQL.SSK_Brd_2015 (20)

Satwinder SQL.SSK_Brd_2015