SUMMARY

• 8 years of IT experience in Microsoft Database Technologies which includes Database Administration, System Analysis, Design, Development and Support for MS SQL Server 2008 R 2 / 2008/2005/2000 in Production, Testing, Development and Clustered Environments.
• Experience in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in Database Backups, Recovery models and Disaster Recovery procedures.
• Experience and knowledge in configuring and managing high availability solutions like Clustering, Log Shipping and Database Mirroring.
• Experience in implementing different types of Replication Models like Snapshot, Transactional, transactional with updatable subscriptions and Merge Replications.
• Experience in database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Good knowledge and experience in upgrading (migration) MS SQL Server /2008.
• Good knowledge in installation and configuration of clustered servers in Active/Active and Active/Passive environments.
• Experience in implementing Database Mirroring in SQL Server 2008R2/2008/2005
• Successfully tested and implemented Log Shipping Technique used for hot backup solution for Sql server 2008 R2/2008/2005 databases.
• Experience in implementing database consistency checks using DBCC utilities.
• Experience in Creation and Maintenance of Databases, creating roles and managing user permissions.
• Good knowledge in RAID technologies 0, 1 - 5.
• Experience in using tools like SQL Profiler, Windows Performance Monitor (counters) for monitoring and tuning purposes.
• Experience in migration of data by BCP and DTS utilities.
• Experience in Data Modeling using ERWIN and Microsoft VISIO.
• Experience in data extraction, transforming and loading (ETL) data using SQL Server Integration Services (SSIS) and DTS.
• Experience in using SQL Server Management Studio(SSMS) 2008R2/2008/2005
• Experience in using version control tools like Microsoft Visual SourceSafe 6.0
• Experience in upgrading SQL Server 2000 DTS packages into SQL Server 2005 Integration Services (SSIS) packages.
• Experience in generating reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Worked with third party monitoring tools like Patrol, SQL Diagnostic Manager Idera’s Diagnostic Manager and SQL LiteSpeed.
• Experience in upgrading SQL Server to new versions and applying service packs and hot fixes.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003, Windows 2000 Advanced Server, Windows Datacenter Server, Windows NT 4.0, Windows XP Professional/ Media Center/Standard, Windows 9.x, Unix, Linux

Monitoring Tools: Trace Profiler, Database tuning advisor, Quest Performance Analysis Windows Performance Monitor Patrol Imceda LiteSpeed Idera s SQLSafe Red gate SQL Compare / SQL Database Compare.

Languages: C, C++, T-SQL, HTML

RDBMS: MS SQL Server 2008 R2,2008,2005, 2000, 7.0, MS Access 2000, 2003

SQL Server Tools: SSMS, SQL Server Profiler, SSIS, SSMS, Query analyzer

Version Control Tools: Microsoft Visual Source safe 6.0

Data Modeling Tools: Erwin, MS VISIO 2003/2005

Other Tools: SQL Diagnostic Manager (by Idera s), SQL LiteSpeed, Lumigent Log explorer 4.0, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Richmond, Virginia

MS SQL Server DBA

Responsibilities:

• Provided 24/ 7 production support on SQL Server 2008R 2/ 2008/2005/2000 .
• Installation and configuration of SQL server 2008 R2, 2008 and 2005 on Standalone and Clustered Environments
• Successfully implemented Database Mirroring in SQL Server 2008/2005 for high availability on required instances on SQL Server.
• Implement and Tested Log shipping between Production and Disaster Recovery servers.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates
• Involved in replication and implemented Snapshot, Transactional and Merge Replications.
• Involved in Monitoring Performance of different production servers
• Creating Logins and Roles with appropriate User permissions.
• Creating tables, indexes and designing constraints
• Prepared and documented Backup & Restore Plans, DR and Change Control procedures
• Creating and Maintaining Database Maintenance Plans
• Involved in migrating the databases from SQL server 2005/2000 to SQL server 2008
• Managed various issues like the Orphan user and transfer of logins etc., during the process of migration of SQL server 2005/2000 to SQL server 2008.
• Experience in Installation and Configuration of Cluster SQL Servers in SQL Server 2005 as Active/Passive node clusters.
• Troubleshooting SQL server (SQL 2008/2005) Installation issues for customer on various windows servers (Windows 2008/2003).
• Resolved issues related to Database Maintenance (Update statistics, re-index and Log file Shrink/Missing etc).
• Involved in developing the SSIS packages to migrate data from different sources
• Implementing database standards procedures and naming convention for the database objects.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Expertise in Monitoring and Troubleshooting SQL Server Performance issues.
• Worked on various tools like SQL LiteSpeed for backups.
• Used Patrol for monitoring the SQL Servers
• Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
• Size of databases varied from 50GB to 1 T byte, each server contained around 15 to 30 databases in all the 40 servers and other 16 DR servers and worked as a DBA in a team of 6

Environment: MS SQL Server 2008R 2/ 2008/2005/2000 , Windows 2008/2003/2000 data centre/advance server, SQL Profiler, Crystal Reports 11, ERWIN, Red Gate, and Idera’s Diagnostic Manager.

Confidential, Ashburn, Virginia

SQL Server DBA

Responsibilities:

• Installing, Configuring and Maintaining SQL Server 2008/2005 with latest Service Pack, Hot Fixes.
• Create and maintain various databases for Production, Development and Testing environments using SQL Server 2008/2005/2000
• Involved in creating scheduled full, differential, transactional log backups in all the test and Development, production environments
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 Integration Services (SSIS).
• Database optimization, performance monitoring and index tuning.
• Creating jobs and alerts for monthly and weekly maintenance.
• Used SQL Server 2008/2005 Management Studio (SSMS) to develop, deploy and troubleshoot Databases.
• Data migration from other data storage like Oracle and DB2 using SSIS.
• Tested and implemented Database Mirroring solution for Production critical application.
• Ensure that SQL Server databases are updated accurately and regularly.
• Implemented transactional replication for populating reporting database.
• Write, test and implement SQL queries for the application using T-SQL.
• Review SQL code, including stored procedures and DTS packages, to ensure performance, integrity, and other project standards are met.
• Identify and resolve user login and permission problems.
• Develop and Document DR procedures and Change Control procedures.
• Plan and administer database integrity.
• Used Version Control tools.
• Used Idera’s Diagnostic Manager and Performance monitor for monitoring SQL Server.
• Resolved issues related to query optimization, database optimization and index tuning.
• Resolved issues related to long running queries.
• Configured and managed Transactional Replication.
• Test and implement backup strategies. Good knowledge in SQL LiteSpeed a backup solution for MS SQL Server.
• Backup and Restore databases in SQL Server 2005 for maintaining stand by server.
• Created and Scheduled SSIS Packages for importing and exporting data to data warehouse
• Extensively documented all the databases, database objects, jobs and the changes made to the database.
• Documentation and Automation of various database related procedures.
• Created Linked Servers to move data from one server to another
• Designed and Implemented DTS packages for moving data (Export/Import).

Environment: MS SQL Server 2008/2005, Windows Server 2008/2003 EE, Windows 2000 Advanced Server, SQL LiteSpeed,, Idera’s SQL Diagnostic Manager

Confidential, Moline, IL

SQL Server DBA

Responsibilities:

• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc
• Created and managed Users/Logins.
• Worked with SQL server Profiler to generate traces.
• Actively participated in Logical design phase of new database. Worked on MS Visual Studio to draw data model.
• Solved issues related to server performance and disk space.
• Resolved issues related to query optimization, database optimization and index tuning.
• Monitored the database and alerts from Fog light application
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Configured Log shipping from one production server to the reporting server.
• Implemented built in log shipping with SQL Server 2000 for disaster recovery server.
• Creating the Packages for running the jobs automatically
• Good in Implementing SQL Server security and process control
• Implemented and documented proactive monitoring scripts for production databases.
• Develop the reports for business users using Crystal Reports.

Environment: SQL Server 2005/2000, Visual studio.net, Windows 2003/2000 server, HP net server LP1000r servers, Crystal Report 8.0.

Confidential, Benton Harbor, MI

SQL Server DBA

Responsibilities:

• Importing and Exporting of the data using DTS routines that extract, transform, and load data from heterogeneous sources.
• Administered Backup and Recovery.
• Monitor production Server activity.
• Develop MS SQL Server Log Shipping plans Disaster recovery plans and apply on production servers.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Resolving locking and blocking issues.
• Implemented change control.
• Enhanced performance by reviewing disk configuration and storage allocation.
• Reviewed third party tool (Idera’s) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Monitored SQL Server logs, Application logs and analyzed the logs.
• Documented disaster recovery plans and participated disaster recovery drills.
• Conducting the root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Wrote, Tested and Documented Program code and implemented program.
• Implemented OLAP cubes with MS Analysis Services

Environment: SQL Server 2005/2000, Windows 2003/2000 advance server, Dell power edge 6650 database server.

Confidential, Lansing, MI

SQL Server DBA

Responsibilities:

• Created logical and physical databases for the production development and testing servers as per the end-user specification.
• Responsible for Query optimization and Performance tuning.
• Implemented database mirroring as a part of disaster recovery plan.
• Used SSRS in creating the reports about the database administration.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Created entity relational diagrams while designing the databases in the SQL server according to the end-user specification.
• Setup profiler traces for slow running queries & analyze load file through query tuning wizard
• Automated various Database maintenance plans used the DTS packages and SSIS in SQL server.
• Implemented transactional replication model and involved in maintenance of the replication.
• Implemented Backup and restore in SQL Server 2005.
• Maintained multiple instances SQL Servers with maximum availability
• Performed database administrative job of Security & Backup/Recovery.

Environment: MS SQL Server 2005/2000 Enterprise Edition, MS Windows Server 2003/2000.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Install SQL Server on Windows 2000 Advance Server.
• Involved in entire life cycle including database Design, Development, Testing, Optimizing, deploying on development and production servers..
• Creating and managing schema objects such as Tables, Views, Indexes, Procedures, Clusters, Triggers and maintaining referential integrity.
• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee’s requirement and generating records between front End and back end. .
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Checks, Update Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Setup, configure and administer Snapshot and Transactional Replication on MS SQL Servers.
• Experience with MS SQL Server Log Shipping.
• Responsible for General Database Administration, Query Performance tuning.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.

Environment: MS SQL Server 2000/7.0, T-SQL, DTS, Windows 2003/2000 Advanced Servers and Crystal reports 8.0.