SUMMARY

• Over 8+ Years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/2005 and 2008.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Implemented Side by Side Migration of MS SQL SERVER 2000/ .
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good knowledge about Client Server Architecture/Database Architecture/Server architecture and Administration Architecture.
• Worked extensively on Active - Passive Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication and Log shipping for SQL Server High Availability.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS for the instant analysis.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
• Expert in analyzing the execution plan and index management.
• Experience in using FOGLIGHT, SPOTLIGHT tools for tuning and for optimal performances of SQL SERVER.
• Explicitly used third party tools like Foglight, Spotlight and Performance Analysis tool.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans and Explicitly used COMMVAULT tool for backup jobs.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles (Securable and Permissions).
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables.
• Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
• Involved in all phases of the SDLC (software development life cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Server 2003,Server 2008

Databases: MS SQL Server 2008/2005/2000 , 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: IDERA Diagnostic Manager, Light speed, Foglight,Commvault.

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

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

PROFESSIONAL EXPERIENCE

Confidential, Medford, MA

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers.
• SQL SERVER 2008R2/ 2008/2005/2000 Production Environment.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on migration and maintenance of data using various utilities like EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Extensively used IDERA for performance monitoring tool.
• Applied Patches and Service packs to update different versions of MS SQL SERVER in Clustered and Standalone Environments.
• Worked on Resource Governor which is new feature on SQL 2008.
• Maintaining User account administration for Different domains.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• To set up SQL Server configuration settings.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, SSAS,VM ware, IDERA,EMBARCADERO, MS- Excel, SQL Mon

Confidential, Park Ridge, NJ

SQL SERVER DBA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER /2008 on Windows
• Migrated databases from SQL Server 2000 to SQL Server 2008 and documented the process with Pre-Migration and Post-Migration steps.
• Developed SSIS packages in importing data into slowly changing dimensions tables in the Data warehouse databases.
• SQL Server 2005 and SQL Server 2008 Failover Cluster Installation and Experience with Cluster Configuration in SAN environment.
• Applied Patches and Service packs to update different versions of MS SQL SERVER in Clustered and Standalone Environments.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2005.
• Scheduled regular BACKUP JOBS using COMMVAULT backup tool and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Snapshot, DMV’s, DMF’s.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used COMMVAULT backup tool with MS SQL SERVER 2005.
• Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Utilized Foglight for monitoring the deadlocks, blockings and windows level performance also.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Implemented SSL certificates for network level encryption for database security.
• Creating logins and mapping the user to roles by assigning permissions.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Maintaining User account administration for Different domains.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL SERVER 2000/2005/2008 , SSRS, VISUAL STUDIO 2005, WINDOWS SERVER 2008/2003,IIS,Foglight.

Confidential, Edison, NJ

SQL Server DBA

Responsibilities:

• SQL SERVER 2005/2000/2008 Production Environment.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005.
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• 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.
• Used log shipping for synchronization of databases
• Prepared Documentation for the Disaster Recovery plan. Worked in Active passive cluster environment.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually.
• 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.
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used lite speed backup with MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS) and SharePoint
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows bit, DTS, SSIS, Profiler, LiteSpeed.

Confidential, Nashville, Tennessee

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Using the Lite speed to take backups.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS
• Used Data Partitioning and Snapshot Isolation in SQL Server 2005/2008. Using log shipping for synchronization of database.
• Good experience in data modeling and metadata services.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, SSAS,VM ware, Litespeed, Spotlight, MS- Excel, SQL Mon

Confidential, Baltimore, MD

SQL ServerDBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2008/2005 on windows 2003/2008 on clustered environment.
• Workedon32 bit,64 bitclusteredenvironments.
• Performed Node Injectionfor the enhancements of hardware in the Clustered environment.
• Installedandconfiguredandmaintained failover clusteringforSQL SERVER 2005.
• Migrationof databases fromSQL Server 2000/2005toSQL Server 2005, 2008.
• Monitored Log shippingas high availability solution.
• ConfiguredServer Memoryfor maximumPerformanceand effective utilization.
• Monitoring SQL server performance usingprofilerto find performance anddeadlocks.
• Integrated Performance monitorandSQL tracesto have better graphical analysis to find system bottlenecks.
• Administered and maintained windows 2003 server based network of 40 servers.
• Implemented RAID1 and RAID5 on mission critical servers.
• Proficient in working knowledge of Clustering and SAN.
• UsedDynamic Management Views (DMV)for monitoring the performance of the server.
• Worked withIP MonTool by setting upalertsfor the Monitors of various SQL Servers.
• Performed Database Integrity Checks, updated Database Statistics and performedRe-indexing through Maintenance Planner.
• Maintaining the database consistency with DBCCat regular intervals.
• Creating SQL Server Loginsand assigning Roles and Authentication Modesas a part ofSecurity Policiesfor various categories ofUser Support.
• Created Maintenance Plansthat helped in effective disk utilization and index maintenance.
• Effectively managed disk space usingEMC toolfor Data base Backups.
• Created, Scheduled and monitoredSQL Server Jobs,making sure jobs run successfully every night.
• Extensively worked onProduction supportand involved in trouble shooting SQL servers in various levels.

Environment: Windows 2000/2003/2008 , MS SQL Server 2000/2005/2008 , Microsoft.NET, SSRS, SSIS, SSAS, MS Office Access 2003.

Confidential, Dallas-TX

SQL Developer/DBA

Responsibilities:

• SQL Server 2005/2000 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
• Established Maintenance Plans for Regular Backups and Index rebuilding.
• Expertise in Tuning Slow running queries using Profiler and Statistics IO by using different approaches like evaluating joins, indexes, updating Statistics and code modifications.
• Migrated DTS packages to SSIS packages and successfully implemented the Capacity planning for different servers.
• Configured more than 2 GB ram on 32 bit Environment.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Checked Database Health by using DBCC Commands and DMVS. Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Wrote scripts to extract data from database tables and write the data to text Files.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity, procedures and functions for business & data transactions with error handling.
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Created the documentation for issue diagnostics reports.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance.

Environment: Windows 2003, MS SQL Server 2000/2005, Oracle, .net, VB and ASP

Confidential, CT

SQL Server DBA/Developer

Responsibilities:

• Creating SQL User account using windows authentication and mixed mode and creating group and assigning appropriate permissions to those groups or users.
• Experience with accessing data from SQL Database using basic SQL Queries.
• Created and scheduled jobs to migrate database from one server to another server.
• Created DTS packages to maintain central repository. Extensively used different SQL 2000 DTS Tasks.
• Created Transactional replication on different servers.
• Performance tuning in Database level, T-SQL level and operating system level. Updated servers with the latest Patch.
• Created Replication in between the servers depends on the business requirements and architecture of the application.
• Created Fail over cluster environments, depends on the application and business requirements Active - passive clusters.
• Procedures, triggers and problems related to the privileges.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, SQL Profiler, Database Maintenance Plan and Data Transformation Services, T-SQL, Windows 2000 server.

Confidential 

SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2000.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring 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.
• Dropped and recreated the indexes on tables for performance improvements.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Created indexes to speed the execution of data retrieval queries and stored procedures.
• Experience in applying Service Packs at database and OS Level.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Worked on Fail over Clustering for SQL Server databases for mission critical applications.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000, ASP, Windows 2000.