Sql Server Database

Dinesh Kumar

Email: - *****.*****@*****.***

Contact No: +91-837*******

OBJECTIVE:

To obtain a challenging position in a quality environment where my academic skills will add value to organizational operations & provide wings to my career.

Core Competencies

Creative Problem Solving Database Management Analytical Approach

Product Improvement Process Validation Assessment/ Plan / Implement

Highlights of Employment

Mukund Softs Pvt. Ltd. (May. 2014 To March 2015)

Working as Software Engg. and PLHA Help Desk Team Member.

Key Responsibilities as –

Installation of SQL Server at Centers by using Telnet Software like Team Viewer, Ammy Admin.

Troubleshooting SQL Server Related Problems at ART (Anti Retroviral Therapy) Center.

Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility.

Installing multiple Instances of SQL Server so that we can work with independent Databases.

Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.

Creating users with Windows or SQL Authentication and assigning permissions.

Shrinking Database and Log Files to save the Storage.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).

Worked closely with management, applications development staff, and users on database solutions to business problems.

Generating reports by executing Query Statements for NACO Officials.

Core Data Base Systems- Noida (Jan 2013 – July 2013)

Implemented Two Projects (Data Base Migration from One OS to Other) and Data Guard.

Key Learning:

Oracle 9i/10g Database Server Installation & Configuration.

windows /Red Hat Linux Installation.

Creation of User, Role, Profile, Granting permission and Auditing of Database

Creation of Oracle Database Manually and using DBCA.

Management and Manual Recovery of Standby Database for Disaster Recovery.

RMAN Configuration and Maintenance; Rman Backup/Recovery of Database.

User Managed Backup (Hot & Cold) on Disk and User Managed Recovery.

Creation of Different type of Table Spaces and Adding/Resizing Data files, Multiplexing of Control File and Redo Log File, Cloning of Database.

Configuration of Archive and No Archive log mode.

Technical Skills

Operating System Windows vista, Windows 7, Linux

Languages Known Html, Sql

Database Oracle9i,10g, Sql Server 2008

Computer Skills Software: Microsoft word, Excel, Power

Point, Access

Project Works

Database Migration (Migrate Database from One Operating System To Other on same platforms like 32bit/64bit).

Data Guard (Data security in case of Database failure or Disaster Recovery).

Education Summary

MCA with 72% from Himachal Pradesh University.

PGDCA with 64% from Vinayaka Mission University.

Bachelor’s Degree in non-medical with 50% from Himachal Pradesh University.

Senior Secondary in non-medical stream with 56% from Himachal Board Of School

Education Dharmshala.

Matriculation with 70% from Himachal Board Of School Education Dharmshala.

Personal Detail

Name Dinesh Kumar

Father Name Sh. Gain Chand

Sex Male

Marital Status Single

DOB 14-dec-1987

Address vill-dehra,po-hatwar,teh-ghumarwin,distt-bilaspur

Himachal Pradesh,174028

Contact this candidate