Sukhjinder Singh

SQL Server DBA

E-mail: aco0hn@r.postjobfree.com

Mobile: 516-***-****

Summary

Seven plus years of IT experience with more than six years in Database

Architecture, Administration, System Analysis, Design, Development and

Support of MS SQL Server 2008 R2,2005,2000 in Production, Test,

Development, Replication & Cluster Server Environments in Windows

Environment

Installation, Upgrade, Configuration and Administration

. Hands on experience in installing, configuring, managing, upgrading and

migrating, monitoring and troubleshooting SQL Server 2008 R2/2005/2000.

. Experience in upgrading SQL Server software to new versions and applying

service packs and hot fixes and unattended Installation.

. Experience in Installing and Configuring SQL Server Active/Active and

Active/Passive clusters.

. Worked on SAN for SQL Server Databases and good understanding in Capacity

Planning.

Backup and Disaster Recovery

. Implemented different types of Replication Models such as Transactional

and Peer to Peer in OLTP Environments.

. Implemented and successfully tested Database Mirroring in SQL Server 2005

and 2008 R2.

. Implemented and successfully tested Log Shipping in SQL Server 2000,

2005, 2008 R2.

. Experience in Database backing using Database Maintenance Plan Wizard,

Idera SQL Safe and scheduling it in accordance with the management.

. Experience in Extracting, Transforming and Loading (ETL) data from Excel,

Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS

services.

. Experience in working with Reporting tools like Crystal Reports,

Microsoft Reporting services.

Performance Monitoring and Tuning

. Monitor the production server using tools like SQL Profiler, Windows

Perfmon, Performance Counters and SQL server logs for Monitoring and

Tuning SQL Server.

. Experience in creating packages, jobs, sending alerts using Database and

SQL Mail.

. Monitored and managed SQL server instances with popular Monitoring

Solutions Idera diagnostic manager.

. Experience in MS SQL Server Configuration, Performance Tuning, Client-

Server Connectivity, Query Optimization, Database Maintenance Plans and

Database Consistency Check using DBCC commands.

. Created, altered, maintained system roles and permissions to users on

various database objects.

. Strong debugging skills and the ability to solve complex problems.

Stored Procedure, Functions, Views and Cursors

. Expertise in creating and managing Databases, Tables, Stored Procedure,

DDL/DML Triggers, Views, User defined data types, Cursors and Indexes

using T-SQL.

. Experience in using T-SQL in SQL Server 2000, 2005 and 2008 R2 platform

Database Design and Implementation

. Experience in using Data Modeling Tools like Erwin, MS access and

Microsoft Visio.

. Experience in Database Capacity Plan

. Good knowledge in Normalizing and De-normalizing the tables and

maintaining Referential Integrity by using Triggers and Primary and

Foreign Keys.

. Good knowledge of System Development Life Cycle (SDLC).

. Good in implementing SQL Server Security and Process Control.

. Experience in Creating Roles and Assigning Permissions to the users.

. Experience working on Production Server including Weekends and change

control support over nights

. Experience in contacting Microsoft PSS and other vendors for product and

technical support

. Experience in providing 24/7 support.

Education

Bachelor of Technology in Electrical Engineering from India. (Year of

Completion: May 2005)

Certification of Excellence from Microsoft

. 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

. 70-432 Microsoft SQL Server 2008 - Implementation and Maintenance

Technical Skills

Languages C, C++, T-SQL, Java.

Web Technologies HTML, DHTML, ASP.Net, XML, Java Script and VB Script

RDBMS MS SQL Server2008 R2, 2005, 2000, 7.0,

MS-Access,Oracle8.i,Oracle 9.i

Front End MS Visual Basic 6.0

OLAP Tools MS OLAP Services Manager

Version Control Tools Visual Source Safe, Rational Clear Case

Web Server IIS 5.1/6.0

Technologies

Reporting Tools Crystal Reports 8,9,10, Microsoft Reporting services

2005/2000.

Modeling Tool ERWIN 7.1, Visio 2003

Operating Systems Windows 2003/2008 R2, Windows Exchange Server 2003

Windows NT 4.0/3.5, Windows9.x, Windows XP, Unix, Linux

Hardware Dell Power Edge R900/R710, HP Proliant BL460c, 8500G2

server.

Application Areas

. Setting up Replication

Implemented Transactional Replication to synchronize the subscriber

server with the Publisher server has ample experience in implementing

peer to peer replication in Microsoft SQL Server 2005 and 2008 R2.

. Setting up Log Shipping

Implemented Log Shipping technique for DR solution for Microsoft SQL

Server 2000, 2005, 2008 R2 also solved and automated manual log shipping

issues.

. Installed and Managed Windows and SQL Server Cluster

Implemented, configured and Managed SQL Server Cluster in Active/Active

and Active/Passive mode.

. Troubleshooting and Performance tuning.

Experience in using tools like SQL Profiler and Windows Performance

Monitor for monitoring and performance Tuning.

. DTS (Data Transformation Service) & SSIS (Integration Services)

Professional Experience

FIS, New York. Duration: Feb

2014 - Present

Position: SQL Server DBA

Location: New York, NY

Description: I am working for "Fidelity National Information Systems" as a

backend SQL DBA in the maintenance of existing applications, migrating SQL

server databases from development to production Servers and giving support

to new applications. FIS Provides IT solutions to Bank Leumi USA such as

payment processing, banking solutions, providing software, services and

outsourcing of the technology that drives financial institutions.

Responsibilities

. Installed, configured, maintained and supporting SQL Server 2000,

2005, 2008, 2008 R2 and 2012 in high availability environments.

. Successfully Implemented 2 Node Active\Active clustering for

production applications with multiple instances of SQL Server 2012,

2008R2, 2005, 2000.

. Involved in migrating SQL Server Databases from Development to

Production Server.

. Creating and maintaining various databases on production/development

servers and provide 24 x7 support

. Created and Managed Backup and Disaster Recovery plans.

. Configure and manage database maintenance plans for update statistics,

database integrity check and backup operations.

. Tuned the Production server to get performance improvement by using

SQL Profiler, SQL Commands and Database Tuning Advisor and Performance

Monitor.

. Tested and implemented Database Mirroring solution for Production

critical application.

. Involved in development of automated daily, weekly and monthly system

maintenance tasks such as database backup, integrity verification,

replication verification, and indexing updates.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Create new databases, tables, and fields for data entry, performing

database capacity planning.

. Identified, tested and resolved database performance issues to ensure

data optimization.

. Used tools like SQL Server profiler, Performance Monitor to identify

bottlenecks.

. Implementation of system wide security policies and trouble shooting.

. Involved in installing SQL Server 2008R2, 2012 on Development,

Production for new applications.

. Involved in apply new service packs on SQL server 2005, 2008 and

2008R2.

. Troubleshooting high availability scenarios involving Clustering,

Database Mirroring, Log Shipping and Replication.

. Deployed and scheduled SSIS package.

. Managed Login and User: adding logins, roles, groups to the Windows

Server and MS SQL Server and maintaining proper security procedures.

Environment: Virtualization - VSphere 5.1 with update 2, HP Blade server

BL465C Gen 8 with 256 GB RAM, 2 CPU 16 core each. SQL Server 2008

R2/2008/2005 Enterprise and standard Edition, Windows Server 2003/2008 R2

Enterprise edition.

NEC Corporation of America.

Duration: Jan 2011 - Jan 2014

Position: SQL Server DBA

Location: Irving, TX

Description: NEC Corporation of America is a provider of semiconductor,

imaging, communication and Network technologies. The company operates

design, production, systems integration, marketing, and research and

development operations throughout North America. NEC Corporation of America

is a subsidiary of NEC Corporation, which is a publicly traded company that

offers broadband and Wireless Networks and information technology products

and services. I am working as a consultant back end SQL DBA in the

maintenance of existing applications and migrating SQL server databases

from development to production Servers.

Responsibilities

. Setting up Failover Clustering in SQL server 2008R2 (Active/Passive)

. Involved in migrating SQL Server Databases from Development to

Production Server.

. Creating and maintaining various databases on production/development

servers and provide 24 x7 support

. Configured Log shipping from Production to Disaster Recovery server.

. Tested and implemented Database Mirroring solution for Production

critical application.

. Involved in development of automated daily, weekly and monthly system

maintenance tasks such as database backup, integrity verification,

replication verification, and indexing updates.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Identified, tested and resolved database performance issues to ensure

data optimization.

. Used tools like SQL Server profiler, Performance Monitor to identify

bottlenecks.

. Implementation of system wide security policies and trouble shooting.

. Installed and Managed SQL Server 2005/2008/2008R2/2012 on Development,

Production.

. Troubleshooting high availability scenarios involving Clustering,

Database Mirroring, Log Shipping and Replication.

. Deployed and scheduled SSIS package.

. Implemented Logshipping in SQL 2000/2005 from primary to standby

server.

. Rebuilding indexes (online and offline) on various tables.

. Resolve locking and blocking issues.

. Managed Login and User: adding logins, roles, groups to the Windows

Server and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2008 R2/2008 Enterprise Edition, Windows Server

2008 R2 Enterprise edition, Idera SQL safe Manager, Idera Diagnostic

Manager, Idera Defrag Manager, SSIS, Dell Power Edge R900/R710, NEC Express

5800/R320.

Verizon

Duration: Jan 09 - Dec 2010

SQL Server DBA Location: Irving,

TX

Description: Verizon owns and operates the nation's most reliable wireless

network. More than 61,000 Verizon Wireless people serve over 56 million

customers nationwide. Verizon intends to enhance the features/functions of

the VZT and VZW websites and identify proper approaches to integrating them

across the websites. Focus of the current project is to provide a unified

view of the Verizon Telecom (VZT) and Verizon Wireless (VZW) websites. Each

website contains various bill views and bill pay capabilities in support of

the respective product lines. I am working as a consultant back end SQL DBA

in the maintenance of existing applications and giving support to new

applications.

Responsibilities

. Designed New Indexes on tables and worked with developers to increase

SQL server performance.

. Running DBCC consistency checks, and fixing data corruption in

application databases

. Configure and manage database maintenance plans for update statistics,

database integrity check and backup operations.

. Automate and enhance daily administrative tasks, including space

management, object alteration, backup & recovery and performance

monitoring.

. Experience in creating and maintenance of complex SSIS packages using

proper control and data flow elements.

. Have deployed packages on different servers by configuring it.

. Migrated SSIS packages from SQL Server 2005 to SQL Server 2008.

. Involved in upgrading the instance of development environment of SQL

Server 2005 service to SQL Server 2008.

. Involved in Installation and configuration of 2-node Cluster

(Active/Active) in SQL Server 2008.

. Partitioning tables to achieve better performance for access and

writes.

. Resolving locking (Dead Locks) and blocking issues.

. Creating logins, groups, users, roles, database devices, databases,

checking for database consistency, fixing DBCC errors, monitoring

error logs, database space allocations, transaction log space

allocations, fine tuning SQL performance.

. Used SQL Server 2008 Management Studio (SSMS) to develop, deploy and

troubleshoot databases.

. Tested and implemented Database Mirroring solution for Production

critical application.

. Implemented transactional replication for populating reporting

database.

. Create new databases, tables, and fields for data entry, performing

database capacity planning.

. Analyze various aspects of Stored Procedures and performed tuned as

needed to increase productivity and reusability of code.

. Reviewed Third Party tools Diagnostic Manager (Idera) so as to help

automate routine tasks such as monitoring, blocking and consolidate

status of scheduled jobs.

Environment: MS Windows server 2003 R2/2008 Enterprise Edition, MS SQL

Server 2000/2005, Visual Studio 2005/2008, HP ProLiant 8500 G2, Compaq

DL380, DL580, DL760 G2 with 14 GB RAM, EMC 35 TB, Dell Power edge Servers.

Barclays, New York

Duration: June 08 - Dec 08

SQL Server DBA Location:

Manhattan, NY

Barclays is a major global financial services provider engaged in personal

banking, credit cards, corporate and investment banking and wealth and

investment management with an extensive international presence in Europe,

the Americas, Africa and Asia.

Responsibilities

. Successfully Upgraded from SQL Server 2005 to SQL Server 2008 on

development and Testing Environment.

. Development of automated daily, weekly and monthly system maintenance

tasks such as database backup, database mirroring, replication

verification, database integrity verification and indexing updates and

apply in development and Testing Environment.

. Worked in Active/ Passive Cluster environment.

. Developed disaster recovery plans and contingency systems including

evaluating and recommending appropriate backup and archival software,

hardware, media, off site storage.

. Generated test data and check databases consistency to meet the

functionalities requirements.

. Creating logins and roles with appropriate permissions.

. Configured MS SQL Server 2005 in-built log shipping from primary server

to standby server for report generation.

. Configured Various Replication Types between Primary Server and Read-Only

servers.

. Successfully implemented database mirroring with high availability mode

in SQL Server 2005.

. Installing applications and establish the connectivity with the database.

. Creating Stored Procedures to convert database tables into XML format and

display via web.

. Monitored database performance and rebuilt indexes on tables using Index

tuning Wizard to reduce fragmentation.

. Upgrade DTS Packages to SSIS Packages

. Assist ETL Developers to write and debug SSIS packages.

. Involved in Performance tuning, and optimization of procedures and

queries.

. Worked with SQL Server Profiler to generate traces.

. Had good experience in 24/7 production support.

. Helped Development Team in deploying and testing the application, which

uses SQL Server 2005 backend.

Environment: MS Windows 2000 Data Center, MS Windows server 2003 R2

Enterprise Edition, MS SQL Server 2005/2008, Visual Studio 2005/2008, IIS

6.0, HP ProLiant DL380 G2 with 12 GB RAM, Dell PowerEdge Servers.

Premier Bankcard Inc.

Duration: Jan 08 - May 08

Position: SQL Server Development DBA Location: Sioux

Falls, South Dakota

Description: Premier Bankcard Inc., a leading credit card provider in the

United States, specializes in offering credit to help individuals establish

and re-establish their credit.

This project was focused on the construction of a new accounting

application based on an architecture that is flexible, scalable and can

accommodate current and anticipated future needs for all Premier Bankcard

Inc. credit card and participation certificates (PC securities). The goal

was to provide accounting data on a daily basis, or as close to a real time

business transaction date. I was working there as a SQL Server DBA.

Responsibilities

. Responsibilities include monitoring daily, weekly and monthly system

maintenance tasks such as database backup, replication verification,

database integrity verification and indexing updates.

. Installing, Configuring and Maintaining SQL Server 2005 with latest

Service Packs, Hot Fixes.

. Successfully Implement the 2 Node Active\Passive Clustering for 2

production Servers..

. Implement Log Shipping in SQL Server 2000 from primary server to Standby

server.

. Installing and configuring SQL Reporting Services 2000 on Windows Server

2003 EE environment.

. Responsibilities include Creating and Maintaining Database Maintenance

Plans.

. Responsibilities include advising in Planning and designing the Logical

and physical Data Modeling.

. Help the Development team to write and tuned Stored Procedures, Triggers,

UDF, Queries.

. Performed Structural changes to Database like creating tables, adding

columns according to

Business requirements.

. Monitored growth of data and managed space allocation accordingly.

. Writing and tuning stored procedures, triggers, queries.

. Installing applications and establish the connectivity with the database

. Performance Monitoring with SQL Profiler and NETIQ Appmanager.

. Writing Stored Procedures and Create Jobs for Backup & Restore Plans.

. Work in 24/7 production support.

Environment: Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL

Server 2000 & 2005, Microsoft SQL Server Reporting Services 2005, Visual

Studio.Net 2003, Compaq Proliants 8000/6500,IBM Fast T 700 Storage Area

Network (SAN).

Client: Broadspire Services Inc.

Duration: May 07 - Dec 07

Position: SQL Server DBA

Location: Plantation, Florida

Description: Broadspire is Plantation, Florida based company which was

formed in July 2003. It is a third party administrator for the insurance

industry offering an integrated casualty and disability claim management,

medical management, and risk and safety consulting services.

In order to reduce the operational costs the company migrated to SQL Server

2005 from SQL Server 2000.

Responsibilities

. Successfully Upgraded from SQL Server 2000 to SQL Server 2005 on

development and Testing Environment.

. Responsible for MS SQL Server 2000 & 2005 configuration, tuning and

provide 24 X 7 dedicated support to all Production, development and

clustered servers.

. Maintained the security, integrity and availability of MS SQL Server

2005.

. Performed data backup, recovery, and transfer operations.

. Maintained the security, integrity and availability of SQL Server.

. Used DTS to extract, transform and consolidate data from different

sources into Data Warehouse.

. Configured Log shipping from one production server to the reporting

server.

. Performance Monitoring with SQL Profiler and Windows System Monitor

. Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps

and Schedules.

. Monitored Connections, locks and performance of SQL Server.

. Assign permission to user(s), role(s), and object. Support column level

permission. Administrate security for server's logins (Windows and SQL

Accounts).

. Wrote and integrated Stored Procedures to generate the Reports.

. Expertise in Security Issues such as creation and granting permissions on

various Objects.

. Preparing the reports for the day-to-day as well as weekly/monthly

purposes.

Environment: MS Windows 2003 EE, Windows NT 4.0, SQL Server 2000 & 2005, T-

SQL, Excel, HP Integrity Servers.

[pic]

Contact this candidate