SUMMARY

• Around 8 years of experience in Database Administration for Very large and complex databases in SQL Server 2008R2, 2008, 2005 and 2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Excellent understanding of SQL Server architecture and Database storage structure.
• Experience in implementing Business logic by using T - SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF).
• Well experience in analyzing Performance, Query optimization and tuning, creating Indexes, writing stored procedures.
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
• Solid experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive)
• Handful experience in installing SQL Server 2000, 2005, 2008 & 2008R2, applying service packs and patches on stand-alone and Cluster Environment and Configuring.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
• Proficient with Database Recovery models.
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Experience in SQL Server up gradation from SQL Server 2000 to SQL Server 2005 and (Side by Side and in place) in 32bit to 64 bit architecture.
• Experience in moving system databases and user databases when needed.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Having Extensive knowledge in Clustering at both Windows and SQL Server levels and maintenance.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL Lite Speed, Commvault for performance Fog light for alerting Idera.
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.
• Experience in Administrating Windows Server 2003\2008\2008R2.
• Having knowledge on Active Directory in Windows Server 2003 & 2008R2
• Configured IIS in Windows server 2003
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

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

Operating Systems: Windows 98/2000/2003/2008/ XP/VISTA/7

Databases: MS-SQL Server 2008 R 2/2008/2005/2000

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS).

Reporting Tools: SSRS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, Tennessee

Sr. SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
• Estimated data growth from past years history and allocated SAN Space. Managed gigantic databases across the multiple disks on SAN using the file groups.
• Databases migrated as backup restore and loaded table’s data using SSIS packages.
• Created backup strategies based on database size and scheduled Maintenance plans, automated DB refresh jobs in Test & Development environments.
• Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Configured Database Mirroring with high performance and high availability mode.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle, Teradata and SAS using third-party RDBMS driver tools.
• Involved in SQL Server Hardening.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving
• Used ETL packages to move logins and jobs from one server to another server.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Installed and configured SSRS. Deployed RDL files on report server and managed report’s security.
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), RAID levels.
• Responsible for SSIS, SSRS package executions and availability.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, Business Intelligence Development Studio - SSIS, SSRS, Performance Monitor

Confidential, Austin, TX

Sr. SQL SERVER DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008 R2 on Test, Development and Production Environments.
• Created Logins and Roles with appropriate Permissions.
• Implemented side by side Migration of databases from SQL Server 2005 to SQL Server 2008.
• Usage of native tools like Data tuning advisor, Profiler and Activity monitor for performance analysis.
• Worked with SQL Server 2008 new MERGE statement.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003.
• Install, migrate SQL Server database and schemas into a physical and Virtual Machine environment.
• Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection and Compressed Backups.
• Migrated DTS packages to SSIS packages and maintained the archival data
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
• Monitoring SQL server performance using profiler for identifying performance issues and deadlocks.
• Create and Maintaining Database Maintenance Tasks, including Database Consistency Check, Re-Index Update Statistics and Backups.
• Analyzing and Modifying Stored Procedures to improve execution process.
• Identifying and Resolving Blocking Processes.
• Create and Maintaining Databases across Development and Production Instances.
• Performing Database Refresh from Production to Test, in part of monthly activities.
• Analyzing and Monitoring Disk Space Issues, on Test and Production Servers.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential, AZ

SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2008, 2008 R2 active-passive clustering on Windows 2008 Operating system with consolidated environment of three SQL server versions 2008/2005 and 2000.
• Involved and set up of SQL Server 2008 Mirroring on production servers.
• Involved in Migration of the Server SQL Server, SQL Server and DTS to SSIS, and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
• Maintained servers with multiple instance of SQL Server 2000, 2005 and 2008 with 24 CPU having 100 GB Memory.
• Configured Mirroring with Transaction Replication with principle and mirror at publisher.
• Implemented Snapshot, Transactional, and Performed mirroring as Disaster Recovery Solutions.
• Transactional replication, adding articles, and configuring with Mirroring.
• Involved developing and implementing jobs for SQL server, and involved in various production releases.
• Configured the RAID levels for data files, log files and TempDB at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers and Online indexing.
• Responsible for transferring packages using SSIS and transferring SQL Server Objects from QA to Production Using SSIS Packages.
• Deployed Reports on Report Server.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shooting SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
• Planned the Complete backing up of Database and Restoring the Database from Disaster Recovery.
• 24 X 7 Production Database on Call Support

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.