SUMMARY

• Around 8+ years of experience in SQL Server DBA, Design and Development with 2012/2008 R 2/ 2008/2005/200 0 with System Analysis.
• Expertise in 24 X 7 Production Database support and on Call Support.
• Expertise in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB), Complex Databases up to 6 Terabytes and implemented policies/procedures for ensuring the security and integrity of the databases.
• Expertise in Database Backup and Recovery procedures for Disaster recovery using native and third party tools.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries on 32 bit and 64 bit clustered and standalone server environments.
• Expertise in Migrating/Upgrading SQL Server and from SQL Server 2000 and, 2008 R2 and 2012.
• Expertise in RAID configurations, SAN boxes and Virtual Environment
• Experience in working with SharePoint both MOSS and WSS.
• Expert in Active/Active Clustering, Mirroring, Log Shipping and Replication
• Expertise in Implementing High Availability and Disaster recovery
• Expertise in diagnosing and tuning the server optimal performance using SQL Server 2005's Dynamic Management Views (DMV).
• Experience in implementing High availability like different Replication models, Log shipping, clustering and mirroring on physical and virtual machines.
• Good experience with logical modeling and physical modeling by using ERWIN.
• Expertise in writing and debugging stored procedures, triggers, Optimizing Code and Improving Efficiency in databases including Re - indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Worked with Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs and stored procs for performance
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, and Backup.
• OLAP experience like Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data ware house environment.
• Created varieties of Reports using SSRS 2008/2005 like drill down, cross tab, matrix style layouts, parameterized reports, performance issues handling, Sub Reports, Ad-hoc Reporting framework design.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Good knowledge in Designing and Building the Dimensions and facts for cubes with star schema using SQL Server Analysis Services (SSAS).
• Expertise In using SQL Server monitoring tools like SQL Diagnostic Manager, Spotlight.
• Good knowledge in PowerShell and VBScripting
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

• MS SQL Server 2012/2008 R 2/ 2008/2005/200 0
• Windows Server 2008 R 2/2008/2003/2000
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft SQL Server Reporting Services (SSRS)
• Microsoft SQL Server Analysis Services (SSAS). Data Modeling
• Erwin 4.0/3.5
• PowerShell
• VBScripting
• OLAP Tools
• SQL
• Perl
• Visual Basic
• Oracle
• Sybase
• TOAD
• SQL* Loader
• IDERA Diagnostic Manager
• Apex SQL Monitoring Tools

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior SQL Server DBA

Responsibilities:

• Responsible for maintaining 250 SQL Servers: 150 servers were production servers and 100 were mission critical and 50 were business critical servers, remaining test and development servers.
• On call 24/7 support to databases on weekly rotation
• Worked on supporting environment which in High Availability (HA) and DR
• Supported Systems in Clustered, Log Shipped and Mirrored environment
• Configured Failover Clustering (Active/Active and Active/Passive) clusters
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 and Experience in configuring and deploying SSIS and SSRS reports
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Worked with Profiler for finding Performance problems
• Used DTA (Data Tuning Advisor) to load SQL Scripts and find problem areas
• Used PerfMon and SQL Server DMV’s for finding performance problems and resolving them
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests
• Implementation of SQL Logins, DB Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Administering MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Used SQL Server Management Studio (SSMS and SAC)
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Extensively used Stored Procedures for handling the database operations
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.

Environment: SQL Server 2012/2008 R2/2005, Active/Active Clustering, Mirorring, Log Shipping, Replication, Physical, SSMS, SAC, SCM, DMV,DTA Virtual, Production, Development, SSIS, SSAS, Diagnostic Manager, Litespeed, Windows Server 2008 R2, SAN, VMWare, T-SQL, PowerShell,VBScrit,Oracle, Sharepoint, .NET

Confidential, New York, NY

Senior SQL Server DBA

Responsibilities:

• Installed, configured and supported SQL Server 2008 R2 in clustered and non-clustered environments.
• Administered SQL Server’s linked servers to facilitate distributed Queries.
• Performed capacity planning and resource allocation for SQL Servers in the environment
• Created databases and database’s objects like tables, views for different SQL Server projects.
• Configured and monitored Failover clustering (Active/Active, Active/Passive)
• Developed and tested storage strategies and disaster recovery plans for 1.6 TB database.
• Created plans and procedures to migrate mission critical databases to HP Superdome Servers.
• Upgraded SQL Server and 2008 versions and applied SQL service packs and patches.
• Monitored Windows and SQL Server logs to proactively resolve issues.
• Set up traces and Profiler to fix performance issues.
• Analyzed deadlocks & blocking on the server.
• Fixed problems related to memory, CPU, I/O, Disk, etc.
• Enforced company’s security policies by creating logins and assigning them proper roles and privileges.
• Configured Log Shipping and Mirroring for Disaster Recovery
• Generated DDLs in ERWIN to create objects in non-prod databases as per project need.
• Maintained SQL Server backups and recovery plans.
• Coordinated change controls for production rollouts.
• Performed data transfers through SQL Server import and export wizard.
• Routinely conducted database monitoring and performance tunning using tools like Diagnostic Manager, SpotLight.
• Greatly reduced slow running Queries by proper indexing and updating statistics.
• Properly configured and distributed User DBs and Tempdb files to escalate performance.
• Participated in yearly BCE (Business Continuity Exercises) to validate DR strategy.
• Lead a team of offshore DBAs to support 24x7 critical US-Card log shipped environment.
• Performed database migration to the HP Superdome Servers.
• Worked with Microsoft and Scalability Experts to collect performance metrics on the new HP Superdomes.

Environment: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Diagnostic Manager, Spotlight, ERWin, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL, PowerShell

Confidential, New Brunswick, New Jersey

Senior SQL Server DBA

Responsibilities:

• Installed SQL Server 2008R2 with the latest security patches.
• Performed database migration from SQL Server 2005 to SQL Server 2008 R2.
• Supported SQL Server 2008 R2 in a clustered and non clustered environment.
• Greatly reduced the time to run the nightly jobs to meet the Service Level Agreement (SLA).
• Installed, configured and supported SSRS as a scaled out deployment.
• Imported and exported SSIS packages.
• Performed SQL Server monitoring through Quest’s spotlight.
• Backed up databases and restored databases using lite speed.
• Created and fixed linked servers.
• Participate in creating scripts, stored procedures calls as per the department needs.
• Advised for better SQL Server performance and throughput.
• Performed routine diagnostics to ensure databases and servers are in good health.

Environment: SQL Server 2008/2005 with clustering, SSIS,SSRS,SSAS, T-SQL, Oracle 10g, Windows 2003/2000/XP, SharePoint 2007

Confidential, Agoura Hills, CA

SQL Server DBA

Responsibilities:

• Installed and upgraded SQL Server 2008 from 2005/2000 version on different environments.
• Extensively worked on setting up the transactional replication and monitoring the jobs and setup alerts for the latency.
• Maintained all the environments of SQL Server to the company standards.
• Performed regular backups and restores of the databases using TDP/TSM based on the SLA of the application.
• Worked on the spotlight monitoring tool to setup all DB alerts for any inconsistency and also created native SQL based alerts for some noncritical applications.
• Scheduled and maintained rebuild and reorganize indexes and performed DB consistency checks as part of the maintenance plans.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks for migrating data from DB2 and Oracle to SQL Server environment.
• Extensively worked on SQL Profiler, Perfmon, and DTA to tune the databases, servers and query tuning.
• Monitored and made recommendations for performance improvement in hosted databases which involved index creation, index removal, index modification, file group modifications and update statistics in databases.
• Extensively used DMV's to identify the current server health during the peak hours.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Worked on Capacity planning and database sizing for each of the projects.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Have setup database and server level audits in SQL Server 2008.
• Detected and provided optimized solutions for long running stored procedures and reporting queries run by the development team.
• Provided 24/7 production support and handled outages by fixing them accordingly.

Environment: SQL Server 2008/2005/200 , Clustering, Mirroring, LogShipping, HA, DR,T-SQL, Oracle 10g, Windows 2003/2000/XP, SharePoint 2007,Scripting.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2000.
• Created Database Maintenance Planner for the Performance of SQL Server.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Configured Different RAID Levels (Redundant Array of Independent Disks).
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Written and Tuned Stored procedures.
• Involved in Installation, Configuration and Migration of the Server SQL Server .
• Installed and Configured Share Point Moss 2007 and WSS 3.0.
• Built and Deployed Reports onto the different websites.
• Configured Site Template Customization, Site Definition Customization, Custom Web Parts, Reports, Search, Master Pages, Content Types, Features.
• Extensively Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Extensively worked on SQL Server 2005 like DMV's, DMF's, Performance Dashboard, Online indexing, Try catch blocks, and Table Partitioning.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Monitored Alerts with different thresholds using Spotlight.
• Involved in recovery databases from damaged or suspect conditions.
• Monitored and modified Performance using execution plans and Index tuning.
• Monitored SQL server performance using profiler to find performance issues, deadlocks and blockings.
• Checking Database Health by using DBCC Commands at regular intervals.

Environment: SQL Server 2000/2005 with clustering, T-SQL, Oracle 10g, Windows 2003/2000/XP, SharePoint 2007, Oracle, ASP and VB, Java.