TECHNICAL EXPERTISE

• Over 8 years of experience in the analysis, design, development, implementation, testing, and maintenance of databases in development, test, and production environment
• Strong experience in managing of SQL Server 2000, 2005, 2008 and 2012 in Production, Test, and Development Environment
• Worked on multiple Data Modeling Projects Designing E-R Diagram, Logical and Physical Design of Databases , Database Normalization from scratch to deployment
• Lead on Database Backup, disaster recovery, Installation, Upgrade and Migrating of databases and Instances
• Excellent skills in creating and managing SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good in writing T-SQL and improving performance of T-SQL, and working Developer in writing and helping them
• Experience in query Monitoring performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor, DMV, and DBCC Commands for different purposes
• Strong working experience in Database High Availability Configuration and Management like Database Mirroring, LogShipping, Replication and Clustering
• Complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Created and managed complex DTS and SSIS Packages for different purposes like data movement, Data Migration and Transformation. Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005 and from 2000 and 2005 to 2008.
• Worked in Production 24x7 , Test, and development databases in SQL Server
• Experience in Data Modeling like ER Modeling and Dimensional tables and Operational Data Store ODS .
• Strong on Reporting Services, Report development and administering SSRS

TECHNICAL TOOLS

• Operating systems: Windows Server 2008, 2003, 2000, WINDOWS XP/2000/NT, WINDOWS 9x
• Hardware: DELL, HP, SAN
• Software: MS SQL Server 2008/R2/2005 , MS Access 2000/97, Visual Basic 6.0, Visual Source Safe
• Third party tools: Quest FogLight, SpotLite, SpeedLite, Idera DBA/Developer Tool
• Data Modeling Tools: Toad Data Modeler , ERWin

PROFESSIONAL EXPERIENCE

Confidential

• Installation and configuration of SQL server 2008 and 2012 on Dell Servers
• Applied patches and service packs to keep the database at current patch level
• Responsible for configuration of Microsoft Server/Client Products and implementation
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes
• Responsible for General Database Administration and Performance tuning
• Experienced in resolving deadlock and blocking issues for concurrent users
• Worked with DTS packages to load the data into Data warehousing system
• Data Migration from legacy to master tables using DTS-Import and Export wizard
• Performance tuning of different apps running on SQL Server 2008 and 2012
• Developed Database Backup Scripts and automated this process
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Worked on various data modeling projects

Environment: MS SQL Server 2008/2012, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0, Windows 2007 Server

Confidential

• Installed and configured SQL Server 2008 R2, 2008 and 2005
• Involved in data modeling for the application and created ER diagram using Toad Data Modeler
• Created and managed Database Objects like Tables, Stored Procedures, Functions, Views, Triggers, user defined data types
• Implemented database standards and naming convention
• Developed DTS and SSIS packages to extract, transform, and load data into SQL Database from flat, Excel, other RDBMS Databases Oracle, MySQL, SQL Server
• Created and configured an OLTP replication database for disaster recovery purpose
• Worked with developers to tune the SQL queries using SQL Profiler, Execution Plan, Index and Database Tuning Advisor
• Provided Production support for the database and application issues.
• Applied patches and service packs to keep the database at current patch level
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning
• Lead on Backup and Disaster Recovery
• Solved critical production problems and performed point in time recovery plans
• Lead Data Modeling
• Expert on Managing Database constraints and Indexes
• Expert on Database High Availability Solutions Database Mirroring, LogShipping, Replication, and Database Clustering

Environment: MS SQL Server 2008/2005/2000, T-SQL, DTS, SSIS, VB.Net, ASP.Net, Visual Source Safe 6.0, Windows Server 2008/2003 and Compuware QA Load test

Confidential

• Installed, Configured, and Managed SQL Server 2008, 2005 2000 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Database High Availability:
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/2005
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed Reports using SSRS
• Deployed Reports
• Developed Ad-hoc Reports using Report Builder 3.0, 2.0
• Database Upgraded development, testing and production environment :
• SQL Server 2000 to 2005/2008
• SQL Server 2005 to SQL Server 2008
• Database Migrated testing and production environment
• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008
• Oracle 10g databases to SQL Server 2008
• My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008
• Data Modeling:
• Worked on data modeling projects and generated E-R Diagram
• Data Modeling tools used using ERWin, Oracle SQL Developer, SQL Server Data Diagram
• Backward Forward Engineering with data modeling tools mentioned above
• Patch Management:
• Applied SP Service Pack on SQL Server 2000, 2005, 2008
• Applied HOT Fixes on SQL Server 2000, 2005, 2008
• Applied Patch on Windows Server 2003 Enterprise Edition
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
• Database Programming:
• Writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• DTS/SSIS:
• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup

Environment: SQL Server Management Studio, Query Analyzer, SpotLite, Idera, Business Intelligence Development Studio BIDS , PMON, IIS, ASP.net, Windows Server 2000, and 2003.