SUMMARY:

• 7+ years of experience in Database Management Technology in cluster, replications and log shipping
• Extensive experience in database Design, Implementation and Administration in MS SQL Server 2012/2008/2005/ 2000/7.0/6.5 , Data Warehouse, SSIS, SSAS
• Strong SQL Back End Programming in both Web based and Client/Server environment
• Excellent communication skills and a key team player. 
• Highly motivated and quick learner

TECHNICAL EXPERTISE:

Languages: SQL, T - SQL, PL/SQL, C++, VB, VBA, HTML, ASP, Java Script and Shell Script, HL7, CL

Software:   Forms, Reports, SQL*Plus, SQL*Loader, Borland C++, Micromedia Dreamweaver 4.0, PowerBuilder, Crystal Report 6.0/7.0/8.5/9.0 , MS FrontPage 2000/98, Visual Source Safe, MS office XP/2000/98, Visible Analyst 6.0, Visio, OLAP, Data Warehouse, Eclipse, DB Artisan, Lumigent, Netcool, MOM, Sybase Central, Relativity, MongoDB and NoSQL Team Quest, Precise, SharePoint, Idera, Team Quest, Precise, Foglight

Database:   SQL Server 2012/2008/20005/2000/7.0/6.5 , Sybase, IBM DB2, MySQL, Data Modeling, OLTP,DTS/SSIS, OLAP, Data Warehouse, Foxpro, Business Intelligence, MS Reporting Services, MS Analysis Services, SSAS, SSRS,BCP

Systems:    Windows 7,8/XP/NT/2000/98/95, UNIX, Linux, IIS, AS/400, IBM iSeries Server, HP Polyserve, SAN, BizTalk, IIS, Commerce Server 2007, Virtualization

PROFESSIONAL EXPERIENCE:

Confidential 

Sr. SQL Server DBA

Responsibilities:

• Provide Production Support for MS SQL Server Databases in High Availabilities
• Perform day-to-day administration on SQL Server 2005-2012 environments
• Set up and Configure database Mirroring, Log shipping, Replication
• Ensure database health and integrity across all systems
• Diagnose & troubleshoot issues, Conduct performance tuning for optimizations
• Manage database Capacity growth, refresh data from production to lower environment
• Monitor databases, migrate SQ Server from SQL 2005 to SQL 2008
• Support SSIS, SSRS, Data warehousing
• Manage and implement production release
• Lead the Disaster Recovery
• Install SQL Server in Cluster and Migrate SQL Server from SQL 2005 to SQL 2008
• Set up and configure database Mirroring, Logshipping, support SSRS, SSAS
• Automate maintenance jobs, install services patching
• Identify problems, find root cause and perform tuning to ensure application performance
• Manage database Capacity growth, write stored procedures, triggers
• Maintain & manage Database security, install monitor tools on the Server
• Provided production support for MS SQL Server 2005/2008 and maintenance in High Availability Cluster, Logshipping, Mirroring and SRDF
• Collect business need to design server specs for new projects, install & configure new SQL Server 2008 in Cluster
• Conducted SQL Migrations from SQL 2000 to SQL 2005 and to SQL 2008 for large Data Center
• Set up database Log shipping, Mirroring, Replication, install & configure monitor on the Server
• Diagnosed bottlenecks, Perform tuning for optimization
• Managed database capacity growth, support Business Intelligence, MS Report Services
• Implement service packs and manage database health, manage user security for compliance

Confidential

SQL Server DBA

• Manage and Support MS SQL Server 2000/2005 Production Databases
• Install SQL Server in Cluster and upgrade SQL Server from SQL 2000 to SQL 2005
• Troubleshoot and Conduct performance tuning for applications
• Automate DBA activities to help ensure the high availability of the Server
• Write stored procedures, triggers and views
• Set up log shipping and management strategy and Capacity planning
• Configure database in SQL 2005 to automate operation alert
• Maintain and support developers for SSIS/DTS, SQL Analysis Services SSRS
• Migrate DTS to SSIS and Implement SSIS to load data into DW systems
• Support large web applications and large Data warehouse systems
• Manage and Support large amount of MS SQL Server 2000/2005 database in high
• availability environments including Cluster and Log shipping, Replication
• Lead DBA for consolidating MS SQL Server databases on HP Polyserve Matrix
• Proactively monitor, tune and improve Database Performance
• Strong ability to Identify/ troubleshoot problems and resolve real-time database issues
• Conduct performance tuning for applications
• Perform database Backup and Recovery, lead the Disaster Recovery
• Upgrade MS SQL Server 7.0/6.5 to SQL 2000 and from SQL 2000 to SQL 2005
• Write batch files to Manage databases and Migrate data across Servers
• Transfer data from different platforms using DTS/SSIS package
• Design and troubleshoot DTS packages for the business needs
• Write stored procedures, triggers and views
• Convert database from Froxpro to MS SQL 2000
• Automate DBA activities to help ensure the high availability of the Server
• Apply SQL Service patches and manage SQL server security, Support SharePoint in SQL
• Support SSAS and Manage OLAP database for Data warehouse for financial business
• Setup log shipping and replication
• Support Sybase database applications
• Built database Triggers and Referential Integrity Constraints to implement business rules
• Set up maintenance jobs and configurations on the Server
• Provide support for production releases related with database work
• Install SQL SERVER 2008 On Cluster
• Migration Databases from SQL 2005 to SQL 2008
• Manage and maintain 2008/2005 Production Database Servers SSIS SSRS
• Support Developers and Business, write stored procedures\Queries
• Set Best Practice for the server management
• Conduct Performance tuning and work with Full text Index