SUMMARY

• Twelve years of experience in Database Administration, Architecture, Design, Implementation, Performance Tuning, Deployment, Development, Capacity Planning, Scaling & Support of Mission Critical MS SQL Servers 2012/2008 R 2/2008/2005/2000 /7 in Development, Production, Test, Replication, Cluster, QA and VLDB Environments.
• Installed, configured, maintained and monitored MS SQL Server 2012/2008 R 2/2008/2005/2000 /7.0 Versions in both Mission Critical, Clustered (Active/Passive and Active/Active), Stand - Alone, Hyper-V and VMware Environments.
• Implemented High Availability plans like Clustering, Log shipping & Database Mirroring.
• Improved the performance of the databases, SQL Servers, Windows Servers, applications and optimized the slow running queries.
• Performed Database Optimization, Server Optimization, Consolidation and Standardization.
• Performed Upgrades & Migration from SQL Server 2000 to SQL Server 2005/2008/2008 R2, SQL Server 2005 to SQL Server 2008/2008 R2, SQL Server 2008 to SQL Server 2008 R2 and SQL Server 2008 R2 to SQL Server 2012 in both 32 bit and 64 bit environments and resolved the issues.
• Performed Migrations from Oracle, DB2 and MYSQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 to Netezza.
• Designed and implemented OS Layout for SQL Server, OLTP Databases, Data-ware Houses (Kimball and Inmon), Data Marts, Data Mining and Reporting Servers.
• Designed, implemented & tested Archiving, Database Backups, Point in time Restores and Disaster Recovery Procedures.
• Resolved Database, Performance, Replication, Log-shipping, Database Mirroring, Connectivity, Security, Blocking and dead locking related Issues.
• Used ETL tools like DTS, SSIS and automated the collection of the data from various Data Sources, Data-cleansing and loading them into Staging, ODS and Data ware-houses.
• Performed Data Modeling, Conceptual, Logical and Physical database design using Erwin Tool.
• Implemented SQL Server 2012/2008 R2\2008\2005\2000 Best Practices, Management Data Warehouse, different types of Replication models like Snapshot, Merge and Transactional replication and monitored them.
• Created Reports using Microsoft Reporting Services (SSRS) and Crystal Reports.
• Experience in Resolving Tickets, Software Development Life Cycle (SDLC), SQL Server Memory Management, Incident Management, Change Management, Version Control, OLTP, OLAP, MS-DTC and fixing the database corruption.
• Used Tools like SQL Litespeed for backup-recovery and Spotlight for performance tuning.
• Performed Schema Management, Client/Server Connectivity, Database Rollouts, Load Testing, Load Balancing, Database consistency checks using DBCC Utilities.
• Resolved issues related to database performance, database capacity, Cluster, replication and migration.
• Used Performance Monitor/Profiler to resolve the Blocking, Dead Locks and Long Running Queries.
• Created Linked Servers, Maintenance Plans, Entity-Relationship Diagrams, Perl Scripts, VB Scripts and Power shell Scripts.
• Involved in the Design of Databases and database objects like Tables, Indexes, stored procedures and views.
• Created Logins, Users and controlled their permissions and access by using Server Roles, Database Roles and User defined Roles.
• Created Packages, Jobs and had set up the Database Mail and Alerts using the SQL Server Database Mail and SQL Mail.
• Configured and Maintained the Report Server and the Report Manager.
• Installed SQL Server 2005/2008/2008 R2/2012 Reporting Services in SharePoint integrated Mode and had done configurations on the MOSS box.
• Created Star Schemas, Snow Flake Schemas, Data Marts, Multi-Dimensional Cubes, OLAP Cubes and modified the cubes using Cube Designer.
• Detected SQL Injection and eliminated it.
• Wrote MDX expressions for cube calculations and KPIs.
• Prepared project documents like Change requests, Status reports, Issue tracking.
• Implemented Change Releases to Production.
• Implemented policies and procedures for ensuring the security and integrity of the SQL Server databases.
• Experience in Security management, auditing (Sarbanes-Oxley) and user access control on the databases and Servers.
• Created Databases, Tables, Views, and Stored Procedures in Netezza and optimized them.
• Created Users, Groups and Maintained the security of the users, Groups in Netezza.
• Performed Netezza backups and restored them.
• Provided 24X7 on call Production Support for the Applications and SQL Servers.

TECHNICAL SKILLS

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 /7.0 , MS Access, Oracle 9i/10g/11g/12c, Netezza 7.0.5/7.0/6.0.5 , Sybase, DB2, MySQL, SQL Azure, DB2 UDB.

Languages: T-SQL, PL/SQL, NZPLSQL, ASP.Net, VB.Net, C, C++, ColdFusion MX, XML, XSLT

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import, MS BI Dev Studio, SSAS, Client Network Utility, Server Network Utility, SQLCMD, SQLDIAG, SQL Server Configuration Manager, Service Broker, BCP, Database Engine Tuning Advisor, Replication Monitor, Report Services Configuration tool, T-SQL Debugger, Activity Monitor, Resource Governor, Performance Data Collector, Policy Based Management, Central Management Server, Compressed Backups, SQL Server Audit, Data Compression, Cube Designer, Dimension Designer, Mining Model Viewer, Master Data Services Configuration Manager, Master Data Manager

Web Servers: IIS 6/7, Web Logic, Sun One (Web Server 6.1)

Framework: .NET Framework 1.0/2.0/3.0/3.5/4.0/4.5

ETL Tools: DTS, SSIS, IBM Info Sphere DataStage, Abinitio, Informatica

Reporting Tools: SSRS, Crystal Reports, Report Designer, Report Builder, Report Manager, RSKeymgmt, RS, Model Designer, Hyperion, Congo’s 8 Business Intelligence, Dundas Chart for Reporting Services, ProClarity, LogiXML, mysqlreport, Power Pivot, Power View

Back UP Tools: Idera’s SQL Safe backup, Quest’s Litespeed, IBM’s Tivoli Storage Manager, Red Gates SQL Backup, RMAN

Change Management Tools: Idera’s SQL Change Manager, Quest’s Change Director, Embarcadero Change Manager

Cluster: Cluster Administrator, Veritas Cluster Server, Veritas Cluster Server Web-based Cluster management console(VCS MC)

Data Modeling Tools: Erwin Data Modeler, Erwin Data Model Validator, ER/Studio, MS Visio, Quest Toad Data Modeler, Sybase’s Power Designer

Performance Monitor Tools: Perfmon, SQL ultimate Performance Monitor, Foglight Performance Analysis, Spotlight, SQL Diagnostic Manager, SQLdiag, SQL Sentry 7.5, PAL,SQL Trace, SQL Nexus, dmv’s, Extended Events, Management Data Warehouse, phpMYAdmin, MySQL Tuning Primer Script, MySQLTuner, mytop, innotop

SharePoint: SharePoint Server 2013, SharePoint Server 2010, Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0, Office SharePoint Designer 2007, Power Pivot Gallery

Scripting: Power Shell 1/2/3, Shell Script, Java Script, VB Script

Other Tools: Visual Studio 2005/2008/2010/2012 , LINQ, Legato Networker, event viewer, FTP, SQL Server Migration Assistant for Oracle, MS-DTC, Visual Source Safe, Visual Studio Team System (VSTS), Team Foundation Server (TFS), Microsoft Baseline Security Analyzer(MBSA), WinSQL, Ultra Edit, Opsware, DB Artisan, NZADMIN 7.0/7.0.5,Active Directory, NTLM, Kerberos, Power BI

Operating System: Windows NT 2012/2008R 2/ 2008/2003/2000 /4.0/ XP/7, Unix, Wintel Server, Linux, Mac OS X, Windows Azure

Gaming: IGT Advantage 9.1, IGT SBX 4.1, EZPay 9.1, TableManager 9.1, Tournament Manager 2.0, Bravo, eMarker

VMware: vSphere Client 4.0/4.1/5.0/5.5

Netezza: TwinFin 3, Model 1000-3, Host Model x3650 M3, NPS 6.0.5.P2/7.0.P2/7.0.P5, 1000 DW Appliance, NZADMIN

Slot Systems: Oasis, CMS, LMS, Legacy

SAN: HSG80/EVA5000/EVA8000/AMS2500/HDS AMS2500(40 TB)/ VNX 5500/5700

Networking: NAS,DAS,LAN,WAN,TCP/IP, DNS, VPN, Intranet, Terminal Services

PROFESSIONAL EXPERIENCE

Confidential, Hagerstown, MD

Sr. SQL Server DBA/ Architect and Netezza Developer

Responsibilities:

• The project was to Creating, optimize and test the Databases, Tables, Views, and Stored Procedures. Applying Best Practices in writing the Stored Procedures. Provided Recommendations on the Stored Procedures. Took Netezza databases backups and restored them. Performed Database Migrations from MYSQL and DB2 to SQL Server 2012 and SQL Server 2012 to Netezza. Setup Always on Availability Groups on SQL Server 2012. Had Set Up SQL Server Clusters on active- active Node. Trouble-shooted and Deployed SSIS Packages. Created SSIS Packages and loaded the data into Netezza and SQL Server databases. Performed Database Maintenance in Netezza and SQL Server. Used Datastage to load the data into Netezza. Performed patch installations in Netezza. Created Reports using SSRS and scheduled them. Created SQL Server Disaster recovery plans and tested them. Created Cubes and wrote MDX Queries.

Environment: SQL Server 2012/2008R2/2008, SSIS, SSAS, SSRS, TwinFin 3, NPS 7.0.P5, 1000 DW Appliance, SharePoint Server 2013, RedGate SQL Monitor, RedGate SQL Admin Bundle

Confidential, Atlantic City, NJ

Sr. SQL Server DBA/ Architect and Netezza Admin

Responsibilities:

• The project was to resolve the performance problems for the Gaming (IGT) and Non-Gaming SQL Servers. The project Involves in designing a new OLTP Server and Implement the best practices. Responsibilities were to perform Monitoring, Performance Tuning, Troubleshooting the issues, Backup and Restores, provide High Availability, Security, Design specifications for the OLTP server, databases, Transactional Replication, Perform Auditing, Creating SSIS Packages and scheduling the Jobs, Perform Capacity Planning, Setting up Management Data Warehouse, Always on Availability Groups, Alerts and Notifications, Creating Disaster Recovery Plans and testing them. Creating Data warehouses, Loading the data into data warehouses and generating SSRS Reports, Creating, optimize and test the Databases, Tables, Views, and Stored Procedures. Applying Best Practices in writing the Stored Procedures. Providing Recommendations on the Stored Procedures. Taking Netezza databases backups and restoring them. Performed Database Migrations from MYSQL and DB2 to SQL Server 2008 R2 and SQL Server 2008 R2 to Netezza. Provide Support to applications like IGT(Advantage & SBX),Bravo, eMarker, Infogenesis Universal Desktop 4.3.1, RedRock, MGT, UltiPro, Bartech, SolarWinds, SharePoint, Labor Scheduler, BellDesk, AllStar, Fusion, Nagios, MDM, Scannet, NetPay, iTrack, Performance Management, Four Winds and CallCopy. Used Datastage to load the data into Netezza. Performing Netezza database Maintenance and patch installations.

Environment: SQL Server 2012/2008R 2/2008/2005/2000 , MS Visual Studio 2012/2010, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, C#, MS Visio, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management Data Warehouse, Windows Server 2003/2008/2008 R2/2012, Team Foundation Server, Unix, Power shell 2, Erwin, IIS 7.0, SQL Sentry 7.5, IGT 9.1, SBX 4.1, ezPay 9.1, Tournament Manager 2.0, Table Manager 9.1, TwinFin 3, NPS 6.0.5.P2/7.0.P2, 1000 DW Appliance, Cognos, UNICA Campaign 9.0.0.1 and Infogenesis POS, vSphere Client 5.0/5.5, Solar Winds, Microsoft Access 2010, Master Data Services Configuration Manager, Master Data Manager

Confidential, Boston, MA

Sr. SQL Server DBA/ Architect

Responsibilities:

• The project was to resolve the performance problems for their DXMark Servers. The project Involves in designing a new OLTP Server and create a data ware house and a reporting server. Responsibilities were to perform Monitoring, Performance Tuning, Troubleshooting the issues, Backup and Restores, provide High Availability, Security, Implementing Best practices, Design specifications for the OLTP server, databases, Transactional Replication. Provide Support to Marketing applications like DXMark. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R2/2008, MS Visual Studio 2008/2010, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, SQL Diagnostic Manager, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management Data Warehouse, Windows Server 2008, Team Foundation Server, Unix, Power shell 2, Erwin, IIS 7.0, DXMark, Foglight Performance Analysis for SQL Server, Spotlight on SQL Server Enterprise, ProClarity, SQL Compare 9.0, Citrix

Confidential, Wakefield, MA

Sr. SQL Server DBA/ Architect

Responsibilities:

• The project was to move the HLI servers from Bank of America to Confidential .The project Involves in laying the same Infrastructure at Confidential as it is in Bank of America, bring the HLI servers live and support Bank of America HLI Servers at Confidential . Responsibilities were to perform Monitoring, High Availability, Performance Tuning, Troubleshooting the issues, Security, Implementing Best practices, Backup and Restores. Provide Support to Campaigning applications like T1, Siebel Marketing, Siebel web client, Max, SelfScrub, OBIEE, Portfolio Reporting. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R 2/2008/2005/2000 , MS Visual Studio, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, SQL Diagnostic Manager, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management data warehouse, Windows Server 2008, Team Foundation Server, Unix, Power shell 2, Erwin, Tivolli Workload Scheduler, Data Integrator, T1 3, Siebel Marketing 7.7, Siebel web client 7.7, Max 2, SelfScrub 2, OBIEE 10.1.3.3.2 , Portfolio Reporting, Sun One (Web Server 6.1), AIX( App server webphere 6.1), 3DNS( Automatic Fail over Tool),IIS 6.0,Veritas Backup, Gnuwin 32,SSH tectia, ODBC for teradata, Terradata, SQL Assistant 12.0, Litespeed, Oracle Business Intelligence, Siebel 7.7,Teradata Client 13.10, SAS 9.2,EMC PowerPath, Emilex HBAnywhere, Arcsight SmartConnector, Citrix

Confidential, Edison, NJ

Sr. SQL Server DBA

Responsibilities:

• Responsibilities were to perform Health checks, database tuning, assessments, upgrades, migrations, on-call support, troubleshooting, logical and physical database design, monitoring servers, fine tuning the slow running queries, perform backup and restores, replication and provide High availability. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R 2/2008/2005/2000 , MS Visual Studio, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, DMV’s, Vb.NET, MS Visio, Litespeed, Perfmon, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management data warehouse, Windows Server 2008 R 2/ 2008/2003/2000 , Team Foundation Server, Unix, Power shell 2, Perl.

Confidential, Cherry Hill, NJ

Lead SQL Server DBA

Responsibilities:

• The project goal was to provide production support for Foursite, Navitrace, Accuplus, Boomi, TMT Fleet Maintenance, the Dawg, Mechanic Workstation, Shop Planner Applications and mission critical SQL and Oracle databases. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows Server 2008/2003/2000 , MS Visual Studio, MS BI Dev Studio, Enterprise Manager, SSIS, SSAS, DMV’s, DTS, SSRS, Oracle 10g R2, IIS, Query Analyzer, Vb.NET, Crystal Report, MS Visio, Litespeed, Perfmon, LINQ, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Change Director, Numara Track-It 8, Microsoft Visual Source Safe 6, Confidential Query Farm Maintenance, Team Foundation Server, Unix, Power shell 2, Perl.

Confidential, Lexington, MA

Lead SQL Server DBA/ SQL Server Developer

Responsibilities:

• The project objective was to provide production support for Sorian Financials and Clinicals applications. I have to migrate the DTS Packages to SSIS Packages, load data into the Data-warehouse, support SharePoint environment, provide documentation for the SOX compliance and perform database administrative tasks and development work. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2005/2008, Windows Server 2003/2008, MS Visual Studio, MS BI Dev Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, DMV’s, Oracle, IIS, Query Analyzer,Vb.NET, Crystal Report, MS Visio, Litespeed, Perfmon, LINQ, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Change Director, LogiXML, Netezza, WinSQL, Team Foundation Server, Unix, Power shell 2, Perl.

Confidential, Crestview Hills, KY

Lead SQL Server DBA / Architect

Responsibilities:

• The project objective was to work on database development, data warehousing and maintenance of data architecture, business intelligence, database administration, performance tuning, operating platforms, design, development, data modeling, monitoring, database capacity and utilization, server applications security, archiving, Disaster Recovery, and documentation based on the corporate policies, industry best practices and business Requirements. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2000/2005/2008 , Windows Server 2003/2008, MS Visual Studio, MS BI Dev Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, DMV’s, Oracle, IIS, Query Analyzer,Vb.NET, Crystal Report, MS Visio, Litespeed, Perfmon, ProClarity, LINQ, Legato Networker Module, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Change Director, Unix

Confidential, Dallas, TX

Lead SQL Server DBA

Responsibilities:

• The primary role of my position was to provide daily code deployment, query development, performing data migration between production/testing/development environments, report creation, and other database TSQL programming. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2000/2005, Windows Server 2003, MS BI Dev Studio, Enterprise Manager, SSIS,SSAS, DTS, SSRS, DMV’s, Oracle, SSAS, IIS, Query Analyzer,Vb.NET, Crystal Report, Litespeed, ERWIN, ER/Studio 7.5, Legato Networker, Spotlight, MS-DTC, Change Director, VSS, Unix.

Confidential, Las Vegas, NV

Sr. SQL Server DBA

Responsibilities:

• The project objectives were to support multiple SQL Server 2000 and 2005 databases, SQL Server upgrading, and also developing and monitoring DTS and SSIS packages. The aim of this project was to maintain large SQL Databases in the production environment and supporting large user groups, performing troubleshooting and tuning of the SQL queries, gathering, validating, and documenting reporting requirements and developing recurring, streamlined production reports for the Business Marketing teams.

Environment: SQL Server 2000/2005, Windows Server 2003, MS BI Dev Studio, Enterprise Manager, SSIS, DTS, SSRS, SSAS, DMV’s, IIS, Query Analyzer,.NET, MS Visio, LiteSpeed, Crystal Reports, Erwin, XML

Confidential, San Francisco, CA

Sr. SQL Server DBA

Responsibilities:

• The Project objectives in this bank were to develop, implement and maintain all databases including Stored procedures, Triggers, and complex queries, which include the administration of various bank databases in both development and production environment. Creating SSIS Package and scheduling them through SQL Server Jobs.

Environment: SQL Server 2000/2005, SSRS, SSIS, Windows Server 2003/2000/NT, Enterprise Manager, DTS,IIS, Query Analyzer,.NET, MS Visio, Erwin, LiteSpeed, DTA, MS-DTC.

Confidential, Troy, MI

SQL Server DBA

Responsibilities:

• As a DBA, my duties were mainly focused on administrating, maintaining, and optimizing the existing databases; designing and implementing new databases for various projects according to the requirements from clients; monitoring database performance and growth, performance tuning, establishing and administering database security in development, testing, and production environments. Creating DTS Packages and scheduling them through SQL Server Jobs.

Environment: s: SQL Server 2000 Enterprise Edition, Windows Enterprise Server 2003, Enterprise Manager, Query Analyzer, DTS, IIS, MS Visio, VB, Erwin, MS-DTC.

Confidential, Roseland, NJ

SQL Server DBA

Responsibilities:

• My project objective in this organization was to support the office database needs. My role was to encompass the hands-on support of terabyte class databases, including, monitoring, re-indexing, general database maintenance, extract-transformation-load, backup/recovery, documentation, and configuration. Creating DTS Packages and scheduling them through SQL Server Jobs.

Environment: MS SQL Server 2000, Windows 2000/NT, Enterprise Manager, Query Analyzer, DTS, Maintenance Wizard, Index Tuning Wizard, VB, Excel, MS Access, Erwin, Oracle.

Confidential

SQL Server Developer

Responsibilities:

• This system involves the computerization of a Teleconferencing Billing Process. The system generates invoices, which would be sent to the clients. The system also includes the account receivable section, which involves applying of payments received from clients.

Environment: MS SQL Server 2000/7.0, Windows 2000/NT, T-SQL, DTS, Enterprise Manager, Query Analyzer, Maintenance Wizard, Index Tuning Wizard, VB