Kapil S.

DATABASE ADMINISTRATOR

197 dollar
Freelancer
3 years
Delhi, INDIA

My experience

More

Primus Telecom Group Inc (USA)November 2009 - September 2012

Domain Telecom
Clients Primus Telecom Group Inc (USA),
Technology MS SQL SERVER 2000/2005/2008

Roles & Responsibilities:


* Installation, configuring and upgrading of SQL Server.

* Taking Full, Differential and log backup.

* Implement and maintain Database security (create and maintain users and roles, assign privileges).

* Creation of Databases objects i.e., tables and views

* Import/export data into SQL Server using BCP, Bulk insert and import/export wizard.

* Moving Databases from one SQL Server to another using detach/attach and other tools.

* Track locking, blocking and long running queries and take appropriate action if occur.

* Create configure and maintain the SQL Agent Jobs, maintenance plan, snapshot, log shipping, mirroring, and replication of database

* Monitoring the growth of Database and taking proper action.

* Maintaining archived data on tape.

* Share knowledge by effectively documenting work

My stack

VMWare, Troubleshooting, SQL Server Reporting Services, SQL Server Replication, Nagios, MS SQL Server 2008 SP1, Microsoft Windows 2003 Server, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server, Database Management, Database Administration