SUMMARY

• 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 SKILLS

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

Database Administrator

Confidential

Responsibilities:

• 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

Database Administrator

Confidential

Responsibilities:

• 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

Database Administrator

Confidential

Responsibilities:

• 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