SUMMARY

• 7+ years of experience as Database Administrator, Architect and Developer in Production, Development and Testing Environments.
• 24/7 On Call Support for Production server
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments with single and Multi Instances.
• Strong working knowledge with 32 and 64 bit Windows 2000/2003/2008 servers.
• Experience in migrating teh databases from SQL Server 2000 to SQL Server 2005/2008.
• Extensive experience in Upgrading SQL Instances using Side by Side and In-place Upgrade.
• Experience in scheduling Backups, Restore and Maintenance plans using Native and Third-party tools (Lite Speed)
• Experienced in using different Recovery models Simple, Full and Bulk-logged depending on Application requirement.
• Experienced in high availability solutions with SQL Server Failover Clustering, Database Mirroring in (Synchronous and Asynchronous modes).
• Experienced in implementing Log shipping and Replication (Snapshot, Transactional and Merge Replications)
• Experienced in planning and implementation of Storage Area Network (SAN) for Clustering in Active-Active/Active-Passive Environments.
• Experienced in Log Shipping with single and multi stand by Databases with scripts and Tools (Lite speed)
• Experienced in Installing, Configuring, Developing and Deploying SSRS using local, scale out and scale up Topologies.
• Experience in Designing, Developing, Testing and Deploying SSIS packages.
• Experience in creating and automating jobs, alerts, SQL Mail Agent and SSIS packages in SQL Server.
• Extensively worked in Designing, processing and Administration of cubes using SSAS.
• Experience in analyzing execution plan, me/O statistics, index tuning for SQL queries.
• Good skills in optimizing teh performance of teh database and running Database Consistency Check scripts for databases.
• Creating Linked Servers for OLEDB Databases.
• Extensive experience with data modeling, logical and physical database design.
• Experience with establishing and maintaining security integrity controls.
• Solid experience with creating alerts, schema management, database reorganization, data loading.
• Extensive experience in controlling teh User Privileges, Monitoring teh Security and Audit issues as per SOX Standards.
• Experience in Performance Tuning Query Optimization, Client/Server Connectivity, and Database consistency checks using DBBC utilities.
• Worked in development environment, with knowledge of Query estimation, Index tuning wizard and database Optimization techniques.
• Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Proficient in server Capacity Planning in clustered, non-clustered and SAN environment.
• Implementing SQL server best practices and improvising server and instance consolidation, understanding of RAID-1, RAID-5 implementation for highly OLTP environment.
• Implemented Third party tools Litespeed, IDERA SQL compliance, SQL Diagnostic manager, SQL solutions deadlock detector, Redgate SQL Compare for schema comparison, SpotLight performance monitoring and performance improvement.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

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

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

Databases: MS-SQL Server 6.5/7.0/2000/2005/2008/2012, MS Access

ETL Tools: Data Transformation Services, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

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

Third party Tools: Erwin, Visio, SQL DB Control, Red gate, Lite Speed, Idera, Quest, SQL Solutions Etc.

PROFESSIONAL EXPERIENCE

Confidential, MD

SQL Server DBA, Senior Advisor

Responsibilities:

• Responsible for installation and maintenance of all teh SQL Server 2005/ 2008 R2 servers with teh design, document, development, enhancement and support of MS SQL Server databases.
• Involved in Architectural design for teh databases and database tables and capacity planning.
• Responsible to assign permission to user(s), role(s), and object. Support column level permission and Administrate security for server’s logins (Windows and SQL Accounts).
• Involved in setting up teh SQL Server Integration Services (SSIS) and SQL Data Transformation Services (DTS) for data migration and Extracting and Transforming data between different servers.
• Implementing and administrating Transactional replication as disaster recovery solution
• Configure, maintain and troubleshoot replication for databases as large as 40 TB.
• Implemented methodologies such as making changes to teh distributor properties, subscription stream parameters etc., to improve teh latency of heavily replicated articles.
• Prepared scripts for manual configuration replication both by snapshot and by database refresh.
• Troubleshooting log reader latency issues, distributor latency issues, data consistency issues while replicating deferred updates.
• Prepare and notify teh management about daily status of replication and latency
• Taking schema only backups and refresh teh databases with schema, compare schema on teh databases and finding out teh abrupt changes
• Developed new database Maintenance plans which involves Create statistics, Update statistics, rebuilding teh Indexes, Database Integrity checks for all teh newly built SQL Server 2008 R2 servers.
• Performed all aspect of database administration, including backup, recovery and Log Shipping for SQL 2008 R2.
• Identifying and analyzing deadlocks investigate teh statements and provide suggestions to developers.
• Design and schedule jobs regarding reclaiming space in a timely manner for better performance of teh servers.
• Monitor teh indexes fragmentation status and schedule teh reorganize and teh rebuild jobs accordingly.
• Experience in scheduling Backups, Restore and Maintenance plans using Native & Third-party tools (Lite Speed)
• Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
• Rebuilding teh Indexes at regular intervals for better performance.
• Tuned SQL queries and Stored procedures using SQL Profiler.
• Experienced in implemented Log shipping and Replication (Snapshot, Transactional and Merge Replications)
• Involved in teh performance fix deployments, new code deployments, Migration of teh servers, Rebuilding databases.
• Provided on-call support for performance activities such as data purging and operations processing and maintenance tasks.
• Work with Microsoft support to troubleshoot disk related performance issues and unidentified abrupt system shutdown issues.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Backing up master & system databases and restoring them when necessary.
• Verify backups and error logs on teh servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Spontaneously responding to teh tickets assigned to me and fixing any database issues and working on projects that me have been assigned to as a resource from teh Database Management team.

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2) on Test, Development and Production Environments.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Experience working with TSM Backups and Restore.
• Disaster Recovery Planning, Testing and Analyzing and continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler
• Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Worked with DTS Packages to load data into Data Warehousing System.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve teh performance of database access.
• Extensively worked on performance issues like Update statistics and Autostats
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized teh database server usingDMV’s and DMF’sand performed acode reviewandtuningfor teh best performance of teh application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Mentored team members to optimize SQL Queries.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008 on teh server and client machines, provide connections and manage databases.
• Create and maintain various databases for Production, Development Servers using MS SQL Server 2005/2008.
• Planning teh location of data, indexes, and Transaction log files on teh disk.
• Use of DBCC Utilities to maintain teh consistency and integrity of each database in teh production server.
• Conducted root cause analysis of application availability and narrow down teh issues related to coding practices, database bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Experience in memory configuration for SQL server on 32-bit boxes
• Tuning teh Production server to get teh performance improvement.
• Running Index tuning wizard for optimal query performance.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Experience working with SQL Solutions tool in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Monitoring SQL Server LOGS, Application logs and analyzing teh logs.
• Providing 24*7 support to SQL application developers in implementing teh applications on production server.
• Reorganizing or Rebuilding Indexes based on teh Index fragmentation
• Maintaining both DEVELOPMENT and PRODUCTION Servers in sync.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created teh SSIS packages for executing teh required tasks. Created teh Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases.

Environment: MS SQL Server 2005, MS SQL server 2008, Windows 2000/2003/2008 server, IIS Server 5.0, SSIS, Reporting Services, XML.

Confidential, Milwaukee, WI

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005)/(2008), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• Wrote teh packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks.
• Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for teh Application.
• Extensive testing on teh Performance of teh Stored Procedures.

Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY ANALYSER, C#, WINOWS SERVER 2003/2008, SSAS.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on teh SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per teh developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Involved in Migration from SQL Server 2000 to 2005.
• Created Database Diagrams using ERWin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in teh creation of cubes in teh MS SQL Analysis Services.
• Restore Development and Staging databases from production backups as per teh requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run teh jobs manually in case of failure depending upon teh necessity.
• Prepare daily report on teh job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003 servers, Outlook Express, .NET, MS Access.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for teh project.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing teh physical design for database.
• Writing complex Stored Procedures to meet teh business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write teh data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.