SUMMARY

Around 6+ years of experience in the analysis, design, development, implementation, testing and maintenance of application systems in the Internet/Intranet, Client Server environment Microsoft SQL server database management and performance monitoring.

• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Rules, Defaults, user defined data type and functions.
• Very good T-SQL programming skills. Experience in query optimization & performance tuning. Used SQL profiler, Execution Plan, Performance monitor and DBCC commands.
• Experience in Database backup and disaster recovery procedures.
• Experience in Transactional replication.
• Experience in MS SQL Sever upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL Server 2005.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, Programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the developers on technical issues.

Web technology - ASP.Net, IIS
Database - SQL Server 2000, SQL Server 2005 and SQL Server 2008
Tools - VSS6.0, Visio6, Crystal Reports.

MBA (3 yrs).

Microsoft® Certified IT Professional (MCITP) – (SQL Server 2005) - Scored 81%
Microsoft® Certified Technology Specialist (MCTS) – SQL Server 2005
Microsoft® Certified Professional (MCP) – (SQL Server 2000) – Scored 91%

Experience Summary

July 2005 to Aug 2008 -
Web developer cum Support Data base (sql 2000), EDS Pvt Ltd., Confidential,
Sep 2008 to Till now -
Data base Administrator cum Data base developer, Confidential,

Confidential,Bangalore India
Sep 2008 – till now.

Admin and guide is a CRM application mainly used for customer supports and Online shopping (E-commerce) Module. Our applications support 3 lakhs customer’s records and frequently update, insert bulk and modifying the customer packages.

Environment : SQL Server 2005 & SQL Server 2008
Role : DBA, SQL server 2005, 2008 Developer and Production Server db support.
Duration & Team Size: 3.2 years and 3 Members

Responsibilities

• Responsible for installation and configuration of SQL server 2005 & 2008 database on the servers.
• Applied patches and service packs to keep the database at current patch level.
• Suggested Disk capacity, Processors and Memory based on the capacity planning.
• Developing SQL scripts for maintaining administration tasks.
• Based on the business needs created Transactional replication in database.
• Estimating of table sizes and record sizes. Maintaining proper licenses.
• Maintain all the SQL documents include installation and data conversion procedures documents.
• Trouble shooting problems by using SQL server Profiler.
• Solved critical production problems and performed point in time recovery plans.
• Implemented database standards and naming convention for the database objects.
• Data base objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions for this project.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Developed database backup scripts and automated this process.
• Partly participated in system study and analysis of software applications.
• Worked with developers to tune the SQL queries using SQL profiler.
• Provided 7 X 24 production supports for the database and application issues.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
• Created and maintained Users department, Users role and User groups.
• Backup recovery schedules, Backup scripts.
• Focuses on Index tuning and fragmentation of the Index pages with the help of alter index script and finalize based on the average fragmentation >30 then doing “Rebuild” and < 30 then doing “Reorganize”.
• Rewrote and tuned long running SQL queries to cut execution time, ease database load and improved scalability.

_______________________________________________________________________________
Easy design system Pvt limited
Confidential, July 2005 – Aug 2008.
CSS Logistics – Material Management and Inventory Management System.
This system handles the basic material management functions like materials planning and programming of procurement and supplies, Purchasing, inventory control, storekeeping and warehousing, Materials handling and transportation, codification and standardization, Value analysis, identification, Disposal of supplies and scrap materials.

Handles all functions related to the tracking and management of material. This would include the monitoring of material moved into and out of stockroom locations and the reconciling of the inventory balances also bin management, Landed cost, Customer and volumes pricing, Multi currency Pricing, Multi Location, Multi units of Measure, Bulk ordering, Special Orders, Item Upgrades/Downgrades Audit for Inventory Adjustments and stock Transfer from one location warehouse to another warehouse.

Environment : ASP.Net, VB.Net, Crystal Reports 9.2, SQL Server 2000, Infragistics Controls
Role : Web developer, SQL server developer and Production server database support.
Duration & Team Size: 3 years and 10 Members.

Responsibilities

• Partly involved install, configure and upgrade MS SQL Server.
• Partly involved system study and database designing.
• Partially involved performance tuning.
• Used MS Visual Source Safe 6.0 as a version control system.
• Developed the Master Admin pages (ASP.Net) with third party control Infragistics grid.
• Generated Dynamic reports using Crystal reports.
• Responsible for developing GUI screens with the help of dream viewer.
• Defined relationship between tables and enforced the referential integrity constraints. Created cluster and non cluster Indexes.
• Monitored User accounts, User permissions user roles and user groups.
• Involved in developing ER diagrams, Logical & Physical data modelling, development and implementation of the system.
• Created and Monitored the Jobs which is failed then sent a mail thru sql server mail.