Professional Experience of 10 years with analysis, design, development, implementation and deployment and integration of Database. Write, Review, debug & Maintain Stored Procedure, table, ER-Diagram of Database. Specialize in SQL Server, advanced T-SQL queries, DTS, QA, and developing using XML, Access, Office. Database performance tuning and monitoring, Various Optimization procedures, Capacity planning. Database Refresh on standalone as well as high available Database and Disaster Recovery Planning. Experience in high availability of SQL Server Solution like Database Mirroring, Logshipping, Replication, MS Clustering. Monitored scheduled jobs and set up maintenance plans, Log space monitoring, various dbcc commands, troubleshooting with various DMVâ??s. Configuration of external services like Mail notifications and Linked server Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance. A Person who is detail oriented and good at task requiring vigilance, accuracy, speed, and detection of minor differences. A DBA with strong analytical, trouble-shooting, and problem-solving skills. Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.2. Proficient in creating indexed views, stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and complex business logic using Batch Files. Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. Expertise in database optimization using tools like Index Tuning Wizard, SQL profiler, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup. Connected remote SQL Servers as Remote and Linked Servers to run distributed queries between SQL servers and other data sources like Excel using ODBC, OLE DB Drivers. Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.