SUMMARY

• Over 5 years of experience in SQL server Database Administration for very large and complex databases using SQL Server 2012, 2008 R2, 2005 and 2000.
• 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, OpNet
• 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 2012/2008 R2/2005/2000, MS Access 2007 & 2003

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

Operating System: Windows Server 2012, 2008 R2/2003/2000, Windows XP/NT4.0, MS-DOS, VMware

Languages: SQL, T-SQL, HTML, DHTML, XML JavaScript, ASP, ASP.net

ETL Tool: SSIS/DTS, BCP, OSQL, ISQL

Reporting Tool: SSRS (SQL Server Reporting Services)

Data Modeling: Toad Data Modeler, ERWin

Networking: Active Directory, TCP/IP, DHCP/DNS, LAN

Hardware/Storage: SAN/NAS, RAID

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

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

MS SQL Server Database Administrator/DBA

Responsibilities:

• Administered production and development servers running MS SQL Server 2012, MS SQL Server 2008 R2 and MS SQL Server 2005
• Installed and Configured, and Managed SQL Server 2012 and 2008 R2 managed in development, test and production environment
• Installed, configured and maintained Database Mirroring, Log Shipping and Replication
• Upgraded Databases from SQL Server /2008 R2, from SQL Server 2005 to SQL Server 2008 R2/ 2012
• Migrated Databases from Oracle 10gR2 databases to SQL Server 2008 R2 and 2012, and MySQL 5.1.23 databases to SQL Server 2008 R2
• Applied SP (Service Pack) and HOT Fixes on SQL Server 2000, 2005, 2008 R2 and 2012
• Applied Patch on Windows Server 2003 Enterprise Edition
• 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/20008 R2
• 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

Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, Apache Tomcat 5.5, SQL Server 2012, 2008 R2, 2005, ASP, ASP.net, PHP, AD (Active Directory)

Confidential, Richmond, VA

SQL Database Administrator/DBA

Responsibilities:

• Installed, configured, and managed SQL Server 2008 R2, 2005 & 2000 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, 2008 R2 and 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 for production and development environment.
• Experienced with Point-in-Time Recovery
• Attended Weekly and monthly meetings.

Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache, Tomcat 5.5, SQL Server 2008 R2, 2005, ASP, ASP.net, AD (Active Directory)