Professional Summary:

over Eight 8 years of experience as a SQL Server DBA with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server, SharePoint, and Operating Systems. Depth knowledge and experience in data modeling including gathering and analyzing business requirement. Solid working experience in managing large databases in 24/7 data processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services SSRS , Monitoring, Stored procedures, triggers, functions, constraints and views etc. and as well as reports using Microsoft Reporting Services, and Crystal Reports technologies. Working experience entails strong knowledge on using database third party tools Idera, Spotlight, RedGate, ERWin, and TSM . Managed daily tasks with planning and organizing with prioritize basis. Quick response any email and attending daily, weekly meeting and a great team player.

TECHNICAL SKILS

Professional Experiences:

Confidential

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012, 2008, 2005 in development, test and production environment
• Installed and Configured SQL Server 2012, 2008 and 2005 for testing different features and stability

Database High Availability:

• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008R2 and 2005
• 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 and Deployed Reports using SSRS
• Developed Parameterized, Drill down, dropdown link report, Ad-hoc Reports using Report Builder 3.0

Database Upgraded development, testing and production environment :

• SQL Server 2000 to 2005
• SQL Server 2005 to SQL Server 2008R2
• SQL Server 2008R2 to SQL Server 2012

Database Migrated development, testing and production environment

• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, 2008
• Oracle 10g databases to SQL Server 2005, 2008R2
• My-SQL 5.0.1 databases to SQL Server 2005,2008
• SQL server 2008R2 to SQL server 2012

Data Modeling:

• Worked on more than 10 data modeling projects and generated E-R Diagram
• Data Modeling tools used using ERWin, VISIO, Oracle SQL Developer, SQL Server Data Diagram
• Backward Forward Engineering with data modeling tools mentioned above

Patch Management:

• Applied SP Service Pack on SQL Server 2005, 2008
• Applied HOT Fixes on SQL Server 2000, 2005, 2008
• Applied Patch on Windows Server 2003 Enterprise Edition

Database Monitoring/Performance Tuning:

• Strong knowledge on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage

Database Programming:

• Writing T-SQL, User Define Function, Trigger,
• Create and maintain Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures

DTS/SSIS:

1. Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
2. Export Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

Security Management:

• Create appropriate server level login, Users for database level and permission for column level to protect data bases
• Periodically monitor users activity by auditing.

Backup/Recovery:

• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Use DMV for Server health check
• Strong working experience in creating, modifying tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, and solving problem as needed

Environment:

MS SQL Server 2012/2008R2/2005 Enterprise, Windows server 2003/2008 64 bit, SSIS, SSRS, IIS, SQL Profiler, Crystal reports T-SQL, DTS, SQL Agent, RedGate, Foglight, Idera, TSM.

Confidential

SQL Server Database Administrator

Responsibilities:

• Installed and Configure SQL Server2008, 2005 2000 in development, test, and production environment
• Installed, Configured and Maintained SQL Server 2000 2005 Fail-Over Cluster Servers
• Installed and Configured Operating System, Windows Server 2000 2003
• Migrated databases from SQL Server 2000 to 2005 in test and production environment
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks
• Involved in Performing Production data refresh in Mobility Performance environment
• Implementing DR solution, High availability of database servers using Database mirroring and replications
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities and raising Tickets for the upgrading of CPU and memory space
• Performed data modeling activities using ER diagrams, application performance tuning and code reviews and documenting the changes.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Migrated MS Access 2000/97 databases into MS SQL Server and Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database
• Work experience and strong knowledge in disaster recovery
• Configured Log Shipping from Production to Standby Server Running as Reporting Server
• Configured and Maintained Replications Transactional
• Writing T-SQL and Stored-Procedures
• Performance tuning index tuning
• Created Backup strategy for production and development environment
• Database Backup Restore and scheduled jobs by using the 'Database Maintenance Plan'
• Monitor Servers activity, solving problem and daily check the SQL Server Error Log, space usage, etc
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes
• Extensively experience in using DTS, BCP to import export data from flat files, excel and MS Access to MS SQL Server databases
• Designed Logical Physical Database and Backward Forward Engineering by using ERWin
• 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
• Provided 24/7 Support for Production, Development Test Servers of MS SQL Servers dedicated databases.

Environment:

MS SQL-Server 2008R2/2008/2005/2000, Windows 2008/2003/2000 Server, Idera, Lite Speed, TSM, SSRS, Performance Monitor, IIS, Crystal Reports. Integration services SSIS , SQL Profiler, T-SQL, DTS, SQL Agent, and RedGate.

Confidential

SQL Server DBA

Responsibilities:

• Experience with Transparent Data Encryption TDE , in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, deadlock resolutions, and fragmentation issues
• Extensively working on performance issues like update statistics, Auto Stats.
• Performed data partitioning for efficient management of database tables and indexes
• Monitored SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Resolving performance issues using DMVs Dynamic Management Views .
• Setup Database Security and maintained accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems response delay, locking, server down time, etc to avoid and optimize.
• Expertise in working with Transactional Replication Environment and handled the publication conflicts manually depending on last changed date.
• Expertise in setting up and troubleshooting Database mirroring.
• Migrated Databases from SQL Server 2000 to SQL server 2005
• Upgrade SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed and configured SQL Server 2005/2000 on new servers with service packs.
• Worked on log shipping for synchronization of database.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Used native tools like Database Tuning Advisor, Performance Monitor and Activity Monitor for performance tuning
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans
• Involved in Configuring and testing the setup of SQL Server Database encryption on DR servers
• Provided 24/7 Support for Production , Development Test Servers of MS SQL Servers

Environment:

SQL Server 2005/ 2000, Windows 2003/2000 Server, SQL Lite Speed, VSS, Erwin, DTS, SSRS, SSAS, Excel, Tomcat, VB.NET, ASP.NET, IIS, Transact-SQL