SUMMARY:

• Over 6 years of experience in SQL server Database Administration for very large and complex databases using SQL Server 2014, 2012, 2008 R2, and 2005.
• Strong experience in Database Administration and Management like Installation, Migration, HA - Mirroring, AlwaysOn, Replication, Log Shipping and Clustering, Upgrade server, apply SP (Service Pack), Security, TDE (Transparent Data Encryption), Backup and Recovery, Data Modeling, Performance Tuning
• Used many native and third party tools like SSMS, Query Analyzer, Database Tuning Advisor, PerfMon, Execution Plan, Profiler, Toad Data Modeler, idera, ERWin, RedGate, Solar Winds,
• Strong technical background includes performing business analysis, writing documentation and specifications
• Wrote SQL/TSQL queries/scripting like T-SQL, stored procedures, triggers, functions, and other scripting for different purposes
• Outstanding experience in Database Monitoring tools - SQL Server Log, Agent Log, Windows Event, Session monitoring, users monitoring, Query Monitoring and other third party tools
• Strong work experience on SSRS (SQL Server Reporting Services) and SSIS, DTS, BCP/Bulk insert
• Experience in managing large database in 24/7 environment (Test, Dev & Production)
• Self-motivated, proactive, team player, able to manage own projects efficiently for on time delivery.
• Excellent verbal, written and presentation skills, Independent problem solving and detail oriented skills.
• Proven ability to manage multiple tasks with different vendors.
• Excellent coordination, cooperation, organizational, interpersonal skills and cross group Collaboration

TECHNICAL SKILLS:

Database: MS SQL Server 2014, 2012/2008 R2/2005, MS Access

Database Migration: Migrated MySQL databases to SQL Server 2008 R2 and 2012

Operating System: Windows Server 2012, 2008 R2/2003

Languages: SQL, T-SQL Scripting

ETL Tool: SSIS/DTS, BCP, Exp/Imp Tool

Reporting Tool: SSRS (SQL Server Reporting Services)

Data Modeling: Toad Data Modeler, ERWin

Third Party Tools: Toad Data Modeler, ERWin, Idera, SolarWinds, OpNet, RedGate

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

MS SQL Server Database Administrator/DBA

Responsibilities:

• Administered Database Servers running MS SQL Server 2014, 2012, and 2008 R2
• Installed and Configured, and Managed SQL Server 2014, 2012 and 2008 R2 managed in development, test and production environment
• Installed, configured and maintained Database Mirroring, Log Shipping, Replication, AlwaysOn, and Clustering (Active/Passive)
• Upgraded Databases from SQL Server 2008 R2 to SQL Server 2012
• Migrated Databases from MySQL 5.1.23 databases to SQL Server 2008 R2
• Applied SP (Service Pack) and HOT Fixes on SQL Server 2008 R2 and 2012
• Worked on many data modeling projects. Created and managed E-R Diagram Data Modeling tools. Used Toad Data Modeler. Used Backward & Forward Engineering with data modeling tools mentioned above
• Maintained Fail-Over Clustering using SQL Server 2012
• Report Server Installed, configured and administered SQL Server Reporting Services ( SSRS )
• Developed and deployed Reports using SSRS and Managed security of Reports and Report Server
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
• Experienced on database monitoring, performance tuning and query optimization as well as monitoring SQL Server Error Log, space usage and solving related issues as needed.
• Scheduled and maintained new and existing jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, database statistics, rebuild or reorganize indexes.
• Experienced in Database Backup and Disaster Recovery (DR Solutions), Designed and Maintained Backup strategy for Databases, and Point-in-Time Recovery solutions
• Managed security by creating Groups, Logins, and users with proper authentication and grant them appropriate permission on Server level, Database level as well as Object level.
• Attended weekly and monthly meetings with other DBA, Project Manager, Development Team and Test Team regarding current project status, future projects, project deadline or any kind of technical issue & solution and worked closely to meet deadlines of resolve issues.
• Created notification if there is any failure, error, warning or disk issue.
• Wrote T-SQL, Trigger, Stored-Procedures and assisted Database Developers to optimize SQL queries and Stored Procedures and Triggers.
• Exported & Imported data from Flat file, Excel file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Exported & Imported data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• In Process - Architecture planning on migration SQL server 2014
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure.

Work Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, SQL Server 2014, 2012, 2008 R2 and applications in ASP, ASP.net, PHP

Confidential, Sterling, VA

SQL Database Administrator/DBA

Responsibilities:

• Installed, configured, and managed SQL Server 2008 R2, and 2012 in development, test and production environment
• Configure and maintained Database Mirroring, Log Shipping and Replication.
• Installed, configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports using SSRS and deployed Reports
• Upgrade Databases from SQL Server 2000 to 2005, 2008 R2 and 2005 to 2008 R2
• Migrated Databases (development, testing and production environment ) MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005 and 2008 R2
• Migrated Databases from Oracle 10g databases to SQL Server 2008 R2, My-SQL 5.1.23 databases to SQL Server 2005 and 2008 R2
• Participated in data modeling projects and generated E-R Diagram Data Modeling tools using SQL Server Data Diagram.
• Applied SP and HOT Fixes on SQL Server 2000, 2005, 2008R2
• Managed Security.
• Performed on database Monitoring and Performance tuning using SQL profiler, Database Tuning Advisor and Windows performance monitor.
• Identified slow running queries and Stored procedures and tuned them.
• Experienced on creating and using stored procedures, functions, Triggers and T-SQL.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes
• Created, scheduled and maintained automated job for backup, backup validation, disk space and monitoring database health.
• Exported & Imported data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Strong knowledge and working experience in Database Backup and Disaster Recovery and restoring Database from backup
• Created and implemented backup strategy
• Experienced with Point-in-Time Recovery
• Attended Weekly and monthly meetings.

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache, Tomcat 5.5, SQL Server 2008 R2, 2012, and applications in ASP, ASP.net