SUMMARY:

• 8+ years experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012.
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Failover Cluster and Always ON availability.
• Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, log shipping, mirroring, connectivity, and security related issues.
• Experience in Using SQL Server tools like the Import/Export, PowerShell Scripts, SQL Profiler and SQL Query Analyzer.
• Experience in installing and configuring SQL Server, applying patches and fixes
• Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
• Solid Experience monitoring, troubleshooting and performance optimization related issues
• Extensive experience in using SSIS, SSRS to import/export data from different sources of data into SQL Server Databases
• Strong experience with Installing, configuring, creating, supporting and managing Oracle Database systems
• Experience writing SQL, batch and Shell scripts for backups, SQL*Loader, export and import of database
• Oracle database refresh from production to Development or Test environment using export dump
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning
• Strong knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs
• Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently
• Team player, Dedicated and a Fast learner with capability to master and implement new technologies
• Excellent presentation and documentation skills

TECHNICAL EXPERTISE:

ETL Tools: SSIS, BCP, & DTS

SQL Server Native Tools: SQL Server Management Studio, Database Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor, Reporting Services, Configuration Manager, Business Intelligence Development Studio (BIDS)

Operating System: Windows Server 2012, 2008, 2003, Windows XP Professional, Windows 7, 10 Professional, VMware

Hardware/Storage: SAN, RAID

Third Party Tools: Idera, LiteSpeed, Spolight

PROFESSIONAL EXPERIENCE:

Confidential, Laurel, MD

SQL Server - Database Administrator

Responsibilities:

• Performed database monitoring and Performance tuning.
• Monitor Servers activity, and worked with clients to solve different problems.
• Performed index and statistics management.
• Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
• 24X7 Production Database on Call Support.
• Created and managed Index (Cluster/Non-Cluster), Constraints.
• Used tools like SSIS, and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
• Created and Managed users, roles, security at object level, data encryption.
• Import and export database tables to excel and access.
• Creating SSIS packages to import and export data.
• Work experience and strong knowledge in disaster recovery.
• Rebuild databases using backups.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Developed Reports using SSIS.
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping.
• Installed, Configured and Maintained Failover Cluster Servers in SQL Server 2008 and 2012 R2 enterprise.
• Configured AlwaysOn availability group in SQL Server 2012 R2 by using SQL Server Management Studio
• Installed, Configured, and Administered SQL Server 2008/2008 R2 in development, test, and production environment.
• Installed and Configured Operating System, Windows Server (2008 and 2012).
• Migrated MS Access 2003/2000/97 databases into MS SQL Server.
• Migrated MS SQL Server 2008 & 2012 R2 enterprise
• Imported data from Excel, Flat file, to SQL Server Database.
• Created Backup jobs for different types of backup models like SIMPLE, BULKLOG and SIMPLE FULL.
• Created a scripted maintenance plan that takes a FULL and TRANSACTIONAL BACKUP of all system and user databases,
• Created Maintenance Job called Index Optimize - Re-Organize/Rebuild Indexes and Update Statistics.
• Created BAT programs to move backup and other files to backup servers.
• Configured Database mail
• Created Database that can store FILESTREAM data
• Changed recovery Model to the effectiveness of the backup and restore options
• Changed database state form READ ONLY to READ and WRITE
• Created multiple connections to database and changed RESTRICED USER and ROLLBACK IMMEDIATE.

Confidential, Beltsville, MD

SQL Server-Database Administrator

Responsibilities:

• Installed and Configured SQL Server 2005, 2008/2008R2 & 2012 in production and test 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.
• Actively involved in installing and managing multiple 2-nodes failover cluster setup in Active/Passive environment for High Availability Always On
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux and Windows OS.
• Performed Oracle database Upgrade from Oracle 10g to 11g.
• Installation and application of several Oracle critical patches to various database versions.
• Monitor, optimize and allocate physical data storage for database systems.
• Developed, implemented and maintained an Enterprise Oracle backup, recovery and disaster recovery strategy.
• Implemented the use of Oracle Recovery Manager (RMAN) to backup the databases.
• Performed import and export using traditional (exp) and export dump(expdp) as needed and scheduled nightly export on each database.
• Perform various RMAN cold and hot backups.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Wrote T-SQL and Stored-Procedures and performed Database, SQL, and index tuning.
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Created Backup strategy for production and development environment.
• Scheduled jobs, setup and configure Database mail for notification purposes.
• Developed Database Maintenance Plan to monitor Servers activity
• 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.
• 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.
• 24X7 Production Database on Call Support.