SUMMARY

• Around 8+ years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2014/2012/2008/2008 r2/2005/2000 in retail and banking sector.
• Experience in managing Windows 2000/2003/2008 R2 servers in a clustered environment.
• Experience in supporting Very Large OLTP Databases of size 13 TB and troubleshooting the performance bottle necks.
• Experience with SQL Server 2014/2012/2008 R2/2005/2000 installation, Migration, configuration, SSIS, SSRS and administration.
• Experience in Implementing SQL Server Reporting, Analysis and Integration Services
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring, Replications, Always On and Clustering.
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels (Active/Active and Active/Passive).
• Experience in Replication - Snapshot and Transactional replication.
• Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments. Experienced in physical, logical database design by using Erwin and VISIO.
• Expertise in Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in Creating linked servers between SQL Servers.
• Expertise in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases.
• Hands-on working experience with analysing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Identifying the bottle necks using SQL Server Profiler and Perfmon.
• Experience in performing Online Indexing. Experience with monitoring, troubleshooting related issues.
• Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.).
• Experience in planning and implementing Microsoft SQL Server Security and database permissions Proficient with database backup and recovery models.
• Expert in configuring and using third party tools like IDERA Diagnostic Manager and Foglight
• Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.
• Expert in Monitoring, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third party tools.
• Configure, maintain, and monitor general purpose Microsoft System Center Configuration Manager (SCCM).
• Expert in Administering SCOM.
• Experience with Normalized and de-normalized database design.
• Involved to planning and designing SSAS 2012 cubes and building attribute relationship for optimal MDX query performance of Hierarchies’ and Fact Dimension.
• Industry working experience in SQL Server and DB2 database management, maintenance, and troubleshooting.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and DB2.
• Proficient with SQL Server Analysis Services. (SSAS)
• Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement
• Extensively worked on VMware and Implemented SQL Server 2005/2008/2008 R/2012/22014
• Rebuilding the indexes at regular intervals for better performance.
• Extensive experience in using Version control system tools for deploying scripts in various stages of SQL Server.
• Worked extensively in Query analyser and profiler for tuning queries using variable for characteristics and query costs.
• Flexible and versatile to adapt to any new environment and work on any project.
• Strong time Management skills and excellent team player.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008 R2/2003

Databases: MS SQL Server 2012/2008 R2/2005/2000, Oracle, Sybase, MS Access

ETL Tools: DTS (Data transformation services), Integration Services.

Database Tools: SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, CluAdmin.exe, DTS Import/Export, SSRS, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, IP Mon, Lite Speed, TFS IDERA Diagnostic Manager, Fog light, Red gate

Data Modelling: ER-Win v 4.0., VISIO

Languages: T-SQL, HTML, XML, C, Microsoft.NET, Java Script, JSON.

Network Topologies: TCP/IP, FTP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Senior SQL Server DBA

Responsibilities:

• SQL Server 2012/2014 installations, patches and upgrades on both physical and virtual environments of production, test and development.
• Responsible for SQL server logical and physical database design, implementation, maintenance on both Stand- alone and clustered environment.
• Creating SQL Server Always On Availability groups including installing clusters and SQL Servers and creating end points required for AG.
• Automate maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
• Automated database refresh jobs on QA from production backups using SSIS.
• SQL Server Database Administrator supporting OLTP and DSS systems
• Installed SQL Server 2014/2012/2008/2008 R2/2005 on windows 2003/2008 environment.
• Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.
• Managed Servers in Clustered, Mirrored and Log Shipped Mode
• Worked extensively on SQL Server 2008 R2 Transactional Replication.
• Configured logical drives and RAID levels Using HP Array Configuration Utility.
• Partitioning ACID property, Data Warehouse, Bill inmon, methodology, SSAS dimension Attribute properties and etc.
• Involved in Monitoring and troubleshooting replication issues
• Configured Server Memory for maximum Performance and effective utilization.
• Configured Temp DB for to increase the performance of SQL Server.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization
• Implemented Reporting Services, Analysis Services and Integration Services
• Involved Design, Troubleshooting and Deployment of SSIS packages
• Migrated DTS packages to SSIS packages
• Involved in deploying XMLA scripts to SSAS and also maintained the security of SSAS databases.
• Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.
• Refresh the Production databases to DEV and QA environments for new releases.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.
• Used new security feature called AUDIT in SQL 2008 on both server level and database level
• Worked with IDERA Tool by setting up alerts for the Monitors of various SQL Servers
• Worked and generated reports using SQL Server 2008 R2 Reporting Services (SSRS)
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Configured SCOM for Administration.
• Maintaining the database consistency with DBCC at regular intervals
• Migrating on-premises databases into SQL AZURE.
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data Base Backups
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS) and power pivot.
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Extensively worked on 24X7 Production support and also involved in on call rotation.
• Worked in REMEDY ticketing system and resolved tickets ranging from P1 to P4.
• Worked on Build and Releases with Off-shore developer teams
• Extensively worked with Native and SQL SAFE compression Backups.
• Extensively used IT Change Request (ITCR) tool to document, track, authorize and record implementation details of changes made to the various applications in the firm.

Environment: Windows 2003/2008, MS SQL Server 2005/2008/2008 R2/2012/2014, MSCS, Microsoft IIS 6, SharePoint2007, Microsoft.NET, SSRS, SSAS, MS Visual Studio 6.0, REMEDY, IDERA.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008R2/2008/2005 on windows 2003/2008 on clustered environment.
• Worked across 60 servers and more than 600 databases.
• Worked extensively on SQL Server 2005 Transactional Replication.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Configured and maintained IIS 6.0.
• Migration of Replicated databases from SQL Server 2000 to SQL Server 2005.
• Involved in Monitoring and involved in trouble shooting replication issues
• Configured Server Memory for maximum Performance and effective utilization.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Integrated Performance monitor and SQL traces to have better graphical analysis to find system bottlenecks.
• Migrated DTS packages to SSIS packages
• Worked on Data portioning for high availability of data
• Involved in performing audits and recovery operation of SSAS objects.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Worked with IP Mon Tool by setting up alerts for the Monitors of various SQL Servers
• Worked and generated reports using SQL Server 2005 Reporting Services (SSRS)
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Maintaining the database consistency with DBCC at regular intervals
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data Base Backups
• Worked on VSS and maintained the data in Source control.
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Extensively worked on 24X7 Production support and involved in trouble shooting SQL servers in various levels.
• Worked in PEREGRINE ticketing system and resolved tickets ranging from P1 to P4.
• Extensively used Enterprise Change Management System (ECMS) tool to document, track, authorize and record implementation details of changes made to the various applications in the firm.
• Extensively worked on Documentation of run books and release documents for production deployments and other processes.

Environment: Windows 2003/2008, MS SQL Server 2000/2005/2008 , MSCS, Microsoft IIS 6SharePoint2007, Microsoft.NET, SSRS, SSAS, DB2 9.7, MS Visual Studio 6.0, Peregrine, Clear Quest.

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Worked on 32 bit, 64 bit clustered environments
• Performed Node Injection for the enhancements of hardware in the Clustered environment.
• Migration of databases from SQL Server 2000/2005 to SQL Server 2005, 2008.
• Installed and Configured Share Point Moss 2007 and WSS 3.0.
• Involved in Configuration and Administration of SharePoint 2007 environment.
• Monitored Log shipping as high availability solution.
• Configured Server Memory for maximum Performance and effective utilization.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Integrated Performance monitor and SQL traces to have better graphical analysis to find system bottlenecks.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Performed Compressed Backups for Huge databases.
• Migrated DTS packages to SSIS packages
• Worked on Data portioning for high availability of data
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Worked with IP Mon Tool by setting up alerts for the Monitors of various SQL Servers
• Worked and generated reports using SQL Server 2005 Reporting Services (SSRS)
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Maintaining the database consistency with DBCC at regular intervals
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Developed ETL Packages and deployed them
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data Base Backups
• Worked on TFS and brought all the servers under Source control.
• Export all Maintenance Packages and brought them under Source control
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Worked on multiple instances of SQL server using VM Ware
• Extensively worked on Production support and involved in trouble shooting SQL servers in various levels.
• Review the Build level for all the servers every month

Environment: Windows 2000/2003/2008 , MS SQL Server 2000/2005/2008 , MSCS, Microsoft IIS 6SharePoint2007, Microsoft.NET, SSRS, SSAS, Oracle 9i, MS Office Access 2003, MS Visio Pro 2002.

Confidential, Markham, ON

Junior SQL Server DBA

Responsibilities:

• Developed stored procedures and triggers.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Logical and Physical design of database for projects on basis of user requirements using ERwin
• Reporting on a weekly basis to the project manager.
• Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Moved the entire phase from the Staging to the Production.

Environment: Windows 2000, MS SQL Server 2000, SQL, T-SQL, SQL Query Analyzer, Profiler