SUMMARY:

• Result oriented and skillful professional having great knowledge of IT a pproximately over 5 years of experience in production database Administration for very large databases in SQL Server 2014, 2012, 2008 R2/2008, 2005 and 2000.
• Experience in working with VLDB databases up to 20 TB in production, Managing Backups, Disk & Drive Space issues, managing indexes.
• Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintain and migrate databases and Monitored appropriate disk storage requirements for the database.
• Expertise and proficiency in SQL Server Replication with Disaster Recovery Planning and Security Management operations.
• Involved in Capacity management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.
• Extensive experience in SDLC in developing an application, with Installation, design, architecture, data flow, Maintenance and Operations of a system.
• Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management
• Experience in working with VLDB databases up to 20TB, Managing Backups, Disk & Drive Space issues, managing indexes.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
• Experience in deploying, configuring and administering AlwaysOn: Availability Groups
• Upgrading/Migrating SQL Server to higher versions, 2005, 2008, 2012, 2014.
• Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
• Performance Tuning Application level for code, queries, Identify slow performing SQL objects and enhance for optimum database performance.
• Hands on experience with TFS and SharePoint. Expertise in configuration, installation, and efficient utilization of third party tools Idera DM, SqlMonitor, Lite speed, DTA,7o - ziper.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012R2, 2008R2, 2003, Windows 2000 and Windows 7/Vista/XP/NT/2000

Databases: MS SQL Server 2016, 2014, 2012, 2008/R2, 2005, 2000

Languages: T-SQL, PL/SQL, MySQL 4.1 C#, C++, and Core Java 1.1, Matlab, Maple, XPP, R, Neuron, SPSS, HTML

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, 2008, 2013 Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Activity Monitor, OSQL, DTS, Log Shipping, Mirroring, Replication, Server Network Utility, Database Tuning Wizard, TFS, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Table Partitioning

Report Tools: SSRS

Data Migration: MSDTS, SSIS, BCP, SQL Loader, Import/Export Wizard

Database Modeling and Other Tools: ERWIN 4.X, MS Visio, Quest Litespeed, Quest SQL Spotlight, RedGate, SQL Compare, SQL Trace, BMC Remedy Pac 2000 (for helpdesk tickets, change requests - CR, work order - WO, problem tickets -PO).

MSOffice: MS-Office Word, Excel, Access, Outlook Express and Power point, MS Visio

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Reston, VA

Responsibilities:

• Worked as a Production DBA and Responsible for Database uptime, the performance of that SQL Server instance and the safety (backups/DR) of the data in the database.
• Provision new database instances, both in clustered and non-clustered configurations ensure performance, security, and availability of databases.
• Upgraded SQL server 2005 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Installed and administered two-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Handle common database procedures such as upgrades, failovers, backups, recovery, data migration, creation of new database, online maintenance work.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in Source Data Analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Worked with Database Developers to help them Optimize T-SQL code.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to move data from SQL Server 2005 to SQL Server 2014.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle).
• Experience in designing/generating/using/deploying Visual Studio 2008/2010 Business Intelligence Reports, SQL Server 2005/2008R2 Reporting Services (SSRS).
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experience in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding /monitoring the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitoring SQL server performance using SQL Profiler, Activity Monitor, to find performance and dead locks.
• Recovering the databases from backup in disasters Implementing Point-In-Time Recovery solution.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Performed installation of SQL Server 2008 R2 and Windows Server 2008 R2 on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitor daily tasks including backup and restore by using SQL Server 2005 and SQL Server 2008R2 tools like SQL Server Management Studio, using Maintenance plan.
• Experience working in SharePoint 2010, creating users, adding links, removing links, assigning users to a group.
• Involved and Build in installation and configuration of SQL server 2005 on Dell Servers. Applied patches and service packs to keep the database at current patch level
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory, CPU and I/O issues.
• Worked and maintained production and development databases in SQL 2000/2005/2008 and R2 in a non-stop heavy transactional and reporting environments.
• Monitoring the servers using RedGate.
• Migrated SQL 2000 server databases to 2008R2 and from SQL 2008 to SQL 2012 by using side by side upgrade process.
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded. Maintaining SQL Script for creation of Database Objects.
• Experience with SQL Database Operational support of Developers and Business users
• Knowledge of and experience with implementing automation of reoccurring DBA tasks
• Good communication and documentation skills for processes and procedures
• 24 x 7 Production Database on Call Support.

Environment: MS SQL Server 2008R2/2005/2000,T-SQL,SSIS, Report Builder, Red-gate, LiteSpeed, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering Windows Server 2008R2 and Windows Server 2003, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g.

SQL Server DBA

Confidential, Trenton, N ewJersey

Responsibilities:

• Complies with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at the Company.
• Installed SQL Server 2008 R2 and on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Maintains data in all production and non-production databases and replication servers.
• Manages database distribution, security, and access requirements also designs and develops logical and physical layers of various databases.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Monitoring the server for High availability of the SQL Server Databases.
• Responsible to Monitor and troubleshooting Log Shipping.
• Checking Database Health by using DBCC Commands and DMVs.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Participate in implementation of new releases into production.
• Created, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
• Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented and Scheduled Replication process for updating our parallel servers.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Monitored and modified Performance using execution plans and Index tuning.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Responsible routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2005/2000,T-SQL,DTS, SSIS, Report Builder, ASP.Net, C#, BCP, SQL Profiler, Performance Monitor, Backup Utility, Replication, Log shipping, Mirroring, Active Directory and Windows 2003/2000 Server.