Sql Server Manager
Resume:
Sukhjinder Singh
SQL Server DBA
E-mail: *******@****.***
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