SUMMARY

• Around 8 years of experience in Database Administration, Development and Design Extensive experience with SQL Server 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 to 25 TB and troubleshooting the performance bottle necks.
• Experience with SQL Server 2008 R2/2005/2000 installation, Migration, configuration, SSIS, SSRS and administration.
• Expertise 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, Clustering and Mirroring.
• 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.
• Hands-on working experience with analyzing query plans, using extended T-SQL, 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 Administering SCOM
• Experience with Normalized and de-normalized database design.
• 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 R2.
• 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 analyzer 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, Foglight, Red gate.:

Data Modeling: ER-Win v 4.0., VISIO

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

Network Topologies: TCP/IP, FTP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Senior SQL Server DBA

Responsibilities:

• SQL Server Database Administrator supporting OLTP and DSS systems
• Installed SQL Server 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.
• Involved in Monitoring and troubleshooting replication issues
• Strong RDBMS concepts and experience in creating, maintaining and tuning views, stored procedures user Defined functions and system functions using SQL Server, T-SQL.
• Configured Server Memory for maximum Performance and effective utilization.
• Configured Temp DB for to increase the performance of SQL Server.
• Designed, developed and maintained Postgre SQL database architecture
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• You can use IBM Cognos Configuration to generate a DDL file that you can use tocreate a content store in IBM.
• 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
• Worked on multiple instances of SQL server using VM Ware.
• Designed and developed database packages, procedures, functions and triggers on Oracle 10g/11g databases.
• 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
• Good understanding of automating windows management tasks with MS windows Powershell.
• Configured SCOM for Administration.
• 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.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data base Backups
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored T-SQL, 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 2000/2003/2008 , MS SQL Server 2005/2008/2008 R2/2012,MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, MS Visual Studio 6.0, REMEDY, IDERA, Oracle. Powershell.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 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 DB mail, linked servers in SQL server 2005.
• 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
• Proficient in Oracle Tools and Utilities such as TOAD, Developer 2000, SQL*Navigator and PVCS Version Manager, Subversion
• 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.
• 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.
• I have very good experience working in T-SQL.
• 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 2000/2003/2008 , MS SQL Server 2000/2005/2008 , MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, DB2 9.7, MS Visual Studio 6.0, Peregrine, Clear Quest.T-SQL

Confidential, Los Angeles, CA

Sr.SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Worked on 32 bit, 64 bit clustered environments
• Performed Node Injection for the enhancements of hardware in the Clustered environment.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• 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
• Having very good knowledge on creation and scheduling of T-SQL jobs to run daily.
• 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,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, Oracle 9i, MS Office Access 2003, MS Visio Pro 2002.

Confidential

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