SUMMARY

• Over ten years hands - on professional experience in SQL Server database as a DBA
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
• Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, Error log, mirroring, connectivity, and security related issues etc.
• 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, and production environments
• Solid Experience monitoring, troubleshooting and performance optimization related issues
• Extensive experience in using SSIS, SSRS and BCP to import/export data from different sources of data into SQL Server Databases and vise visa
• 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
• Devoted and Quick learner with capability to master and implement new technologies
• Excellent presentation and documentation skills
• Multi lingual with knowledge of 2 different languages
• Sound experience with IDERA, SCOM, SOLARWINDS monitoring tools

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2000/2005/2008/2012 , TSQL

Tools: SSIS, SSRS, SQL Doctor, BCP, Import and Export Wizard, Profiler, DTS, SQL Red Gate, SQL Diagnostic Manager (Idera), and Forefront Identity Management (FIM)

Microsoft Office: (Word, Excel, Power Point, Outlook, Access)

Operating System: Windows server 2005, windows server 2008, Windows Server 2012 R2 and Vista/window s 7, Windows 8/8.1

Windows Engineering: Rebuild server and add server to Domain

Contribution: Production OPS DBA/QA Environment (SQL Database Administrator)

PROFESSIONAL EXPERIENCE

Confidential, Laurel, MD

SQL Server DBA

Responsibilities:

• Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
• Major duties: Installed and Configure SQL Server 2005, 2008, and 2012 in TestDev and production environment.
• Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
• Created Backup jobs for different types of backup like FULL, BULKLOCK, and SIMPLE Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
• Created BAT programs to move backup and other files to backup servers.
• Created Database that can store FILESTREAM data
• Major duties: Installed and Configure SQL Server 2005, and 2008 in test and production environment.
• Migrated databases from SQL Server in test and production environment.
• Closely worked with business analyst to collect requirements & make systems available ASAP.
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Writing T-SQL and Stored-Procedures.
• Performed Database, SQL, and index tuning.
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Created Backup strategy for production and development environment.
• Database Backup & Restore.
• Scheduled jobs.
• Setup and configure Database mail for notification purposes.
• Providing day-to-day production and non-production support for databases (more than 600 databases) of more than 15 applications.
• Designing architecture of SQL Servers infrastructure and implementation of Dev, and QA environment.
• Setup High Availability and Disaster Recovery solutions for SQL server 2008 /R2 databases.
• Setup SQL server Clustering, Replication.
• Gathered business requirement, impact analysis, prepare implementation plan, pass on information to offshore and work towards execution of the plan.
• Conducted pre-release checks on deployment of database scripts. To deploy and support Post deployment validation.
• Performance tuning of stored procedures and optimizing of the database.
• Configuring database mail, notification services, scheduled jobs & alerts for blocking, disk space, services, replication, etc.
• Access control for users and applications as per database access policies and business specifications
• Worked on SQL Server 2012 new features
• Developed Database Maintenance Plan.
• Monitor Servers activity, solving problem.
• Monitor and resolve deadlock for client issues. Troubleshooting connectivity issues Permissions, etc.
• SQL Server Error Log, space usage.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Export & Import data from MySQL, and Access Database including flat files like text, excel, and into SQL Server databases.
• 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.

Confidential, Annapolis, MD

SQL Server DBA

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.
• Updates ErrorLogs and document the resolutions.
• Create DatabaseIndex/Constraints, Triggers, Stored Procedure:
• Created and managed Index (Cluster/Non-Cluster), ConstraintsSecurity Management:
• Created and Managed users, roles, security at object level, data encryption.Export & Import data:
• From/to MySQL, and Access Database including flat files like text, excel, and to SQL Server 2005/2008/2012. Backup/Recovery:Work experience and strong knowledge in disaster recovery.
• Rebuild databases using backups.
• TDE backup and restore
• Window Events Log backup and clearReports:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Managed security for reports.Database High Availability:
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping.
• Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2005 & 2008.SQL Server & Windows Server Installation:
• Installed, Configured, and Administered SQL Server 2005, 2008 in development, test, and production environment.
• Installed and Configured Operating System, Windows Server (2000, 2003, 2005 & 2008).Database Migration:
• Migrated MS Access 2003/2000/97 databases into MS SQL Server.
• Migrated MS SQL Server 2005 to MS SQL Server 2008.
• Imported data from Excel, Flat file and BCP to SQL Server Database.Export data from SQL Server Database using Import export wizard and BCP to Excel, Flat fileDatabase Automation:
• Created Backup jobs for different types of backup like FULL, BULKLOG, and SIMPLE Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, database 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

SQL Server Database Administrator

Responsibilities:

• Major duties: Installed and Configure SQL Server 2005, and 2008 in test and production environment.
• Migrated databases from SQL Server in test and production environment.
• Closely worked with business analyst to collect requirements & make systems available ASAP.
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Writing T-SQL and Stored-Procedures.
• Performed Database, SQL, and index tuning.
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Created Backup strategy for production and development environment.
• Database Backup & Restore.
• Scheduled jobs.
• Setup and configure Database mail for notification purposes.
• Developed Database Maintenance Plan.
• Monitor Servers activity, solving problem.
• 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.
• Export & Import data from MySQL, and Access Database including flat files like text, excel, and into SQL Server databases.
• 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.

Confidential, MD

SQL Server DBA

Responsibilities:

• Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
• Major duties: Installed and Configure SQL Server 2005, and 2008 in test and production environment.
• Migrated databases from SQL Server in test and production environment.
• Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
• Created Backup jobs for different types of backup like FULL, BULKLOG, and SIMPLE Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
• Created BAT programs to move backup and other files to backup servers.
• Configured Database mail
• Created Database that can store FILESTREAM data