MS SQL Server DBA Resume

SUMMARY

Comprehensive understanding of databases like MS SQL server 2000, MS SQL server 2005, MS SQL server 2008, MS SQL server 2008 R2
Basic understanding of development languages like C#.net, ASP.NET etc.
Good communication, analytical and interpersonal skills with the ability to grasp new concepts and utilise the same in a productive manner.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server DBA

Responsibilities:

Database Migration from SQL server 2000 to SQL Server 2005 and 2008.
Database Migration from sql server 2005 to sql server 2008 and 2008 R2
Implemented CLUSTERING (Windows and SQL) on production environment.
Performed Logshipping activity and Table partitioning activity on production server for table which consist 8 crore rows
Implemented security policy, backup policy and complete performance tuning in production environment
Performed DR drill activity (LOGSHIPPING DR Drill) for multiple clients
Applying SQL server patches on Production Server and UAT servers.
Performance monitoring & Tuning using SQL Profiler, DTA.
Installing/Uninstalling/Upgrading/Hardening SQL server 2000/2005/2008/2008R2, Monitoring and troubleshooting performance alerts and space management.
Dealing with performance issues on production servers.
Taking care of problems faced by users related to slow execution of queries etc.
Analysing the problem first & then taking required measures to resolve the same.
Backup and restore of the SQL server database.
Creation of Logins, Roles and granting rights.
Implementing and configuring Database Maintenance Plan.
Implementing & Monitoring the Log Shipping for DR server.
Utilization of DBCC commands for maintaining database consistency.
Recover databases in case of any failures.
Scheduling and checking jobs.
Done Database Archival activity on production server.
Database maintenance activities using DBCC and DMVs.
Implement Backup Policy on Production Environment.
Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Installation, configuration and maintenance of MS SQL Server2000/2005/2008/2008R2.

Confidential

Database administrator support

Responsibilities:

Taking Backup and Restoration in SQL Server 2000 and 2005.
Monitoring (database) disk space & logs on servers, Database Monitoring.
Create new query and run Store Procedure.
DTS execution, checking the data integrity.
Grant SQL Privileges to users.
Shrinking of Log files and Database file in SQL.
Checking Backup and Log Backup on Production servers.
Run SSIS Packages.
Support: Support application teams and resolve database problems.
Monitoring and executing (Import, Export) DTS.
Troubleshoot day to day database and application issues with the help of developers. Support multiple databases in production environments.
Provide on call support 24/7 in rotation with other members of the database administrators for MS SQL databases.
Uploading / transferring data to the FTP server.
Run SSIS Packages.
Export, Import Data. (MS - SQL Server 2000, 2005).
Importing & uploading files from different remote locations, Preparing Reports.
Run patches (Insert, Delete, and update) in Production server and UAT server.
Backup and restore on daily, weekly and monthly basis of SQL Servers. Verifying the data by crosses checking and Escalation of the problem facing through execution of the DTS package during the task schedule with the help of developers
Worked as a Technical Assistant in Confidential for 6 months on project of CIPA.

Technical Assistant

Confidential

Responsibilities:

Daily Backup and Restore.
Export, Import Data. (MS-SQL Server 2000, 2005).
Inserting new records, modifying existing records, deleting old records from database.
Database Monitoring.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/XP/2000.

Languages: C, C++, MS - SQL.

Front End: Visual Basic 6.0, C#, ASP.net, VB.net.

Back End: MS SQL Server 2000, MS SQL Server 2005, MS Access.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship