SUMMARY

• 8 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2008/2008 R2/2012/2014 and SQL Server 2005/ 2000/7.0.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Worked on SQL Server 2012 migration from SQL Server 2008 and 2008R2.
• Extensively worked on Data and Backup compression in SQL Server 2008.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience in implementing DISASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication (Snap Shot and Transactional with Updatable Subscriptions).
• Implemented HIGH AVAILABLITY concepts like ALWAYSON Failover Cluster Instances, ALWAYSON Availability groups for SQL Server 2012 environments.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience working on migrating to SQL Server 2008 R2 from SQL server 2000 and 2005.
• Experience in designing, developing and maintenance of databases in MS Access
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expert in MS SQL Server BI suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in scheduling jobs using tools like Tidal and Performance monitoring using Idera SQL Diagnostic Manager.
• Data modeling Experience like Physical data modeling and logical by using ERWIN.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in creating the MDX cubes and dimensions when working on OLAP databases.
• Developed and Executed the MDX queries on cubes to get the information.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using SS Analysis Services.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Implemented the 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.
• Experience in using DMV and dynamic management functions (DMF) for finding out long running queries.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Administering SQL Server High Availability.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• 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.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment.
• Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008/2008 R2.
• Experience in analysis, development and deploying of windows application, web services and window services in Microsoft Visual Studio .Net IDE using C#.Net 1.1, C# .Net 2.0, VB.Net, ASP.NET, ADO.NET and SQL Server.
• Followed the Lean methodologies while Designing and developing the Software Development Life Cycle.
• Worked on call 24/7 Support on weekly basis.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000/7.0

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

Business Intelligence Tools: SQL Server Integration Services (SSIS), Data transformation services (DTS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

Operating Systems: Windows 2000 Advanced Server, Windows 2003/2008/2008 R2 Server, Windows 95/98/XP /Vista/7

Reporting Tools: SQL Server Reporting Services

Languages: T-SQL, C/C++,C#, Java script, VB.Net

Technologies: ASP.NET 1.1, ASP.NET 2.0, VB.NET, C#.NET, Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Texas

MS SQL Server DBA

Responsibilities:

• Experience in installation, configuration, and Up gradation of 2008R2 servers to SQL Server 2014.
• Involved in supporting Multi node Cluster environment in production having databases of size 3 to 10TB.
• Experience in using SQL SERVER ALWAYSON (Enterprise Edition) feature to set up a redundant application environment.
• Expertise in Server failure issues like dealing cluster failover issues, finding out root cause for failovers by analyzing the dumps and configuration, taking precautionary steps to follow for server failures and handling server failures by bringing back the server online.
• Implemented Automating the Replication Tear Down/ Rebuilt by running them in the Power shell.
• Involved in Setting up Environments For all the PROD, Pre-Prod, STAGE, DEV and QA Environments with A Detailed Analysis of Project requirements(RAM and CPU).
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Database Design -reviewing\approving database designs before moving to production
• Database Code - reviewing\approving database code before moving to production.
• Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load. Work with Tech services Database administration as needed.
• SQL RAP- With help of Microsoft. F.E a Risk Access Program Analysis was Conducted to know Server Health checks.
• Attended Many SQL Workshops Conducted by Calif. State Government and Microsoft on Topics related to Performance Tuning, Server Health Checks.
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Work with Tech services Database administration as needed.
• Involved In Quick Projects right from Gathering Business Requirements to Go-Live Date
• Identify deadlock, blocking scenarios and Perform Re-indexing and Index defrag operations for the maintenance of large tables to resolve performance issues
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis
• Auditing of database for user transactions, login and database action and in removing orphaned users.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Environment: MS SQL Server 2012/08R2/08/05,Windows 2008/2003 Server,, Foot Print, Total View, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008,.NET, SQL RAP,SCOM 2012

Confidential, New York

MS SQL Server DBA

Responsibilities:

• Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.
• SQL Server 2005/2008 Production Database Administration.
• Installed and configured SQL Server 2005/2008R2.
• Worked on call support 24/7 and solved many Incident Tickets.
• Hands on experience in Performance issues and troubleshooting database issues.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Created and Maintained jobs, alerts and Maintenance plans.
• Worked in Active passive and Active cluster environment.
• Worked in Huge Transactional, Merge Replication environment.
• Extensively worked to implement Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.
• Worked to implement Asynchronous mode for Database mirroring in Staging Environment.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• .Used Online Indexing and online Restoring in SQL 2005.
• Created a new Reporting server in SQL SERVER 2005 environment which is being tested.
• Tested on Test environment with new stored procedures developed by Developers and applied on Production through Change management.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
• Configured and maintained Database Mirroring and CTE.
• Implemented new topics like CLR integration on Development server.
• Maintained the database consistency with DBCC at regular intervals.
• Maximum performance and uptime in production environment.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Documentation for steps need to be taken while upgrading the SQL server 2005 to SQL server 2008.

Environment: SQL Server 2005/2008/2008 R2, Windows 2003, QNXT, Care Advance, Biz Talk, Crystal Reports, SSRS, SSIS, Visual Basic, .NET, ADP Pay Roll.

Confidential, Connecticut

MS SQL Server DBA

Responsibilities:

• Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management. Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.
• Experience on Import / Export using DTS and BCP utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
• 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.

Environment: MS SQL Server 2000/2005/2008 , MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

Confidential, Florida

MS SQL server Developer/DBA

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Created and optimized SSIS packages for data flow between SQL Servers.
• Extensively used SSIS and DTS packages for Data Archiving.
• Extensively worked on Extracting, Transforming and Loading(ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Installed, configured and maintained transactional Replication Server.
• Configured Different RAID Levels
• Checking Database Health by using DBCC Commands and DMV.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created Triggers to enforce data and referential integrity.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Environment: SQL Server 2000/2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management

Confidential

Jr. MS SQL server Developer/DBA

Responsibilities:

• Involvement in the Design and Development of Database.
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance
• Monitoring Log shipping/Replication and trouble shooting of errors
• Security issues related to logins database users and application roles and linked Servers.
• Performance Tuning of SQL 7.0
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Backup and Restoration of data/database.
• Involvement in Development and Implementation
• Designing the database
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Security issues related to logins database users and application roles and linked Servers.
• Timely completion of activities for database backup, restoration and health check of databases.
• Involved in trouble shooting and fine-tuning of databases
• Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases. Troubleshooting ODBC and OLEDB issues between the application and the server.
• Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL SERVER 2000, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.