Sql Server Project

I Have ** years of extensive experience in Database Administration,

Database designing, modeling of business application systems in

Client/Server/Web environment. Highly technical SQL Server DBA with Strong

Project Management Skills, good hands on experience with NT & UNIX Systems,

application development. Extensive experience in problem resolution, 24x7

production Support, systems analysis, Backup and Recovery, design, testing

and implementation of application software in various platforms.

Education:

Bachelor of Engineering in Electronics and Communication, Computer software

as Elective (BS)

Microsoft certification: MCSE

EXPERIENCE:

(Jan 98 - Dec98), (July 99 -Feb 03) and (Dec 05 - Till now) 10 years.

SQL Server DBA J.P. MorganChase, NY

MS SQL Server Support and service for servers: supporting back-end (MS SQL

Server 2008-6.5) for different departments for Regulatory, FX Web Market

Maker Project, MP2 Server, E-Awards Server, Clear Quest Project, CA TNG

Unicenter, Assentor Project, BAS Project, VB Project, BMC Patrol etc. Apart

from day to day activities. This project involved formulation of Best

practices of MS SQL. And helping developers and application groups on query

tuning and index, for writing store procedures, joining tables and

normalization.

(Sept 04-Dec 05) SQL Server DBA Howrey DC/VA

Primary SQL DBA for the firm, and carried many projects like moving SQL

server for new H/W. Upgrading with new service packs, creating replication,

multiple instances, server installation and planning for new projects,

writing many shell scripts to match the need of the firm and also

responsible for many projects within the firm LegalKey, DM, Collaboration,

Alecto, Litigation docketing, CompuLaw, iBillback etc. apart from Daily

Maintenance, Monthly maintenance and performance tuning etc.

(Apr 03-Sept 04) SQL Server DBA Chrysler MI

This project involved, primary DBA to MS SQL database Servers and secondary

DBA to Sybase Servers, for Web and Stand alone applications, some extent

helping UDB DBAs, this project involved other than day to day jobs, moving

SQL server and Sybase databases from old EMC to new EMC drives, writing NT

and few Unix Shell scripts for alerting jobs. Exporting and importing data

from various databases to and fro of MS SQL and transforming it (ETL),

executing DTS packages, compiling triggers, stored procedures and

performance tuning on SQL2K servers on W2K clustered servers.

(Jan 99 - June 99) AT&T NJ

MS SQL Administrator: Was Responsible for maintaining Production Server and

responsible for developing SQL server back end for AT&T-TCI merger single

bill project and transferring Data extracted from mainframe (File) to MS

SQL Server.

Going through the clients' requirements and coming up with database design

and application architecture. Providing consultation on SQL Server to our

development teams. Installing, configuring, administering and securing

production servers.

Writing Ad-Hoc queries team to analyze data.

(Nov 97 - Dec 97) Brown Brother Harriman & Company NJ, USA

This was a short term and 1st USA project involved in installation

& Designing of Dynamic Host configuration protocol (DHCP) Server,

configuration and implementation of WINS and DNS Server in BBH

environment

(Jan 96 - Oct 97) Electronic Data Systems, Japan (Head Office: EDS, Plano

Texas)

Clients: ING Baring Securities, CITI Bank and EDS internal client

These projects were meant to Install and configure MS SQL Server. Migrate

to NT from present network and transit smoothly all existing applications

to NT Environment, maintain, administrate the NT network and train the

user. Managing and creating User accounts, Managing Security of Local and

Global groups, Domain Management, Windows NT Interconnectivity, Application

and package management in NT Environment, De fragmenting (Jet Packing).

Technical Skills:

O/S: Win (NT), UNIX, NetWare & MS-DOS

Hardware: Compaq, Dell & IBM Servers

Languages: TSQL, Shell Script, JavaScript and HTML

RDBMS: MS SQL 2008-6.5, Sybase 12.x, Oracle 10.4

Protocols: NetBEUI, IPX/SPX, NWLINK, DLC, SMTP and TCP/IP

Tools and Servers: Tomcat, Vignette, iPlanet, Crystal Reports, ERWIN,

CAST SQL Builder and DBARTISAN. Humming bird Exceed, BMC

PATROL. PC-Anywhere, Terminal Service, MS Office Products.

o Excellent experience in managing SQL Server 2008- 6.5, fair knowledge

about Sybase ASE 12.x and 11.x and Oracle 10.4.

o Extensive knowledge in Troubleshooting, Performance Tuning, Security,

Software Maintenance and Resource Management.

o Conduct application transaction volume and traffic analysis and interpret

impact on database and network performance.

o Experience in system study, logical data modeling, physical database

design and creation, Development, testing and maintenance.

o Implementing strategies for different kinds of backups and scheduling

those backups on Clustering, disaster recovery plans.

o Excellent experience in writing T-SQL functions, procedures, packages,

and triggers.

o Writing triggers, procedures, queries, joins, DML, DDL, shell and batch

scripts.

o Performing ETL, fair knowledge of Log shipping and Rep activities to

comply replication process between instances.

Contact this candidate