SUMMARY:

• 7 years of Database Administration, Data Architect and Development experience on MS SQL Server 2008 R2/2008/2005/2000/7.0 in Very Large Data bases.
• Data base manipulation Using VB.Net
• Managing SSIS Packages using C and VB.Net
• 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.
• 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.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, Set up different topologies in replication, Log shipping and mirroring.
• Extensively Worked on Transactional Replication and Snapshot Replication.
• 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.
• 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.
• Extensively worked on new concepts in SQL server 2008 like TDE, Data and Backup compression.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2000/2003.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Worked on configuring SQL Server with minimum privileged access.
• 7 Years SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• Expert in extracting from different sources like Oracle,SQL server, excel etc. transforming and loading data using transformation services like data transformation services like Batch processes , Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Extensively worked on SSRS building various types of reports and ad-hoc models.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• 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.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Extensive experience in Capacity Planning, Disaster Recovery Planning, Troubleshooting, Security Management, Backup and Restore Procedures.
• Used third party tools like Idera, Litespeed, Redgate, Veritas net backup.
• 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 knowledge on new concepts of 2008 like PowerShell, 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.
• 24 X 7 Production Database on Call Support
• Microsoft Certified Technology Specialist MCTS

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

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.
• Data migration from different sources like Oracle,Excel,Flat files to different destination using many transformations and error handling
• 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 Oracle, Flat file, Excel and heterogeneous data sources to SQL Server using SQL Server Integration Services SSIS Packages.
• Data Manipulation Using VB.Net
• Scripting SSIS packages with VB.Net
• 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.
• Worked on designing cubes and making partitions and did MDX queries

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

Confidential

SQL Server DBA

Responsibilities:

• Administering and maintaining large SQL Server 2008, 2005 and 2000 databases with more than 100 million records in individual tables using SQL server management studio
• Table Partitioning for existing and new application databases.
• Developing Reports using SQL Reporting Services like drilldown, drill through, parameterized reports,Tabular,matrix
• Data Analysis and BI Reports against OLAP/MDX Data cubes using SSRS.
• Disaster Recovery planning and implementation Database mirroring, Log shipping, Active Passive clustering
• Involved in installations, releases, and change control systems.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• VB.Net usage in SSIS
• Data modification using VB.Net
• Supporting production issues during work and after hours as required.
• Monitoring SQL Services using MOM, SQL Sentry.
• Backups and Restore using Lite speed for SQL Server
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views DMV
• Database Design and maintenance for trading data services and collaboration services for users of financial community traders, bankers, hedge fund managers
• Creation of tables, views, triggers, stored procedures and functions using SQL Structured Query Language and T-SQL Transact-SQL .
• Using SQL Server Service Broker to create async. message based database update services.
• Maintaining database security and application security framework using security matrix, windows based group memberships and database roles.
• Extensively using XML for input and export operations.
• Using TFS for version control of Database code.
• Implemented Database Replication Merge and Transactional for Call Center Database on SQL Server 2005.
• Upgraded DTS to SSIS Packages, deployed SSIS packages from Dev to Prod, Created Deployment utilities ,created Configuration files XML ,Created Completed Complex SSIS packages for Data extraction and transformation using various new features like fuzzy lookup, fuzzy grouping, Sequence container, for loop container ,Merge troubleshooting package related issues and errors.
• Created and Implemented SSIS Packages for importing and exporting data to other data storage like Oracle,DB2,Excel,Flat file etc.
• Error handling ,Configuration, Deployment in SSIS projects
• Designed and built cubes using SSAS by using facts and dimensions

Environment: SQL Server 2008, SQL Server 2005, Windows server 2008, Windows server 2003, Transact-SQL, SQL Server Reporting Services, SQL Sentry, VMware

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Migrated 170 application and 49 servers from SQL SERVER 2000 to 2005 both in place and side by side.
• Used DTSXchange tool for migrating DTS packages to SSIS.
• Migrated packages from oracle and other Databases to other destination using Derived column, Data conversion, Conditional split, Lookup etc.
• 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.
• 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 Lite speed 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.
• Creating SSIS Packages using VB.Net Script
• 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.