SUMMARY:

• 10+ 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 / 2014/2016/2012/2008/2005/ 2000/ , Data Warehouse, SSIS, SSRS,
• Sound experience with IDERA, SCOM,SQL Doctor and Solarwinds
• Currently managing over 1000 database in production.
• Configured database mirroring on all 1000 production databases to our alternate facility
• Configured database encryption on our SharePoint databases using TDE
• Strong SQL Back End scripting in both Web based and Client/Server environment
• Experience in SQL Server RDBMS, MySQL
• Experience with Data Migration from SQL Server 2000 till present.
• Experience with COTS Product Meaning 3Rd Party tools
• Excellent communication skills and a key team player.  Highly motivated and quick learner, Netapp Snapshots, Snap Manager for SQL, Native SQL Server Backup/recovery Tools

TECHNICAL EXPERTISE:

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

Software: Forms, Reports, SQL*Plus, SQL*Loader, Borland C++, PowerBuilder,, 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, Toad for Oracle/SQL, Relativity,MongoDB and NoSQL, Team Quest, Precise, SharePoint, Idera, Team Quest, Precise, Foglight, .Net 4.0:

Database: SQL Server 2012/2008/20005/2000/7.0/6.5 , 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, Power Shell, HP, SAN, BizTalk, IIS, Commerce Server 2007, Virtualization

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Server DBA

• 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 2008 and to SQL 2012 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
• 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 2012
• Manage and maintain 2000/2012 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

Confidential

Sr. SQL Server DBA

• 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 2012
• 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 2012
• 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
• Import and export data in Oracle Data Pump utility
• Manage User security in Oracle and backup database
• 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 2012
• 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 2012
• 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
• Import and export data in Oracle Data Pump utility
• Manage User security in Oracle and backup database

Confidential

Sr. SQL Server DBA

• 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 2008 and to SQL 2012 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
• 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 2012
• Manage and maintain 2000/2012 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

Confidential

Sr. SQL Server DBA/ Lead

• Manage and Support MS SQL Server 2000/2012 Production Databases
• Install SQL Server in Cluster and upgrade SQL Server from SQL 2000 to SQL 2012
• 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
• 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 2000 /2012
• 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
• Create database and Manage backup in Oracle
• 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