Name: 
E-mail: 
Phone:

OBJECTIVE
Seeking a challenging career and growth oriented position in Microsoft Sql server Database administrator Environment where knowledge can be shared & enriched logically. 

EXPERIENCE SUMMARY

- Over 4 years of industry experience SQL Database Administration and SQL Database Development
- Proficient at database query analysis and optimization, configure Log-shipping, maintaining sql server security, configure maintenance planning
- Expertise in planning and configuring backup strategy, creating store procedure, trigger, cursor, view, subquery and administration of Ms SQL Server Databases. 
- Maintenance & Support of MS SQL Servers 2008,2005,2000 and 7.0 in Production, QA, Development environments & Replication.
- Experience in Replication – Snapshot and Transactional and extensive knowledge in Merge replication, creating jobs, alerts, sql server login and database user and define sql server role and database role.

PROFESSIONAL CERTIFICATIONS & TRANINGS

Successfully Completed -  
- Microsoft certification of MCTS–70-431 Sql server 2005. 
- Microsoft certification of MCITP-70-443 Designing a Database Server Infrastructure Sql server 2005.
- Microsoft certification of MCITP- 70-444 Optimizing and Maintaining a DBA Solution Sql server 2005.
- Sql server 2005 Database administrator (DBA) training from XYZ.
- Sql servers 2005 Sql implement (Development) training from XYZ.
- Sql server 2000 (Development) training from XYZ

AREA OF EXPERTISE

- Installation and configuration of MS SQL Server 2005/2008/2000/7.0 versions administration.
- Administration, Database backup strategy and recovery of database, Recovery of suspected databases procedures, Performance Analysis and Production Support.
- Planning and implementing MS SQL server security and database permissions and Sql server role.
-Configuring and implementing Log Shipping Technique used for warm backup solution for MS SQL Server 2008/2005 databases.
- Sql server maintenance plan, configured Scheduled job, rebuild the databases indexes   .
- Table Design, Index Design , Performance Tuning and query optimization.
- Optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks. 

SYSTEM MANAGEMENT & TROUBLESHOOTING

- Addressing & resolving Windows OS performance bottlenecks and ensuring maximum uptime.
- Server hardening exercise for Microsoft Windows 2003 / 2008 Servers 
- Coordinating with Backup, Network and SAN ensuring smooth project continuity.
- Knowledge Transfer trainings to the resource & customers during the post-implementation phase.

RESPONSIBILITIES HANDLED: 

- Create and implement best backup and recovery strategies (Full Backup Model with transaction logs backups)
- Installation and configuration of MS SQL Server 2005/2008/2000/7.0 versions administration
- Oversee and train database developers and web programmers in query writing, query optimization, performance tuning
- Improve the Server performance and SQL server optimization
- Troubleshoot performance-tuning issues by running SQL server Profiler, creating trace and run these traces in SQL Server Database Engine Tuning Advisor and analyzing the reports. 
- To analyze poor performing queries and tune the same to optimize application and system performance
- Deploying DB script patch on UAT and Live server 
- Deploying HOT FIX patch on UAT and Live server 
- Monitored and modified Performance using execution plans and Index tuning
- Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test

ACHIEVEMENTS:

- Awarded "Employee of the month" for Mar-20XX for recovering a major database. 

ACADEMIC QUALIFICATIONS

- B.com from XXX University -2005 year.
- H.S.C. from XXX University -2001 year.

PERSONAL DETAILS

Date Of Birth: 
Languages Known: 
Address: