Sql Server Project

Location:

Bridgewater, NJ, 08807

Salary:

$80/Hr on C2C

Posted:

March 26, 2013

Contact this candidate

Resume:

[pic] [pic] [pic]

Kuljit Singh

**************@*****.***

201-***-****

PROFESSIONAL SUMMARY

. 10+ years of Database Experience on SQL Server 2008/ 2005/ 2000/ 7.

. Manages SQL components - Production and Non-Production environments.

. SQL Server Configuration /Installation- Stand-alone/ Networked/

Clustered/ Virtual Environment

. Extensive experience in

- Server Builds

- Database Automation

- Backup/Recovery - Database & System

- Failover Cluster

- Transactional Replication

- Log Shipping

- Mirroring

- Data Partitioning

- Performance Tuning

- Query Optimization

- Security Management

- Migration - Data & Server

- Server & Client Patches

- Version Upgrades

- High Availability

- Disaster Recovery

- Security Management

- Reporting Services Administration

- Integration Services Administration

- Analysis Services Administration

- Server & Database Monitoring And Alerting

. Maintain database architecture, modify/recreate databases by creating

and maintaining different plans and objects.

. Analyzes system performance and capacity, creating recommendations for

improvements for solutions to problems

. Hands-On experience of T-SQL.

. Implement and Maintain Stored Procedures, Triggers, Views, Functions,

Indexes, Constraints, AdHoc & Distributed Queries, Database

consistency

. Database performance & monitoring solution SCCM/SMS/MOM

. Develop & maintain custom tools to improve day-to-day processes

. Develops and implements departmental policies, procedures, best

practices and SOPs.

. Assistance for database programming to users.

. Good communication and documentation skills,.

. Maintain & present Database & operational usage reports.

. Problem Determination & analysis skills and strong learning ability.

. Evaluates new technologies to ensure efficacy

. Manages changes, upgrades and the introduction of new technologies

to the production environment

. Windows System Administration on 1st level.

. Database experience with Oracle.

. Exposure/Experience to .NET, COM/DCOM.

. Client Application Support -

Web Applications >10

Client/Server Applications >10

Desktop Applications >5

Background Applications >25

\ Processes

TECHNICAL SKILLS

Relational Database MS SQL Server 2008 R2/ 2005/ 2000/ 7, Oracle 9i, MS

Access, MY-SQL

Database Automation SMO, DMO, CScript, WSH

Operating Systems MS Windows Server 2008 R2/ 2003/2000/ XP, Windows 98/ 95,

DOS, Linux (Red Hat)

Programming Visual Basic 6/ .NET

Languages

Scripting VB Script, HTML, XML, Windows script host

Web Servers IIS, Web Sphere, Apache

Packages MS Office, Crystal Reports, JD Edwards, Lotus, WordStar,

FoxPro

Technologies ADO.NET, ADO, COM/ DCOM, MTS, ActiveX, COM+, XML Web

Services, Active Directory, DNS, DHCP

Tools Failover Cluster, Performance Monitor, FrontPage, Adobe

Photoshop, Browsers (Internet Explorer/ Netscape/

Mozilla), FTP tools - WS FTP, WinSCP, Backup -Veritas,

Net Backup, GridApp Clarity, Foglight.

Storage SAN/ NAS

Networking LAN, WAN, Internet, V-LAN

Environment Physical, Virtual - VMWare

CERTIFICATION

1 MCDBA (Microsoft Certified Database Administrator) -- Microsoft,

USA

2 MCSD (Microsoft Certified Solution Developer) -- Microsoft, USA

3 MCP (Microsoft Certified Professional) -- Microsoft, USA

4 DOEACC 'O' Level -- Govt. of India, India

(Dept. of Electronics Accredited Computer Certificate)

EDUCATION

Post Graduate Diploma in Computer Applications, 2005

GJ University, Haryana, India

Graduate Degree,

Panjab University, Chandigarh, India 2003

EXPERIENCE

Client Name Deloitte Touche Tohmatsu Limited

Period February 2012 - Till Now

Project Description The project involves Analyze, Consolidate, Migrate &

Maitain Database Systems.

Role Sr. Operations Database Analyst

Responsibilities

. Install & maintain failure clustering using Active-Passive Clustering.

. Manages SQL components across Global Production and Non-Production

environments.

. Provide triage and escalation support to SQL issues.

. Develop various strategies, Build and Implement them on Database

Servers.

. Infrastructure sizing and installation

. Performs software & server administrative tasks.

. Performs monitoring & control of global production environment.

. Proactive monitoring of Log Shipping using T-sql scripts, VB

Script/windows host script, HTML.

. Provide database solutions for application development.

. Participates in a 24/7/365 on-call rotation.

. Ensures applications are available & reliable.

. Ensures the readiness of disaster recovery & continuity capability is

maintained.

. Ensures SQL application data is backed-up.

. Supports application architecture based on standards & requirements.

. Participates in status calls.

. Comply with and ensure compliance to established change control

process.

. Develops custom tools to improve day-to-day processes.

. Knowledge Sharing / Documentation.

. Distribute operational reports.

. Provide guidance to offshore teams.

Client Name Agadia Systems Inc., Parsippany, NJ

Period April 2011 - January 2012

Project Description The project involved Analyze, Consolidate, Migrate &

Maitain Database Systems to Failover Cluster and

Transactional Replication on SQL Server for www.PaHub.com

Role Sr. Database Analyst/ Migration/ Administration

Responsibilities

. Implement Failover Cluster from scratch.

. Database migration to SQL 2008 from SQL 2005/2000.

. Infrastructure sizing and installation

. Analyze existing database servers.

. Develop strategy, Build and Implement Clustered SQL Server.

. Install & maintain failure clustering using Active-Passive Clustering.

. Implement and Migrate production databases.

. Provide facility to produce and maintain quality data efficiently.

. Incorporating performance measurement by using tools like SQL Analyzer

along with T-SQL, SQL Profiler and Windows Performance Monitor.

. Responsible for technical design and architecture of Failover Clustering

based on established standards.

. Data migration- analysis, design and implementation.

. Database Automation using SMO, WSH, VB Script.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution.

. Documentation and system diagramming.

Environment MSSQL SERVER 2008 R2/ 2005/ Windows Server 2008 R2/2003 (64

Bit/ 32 Bit)

Client Name Emblem Health, NYC, NY

Period March 2011 - April 2011

Project Description Project involved Analyze, Optimize & fine-tune EDI

environment implemented in BizTalk Server.

Role Lead SQL Server 2008 DBA

Responsibilities

. Implement Failover Cluster from scratch.

. Database migration to SQL 2008 from SQL 2005/2000.

. Infrastructure sizing and installation

. Analyze existing database servers.

. Develop strategy, Build and Implement Clustered SQL Server.

. Install & maintain failure clustering using Active-Passive Clustering.

. Implement and Migrate production databases.

. Provide facility to produce and maintain quality data efficiently.

. Incorporating performance measurement by using tools like SQL Analyzer

along with T-SQL, SQL Profiler and Windows Performance Monitor.

. Responsible for technical design and architecture of Failover Clustering

based on established standards.

. Data migration- analysis, design and implementation.

. Database Automation using SMO, WSH, VB Script.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution.

. Documentation and system diagramming.

Environment MSSQL SERVER 2008 R2/ Windows Server 2008 R2 (64 Bit)

Client Name Somerset Medical Center, NJ, USA

Period September 2010 - Jan 2011

Project Description The project involved Analyze, Consolidate and

Migrate Databases to Failover Cluster SQL Server.

Role Database Analyst/ Migration/ Administration

Responsibilities

. Implement Failover Cluster from scratch.

. Database migration to SQL 2008 from SQL 2005/2000.

. Infrastructure sizing and installation

. Analyze existing database servers.

. Develop strategy, Build and Implement Clustered SQL Server.

. Install & maintain failure clustering using Active-Passive Clustering.

. Implement and Migrate production databases.

. Provide facility to produce and maintain quality data efficiently.

. Incorporating performance measurement by using tools like SQL Analyzer

along with T-SQL, SQL Profiler and Windows Performance Monitor.

. Responsible for technical design and architecture of Failover Clustering

based on established standards.

. Data migration- analysis, design and implementation.

. Database Automation using SMO, WSH, VB Script.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution.

. Documentation and system diagramming.

Environment MSSQL SERVER 2008 R2/ Windows Server 2008 R2 (64 Bit)

Client Name EISAI Inc, NJ, USA

Period August 2008 - August 2010

Project Description The project involved Administrating and Maintaining

the database servers and to provide support for server

administration and applications also.

Role Database Analyst/ Administration/ Developer

Responsibilities

. Installation, configuration and upgrading of MSSQL server 2008/ 2005/

2000 including SSMS, SSIS, SSAS, SSRS.

. Database Automation using SMO/DMO, WSH, VB Script.

. Data analysis, Troubleshoot and consult database objects like Stored

Procedures, Triggers, Views, Functions, Indexes, Constraints, Queries,

Distributed Queries.

. Implement and maintain database security (create and maintain users

and roles, assign privileges).

. Maintain & Support in Performance Tuning, Query Optimization,

Client/Server Connectivity, Database consistency checks, Quality

Analysis.

. Plan, Configure and maintain ETL packages.

. Proactive monitoring using t-sql scripts, VB Script/ HTML, windows

host script.

. Provide facility to produce and maintain quality data efficiently.

. Incorporating performance measurement by using tools like SQL Analyzer

along with T-SQL, SQL Profiler and Windows Performance Monitor.

. Database migration.

. Setup & Maintenance of multiple database environment(s) on each given

project.

. Responsible for database technical design and architecture based on

established standards.

. Data migration analysis, design and implementation.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution.

. Mentoring of junior DBAs and support staff including developers.

. Documentation and system diagramming, Application support provided.

. Client Application Support -

Environment MSSQL SERVER 2000/ 2005

Client Name Aginomoto Inc, NJ, USA

Period January 2008 - July 2008

Project Description The project involved Designing and maintaining the

database servers and to provide support for server

administration and application also. Support for SQL

clustering and replication.

Role Database Administration/ Developer

Responsibilities

. Maintain and monitor DB Servers .

. Implement and Optimize Stored Procedures, Jobs and packages in SSIS.

. Performance Enhancement, Query plan Optimization

. Database Automation using DMO, Batch Script, VB Script.

. Database Integrity checks, Quality Analysis.

. Provide database solutions for application development.

. Generating and providing reports on server health to management using

SSRS.

. Implement and maintain database security.

. Performance optimization by using T-SQL query plans, SQL Profiler and

Performance Monitor.

. Setup & Maintenance of multiple environments on each given project by

installing MSSQL Server 2000/2005/2008.

. Responsible for database technical design and architecture based on

established standards.

. Documentation and diagramming of database design and structure.

. Data migration analysis, design and implementation.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution and train company DBAs

. Application Support for 50 Apps. including in-house and third party

applications .

Environment MSSQL SERVER 2000/ 2005

Client Name ForeFront Inc, NJ, USA

Period December 2007 - January 2008

Project Description ForeFront develops, integrates, deploys and manages

information technology that brings innovative business

solutions to clients. Their focuses on the mid-market needs

and delivers a broad portfolio of business solutions.

Role Database Administration/ Developer

Responsibilities

. Installation, configuration and upgrading of MSSQL server 2000/ 2005.

. Implement and maintain database security.

. Maintain and monitor disk space by developing Stored Procedures and Jobs.

. Data analyses and Capacity Planning.

. Develop strategy in order to perform data migration from multiple

Platforms.

. Generating/ developing reports in SSRS following SDLC.

. Documentation and system diagramming, Application support provided.

. Support for troubleshooting production issues.

. Cross training of both other DBAs and support staff.

. Data migration analysis, design and implementation.

. Provide documentation that articulates the database technical

solutions that will be used to guide the delivery of the technical

solution.

Environment MSSQL SERVER 2000/ 2005

Client Name Max New York Life Insurance, US & India

Period June 2005 - October 2007

Project Description NYL is a leading life insurance group. The project

involved Export/Import of Data, Replication, Failover

clustering, Database Objects creation and development,

quality assurance and production stages of SQL Server 2000

Installation, Configuration and Maintenance.

Role Database Administration\ Sr. DBA

Responsibilities

. Installation, configuration and upgrading of MSSQL server 2000/ 2005.

. Provide database solutions for application development.

. Provide facility to produce and maintain quality data efficiently.

. Plan, Configure and maintain, DTS/SSIS, Transactional Replication and Log

Shipping, Quality Analysis.

. Configured database maintenance plans for backup and database

optimization.

. Establish and maintain various backup and recovery policies and

procedures.

. Implement and maintain database architecture, modify/recreate

databases by creating and maintaining different plans and objects.

. Database/ Security modeling.

. Implement and maintain database security (create and maintain users

and roles, assign privileges).

. Implement and maintain database modeling using VISIO.

. Perform database tuning and performance monitoring.

. Incorporating performance measurement by using tools like SQL Analyzer

along with T-SQL and NT Performance Monitor.

. Development of T-SQL objects and writing Stored Procedures, Triggers,

Views, Functions, Indexes, Constraints, Queries, Distributed Queries

as per SDLC.

. Designing test plans for HINTS and initialization parameters for Quality

assurance.

. Added value to the business by facilitating improved process design.

. Windows system administration on 1st level.

. Documentation and system diagramming, Application support provided.

. Involved in troubleshooting production issues.

. Cross training of both other DBAs and support staff.

. Assisted Oracle DBA's.

. Perform general technical troubleshooting.

. Provide consultation to development teams on Stored Procedures,

Triggers, Views, Functions, Indexes, Constraints, Queries, Distributed

Queries.

. Responsible for application database review & testing developed both

in-house and/or by external vendor.

. Responsible for maintaining database code, objects, backups and

version control in development, test and production environments.

. Application Support for performance enhancement and optimized plans.

. Mentoring and coaching to peers.

Environment Windows 2000 / 2003, MSSQL SERVER 2000/ 2005, Oracle 9i,

Replication, Log Shipping.

Client Name Technova Imaging Systems

Period Jan 2004 - May 2005

Project Description The project involved Designing strategy to provide

24 X 7 support.

Role Database Administration/ Developer and Application Support/ Sr. DBA

Responsibilities

. Installation, configuration and upgrading of MSSQL server 2000/ 2005/ 7.

. Failure recovery using Active-Passive Clustering.

. Failover Clustering, Data Partitioning, Mirroring, Data Replication.

. Plan, Configure and maintain Transactional Replication.

. Configured MS SQL Server 2000 log shipping from primary server to

standby server.

. Configured database maintenance plans for backup and database

optimization and DTS.

. Implement and maintain database security.

. Perform database tuning and performance monitoring.

. Plan growth and changes (capacity planning).

. Maintain and monitor disk space availability on SAN.

. Work as part of a team and provide 24X 7 support when required.

. Data analysis, and make recommendations relating to performance and

efficiency of that data storage and database objects like Stored

Procedures, Triggers, Views, Functions, Indexes, Constraints, Queries,

Distributed Queries.

. Incorporating performance measurement by using tools like SQL Analyze

along with T-SQL and NT Performance Monitor.

. Designing test plans for HINTS and initialization parameters.

. Assisted for database programming to developers.

. Windows system administration on 1st level.

. Documentation and system diagramming, Application support provided.

. Involved in troubleshooting production issues.

. Database Backup/Restore using VERITAS.

Environment Windows 2000/ 2003/ XP, MSSQL SERVER 2000/2005, Log

Shipping, Failover Clustering

Client Name Universal Business Systems

Period July 2002 - Jan 2004

Project Description This system recorded all store transactions like

material received against purchase order, material issue,

and stock adjustment voucher, material returned to stores,

material receipt/issue from/to production unit. The system

kept information of stores in terms of quantity and value,

updates purchase order/manufacturing orders depending on

the various stock transactions.

Role Design, Develop & Administer Database, Integrate with Web Site,

Tune for performance

Responsibilities

. Installation, configuration and upgrading of MSSQL server software and