SUMMARY

• Around 8 years of in - depth experience as Database Administration using Microsoft SQL Server.
• Proficient in designing & implementing various solutions for effective SQL server Administration.
• Performed migrations from SQL Server and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012,SQL Server 2012 to SQL Server 2014
• Expertise in applying Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2 versions.
• Have a good understanding of SQL Server 2012 and 2014 features like always ON, user defined server roles and contained databases.
• Strong experience in monitoring database performance and tuning using various native tools namely Performance Monitor, Activity Monitor, SQL Profiler, SQL logs and Third Party Tools.
• Experience in Query Optimization techniques using DMV’s and DMF’s, DBCC commands, Index Rebuild / Reorganising and also used tools to identify slow running queries using Server-side tracing.
• Monitoring locking/blocking and space management issues.
• Experience on Database Mirroring and Log shipping.
• Worked on SQL Server Replication that is Snapshot, Transactional &Merge.
• Experience in controlling the user privileges, monitoring the security and Audit issues.
• Experience in deploying reports in a reporting server and providing required permissions to users on the reports in reporting server.
• Experience in implementing SSIS packages, Scheduling Jobs, Setting up Alerts & notification using Database Mail.
• Performed Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.
• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel, CSV, Flat file, Text format data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.
• Created reports using SSRS and Troubleshooting failed jobs.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks
• Created complex stored procedures, triggers, tables and other SQL joins and statements for applications by using T-SQL.
• Experience in writing T-SQL (DDL, DML, DCL and TCL).Reviewing T-SQL code, maintaining coding standards across the board in all SQL server environments.
• Review of physical and logical database design, promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data dictionaries are used.
• Possess Strong analytical skills with attention to detail and ability to work effectively in a fast paced environment.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Cassandra.

Operating Systems: Windows 2003/2008/2008 R2/2012

Tools: SQL Server Management Studio, T-SQL, Query AnalyzerSQL Profiler, Replication, Clustering, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Activity Monitor, Performance Monitor, Resource monitor, Lite Speed, Tivoli Storage Manager, SSIS,SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Fortmill, SC

MS SQL Server DBA/Developer

Responsibilities:

• Performed migrations from SQL server 2008R2 to SQL server 2012
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Scheduling jobs and monitoring and troubleshooting them.
• Performing query optimization and performance tuning for high load scenarios using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Worked in load balancing SQL server 2012 and Experience in large scale web farms.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel, CSV, Flat file, Text format data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.
• Expertise in Shading distributed Cassandra and mongodb system
• Experience in building Cassandra cluster,
• Monitoring Cassandra cluster for resource utilization.
• Knowledge of Cassandra systems backup and recovery
• Knowledge of Cassandra security
• Knowledge of Cassandra maintenance and tuning - both database and server
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
• Resolving SCOM alerts and implemented maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks

Environment: SQL Server 2014/2012/2008 R2/2005, Windows Server 2008(x64), SQL Server Management Studio, T-SQL,SQL Profiler, Powershell, Cassandra, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, SCOM, SSRS,SSIS

Confidential, Rancho Cordova, CA

MS SQL Server DBA

Responsibilities:

• Responsible for installing and maintaining SQL Server 2005, SQL 2008 R2 Cluster environment.
• Performed migrations from SQL server 2005 to SQL server 2008R2/2012.
• Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.
• Implementing backup, restores and logshipping using Litespeed tool.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Monitoring locking/blocking and space management issues
• Scheduling jobs and monitoring and troubleshooting them.
• Extensively used T-SQL in constructing relational database models, data dictionaries and data integrity.
• Strong in ETL, Data Warehousing Operations, Data Store concepts, data marts and OLAP technologies
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Experienced in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining, Models, Deployment and Processing using SSAS
• Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Created and maintained data objects such as tables, views, indexes, referential integrity depending on user requirements and converting them to technical specifications.
• T-SQL programming for writing stored procedures, used-defined functions, triggers, views, cursors.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Automated many maintenance, security task across all servers using powershell
• Performed Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.
• Maintaining \ having knowledge of Tivoli Storage Manager (TSM) for SQL Server backups.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Environment: SQL Server 2012/2008R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, T-SQL,SSRS,SSIS,SSAS,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, Tivoli storage manager, litespeed.

Confidential, Dublin, Ohio

MS SQL Server DBA

Responsibilities:

• Experience in SQL Server 2005/2008/2008 R2 installation, Configuring, Deploying applying patches, upgrade, troubleshooting and operations
• Experience in database backup and disaster recovery procedures
• Created and maintained SQL 2008 R2 Cluster environment.
• Perform Database upgrades from SQL server 2005 to SQL server 2008/2008R2.
• Experience in High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Involved in creating new logical and physical design of the database using ERWIN and ER STUDIO to fit new business requirements and implemented new design into SQL Server.
• Monitoring locking/blocking and space management issues
• Scheduling jobs and monitoring and troubleshooting them
• Monitoring SQL/Windows/application/security event logs, Monitor and support client server databases on Windows 2003/2008 R2 servers.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Experience in query optimization and performance tuning.
• Implemented SSIS (SQL Server Integration Services) packages
• Maintaining high availability of SQL servers by proactively monitoring the critical services in a 24*7 support environment

Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64),SQL Server Management Studio, SQL Profiler, Activity Monitor, ERWIN,ER Studio,Data Collector, Performance Monitor, T-SQL, Data Compression, Resource Monitor etc.

Confidential

MS SQL Server DBA/Developer

Responsibilities:

• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Developed objects (i.e. tables, views and stored procedures, functions, triggers, indexes) to get a better and faster performance.
• Defined check constraints, rules, indexes and views based on business requirements.
• Generated standard Tabular type reports with Drill down and Drill through functionality and reports.
• Exporting and importing databases using attach/detach or backup and restore.
• Rebuilding indexes at regular intervals for better performance.
• Checking backup and make sure enough space on the disks.
• Installed and configured SQL Instances and provided technical support and maintenance.

Environment: SQL Server 2000/2005, Windows Server 2003(x64), SQL Server Management Studio, Performance monitor, Resource Monitor.