SUMMARY

• 7+ years of IT experience wif 6+ years experience as SQL Server DBA (2000, 2005 and 2008) in Production, Development and Test Environments.
• Expertise in Database Design, Administration, Implementation and Application Development.
• Experience in SQL Server 2000/2005/2008 Installation, Configuration of Stand alone wif multiple instance in Clustered and Non - Clustered environments.
• Migration/upgrading of SQL Server 2000 to 2005 and 2008 and applying Service Packs.
• Extensive experience in high availability SQL Server Solutions which includes Mirroring and Clustering.
• Experience in creating Log Shipping and Replication (snapshot, transactional and merge) for various customers.
• Experience in evaluation of database performance, tuning, backup, and restoring and disaster recovery of databases.
• Extensive experience in controlling the user privileges, roles, monitoring the security and Audit issues.
• Expertise in using various SQL Server Tools like Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS, SSAS and SSIS.
• Provided 24/7 support in monitoring, troubleshooting, optimization and tuning of SQL Server environments and Good hands on performance and tuning issues and developing and implementing emergency fixes, resolving database problems.
• Monitored and tuned SQL Server performance using System Monitor, SQL Profiler, Query Execution Plans and checking the consistency of database using DBCC Utilities.
• Reviewed and optimized queries using Index Tuning wizard, Database Tuning Advisor to help dev teams to achieve better performance. Documented solutions to database issues.
• Created maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics. Expertise wif Table Design, Index Design and Performance Tuning.
• Involved in setting up SQL Jobs, Alerts, Database Mail and MOM.
• Good experience in SQL Server Programming, Integration Services and Reporting Services.
• Migrating packages from SQL server 2000 to SQL Server 2005.
• Experience in working wif production and 24 x 7 on call environments.

TECHNICAL SKILLS

Database: Microsoft SQL Server 2000, 2005, 2008 and 2008 R2

O/S: Windows Server 2000/2003/2008 / NT

Languages: Java, C#, C++Tools: SharePoint 2.0&3.0, OLTP, OLAP, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

SQL Server Database Administrator

Responsibilities:

• Installed, configured, administered and secured SQL Server 2008/2005/2000 on Server and Clients.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures
• Implemented high availability techniques mainly Replication, Log shipping and involved in planning and monitoring Log Shipping.
• Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location and also to Reporting server.
• Successfully implemented Database Mirroring wif High Availability Mode in SQL 2005 and installed SQL Server in a cluster Environment.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Migrated from SQL Server 2005 to SQL Server 2008. And migration of ETS packages to SQL Server 2008.
• Migrated SQL 32 bit version to 64 bit version on 2005 SQL Version.
• Running DBCC Consistency Checks and fixing Data Corruption in user databases.
• Helped developers team in developing and deploying SSRS packages.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Heavily used Transactional Replication, Configured between Primary Server and three Read - Only servers and experience in troubleshooting replication problems.

Environment: SQL Server 2000, 2005 and 2008, Oracle 9i/10g, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows 2000/2003/2008, Veritas Net backup and LiteSpeed.

Confidential, Morrisville, NC

SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL Server 2000/2005 in Production and Development environments.
• Involved in upgrading MS SQL Server 2000 to 2005 on development and test environments.
• Worked as an outsourced consultant solely responsible for designing, developing and maintaining SQL Server databases containing customer information.
• Design and implementation of database Logical and Physical Schemas.
• Created Replication and Log Shipping for different customers.
• Implemented Log Shipping in SQL Server 2005 from Primary Server to Standby Server.
• Responsible for creating, maintaining and monitoring mirrored servers.
• Worked in failover cluster environment Active/Active and Active/Passive nodes.
• Applied patches to SQL Servers in Cluster environment.
• Assist in developing Normalization.
• Estimation of Table sizes and Record sizes.
• Responsible for database tuning using normalization and application tuning.
• Extensively involve in replication and implementation of Snapshot, Transactional Replications.
• Check Performance Tuning, Indexing, Query Optimization, Integration of Third Party Databases.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Creation and maintenance of databases and objects like Tables, Views, Indexes, Stored-Procedures, Triggers and Cursors, Users and User Group creation and maintenance.
• Document disaster recovery plans and participate in disaster recovery.
• Take different types of backup including transaction log, Perform database consistency checks.
• Perform data migration between different environments and third party databases.
• Interact wif the users and troubleshoot the problems involved wif development.
• Schedule DBCC consistency checks.
• Good Knowledge on working wif SSIS and SSRS. Helped dev team in developing and deploying SSIS and SSRS Packages.

Environment: SQL Server 2000 and 2005, Oracle 9i/10g, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows 2000/2003, Tivoli, BMC Patrol, Veritas Net backup and LiteSpeed.

Confidential, Nashville, TN

SQL Server Database Administrator

Responsibilities:

• Installed, configured, administered and secured SQL Server 2005/2000 on Server and Clients tools. Maintained over 40+ SQL Servers in Production, QA, Test and Development Environment.
• Designed, implemented, and administrated databases in SQL Server 2000, 2005.
• Managed Logins, Users, Roles and User permissions, and conducted regular backup and recovery.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Worked in failover Cluster environment Active\Active and Active\Passive nodes.
• Applied patches to SQL servers in cluster environment.
• Implemented High availability techniques Mainly Replication, Log shipping, Mirroring.
• Migrated SQL 32 bit version to 64 bit version on 2005 SQL Version.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Installed, configured and maintained Reporting services boxes.
• Involved in supporting application team in production releases for replication change and schema changes.
• Used SCOM and SQL Sentry to create alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created SSIS Packages to migrate slowly changing dimensions
• Migrated packages from SQL Server 2000 to SQL Server 2005.
• Deployed SQL SERVER INTEGRATION SERVICES (SSIS) packages, Configured Log shipping.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Scheduled and monitored all maintenance activities including database consistency check, and index defragmentation by DBDEFRAG and DBREINDEX and statistics update.
• Helped application teams in query analyzing and its optimization. Coordinating wif users for downtime.
• Provided 24/7 in SQL production support.

Environment: SQL Server 2000/2005, Windows 2K/2003/2008, SQL Profiler, Migration, ETL, DTS, T-SQL, BCP, SSIS, Litespeed 4.8 and 5.0, SCOM, SQL Sentry.

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs and high availability techniques.
• Managing the Clustering environment.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation by DBDEFRAG and DBREINDEX.
• Monitored database status including CPU, memory, me/O, space, and dead lock using SQL Server Utilities
• Modified DTS to SSIS packages to accomplish critical business logic.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Develop Data Warehouse ETL process using SSIS (Integration Service)
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Used Erwin to reverse engineer the existing database design in MS SQL Server 7.0
• Created Jobs to Automate & Scheduled many tasks.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non production database code as well as T-SQL code from developers.
• Worked on all phases of database management wif application development team and other vendors to maintain maximum availability.
• Had good experience in 24/7 in SQL production support.

Environment: SQL Server 2000, Windows 2000/NT, Excel, Access, SQL Profiler, SSIS, Enterprise Manager, ETL, DTS, T-SQL, BCP.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created DTS packages for the loading the data.
• Used the reporting services to create, schedule and publish the reports required.
• Implemented and maintained database security. Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Tuned SQL statements and SQL Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Rebuilding indexes on various tables.