SUMMARY

• Experienced in Installation, Configuration, System Analysis, Design, Implementation and Administration of MS SQL Server 2012, 2008R2, 2005, 2000 in Production, Test & Development.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading, and Migrating SQL Server 2012/2008 & R2/2005/2000 on Clustered and Standby Environments.
• Excellent experience in Designing, Configuring, Implementing and Administering SQL Server Database High Availability Solution
• Strong experienced in Configuring, Managing and Administering Database Mirroring, Log Shipping & Replication as a Disaster Recovery and High Availability solution.
• Experienced in installing and configuring and upgrading of SQL Server failover cluster as a High Availability Solution.
• Experienced in analyzing data integration, developing ETL process using SSIS and BIDS
• Experienced in T - SQL programming in writing, managing and debugging Functions, Stored Procedures, and triggers
• Experienced in installation, Configuration, and Administration of SharePoint server 2010
• Experienced in installing, configuring, and managing Database Servers in VM Environment
• Hands-on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experienced in Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools and Monitoring Server Activity, Error Log, space usage, and solving problem as needed
• Experienced in managing Clustering and Always ON high availability groups
• Knowledge and working experience on SSIS and DTS for data move and manipulation
• Experienced on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
• Experience in setting-up, and Managing Database Maintenance Automation like different types of Database Backups (Full, Differential & T-Log ) jobs, Index Management, Update Statistics History Cleanup, Deleting old file etc.
• Experienced in Managing Database Security and Audit
• Experienced in Applying SPs for SQL Servers & OSs.
• Experience in Database migration from RDBMS like Oracle, MS Access, and Sybase to SQL Server 2012/2008R 2/2008/2005.
• Experienced in upgrading SQL Server 2005 to SQL Server 2008/R2, and SQL Server 2008/R2 to SQL Server 2012
• Experienced in configuring and setup Database Mail Server for database mail notification
• Experienced in Database deployment in Production and refreshing in test environment
• Experienced in administering AD (Active Directory)/Domain and monitoring user activities

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

SQL Server Database Administrator/DBA

Responsibilities:

• Installed, configured, managed, monitored and troubleshooting SQL Server 2008 R2 & 2012 in Test, Development and Production environment.
• Upgraded SQL Server R2, and 2008 R2 to 2012
• Maintained SQL Server Failover Clustering Server and Always ON
• Configured and Managed Replication, Log Shipping, Mirroring and Cluster Instances
• Responsible for securing Database & SQL Server environment by granting proper level of permissions on various Objects.
• Setup Database maintenance plans for Backups, Index Maintenance, Update Statistics, and Cleanup History, Delete old file etc.
• Proactively monitored of SQL Server for disk space utilization, service status
• Performance monitoring using SQL Server native and 3rd party tools
• Built user-defined functions (UDFs), views, indexes, triggers, Stored Procedures.
• Created customized reports using SQL Server 2008 R2 Reporting Services
• Created SOP (Standard operating procedures) for all SQL Server activities like - Installing SQL Server, applying service packs and security fixes
• Backed up and restored user and System Databases. Imported and exported data between MS SQL Server and Non +Microsoft SQL Server using SQL Transfer manager and bulk copy program
• Scheduled and monitored all maintenance activities of SQL Server Instances
• Monitored database status including CPU, memory, I/O, space, and deadlocks
• Created alerts, notifications, and emails for system errors, insufficient resources, hardware errors, and security breach

Environment: Windows Server 2012/ 2008 R2 and IIS 7.5, 7.0 and 6.5, SQL Server 2012, 2008R2, 2008 and 2005. SharePoint 2010, 3rd party tools Idera, Toad Data Modeler, Solar wind

Confidential, Washington, DC

SQL Database Administrator/DBA

Responsibilities:

• Installed, Configured, Upgraded and Managed SQL Server 2008R2, 2005 development, test, and production environment.
• Maintained Fail-Over Clustering using SQL Server 2008 R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes.
• Configured and Maintained Transactional Replications for Load balancing.
• Installed, Configured, Developed and administered SQL Server Reporting Services (SSRS).
• Developed Ad-hoc Reports using Report Builder 3.0, 2.0
• Designed and implemented Database Migration (development, testing and production environment).
• Worked on data analysis, data modeling and generated E-R Diagram.
• Applied forward and Reverse engineering for logical and physical database creation.
• Maintained scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Used Monitoring tools such as Spotlight and Idera
• Monitoring SQL Server Error Log, space usage (routine based)
• Writing Functions, Triggers, and Stored Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Export & Import 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
• Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well

Environment: SQL Server 2008R2, 2005 & 2000, Windows 2003/2000 Server. 3rd party tools Fog light, Toad Data Modeler