SUMMARY

• Around 9+ Years of total IT experience including SQL Server Database Administration for very large and complex databases in SQL Server 2000/ 2005/2008/2008 R 2/2012/2014.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience in working with enterprise environment supporting all aspects of a sql server Database Server with emphasis on 2 - tiered and 3-tiered architecture.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Has an idea in working with SAAS, IAAS, PAAS platforms and virtualized environments.
• Implemented "Always On Availability groups" in SQL 2012 on multi-subnet/Geo Cluster environment.
• Expertise in SQL Server Cluster Implementation (Active-Active / Active-Passive) and troubleshooting the failure.
• Handled multiple SQL Instances on Cluster environment for projects built on SAN using RAID levels.
• Implemented VMware VSphere implementations for SQL Server.
• Configured VMware Infrastructure higher levels of availability for SQL Server. VMware Distributed Resource Scheduler (DRS), VMware High Availability (HA), and the VMware Site Recovery Manager.
• Having hands on experience working with HA/DR SAN Production environment - Always-on, Clustering, Mirroring, Log Shipping, & all types of Replication techniques(Snapshot, Merge and Transactional).
• Worked extensively on Clustering and server consolidation, Troubleshooting production issues and raising high availability.
• Experience on disaster recovery planning and implementing Security Management operations
• Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment.
• Familiar with Virtualization technology and running Windows inside a Virtual Machine.
• Involved in ITIL Service Support areas of Incident, Problem, Change, Release, Configuration Management and Service Desk.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization of Databases and building Referential Integrity Constraints.
• Analyzing and meeting SLAs as per the severity.
• Proficiency and expertise in migrating Database from SQL Server 2012/2008/2005 under various process like Backup/Restore; Detach/Attach, import/export etc.
• Experience to recover data in case of disaster of server.
• Creating and managing of multiple Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g with all required accessibility for Data pull through SQL Jobs.
• Worked on fine-tuning databases, created Clustered and Non-Clustered Indexes for tables, identified Fragmentation.
• Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.
• Creating and configuring Databases based on the clients specifications
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience and proven understanding of managing database audit events and audit records. Expertise in creating, implementing and monitoring Maintenance Plans/SQL Jobs, job scheduling.
• Expertise with the role of Transaction logs and action accordingly Log Space Maintenance and Temp database space issues.
• Hands on experience in using Performance Monitor/Profiler and also good experience in data (table) partitioning.
• Highly skilled in implementing SME Standards for database issues.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc depends on scenarios.
• Expertise in Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages.
• Experience in using the DMVS, DMFS, INFORMATION SCHEMA, SYSTEM VIEW Sand in-built Global variables for the instant analysis.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Administering Database security by creation of SQL logins/users and granting of roles. Implemented Rev Login scripts while creating logins.
• Implemented Secure SQL environment using SOX compliance standards.
• Applying the Patches on the Instances based on both Operating System (OS) and SQL Server on the analyst’s requirement
• Performance Tuning like identifying long running queries; Open Transactions; Blockings; Deadlocks, Trace Flags etc.
• Handful experience in Installs, deployments, certificate renewals, service accounts resets, process job tickets & bugs, test verify backups and recovery.
• Expert in Data Integrity and Query Optimization and tuning complex queries.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Functions, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations and Data center migration, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, CDC (Change Data Capture).
• Experience in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF
• Performing Online/Offline database DR Drills as per the customer requirements.
• Regular monitoring and workaround on Disk Management and Database File growths and take appropriate action.
• Experience in using tools like spotlight, TSM, light speed, HTTP Watch, Fiddler, Wireshark.
• Strong communication, presentation and interpersonal skills and good experience in handling Team as well as end users.

TECHNICAL SKILLS

Operating System: Windows 2000/2005/2008 Server, Windows 95/98/XP/NT, Linux, Solaris, Unix

Databases: MS SQL Server 2014,2012,2008 R2,2008, 2005,2000, Oracle 8i,9i, Sybase

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping, SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), PowerShell

Programming: T-SQL,PL-SQL,HTML,HTML5,XML,CSS,C,C++

DBA: Database administration of MS SQL Server 2014, 2102, 2008 R2,2008, 2005,2000

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard

Backup Utility: Quest Lite speed, SQL Safe, Redgate,Tivoli, Idera

Build Tools Analytical Tools: FreeNAS, OWNCLOUD, Virtual Box, NODE-XL, MS Project and Visio

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Sr Sql Dba

Responsibilities:

• Experience in installing, managing and troubleshooting SQL Server 2014, 2012, 2008R2, 2008.
• Configured ALWAYS ON setup between different Datacenters and on Multi Subnet Cluster.
• Installed and Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2012 server cluster.
• Strong experience in monitoring and tuningsqlserver databases for optimum performance and assistance in capacity planning ofsqlserver database servers.
• Configuring and Managing Log Shipping and Database Mirroring.
• Configured different types of replication like Snapshot Replication, Transact replication from Multiple publishers to one subscriber and one subscriber to multiple publishers.
• Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases.
• Developed ITIL framework in coordination with MSC staff members.
• Checking the SQL Error logs for any errors that may have occurred overnight.
• Checking available physical Disk space, Log Space, jobs for failed completion, backups and log sizes, Monitoring performance with PERFMON COUNTERS.
• Implemented DMV and dynamic management functions for finding out long running queries.
• Extensively worked on DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters
• Checking for outstanding active or blocked transactions. (stored procedure)
• Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.
• Expert in implementing the snapshot isolation and DDL triggers.
• Migrated SQL server 2008 R2 to SQL Server 2012 and SQL SERVER .
• Worked with filestream bystoringvarbinary(max)binary large object (BLOB) dataas files on the file system. Worked with filestream filegroups.
• Experienced with end to end Automation using Powershell for User Account/ Mailboxes/ Distribution Group/ Security Group provisioning and management.
• Architected virtualized MS Hyper-V and VM Ware for Application and Database life cycleenvironments: Development, testing, Q/A, Staging and Production.
• Implemented encryption of sensitive data in the databases using Data encryption Standards like TRANSPARENT DATA ENCRYPTION(TDE).
• Installed patching and administered 2-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Extensively worked on SQL Server Integration Services (SSIS)
• Rebuilding/Reorganizing the indexes at regular intervals for better performance.
• Experience in using SQL Server Profiler, SQL Server Agent.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used execution Plan, DBCC Commands, Profilers and WAIT TYPES.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Implemented ITIL frameworks to manage level of complexity.
• Implemented security considerations for SQL Server during installation, logins, configurations, while encrypting.
• Periodically checking the health of the server and providing recommendations.
• Performance tuning and monitoring of databases, data archiving and purging, troubleshooting and management of production databases and disk space management.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• Analyzing long running slow queries and tunes the same to optimize application and system performance.
• Set up SQL Server configuration settings for better server management.
• Monitoring the servers using Delta Monitoring and Idera third party software.
• Upgrading of SQL server software 2005/2008/2008 R2.
• Designing and creating backups & recovery strategy and meet RPO/RTO objectives.
• Working with customers on Application rollouts and server migrations.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using Red Gate SQL & Lite Speed.
• Resolved and tweaked memory pressures caused during product release.
• Worked with different upstream team for downloading ETL MART data.

Environment: MS SQL Server 2000/2005/2008/2012/2014, Windows 2003/2008, SSIS, SSAS, PL/SQL, MS Access, Perl script, Red Gate, companion, Idera, TSM/TDP

Confidential, Columbus, OH

Sr Sql Dba

Responsibilities:

• Responsible for 24 hour support to manage and maintain database server to ensure that all server available and up and running.
• Responsible for Database support, SQL Server Installation, troubleshooting, planning and migration.
• Performed installation and update of latest SQL Server Service Packs.
• Upgraded databases from SQL Server 2005 to SQL Server 2008 R2.
• Designed and implemented comprehensive Backup plan using SQL Lite Speed
• Ensure optimal performance, reliability, security and optimizing of database server.
• Implemented microsoft tools such as Microsoft security baseline analyzer for SOX security analysis.
• Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.
• Used advanced SQL query, store procedure, function, indexes, trigger and cursor to design and development of database Server.
• Troubleshoot locking, blocking, deadlocks, high resource in long running queries.
• Worked with the FILESTREAM filegroups on shared disk resources, When implementing failover clustering.
• Setup Database Maintenance Plans to reorganize indexes, rebuild index and update the index statistics on the production databases.
• Performed database maintenance and performance tuning for the database server.
• Used SQL Server Profiler to monitor and record database activities of certain database objects. Involved in capacity planning, sizing and database growth projections.
• Extensively worked with powershell automation.
• Used System monitor and Dynamic management view to find the bottlenecks in CPU, Disk I/O and memory to improve the database and application performance.
• Performed DBCC and DMV commands to troubleshoot issues related to database performance consistency.
• Create and implemented language conversion to support multi languages like English, US-English, French, Spanish, German etc.
• Created monitoring scripts to error alert for database issues.
• Fine-tuned Stored Procedures using Execution Plan for better performance.
• Implement and maintain database audit and server security.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Create and maintain offline cube using SSIS and SSAS tool of SQL Server.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Implement and manage SQL Azure database for cloud server.

Environment: MS SQL Server 2000/2005/2008/2012/2014, Windows 2003/2008, SSIS, SSAS, PL/SQL, MS Access, perl script, Red Gate, companion, Idera, TSM/TDP

Confidential, NC

Sql Dba/Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005/2000 on Windows 2003 Server.
• Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.
• Maintained the Active-Passive Clustering as a disaster recovery solution
• Implemented different types of Replication Models like Snapshot and Transactional Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Configured and maintained database mirroring for high availability.
• Using log shipping for synchronization of database.
• Monitored Databases for lock escalation, DeadLock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Profiler.
• Traced long running queries and deadlocks using SQL Profiler
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.
• Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts
• Worked with T-SQL development and performance tuning in T-SQL code. Participated in Performance Tuning of Code using execution plan and SQL profiler.
• Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
• Configuring and implementing SQL Server contained database.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions. Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Global Customer interactions through mails/telephonic etc.
• Normalization and Denormalization of tables. Developed Backup and Restore scripts for SQL Server 2005. Installed and Configured SQL Server 2005 with latest service packs.

Environment: SQL Server 2005, T-SQL, DTS, Lite speed, Double-Take software, SQL backup and BMC Remedy.

Confidential, Minneapolis, MN

Sr Sql Dba/Developer

Responsibilities:

• Gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling.
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dashboards using Microsoft PerformancePoint service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: MS SQL Server 2008/2005, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),Visual Studio, MS Excel, Flat File, Oracle 10g,Erwin, SQL Profiler,C#.NET