Chronological

Summary of Experience

Confidential

Senior Database Administrator

• Worked as a Production DBA supporting OLTP and DSS systems in Physical and Virtual environments.
• Installed, configured and Deployed SQL Server 2012 in Production Environment
• Worked on SQL Server 2012, 2008 R2, 2008, 2005 and SQL Server 2000 in production
• As a Production support DBA responsible for managing production, development and QA environments for OLTP and Decision Support systems.
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments for SQL Server
• Managed Production environments and participated in on call 24/7 support
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2012/2008 R2
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Worked on EMC storage for configuring storage and managing partitions on storage
• Configured EMC for storage on most of the SQL Databases
• Installed and configured Always On Availability group on SQL Server 2012
• Worked on setting up domains, Active Directory and Exchange for Administration
• Participated in Build and Releases and provided Level I support
• Worked extensively with developers in resolving slow running queries and resolving performance issues
• Extensive use of SQL Server DMV's for resolving performance issues
• Exclusive Knowledge of Database security implementing Windows and SQL Authentication.
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
• Worked on Setting up Clusters with MSCS and VMware
• Used Microsoft MSCS and VMware for Clustering and HA
• Implemented Database Mirroring on SQL Server 2008 R2 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008 R2.
• Created strong Backup policy and process by establishing FULL,DIFF and Tran Log backup
• Installed configured and managed Log Shipping for Disaster Recovery
• Implemented Transactional Replication for Reporting
• Manager Publisher, Distributor , subscriber and all articles and subscriptions for replication
• Used SQL Perfmon, Profiler, Activity Monitor and Query tuning advisor for finding performance bottlenecks
• Actively worked on creating SISS packages, deploying them on various environments
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.

Environment: MS SQL Server 2012/ 2008 R2/2005/2000, Oracle, Windows 2000/2003/2008R2, VERITAS Net Backup, TSQL, Litespeed, IDERA, Clustering, Mirroring, Log Shipping, Hyper-V, SQL Job Manager, TSM, Always On, SSIS, SSRS, T-SQL, Microsoft Visual SourceSafe 6.0, ERWIN 7/8

Confidential

Sr. MS SQL Server DBA

Roles and Responsibilities:

• Worked extensively on Government projects as a Senior SQl Server DBA.
• Worked with Government and Department Legacy and current systems
• As a Production support DBA responsible for managing production, development and QA environments for OLTP and Decision Support systems.
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments for SQL Server
• Managed Production environments and participated in on call 24/7 support
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2012/2008 R2
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2012/2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
• Exclusive Knowledge of Database security implementing Windows and SQL Authentication.
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008 R2.
• Worked on creating SSAS cubes
• Worked on managing SQL Server Analysis Services SSAS projects
• Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle and also Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008 R2/2005/2000, Oracle, Windows 2000/2003/2008R2, Clustering, Mirroring, Log Shipping, SSIS, SSRS, Visual Source Safe, Change Management.

Confidential

Sr. MS SQL Server DBA

Roles and Responsibilities:

• 24/7 Production support for SQL server environment.
• Installing and configuring of SQL Server 2008 and 2008R2.
• Fine tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Configured and maintained database mirroring for high availability.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views DMV's .
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active Active and Active Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Performed DBCC utilities and fixed data corruption in User databases.
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
• Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Strong in developing, deploying packages using SSIS from OLTP to OLAP
• worked on developing small time application in .NET and backend as MS Access
• Worked on Visual Studio 2010 using C , ASP.NET and MS Access
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers maintained Referential Integrity.
• Performed Server Application fine-tuning troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Worked on more than 10 Data modeling projects and generated E-R Diagram
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV's, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
• Maintained multiple instances SQL Servers with maximum availability.

Environment: MS SQL Server 2008 R2/2005/2000, Oracle, Windows 2000/2003/2008R2, VERITAS Net Backup, TSQL, Litespeed, SSIS, SSAS, SSRS

Confidential

MS SQL Server DBA

Roles and Responsibilities:

• Production support for SQL server environment.
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Developed system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication
• Involved in Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment
• Managed SQL Servers in 32/64 bit Clustered environments
• Successfully implemented Database Mirroring in SQL Server 2005/2008/2008 R2 for high availability.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Created extensive stored procedure, trigger, view and functions
• Monitored SQL Server for performance bottlenecks
• Tuned stored procedures for maximum output
• Involved in tuning the database and server performance and worked with profiler to trace and tune the database using index tuning wizard
• Administrated the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation, and the impact on the system performance.
• Analyzed potential problems Response delay, locking, server downtime, etc to avoid and optimize
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Created pro active scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, db size and service status monitoring
• Created the standard documents for Disaster recovery testing and implemented them.
• Involved in 24x7 on call support

Environment: Windows XP, T-SQL, MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, Crystal Report, SharePoint 2007, MS SQL Server Reporting Services 2005

Confidential

MS SQL Server DBA

Roles and Responsibilities:

• Production support for SQL server environment.
• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2000 and 2005 environments.
• Involved in Migration from SQL 2000 to SQL 2005.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Used Data Transformation Services DTS an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services SSIS as a part top transfer logins from SQL server 2000 to 2005 and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Migrated MY-SQL 4.1.0 databases to SQL Server 2005 and 2008
• Used DBCC commands to check physical and logical consistency of the databases
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler
• Involved in coding complex stored procedures and debugging for optimum performance
• Implemented Backup and restore in SQL Server using Third party tool Idera SQL safe.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2005 , MS SQL Server Reporting service 2005, MS SQL Server Integration service 2005, T-SQL,DTS, C , .Net, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Crystal Reports

Confidential

MS SQL Server DBA

Roles and Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Involved in Data Migration from SQL 2000 to SQL 2005.
• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Used DTS and SQL server integration services as part of creating the jobs on the server.
• Configuration and Administration of Windows 2000 and Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
• Managed the use of disk space, memory and connections.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained log shipping for disaster recovery.
• Performed DBCC utilities and fixed data corruption in application databases.
• Involved in coding complex stored procedures and debugging for optimum performance
• Involved with the integration of SQL Server on a Storage Area Network SAN platform.
• Managed replication issues during DDL changes over data in Production development servers.
• Implemented Backup and restore in SQL Server 2005.
• Maintained multiple instances SQL Servers with maximum availability.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential

MS SQL Server DBA

Roles and Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Implementing Backups and Restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/dbroles and permission on various database objects.
• Extensively Developed SQL scripts for maintaining administration tasks.
• 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 consistent data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Performed backup/restore, created database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Involved in Performance tuning, query-inventory, analysis and optimization.

Environment: MS SQL Server 2000/2005, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer