SUMMARY

• Over 7 years of IT experience in SQL Server Administration, Development and Database Design in Production, Test and Dev environments with MS SQL Server 2012/2008R2/2008/2005 and in Virtualization with VM ware ESX 3.5 and 4.0.
• Extensive experience in Installation and configuration of SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
• Configured Active/Active and Active/Passive clustering for failover.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in Database Backup, Recovery and High Availability (Clustering, Log Shipping, Replication and Mirroring).
• Hands on experience in Migration of SQL Server 2008 to SQL Server 2012 and SQL Server 2005 to SQL Server 2008 (side by side and in place).
• Experience with Change data Capture in SQL Server 2008.
• Extensively worked on Integration (SSIS) and Reporting Services (SSRS), Analysis Services (SSAS), Business Intelligence and good experience in data migration from Oracle/MS - Access/MS-Excel Sheets/MYSQL to SQL Server 2008/2005.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Experienced in writing T-SQL (DDL, DML, and DCL). Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server /2005/2000 with T-SQL.
• Managed 100+ databases in SAP Environment.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Expert in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
• Working knowledge of .Net Framework (VB.Net, ASP.Net, and ADO.Net) and IIS.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.
• Flexible enthusiastic and project oriented team player with excellent written verbal communication and leadership skills to develop creative solutions for challenging clients need.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

Operating Systems: Windows 2008 server, Windows 2003 Server, Windows 2000 Advance and Professional Servers and Windows NT 4.0.

RDBMS: SQLServer2012/2008R 2/ 2008/2005/2000 , MS Access., DB2

SQL Server Tools: SSMS, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance PlanLanguages C, T-SQL

Hardware: HP Servers, IBM Netfinity Servers and Dell Servers

Web technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0),MOSS 2007

PROFESSIONAL EXPERIENCE

Confidential, NYC

SQL Server DBA

Responsibilities:

• Implemented data models, database structure design, backup and recovery processes.
• Configured Change Data Capture in SQL Server 2008 to maintain the history of the changes in the tables.
• Involved in installation of SQL Server 2012 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases).
• Experience in using TFS (Team Foundation Server). And demonstrated attention to detail, creativity, with excellent time management, team development and organizational skills
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Audits and maintains small-scale to large-scale databases.
• Worked with installation, configuration and deployment of SSIS, SSAS, and SSRS.
• Used Team Foundation Server (TFS) as a Source code control.
• Worked on SQL Server 2008 failover clustering which is built on top of a Windows 2003 server cluster.
• Deployed Cubes on SSAS Server and did cube refresh on demand
• Worked on Active/Active and Active/Passive Clustering.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Responsible for verifying all data to be entered into database meets set standards and requirements.
• Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
• Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Worked on DTS Packages, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Involved in migration of SSIS (2005) packages to SSIS (2008R2) packages.
• Identifies tests and resolves complex database issues (e.g., monitoring and tuning).
• Managed SAP backend SQL Server databases which are in Terra bytes of size.
• Involved in database system management functions (e.g., software installs, version upgrades and configuration management).
• Worked on protocols like Kerberos, TCP/IP and NLTM.
• Defined and provided recommendations database standards, procedures and architecture.
• Designs data models and Data Warehouse database designs.
• Participated in a 24x7 production support on-call rotation.
• Performed SQL Code Index Reviews.
• Involved in Ensuring optimal performance and availability of databases.
• Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: SQL Server 2012,2008 R2, 2005, SSIS SSAS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, TFS, HTML, XML, XSLT, Windows server 2003, 2008.

Confidential, NC

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 R2 on standalone and cluster environments.
• Involved in Migration of SQL 2005 to SQL server 2008 R2.
• Configured and administered SQL Clusters (Active/Passive, Active/Active).
• Experience in Understanding structured data analysis, data models and data normalization.
• Installed and configured SSRS & SSAS services. Deployed RDL files on report server and managed report’s security.
• Involved in rewriting of all the functionality of SQL server 2005 to SQL server 2008 R2.
• Experience in setting up Database Mirroring with witness Server in SQL server 2008 R2 (Manual / Automatic fail-Over).
• Configuring SSIS (SQL Server Integration Services) for named instances, remote access enabling for Users.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Solid experience with SQL 2008 R2 backup and recovery procedures.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Successfully Implemented Multi - Server Administration in SQL Server 2008 R2 and developed scripts to use in Multi - Server Administration.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related issues.
• Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS.
• Developed SQL data migration scripts for application conversion or integration.
• Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.
• Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
• Created various Jobs, scheduled & ran jobs and troubleshoot the failed jobs.
• Had good experience in 24/7 production support.
• Good understanding of developing Data Ware house applications using star schema approach.

Environment: .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server 2003, 2008, QUEST, SSL, IIS 6.0, SQL Server 2008 R2, 2005, SSAS SSIS and SSRS.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Built new Clustered SQL Server 2008R2 environment on bare metal from the scratch. Including Prod, Test and Dev environments.
• Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
• Estimated data growth from past years history and allocated SAN Space. Managed gigantic databases across the multiple disks on SAN using the file groups.
• Maintained DB Security at Active Directory level by creating AD groups (Read, Write, Exec etc...) per database and added business users to the appropriate AD groups.
• Databases migrated as backup restore and loaded table’s data using SSIS packages.
• Created backup strategies based on database size and scheduled Maintenance plans, automated DB refresh jobs in Test & Dev environments.
• Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Performed the DR Drill (Cutover) on clustering and routing the application from DC to DR Servers and testing the Application connectivity on regular intervals.
• Configured Database Mirroring with high performance and high availability mode.
• Migration and maintenance of data using various utilities like SSIS, Import and Export wizard, ATTACH/DETACH Data compare tools.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle and SAS using third-party RDBMS driver tools.
• Involved in SQL Server Hardening.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Monitored the event logs and server logs for troubleshooting and problem solving
• Used ETL packages to move logins and jobs from one server to another server.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 2003/2008/2008 R2 64 bit.

Confidential, Tampa, FL

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 on both cluster and stand-alone environment.
• Installed SQL SERVER Service Packs to keep the SQL Server up to date.
• Maintained DB Security by creating logins, users, roles and permissions for the business people.
• Responsible for activities daily routine backup restore, refreshing databases as per requirements.
• Scheduled and created Maintenance plans on databases and also created automated jobs.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution..
• Configured Database Mirroring with high performance and high availability mode.
• Upgraded SQL Server 2005 to SQL Server 2008/2008R2 in windows server bit.
• Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 databases.
• Experience in migration and maintenance of data using various utilities like Import and Export, ATTACH/DETACH Data Migration tools.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle servers.
• Involved in Moving System databases.
• Maintaining both Development and Test servers in sync with PRODUCTION server by doing Database Refreshes.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving
• Upgraded the SQL Server 2005 to SQL Server 2008.
• Used ETL packages to move logins and jobs from one server to another server.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Implemented different types of replications Transactional, Snapshot and merge replications.

Environment: SQL Server 2008/2005/2000 , MS-Access, Windows 2000/2003/2008 , DTS/SSIS, SSRS, SSAS 2008/ 2005/2000.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the creation of schema objects like indexes, views, stored procedures.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.
• Supported technical teams involved with MS SQL issues and operations.
• Environment: MS SQL Server 2000 Windows Server 2000. Query Analyzer, Enterprise Manager.

Environment: MS SQL Server 2005/2008/2008 R2.