SUMMARY

• 12+ years of experience in SQL Server Database Development / Administration/SSIS/SSRS using MS SQL Server Management Studio2016,2012,2008R2,2005, Enterprise Manager 2000.
• Expert in Database Migration from Older version to Latest Versions and also in Migrating from Heterogenous Environments
• Significant experience in SSIS in analyzing, designing and developing ETL processes for Data Warehousing and Data Migration projects.
• Expert with Database Administration (backup/recovery) methodologies and procedures on a Windows/SQL Server platform.
• As well as expert in Implementing Database Mirroring and Log shipping with SQL server 2014,2012, 2008 R2, 2005.
• Strong knowledge in implementing different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2014, 2012, SQL Server 2008R2, 2005 in OLTP environments.
• Very strong implementation of Confidential Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and Confidential office SharePoint Server 8 in SQL Server 2005/2008/2012/2014.
• Using SQL server reporting services (SSRS) delivering enterprise, Web - enabled reporting so create reports that draw content from a variety of data sources Proficiency in SSRS for reporting services, SSAS data cube and data ware house. Extracting, Transforming and Loading (ETL) data using SSIS, DTS Import/Export utility, BCP and DTS Packages.
• Experience in monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in data Integrity in order to ensure the quality of the data in database.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Created dimensions using SQL Server Analysis Services (SSAS).
• Experience in Supporting Large Databases, Troubleshooting and documenting root cause analysis.
• Experience in MS SQL Server performance tuning along with SQL Profiler, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checker using DBCC.
• Developing reports on SQL Server .Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in installing Service Packs, patches and hot fix for SQL Server and OS.
• Experience in installing and configuration of MS SQL Server and databases in clustered and un-clustered environments.
• Ensure the data validity, integrity etc. during the migration to production.
• Keep update with new feature, service pack, version, technology etc for SQL Database and Management.
• Ensure the Security of SQL Server, backup and its restoration regularly in order to keep the database free from any kind of missing, loss, inaccessibility.
• Experience in implementing Always on Availability Groups with SQL Server.
• Experience in writing Windows DOS scripts and Windows PowerShell scripts.
• Excellent Communication and inter personal skills when working with developers, project managers and application end-users.
• Self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working

TECHNICAL SKILLS

Operating Systems: Windows Server 2012/2008r2/2008.

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSISWeb Technologies XML, HTML, VBScript

GUI Tools: Visual Studio(VB), Visual Studio2012/2008

Languages: VB 6.0, VB.Net, T-SQL.Net Technologies C#,VB. NET, ASP.NET

Web Server: Internet Information Server

Databases: SQL Server 2014/2012/2008 R 2/2008/2005/2000

Version Tool: Visual Source Safe, Team Foundation Server 2012

Reporting Tools: Crystal Reports

OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL):

ETL Tool: SSIS

Third Party Tools: Lite speed, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Northville, MI

Database Architect

Responsibilities:

• Design Data mart Solution for Consolidation of multiple database servers located throughout USA
• Design Database migration Procedures (ETL) and Manage data migration Group
• Analyze data and database Changes and provide performance solutions
• Create Standards for Data driven database backup and maintenance process
• Work Closely with System Architect, Business team and Architect Business rules Engine which would validate the monthly incoming Data from multiple client systems like Oracle/IBM Netezza and generate Micro Strategy based report out of it for Marketing purpose.

Confidential

Senior Database Project Lead

Responsibilities:

• Maintain monthly client data load from heterogenous systems to SQL Server databases through SSIS Packages
• Create SSIS Packages,SQL objects like database,tables, stored Procedures etc.. for new clients for medical,pharmacy,member details for processing
• Analysis of data for capacity planning and also calculating data trends
• Managing security on Production and Development environments.
• Monitoring the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2014/2012/2008 R 2/2005/2000.
• Developed PowerShellscripts for the running all jobs on daily, weekly and monthly basis.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005/2008R2/2012.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring/Clustering.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implementing and testing the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.
• Root cause analysis for issue

Environment: Windows 2012/2008r2, MS SQL Server 2000/2005/2008/2012/2014 , T-SQL.

Confidential, Minneapolis, MN

Project Lead

Responsibilities:

• Database Administration of around 1200 MS SQL Servers
• Installation, configuration and upgrading of Confidential SQL Server.
• Establish and maintain sound backup and recovery policies and procedures.
• Database tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Database migration was done for database from Production to Development and vice versa.
• Performing routine DBA tasks like maintaining Database Space Utilization and troubleshooting the DB and solving the Incidents.
• Data file addition and Migration of database from one disk to another.
• Planning and implementing disaster recovery procedures to ensure minimal downtime and data loss
• Implementing and administering various Database mirroring, Clustering, Replication and Log shipping environments.
• Backing and Restoring of Databases

Environment: MS Sql Servers 2012/2008r2, Windows Server 2008 SP2Enterprise/Standard Edition

Confidential, East Brunswick, NJ

Project Lead

Responsibilities:

• Creating Cosmos scripts and creating the Cosmos jobs for executing the scripts and submit it through Powershell
• Monitoring/tuning the SQL Server using Performance Monitor.
• Recovery Point Objectives (RPO)and business’ Recovery Time Objectives (RTO)
• Troubleshooting SQL Server service outages as they occur, including after-hours and weekends
• Installation of SQL SERVER 2005, 2008 R2 & 2012.
• Upgrading database from SQL Server 2005 to SQL Server 2008R2, SQL Server 2008R2 to SQL Server 2012.
• SQL Database Migrations from SQL 2000 to SQL 2008/2012
• Implementing and administering various Database mirroring, Clustering, Replication and Log shipping environments.
• Perform routine DBA tasks like maintaining Database Space Utilization and troubleshooting the DB and solving the Incidents.
• Database Maintenance Plan jobs were written in order to monitor the log files and Data files of the production databases.
• Database migration was done for database from Production to Development and vice versa.
• Identifying and resolving Blocking and Deadlock issues by using Activity Monitor and Profiler.

Environment: MS Sql Servers, Windows Server 2008 SP2Enterprise/Standard Edition, COSMOS

Confidential

System Specialist

Responsibilities:

• Maintaining the jobs Schedules and Backup and Restoration of Databases.
• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Regular data consistency checks.
• Maintained high availability of database using Log shipping and mirroring
• Migration of databases between the servers
• Scheduled Alerts and Jobs Using SQL Server Agent.
• Identifying and Resolving Blocking related issues
• Configuring and monitoring Replication
• Monitoring SQL Server Performance and Activity
• Successfully migrated SQL Server 2000 databases to SQL Server 2005.
• Create a daily report for all production servers.
• Establish procedure to migrate databases, logins, and jobs to new environment servers.
• Data migration from Heterogenous environment to SQL Server

Environment: MS Sql Servers2008r 2/2008/2005/2000 , Windows Server 2003 Enterprise/Standard Edition

Confidential

Support Engineer

Responsibilities:

• Technologist role to provide technical support for Confidential course wares
• Identifying the Technical reviewers based on the courseware and coordinating on technical discussions and provide input for the same
• Handling and distributing the Keys for the Confidential products
• Updating on the latest technical features of Confidential products to the team

Confidential

Manager Technical

Responsibilities:

• Managing Technical Team of around 12
• Daily Team syncup and status update of the team members
• Providing Technical assistance for all team members.
• Consultation to the clients on SQL 2005/2008/Visual Studio 2008
• Handling Training for Corporate Clients like Infosys, Wipro, HP, CTS etc..
• Providing Technical assistance for corporate clients on SQL, .net issues
• Installation of SQL SERVER 2000,2005, 2008 R2 & 2012.
• Upgrading database from SQL Server 2000 to SQL Server 2005/2008R2,