SUMMARY

• 8+ years of Database Administration, Data Architect and Development experience on MS SQL Server 2008 R 2/ 2008/2005/2000/7.0 in Very Large Data bases.
• Expertise in server configuration and maintenance with outstanding troubleshooting capabilities.
• Extensively worked on new concepts in SQL server 2008 like TDE, Data and Backup compression.
• Extensively worked on Transactional Replication and Snapshot Replication.
• Extensive experience in Capacity Planning, Disaster Recovery Planning, Troubleshooting, Security Management, Backup and Restore Procedures.
• Expertise in setting up Active/Passive and Active/Active Clusters for High availability.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2000/2003.
• Expertise and Interest include Administration, Database Design, Performance Analysis, configuring more than 2GB ram, highly transactional servers and Production Support for Large (VLDB) and Complex Databases.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try - catch blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, set up different topologies in replication, Log shipping and mirroring.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Created Linked Servers between SQL server 7 and SQL server 2008, SQL Server 2000 & Oracle 9i and 10g. Also created DTS package to data transfer between the two environments.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• 24 X 7 Production Database on Call Support
• Having Experience on Data center servers and handling 1.4 TB databases.
• Used third party tools like Idera, Litespeed, Red gate, Veritas net backup.
• Good knowledge on concepts like Policy based management, Resource Governor etc.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Strong experience in mentoring team members and writing documentation.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Exchange 2003, Linux, Unix.

Databases: MS SQL Server 2008/2005/2000/7.0 , MYSQL, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Data Modeling Tools: Erwin, Red gate, Lite speed, fog lite.

Languages: T-SQL, C/C++, Java, PERL, java script, Visual Studio2005/2003, XML, HTML, ASP.NET, VB.Net.

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• 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.
• 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.
• 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 the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• 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.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Windows 2003 Server, MS Visual Source Safe, IIS 7.5, XML.

Confidential, Branchville, NJ

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Maintained Production and Test Database Environment in SQL server 2008R 2/2008/2005.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, TSQL

Confidential, Dallas,TX

SQL Server Production DBA/ Developer

Responsibilities:

• Migrated 170 application and 49 servers from SQL SERVER both in place and side by side.
• Used DTSXchange tool for migrating DTS packages to SSIS.
• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2000 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in data migration and cleaning using ETL tools like Informatica.
• Implemented the new SQL Server 2005 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.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Experience in Database security and integrity planning.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Used VB.NET code in script Task for developing SSIS packages.
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency 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.
• Used log shipping for synchronization of databases.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Managing the VERITAS net backups and Litespeed backup.
• Hands on experience in trouble shooting database issues.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Used SQL server Reporting Services (SSRS) to create reports.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2008/05/00, Windows 2003, MS SQL Server 2000/2005, Oracle, .net, VB and ASP, LiteSpeed, MS Visio.

Confidential

SQL Server Developer/ SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2000.
• Involved in Database designing, Logical and Physical Data modeling using Erwin.
• Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Performed query tuning and reduced response time by 60%
• Managed Disk space, memory and User connections.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Monitored SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Experience on Import / Export using DTS and BCP utility.

Environment: MS SQL server 2000, Windows Server 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler.

Confidential

SQL Developer

Responsibilities:

• Soundknowledge Stored Procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Understanding the environment and tables and business logic.
• Understanding the user requirements and creating the logics and scripts
• Implementing the database objects like stored procedures, Functions and Triggers.
• Debugging and fixing the bugs.
• Worked to create Software Requirement Specification (SRS) document.
• Developed and coded applications in T-SQL.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Created the DTS packages to load the data file excel files into SQL table.
• Designing the scenarios and process flow using UML.
• Preparation of Entity Relationship diagrams and data flow diagrams.

Environment: TSQL, MS SQL SERVER 2000, ENTERPRISE MANAGER, VB.NET, WINDOWS SERVER 2003.