Chintan Mehta

** **** *******, ********** ,** *6604

Tel:1-203-***-****

E-mail: wbhg34@r.postjobfree.com

Objective: To obtain a SQL Database Assistant position in the field of Information Technology.

Summary of knowledge as an SQL Database Administrator:

• 1 year of experience in Database administration activities like Installation, Configuration, Backup & Recovery Database transformation services(DTS).

• Good knowledge of Relational Database Management System (RDBMS)

• Experience in upgrading in MS SQL server 2000 to MS SQL server 2005

• Experience in Database mirroring , Upgrading and Migration

• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.

• Worked on Database mirroring for high availability mode in SQL 2005

• Successfully implemented Log shipping Techniques used for warm backup solution for MS SQL 2000.

• Extensive experience in Disaster Recovery, troubleshooting, Backup and Restore procedures.

• Knowledge of how to configure and manage linked server.

• Creation and maintenance of database, creating roles and managing users permissions.

• Experience in using different feature for bulk load program like DTC, BCP, Bulk insert and knowledge of SSIS

• Experience in using Microsoft built in tool like SQL Profiler, Windows Perfmon and DTS tool.

• Experience in working with Windows 2000 enterprise server and windows 2003 Advance server Administration and installation .

• Monitoring Event Viwer,SQL Error logs and Log file View for software and hardware related errors

Microsoft Certification (MCP & MCTS)

• 070-431 Microsoft SQL server 2005 Implementation and maintenance

Brainbench Certification

• Brainbench : SQL 2005 Administration

• Brainbench : SQL 2005 Programming

• Brainbench : SQL 2000 Administration

• Brainbench : SQL 2005 Programming

• Brainbench: RDBMS concepts

Technical Educational Background:

• Masters of Science, University of Bridgeport, Bridgeport, CT.

Major: Electrical Engineering

• Bachelor of Engineering, University of Mumbai, India.

Major: Electronics

• Diploma of Engineering, Maharashtra State Board of Technical Education, India. Secured first Major: Digital Electronics

Domain knowledge:

Operating Systems Windows 95/98/ME/2000/NT/2003, MS-DOS, Linux (RHAT),Unix

Database MS SQL Server2000/MS SQL2005,

Languages SQL, PL/SQL, Assembly language 8086, 8051 Matlab,C-Prog (basics)., C++ (basics)

Client: AT&T.

Place: Atlanta, GA

Project Name: NRS (Network reporting system)

Environment:MS windows 2000 data center, MS 2003 enterprise server, MS SQL server 2000/2005 Dell Power edge Server

Role: SQL DBA

Description:

The scope of the project that I worked NRS (Network reporting system) facilitate in the maintenance and development of the application. NRS environment contains two applications:NRS ADSL,NRS ATMFR.NRS ADSL application is a data warehouse of ADSL network informations.NRS ATMFR application is a data warehouse of ATM frame relay network informations.Both the application share the same environment.NRS environment has two back-end database server,two front-end reporting server,and one disaster recovery backend server. The IT group is responsible for maintenance of infrastructure and MS SQL database in a 24x7 environment.

Responsibilities:

• Successfully upgraded from SQL server 2000 to SQL server 2005 on development and testing Environments.

• Involved in migrating DTS to SSIS

• Created and maintained various databases for every environment.

• Perform Backup, Recover and transfer operations.

• Worked on Database mirroring for high availability mode in SQL2005

• Knowledge of configuring and managing linked server.

• Creation and maintenance of database, creating roles and managing users permissions.

• Experience in using different feature for bulk load programme like DTC, BCP, Bulk insert and knowledge of SSIS

• Experience in using Microsoft built in tool like SQL Profiler, Windows Perfmon and DTS tool.

• Inexperience in working with Windows 2000 enterprise server and windows 2003

• Advance server Administration and installation .

• Monitoring Event Viwer,SQL Error logs and Log file

Academic Project Detail: (during the degree in electronics eng.)

Project Objective To build a complete controlling system for elevator.

Brief Description

The controlling system for elevator takes care of following aspects:

• Decide the priority to which floor it should serve first for multiple request.

• Control the exact position of the elevator so that it reaches to the commanded location.

• Displaying the floor number when it passes through particular floor & announces the floor no. when it reaches the destination.

Contribution in Project • Studied and shared the concept of Elevator controller requirement for the codec.

• Contributed to make the controller meet performance criteria, within the Compliance framework.

Project detail: (during the diploma in digital electronics eng.)

Project Objective To build a Multilevel Remote Control system for one particular room switch board

Brief Description

It takes care of following aspects :

• Controlling the ten switches remotely

• ON – OFF switch of the light,fan,ac,lamp etc

• Controlling the speed of fan

• Controlling can be done by using a infrared sensor

Contribution in Project • Study all the electronics components which used in this project

• Study the concepts of sensor and communication system for eg transmission and receiving

Other Achievements:

• Received Scholarship from J.R.D. TATA after Completion of Diploma in Digital Electronics

• Received Scholarship from Ratan Tata after Completion of Diploma in Digital Electronics

Major Strengths:

• Ability to set goals and thrive to accomplish in stipulated time frame.

• Highly motivated, creative & versatile.

• Innovative, hardworking & determined.

• Enthusiastic approach towards learning new things.

• Committed to excellence

Contact this candidate