SUMMARY:

• Over Ten years hands - on professional experience in SQL Server database as a DBA
• Worked on 24x7 Production issues and resolve the Performance Issues.
• Proficiency working on T-SQL in developing stored procedures, triggers, indexes and functions.
• Expertise on Data Modeling, Logical and physical database design.
• Strong Experience in Complex SSIS packages for ETL operations in design, development and deployment.
• Installing, configuring, administering and securing production servers and designing enterprise-wide database backup/recovery plans.
• Designing and implementing Backup/Restore Strategies for the SQL databases.
• Configured and Implemented SQL Server High Availability Solutions.
• Proficiency working on configuring Log Shipping, Bulk Insert and DTS.
• Expertise in implementing Disaster recovery plan for SQL Server Database such as
• Log-shipping, Mirroring and Clustering for High DB Availability.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Expertise in Data Extraction, Transformation, Validation and Loading using SSIS.
• Expertise implementing failover, space management, SQL server planning, user management, performance tuning, database maintenance and others.
• Fine tuning the performance of queries, stored procedures, triggers, cursors.
• Produced advanced Structure Query Language SQL reports.
• Expertise working on Infrastructure tasks such as Security Patching, Hyper-v Managing VMs, User/Group Permissions, Build Engineering expertise and Active Directory.
• Expertise working on SQL Server migration, up-gradation, data recovery, security and audit.
• Experience in data modeling using Erwin Visio tools.
• Good experience on Red-gate and some other third party tools for Back Up and other solution for MS SQL Servers.
• Implemented TDE on sensitive databases.
• Possess excellent communication skills, self-motivated, multi-task oriented with strong work ethics and ability to work efficiently.
• Sound experience with SQL Diagnostic Manager (IDERA), SCOM, SOLARWINDS monitoring tools, and Red Gate

TECHNICAL SKILLS:

Databases: : Microsoft SQL Server 2000/2005/2008/2012, 2014

Tools: SSIS, SSRS, SQL Doctor, BCP, Import and Export Wizard, Profiler, DTS, SQL, Red Gate, SQL Diagnostic Manager (Idera), and Forefront Identity Management, (FIM), Microsoft Office (Word, Excel, Power Point, Outlook, Access)

Operating System: : Windows server 2005, windows server 2008, Windows Server 2012 R2 and Vista/window s 7, Windows 8/8.1

Windows Engineering: Rebuild server and add server to Domain

EXPERIENCE:

Confidential, Laurel, MD

SQL Server DBA

Responsibilities:

• Production supporting DBA activities in large environments.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.
• Installed and Configure SQL Server 2005, 2008, 2012, and 2014 in TestDev and production
• Analyzing and designing and implementing different types of Replication Models.
• Implemented Backup and Recovery Strategies for Production Servers.
• Monitoring the Production Servers and fix the SQL Server issues in VMWare.
• Configured Database mirroring from Production servers to standby servers.
• Implemented database storage specifications using capacity planning.
• Resolved deadlock and blocking issues
• Supporting Large Databases, Troubleshooting the problems.
• Spreading large tables to different file groups to achieve maximum performance.
• Writing T-SQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Mirroring, Always On 2012 in windows clustering environments for High Availability.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.
• Worked on Server Patching, Creating and managing VMs using Hyper-V.
• Performing and assisting in SQL upgrades, migrations, and server consolidations from SQL 2008 to SQL Server 2008 R2 and 2012R2
• Supported VMware and Hyper-V virtual machines
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring Memory Usage, SQL diagnostic manager (Idera), running trace and create standard reports on query performance.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Maintaining and Automating SQL Server like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
• Troubleshoot SQL server environments and monitor the DB performance by rebuilding indexes and updated the Statistics.
• Traced SQL Statements on different levels and events using SQL Profiler.
• Worked on setting up/Troubleshooting high availability on production SQL Servers. Experience supporting about 250 client critical databases to ensure 99:95 SLA.

Environment: SQL server 2005/2008/2008 R2/2012, Windows 2000/2003/2008/2012 R2 Server, T-SQL, MS Excel.

ETL Tools: Used tools like SSIS, Import/Export Wizard, and BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.

Confidential, Annapolis, MD

SQL Server DBA

Responsibilities:

• Extensively used the DBCC commands to monitor server, Performance tuning experience resolving the long-running queries / stored-procedures and achieved significant performance improvement.
• Expertise working maintaining high availability of SQL Server databases using mirroring and log shipping.
• Working as a Database administrator supporting pre-production and production environments.
• Implemented Backup and Recovery Strategies for Production Servers.
• Implemented ETL and reporting Process using SSIS and SSRS.
• Monitoring the Production Servers and fix the SQL Server issues in VMWare.
• Configured Database mirroring from Production servers to standby servers.
• Implemented database storage specifications using capacity planning.
• Resolved deadlock and blocking issues.
• Performed backup, and restored the database with back up of specific objects and users of the database using export and import utilities.
• Worked on Server Patching, Creating and managing VMs using Hyper-V.
• Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working with DBA's to support business critical corporate databases.
• Ensured that there is sufficient drive space on the SQL servers take periodical Full/differential backups of all system and production databases.
• Developed automated daily/weekly/monthly system maintenance jobs such as Database backup, database integrity verification and indexing updates
• Manage, troubleshoot and fix Production Support tickets strictly adhere to the SLA.

Confidential

SQL Server Database Administrator

Responsibilities:

• Major duties: Installed and Configure SQL Server 2005, and 2008 in test and production environment.
• Migrated databases from SQL Server 2000 to 2005 in test and production environment.
• Closely worked with business analyst to collect requirements & make systems available ASAP.
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Writing T-SQL and Stored-Procedures.
• Performed Database, SQL, and index tuning.
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Created Backup strategy for production and development environment.
• Database Backup & Restore.
• Scheduled jobs.
• Setup and configure Database mail for notification purposes.
• Developed Database Maintenance Plan.
• Monitor Servers activity, solving problem.
• Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc. with custom applications and SQL.
• SQL Server Error Log, space usage.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Export & Import data from MySQL, and Access Database including flat files like text, excel, and into SQL Server databases.
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes.

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
• Major duties: Installed and Configure SQL Server 2005, and 2008 in test and production environment.
• Migrated databases from SQL Server 2000 to 2005 in test and production environment.
• Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
• Created Backup jobs for different types of backup like FULL, BULKLOG, and SIMPLE Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
• Created BAT programs to move backup and other files to backup servers.
• Configured Database mail
• Created Database that can store FILESTREAM data