PROFESSIONAL SUMMARY:

• Around 4.5+ years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2012/2008/2008 r2/2005/2000 in banking and health sector .
• Sound experience in handling production/development and UAT environments.
• Installed and configured MS SQL Server 2012/2008 R2/2008 and 2005 systems in all environments.
• Knowledge in upgrading and migration systems from MS SQL Server 2005 to MS SQL Server 2008\2008R2.
• Experienced working in TFS as Source Control and for deployments .
• Good knowledge in tuning MS SQL Server 2012/2008/2005 systems for optimal performance.
• Good skills in handing MS SQL Server systems in Clustered environments on 2008/2003.
• Good knowledge on SQL Clustering for MS SQL 2008R2.
• Good knowledge in implementing log shipping mechanism.
• Implemented Database Mirroring on SQL Server 2008/2005 systems.
• Sound knowledge of performance tuning MS SQL Server 2008/2005 for best performance.
• Good knowledge in fine tuning stored procedure for super performance.
• Good knowledge in fine tuning queries taking a long time.
• Experience in Creating, Suggesting and implementing Indexes ( Clustered, Non Clustered and Unique).
• Implemented sound backup strategy for all MS SQL Server 2012/2008/2005/2000 database servers.
• Timely full backup / Differential backup and transaction log backup for all environments.
• Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
• Good Knowledge in SQL Server 2005 Reporting Services (SSRS) and SQL Server 2005 Integration Services (SSIS) in Business Intelligence
• Good knowledge of Windows Scheduled Task.

TECHNICAL SKILLS:

RDBMS:: SQL Server 2012/2008R 2/2008/2005/2000.

Database Tools:: Management Studio, BI Development Studio, SQL Profiler, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), Litespeed, Foglight, Microsoft Office, MS Access.

Operating Systems: Windows Server 2003/2008 R2/2012R2, Win XP, Win 7, MS - DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

MS SQL Server DBA Indus tr y: Finance

Responsibilities:

• As a Production and development support DBA responsibility for maintenance on 50+ SQL Servers in virtual environment.
• Working Knowledge on Migration project of SQL 2005 to SQL 2012 migration on standalone environments.
• Extensive knowledge on Backup and restore database process.
• Involved on SQL server installation and configuration.
• Worked on Database refresh from PROD to lower environment.
• Worked on builds and releases for developers
• Worked on creating T-SQL queries, views and stored procedures for development.
• Worked on enhancement project building SSIS packages.
• Good knowledge on Litespeed third party tool for database backup and restore.
• Worked on converting Litespeed backup to SQL Native Backups.
• Created and scheduled SQL JOBS through SQL Agent.
• Worked on Foglight performance tools.
• Worked on creating new users and roles.
• Managed SQL security for all users.
• Created maintenance plan for good running database health.
• Good knowledge on Log shipping and replication
• Good knowledge on system maintenance procedure like upgrade all Microsoft Products, Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
• Apply application specific updates (SQL post SP4, Exchange post SP3 hot fixes).
• Good knowledge on upgrade process from & 2008R2.
• Provide good support to the Developer and QA Environment.
• Involved in DR (Disaster recovery) environment with its initial setups.
• Worked on quarterly DR exercise and update DR steps on LDPRS.
• Created the standard operating procedures (SOP) for SQL Migration Project.
• Good knowledge of configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
• Worked on HP Service Manager for Incident Management and Change Request.
• Update Incidents and Change on application SharePoint site.
• Involved on various application patches installation
• Worked on installation and configuration of FTP site for In/Out files.
• Worked on Windows scheduled tasks for file transfer between application and database servers.
• Knowledge of SQL Avamar Plug-In and EMC Avamar backup for Live database backups.
• Good knowledge on Documentation of SQL Job Timeline, Interface, Windows Scheduled task, component inventory.
• Extensively worked on SSIS Control Flow Tasks.
• Experience working in Team Foundation Server(TFS).

Environment: MSSQL 2012/2008 R2/2005, VMware, IIS, Windows OS 2012 R2, Win XP, Win 7

Confidential

Data Manager

Responsibilities:

• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Configured and maintained Log shipping architecture to provide backup server solution for environments.
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Implemented SQL Server Mirroring on SQL 2008/2005 environments.
• Created the DTS, SSIS packages to import the data from MS Access server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel).
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Installing packages on multiple servers in SSIS.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008 R2/2005, Windows 2000/2003/2008 Server Operating systems,