Consultant ID: SDBA1                                        Get me Complete Resume

SUMMARY

• SQL server 2000/2005 DBA/developer with seven years of IT experience including strong development skills
• Good understanding of SDLC and relation database architectures
• Proactive monitoring of databases
• Extensive IT professional experience with expertise in Database Development, Modeling, Data Warehousing, Design and Technical Management.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
• Experienced in creating SQL server Analysis Projects using MS SQL Server 2005 SSAS
• Good knowledge in database administration, data modeling, installation, performance tuning, backup and recovery using SQL server 2000/2005 in windows environments
• Performed monthly and daily DBA tasks according to the company’s administration norms
• Experience in DTS packages and data designer usage. Moving DTS packages from one environment to another (SSIS)
• Experience in migrating DTS packages, reports and analysis services projects from SQL server 2000 to SQL server 2005
• Experience in writing packages, scripts, triggers, stored procedures, functions and cursors
• Experience in tuning stored procedures and T-SQL statements and DBCC commands
• Data modeling and physical modeling using Erwin tool
• Experience with migration from SQL server 2000 to SQL server 2005
• Installation and configuration of MS SQL server databases
• Implementation of backup and recovery strategies for both production and development environment
• Monitoring SQL server logs to ensure whether the backup operations, batch commands, scripts and have completed successfully
• Database health checks using SQL profiler, performance monitor and performance counters
• Maintaining SQL script for creation of database objects  and generating scripts using  Erwin too

TECHNICAL SKILLS

Databases	SQL Server 2005 & 2000 & 7.0, MS-Access
Database Tools	Enterprise Manager, Query Analyzer, SQL Profiler, SSIS,SSAS, SSRS, DTS, BCP, Management Studio.
Languages	C, T-SQL.
OS	Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP.
Web Servers	IIS 5.0, Apache, Tomcat.
Other Tools	Erwin, Microsoft Visual Studio 2003/2005,VISIO
Architecture	Relational DBMS,  Client-Server Architecture, OLAP, OLTP