SUMMARY

• Microsoft certified SQL Server DBA with over 7 years of experience in database administration, performance monitoring and tuning usingSQLServers 2012/2008R 2/2008/2005/2000 .
• Experience in optimizing database queries, indexes, stored procedures, reports, database backups, repair and recovery, database logical/physical design.
• Proven ability to identify bottlenecks and other database issues with a focus on a process based ability to troubleshoot and resolve issues promptly. Solid experience on high availabilities option including AlwaysOn Availability Groups, Replication, Log Shipping, Mirroring and SQLServerClustering (Active - Active, Active-Passive).
• An effective communicator with exceptional relationship management skills with the ability relate to people at any level of business/management.
• Expertise in installing SQL Server 2000, 2005, 2008 & 2008R2 and 2012, applying service packs and patches on stand-alone and Cluster Environment and Configuring.
• Expertise on Data Modeling, Databases Design/Architecture and capacity planning.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
• Experience on install, Configure, backup and manage Share Point
• Experience in implementing Business logic by using T-SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF).
• Well experience in analyzing Performance, Query optimization and tuning.
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
• Solid experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional),Always ON(Availability group) and Clustering (Active-Passive)
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
• Experience in Data partitioning for large tables to increase performance.
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts. Monitoring and troubleshooting the jobs.
• Experience in SQL Server up gradation from SQL Server 2000 to SQL Server 2005 and (Side by Side and in place) in 32bit to 64 bit architecture.
• Configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Experience in using third party tools ERWin for Data modeling and Idera for performance
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, SSMA BCP and DTS utility.
• Strong knowledge on Active Directory in Windows Server 2003, 2008R and 2012
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical and business staff at all levels.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Sql profiler, Activity Monitor, Query Analyzer

Languages: T-SQL, HTML, XML,PHP

Operating Systems: Windows 8/7/XP/2000/98, Windows server 2003,2005, 2008, 2012

Databases: MS-SQL Server 2012/2008/2005 , Oracle, MySQL

ETL Tools: SSIS, DTS

Reporting Tools: SSRS, Crystal Reports

Programming: T SQL(Store procedure, function, trigger), .NET, Asp/ASPX,HTML

Application Software: Visual Studio 2005/2008, Visual Source Safe, MS Office Suite, Excel

Data Modeling tools: ERwin, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012, 2008, 2005 in development, test and production environment
• Installed VM ware and configure Always ON as a high availability solutions
• Expertise in Database Backup, Recovery and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Database Upgraded (development, testing and production environment):
• SQL Server 2005 to SQL Server 2008R2
• SQL Server 2008R2 to SQL Server 2012
• Database Migrated (development, testing and production environment)
• SQL server 2008R2 to SQL server 2012
• Oracle 10g databases to SQL Server 2005, 2008R2
• My-SQL 5.0.1 databases to SQL Server 2005,2008
• Database Monitoring/Performance Tuning:
• Expertise 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 Temp DB, Server Error Log, Usage space
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed and Deployed Reports using SSRS
• Managed and Developed Ad-hoc Reports, Parameterized, Drill down, dropdown link report
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Writing T-SQL, User Define Function, Trigger,
• Create and maintain Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring.
• Used DBCC and DMV to check database conditions, Rebuilding indexes and other database Maintenance purposes.

Environment: MS SQL Server 2012/2008R2/2005, Windows server 20 bit,ASP.NET, HTML, SSIS, SSRS, IIS, SQL Profiler, T-SQL, SQL Agent, ERWin, Idera

Confidential, Milford, CT

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012, 2008, 2005 in development, test and production environment
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008R2 and 2005. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications (Transactional)
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed and Deployed Reports using SSRS. Developed Ad-hoc Reports, Parameterized, Drill down, dropdown link report
• Database Upgraded (development, testing and production environment):
• SQL Server, SQL Server 2005 to SQL Server 2008R2 and SQL Server 2008R2 to SQL Server 2012
• Database Migrated (development, testing and production environment)
• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, 2008. Oracle 10g databases to SQL Server 2005, 2008R2. My-SQL 5.0.1 databases to SQL Server 2005, 2008. SQL server 2008R2 to SQL server 2012
• Data Modeling
• Data modeling tools used using ERWin, VISIO, SQL Server Data Diagram. Backward & Forward Engineering with data modeling tools mentioned above
• Patch Management:
• Applied SP (Service Pack) on SQL Server 2005, 2008. Applied HOT Fixes on SQL Server 2000, 2005, 2008. Applied Patch on Windows Server 2003 Enterprise Edition
• Database Monitoring/Performance Tuning:
• Strong knowledge on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification. Monitor SQL Server Error Log, space usage
• Database Programming:
• Writing T-SQL, User Define Function, Trigger. Create and maintain 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
• Used DBCC and DMV to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring

Environment: MS SQL Server 2012/2008R2/2005 Enterprise, Windows server 20 bit, SSIS, SSRS, IIS, SQL Profiler, Crystal reports T-SQL, DTS, SQL Agent, RedGate, ERWin, Idera

Confidential, Richmond, Virginia

SQL Server Database Administrator

Responsibilities:

• Installed and Configure SQL Server2008, 2005 & 2000 in development, test, and production environment
• Migrated databases from SQL Server in test and production environment
• Expertise High Availability solution (Log shipping, Mirroring and Replication)
• Monitored server and database performance tuning.
• Writing T-SQL and Create user define Stored-Procedures, Indexes
• Created 'Database Maintenance Plan' Schedule Backup jobs
• Monitor Servers Performance tuning
• Monitor transactional log and temp DB growth
• Run DBCC and DMV statements to check physical and logical consistency of server.
• Experience in using DTS, BCP to import & export data from flat files, excel and MS Access to MS SQL Server databases
• Creating and modifying Data bases, tables, Indexes (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes

Environment: MS SQL-Server 2008R 2/2008/2005/2000 , Windows 2008/2003/2000 Server, Idera, TSM, SSRS, Performance Monitor, IIS, Crystal Reports. Integration services (SSIS), SQL Profiler, T-SQL, DTS, SQL Agent, and RedGate.