SUMMARY

• Have more than 11+ Years of experience in IT, in which 9+ Years of experience in Database administration and Maintenance of Production Servers of MS - SQL Server, Team Foundation Server, WSS 3.0 and SharePoint 2010.
• Designing, Implementing and Administering SQL Server (2000/ 2005/2008/2008 R2/2012) Database.
• Business Continuity Planning, Backup & Administrative Strategies
• Performance tuning using SQL Profiler and Query optimization techniques.
• Migration from other products Oracle, Access to SQL Server.
• Expertise in high availability features like Database Mirroring, Clustering, Replication and Log Shipping.
• Proficiency in Database and Server Security Management.
• Generating various Ad hoc reports as per the client’s requirements.
• Maintaining and monitoring data consistency on daily and weekly basis.
• Exposure to 24X7 Production Support environments.
• Troubleshooting Reporting Services.
• Team Foundation Server Administration (Installing, Configuring, Administering and troubleshooting Team Foundation Server 2008/2010).
• SharePoint Administration (Installing, Configuring, Administering, upgrading/migrating WSS 2.0/WSS 3.0 and MOSS 2010).
• Good team player with strong communication, interpersonal, and management skills

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008R1/R2/2012

Languages: Visual Basic 6.0,HTML,T-SQL,PowerShell

Databases: MS SQL Server 2012/2008R2/2005/2000, Oracle, MS Access& my SQL

Tools: & Utilities: Data Protector (Backup Tool), Data Protection Manager (DPM), Remedy, Red Gate for SQL Server & Quest SQL Litespeed.

Others: Shared Point 2007/2010,Team Foundation Server 2008/2010 and Product Studio

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Server DBA/Project Lead

Responsibilities:

• Leading 5 members SQL Team for execution of SQL operations and deliverables.
• Handled 24x7 support and 24x7 on-call support efficiently and provided support
• Installing, configuring, upgrading & administration of standalone and Clusters of MS SQL Server 2005/2008/2008 R2/2012.
• Develop and test a backup and restore strategy.
• Perform Health check on the servers frequently.
• Monitoring the CPU, Memory utilization and Disk Spaces on servers.
• Develop Performance baseline and Troubleshooting Performance Issues.
• Manage security of database structures and corporate data held within databases.
• Establishing the needs of users and monitoring user access and security.
• Design SSIS package to extract data from External data source to SQL Server.
• Analyze the database growth & trends and Planning the Capacity of the Servers.
• Monitoring the error logs, Database Availabilities, Space to avoid the failure of applications on regular intervals.
• Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, system side stored procedures and programs.
• Configuring the audit alerts to capture the failed login attempts and Monitor the unauthorized user access to the databases and remediates the same.
• Interacting with the support teams so that the database environment is always
• Configuring/Monitoring/Troubleshooting log shipping, database mirroring and Replication.
• Monitoring the servers with various windows performance counters to identify server health.
• Moving System databases from one location to another.

Environment: SQL SERVER 2012/2008/2008 R2/2005/2000, SQL LiteSpeed, windows 2000, 2003 & 2008R1/R2/2012 SSAS, SSIS and SSRS

Confidential, Orland, FL

SQL Server DBA

Responsibilities:

• Installing, configuring, upgrading & administration of standalone and Clusters of MS SQL Server 2005/2008/2008 R2.
• Develop and test a backup and restore strategy.
• Perform Health check on the servers frequently.
• Configure SQL Server maintenance Tasks.
• Configuring/Monitoring/Troubleshooting Database Mail, log shipping, database mirroring and Replication.
• Monitoring the CPU, Memory utilization and Disk Spaces on servers.
• Develop Performance baseline and Troubleshooting Performance Issues.
• Manage security of database structures and corporate data held within databases.
• Establishing the needs of users and monitoring user access and security.
• Provide support to Share Point 2007/2010 and internal applications.

Environment: MS SQL SERVER 2008 R 2/2008/2005/2000 , Red gate for SQL Server, Windows /2008 R2, SharePoint 2007/2010.

Confidential, Redmond, WA

SQL Server DBA

Responsibilities:

• SQL Servers maintenance Tasks/Activities
• Backup/Restore.
• Monitoring and troubleshooting the SQL Server, SSAS, SSRS, TFS, WSS 3.0 and Share Point 2010 connectivity, performance and configuration Issues and other day to day DBA activities
• Installing, configuring, upgrading & administration of standalone and Clusters of MS SQL Server 2005/2008/2008 R2 with SSRS/SSAS, TFS 2010 and WSS 3.0.
• Involved in High availability activities including Replication, Database mirroring, clustering, maintenance and security.
• Provide L3 support to the critical application VSTF (TFS)/ Production Studio.
• Upgrade of WSS 2.0/3.0 content databases to SharePoint 2007/2010.
• Enhanced and Shared the Knowledge across the Confidential Platform by writing and updating the Knowledge Base (KB) the process oriented articles, which are referred and used by users and L1 and L2 teams.
• Conducted trainings, development and Knowledge transfer session organized by Confidential for development and enhancing of skills of the users and clients of the organization.
• Worked closely with problem management/product team in fixing the reoccurring issues and sharing the work load of problem management.

Environment: MS SQL SERVER 2005/2008/2008 R2,Team Foundation Server 2008/2010/ Product Studio, Windows / 2008 R2, WSS 3.0 and SharePoint 2010

Confidential

SQL Server DBA

Responsibilities:

• Migration from Lower versions (SQL Server 7.0/2000) to SQL 2005.
• Manage security of database structures and corporate data held within databases.
• Develop and test a backup and restore strategy.
• Creating users, roles and giving appropriate permissions to the members as part of implementation.
• Use of DTS/ SSIS package to extract data from External data source to SQL.
• Installing, configuring, upgrading & administration of MS SQL Server.
• Capacity Planning of the Servers.
• Monitoring the CPU, Memory utilization and Disk Spaces on servers.
• Check the Integrity of the databases and tables.
• Develop Performance baseline and fine-tuning queries.
• Configuring the SQL Mail/Database Mail.
• Configuring and Monitoring Replication and Log Shipping.

Environment: T-SQL, MS SQL Server 2005/2000, Data Protector, Windows 2003

Confidential

SQL Server DBA

Responsibilities:

• Database Administrator - MS SQL 2000 databases
• Install, maintain and monitoring the production databases, reporting & analysis databases.
• Backups and Recovery processes.
• Manage security of database structures and corporate data held within databases.
• Develop database procedures, triggers and SQL scripts for development teams.
• Assist in the definition and implementation of database standards.
• Monitor the databases for performance related issues and perform tuning the database.
• Monitor the Database Spaces. Checking database integrity, tables.
• Resolve database performance issues, replication, and other distributed data issues.
• Design & implement data models and database designs into physical databases.
• Maintain database changes from Development, QA to Production.

Environment: T-SQL, MS SQL Server 2000/2005, Windows 200