SUMMARY

• Certified SQL Server Database Administrator(DBA) having about 6 (six) years of professional experience with detail oriented, analytical and troubleshooting in different Microsoft products like SQL Server, data modeling, gathering and analyzing business requirement and Operating Systems.
• Solid working experience in managing large databases, SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Working experience entails strong knowledge on using database third party tools like Foglight, SpotLite, RedGate, ERWin, Visio and Toad for SQL Server.
• Strong business and technical vision with ability to manage multiple complex projects, innovative and problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

• Deep understanding and working experience of SQL Server (SQL 2000, SQL 2005, SQL 2008R2 and SQL 2012) - includes installation, configuration, and maintenance of standalone and Clustered Servers Active/Active and Active/Passive Cluster environment
• Knowledge of Microsoft Best Practices with regards to configuration of SQL data/log file and tempdb
• Applied Service Pack (SP) and hot fixes on Database Server - 2005, 2008/R2,2012 and 2000
• Migrated MS Access, MySQL, and Oracle Databases like 10gR2/11gR2 to SQL Server 2008 R2 and 2012
• Performed Data Modeling, data analysis, database design, and developing E-R diagram using ERWin, and Toad Data Modeler
• Optimizing and Performance Tuning for Online Indexing, Query Optimization, using execution plan, Profiler, Database Tuning Tool and third party tool like SPOTLIGHT and FOGLIGHT
• Experienced in using Profiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server
• Experienced in administering AD (Active Directory)/Domain and monitoring user activities
• Master of database Backups and Restoration

TECHNICAL SKILLS

• Database: SQL Server 2012/2008/R2/2005/2000, Migrated Sybase, Oracle, MySQL, MS Access Databases to SQL Server 2008 R2 and 2012
• Operating System: Windows Server 2012, 2008 R2, 2003 R2, VMware
• Languages: SQL, T - SQL, Store Procedures, Trigger, and functions
• ETL Tools: SSIS/DTS, and BCP Migrated and Upgraded DTS packages to SSIS Packages
• Reporting: SSRS (SQL Server Reporting Services) - 2008 R2 and 2012
• Data Modeling: ERWin, Toad Data Modeler, SSDD (SQL Server Database Diagram)
• Networking: Active Directory, TCP/IP
• Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE

Confidential, Hunt Valley, MD

SQL Database Administrator

Responsibilities:

• Installed Configured and managed SQL Server 2000, 2005 & 2008 R2and 2012 in Dev, test, and production environment
• Migrated SQL Server Databases from 2000/ 2005 to 2008/R2 and SQL Server 2012
• Developed Backup Strategies for prod and dev environment including mission critical databases
• Created documentation on Migration project
• Refresh & restore databases in Dev, test, and production server
• Used SQL Server native tools like Performance dashboard report, Activity monitor, Profiler, Database tuning Advisor, Performance Monitor to Troubleshoot Performance related issue & Tuning
• Configured multiple file and filegroups for better performance and as well as to maintain data integrity
• Setup Database Mail server & alert notification in SQL Server 2012
• Applied HOT Fixes and Patches(SP) in SQL Server 2000,2005,2008 R2 to SQL Server 2012
• Configured and Managed Database High Availability: Replication(transactional), Database Mirroring, Log Shipping, Clustering and AlwaysOn Availability Groups (2012)
• Used DBCC and DMV (Dynamic Management View) for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
• Wrote stored procedures for Automation of Jobs and Administrative purposes
• Assisted SQL developers to optimize SQL queries, Stored Procedures
• Created and managed database security, data encryption, and applied object level security
• Managed administered & deploy report to the report server
• Monitored Database Servers Agent activity, SQL Server Error Logs, and space usage through automatic jobs and set alerts

Confidential, Owings Mills, MD

SQL Database Administrator

Responsibilities:

• Installed and Configure SQL Server 2000, 2005 & 2008 R2 in development, test, and production environment
• Installed, Configured and Maintained DR Solutions in SQL Server 2005 & 2008 R2 - Replication, Mirroring and Log Shipping set up and Administered
• Migrated databases from SQL Server 2000, 2005 to 2008 R2
• Wrote scripts using T-SQL and Stored-Procedures for different DBA related tasks and to support Business
• Performed Database Performance tuning using different tools and using different methods like index tuning for fragmented indexes, configured multiple file structures for separating data file, log file, tempdb and system databases
• Developed and Managed Database Maintenance Plans
• Monitored Database Servers and Agent activity, and solved problems
• Monitored SQL Server Error Logs, and space usage through automatic jobs and set alerts
• Run DBCC statements to check physical and logical consistency of database
• Worked on Data Modeling using ER W in including Logical & Physical Database using ER W in
• Backward & Forward Engineering
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers
• Experience with the ETL: DTS & SSIS:
• Experience to use the Import/Export Wizard, the DTS Designer, DTSRun, DTSRunUI, and SQLAgent
• Experience to use tasks to: Transform data— Transform Data task, Data Driven Query task, Parallel Data Pump task,
• Copy and manage data— Bulk Insert task, Execute SQL task, Copy SQL Server Objects task, Transfer Database task, Transfer Logins task, Transfer Master Stored Procedures task
• BCP to import & export data from flat files, excel and MS Access to MS SQL Server databases
• Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files
• Migrated MS Access 2000/97 databases into MS SQL Server 2005/2008 R2
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed and deployed Reports using SSRS and Ad-hoc Reports using Report Builder 3.0, 2.0

Confidential, New York

SQL Database Administrator/DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008, 2005 & 2000 in development, test, and production environment
• Database High Availability: Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/2005. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008. 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 Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0
• Database Migrated (development, testing and production environment). MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008. Oracle 10g databases to SQL Server 2008. My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008
• Data Modeling: Worked on data modeling projects and generated E-R Diagram. Data modeling tools used using ERWin, Toad Data Modeler, and SQL Server Data Diagram. Backward & Forward Engineering with data modeling tools mentioned above