RAMAN KUMAR

ac4jl6@r.postjobfree.com

203-***-**** Certification ID: 14218678

PROFESSIONAL SUMMARY

Around 7+ years of experience in Administration\Architect\Development skills using SQL server 2005/2008/2008R2/2012/2014/2016 systems in OLTP and OLAP environment.

Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.

Implemented side by side and In place Migration of MS SQL server 2005 to 2008R2/2012/2014 and applied Patches and Service packs to update different versions of MS SQL server.

Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.

Experience in implementing and setting up Disaster Recovery and High availability solutions like different Clustering (Active-Active) and Replication

Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues.

Explicitly used third party tools like Lite speed and SQL sentry

Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.

Expert in Data Extraction, Transformation, and Loading (ETL) using Talend, Oracle Data Integrator (ODI) or similar tools such as BODI, Informatica, Data Stage,, or related technologies.

Migrating data from various sources such as Excel, Oracle, MS Access, OLE DB, DB2, flat files to SQL server to different destinations using SSIS.

Great Expertise in creating and managing Event, Handlers, Package Configurations, Logging and User-defined Variables for SSIS Packages.

Strong experience in logical and physical database design and development, Normalization and data modeling.

Experience on creating and migrating Databases to DR sites on Azure Platform.

Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.

Installed Always ON AG groups with Azure DR solutions.

Auditing of database for users transaction, login, database action and removing orphan users.

Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.

Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.

Handled numerous Change Management requests on production servers.

24 X 7 Production Database on Call Support.

Around 5+ years of experience in Healthcare Industry.

Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICALSKILLS

Operating Systems:

MDOS, VMware, Windows95, NT/2003/2008/2010

Databases:

Oracle, DB2, Netezza, MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000, MS Office, Access 97/2000/2003

ETL and REPORTING Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters

Third Part Tools

lite speed, Foglite, Red gate, Web services, SQL sentry.

Languages:

T-SQL, XML, Shell, Linux & Unix.

Education: Bachelor of Technology in CS from JNTUH, Master of Science, UNH.

PROFESSIONAL EXPERIENCE

Anthem Health Care Aug 2016 – Jan 2018

Atlanta, GA

SQL Server DBA\Architect

Anthem is one of the nation’s leading diversified health care benefits companies serving members with information and resources to help them make better informed. The project was about to design and to migrate data and to increase performance by developing high availability strategies.

Environment: MS SQL Server 2008/2008R2/2012/2014 Windows 2003/2007/2010/2012R2, SQL, MS Access, SQL sentry, Lite Speed V8.2.1.

Responsibilities:

Installed and Upgraded from Sql Server 2008 to Sql server 2014 & 2016 on Various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.

Implemented Sql Data Compression Using Sql server 2008 For Compressing Data and Log Files, Back Up Level.

Installed SQL Server 2014 Failover cluster.

Migrating Databases from Sql server 2008 to Sql server 2014 and also to Oracle 12C.

Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.

Installed Always On HADR concept to CA location Datacenter and Used Azure as SQL 2016 DR databases.

Worked on Data marts and Data warehouse concepts like SSIS and Data modeling.

Worked on Data warehouse concepts and ETL tools as an architect.

Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012 to create Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2012 Reporting Services (SSRS).

Extensive experience with clinical (Patient, Pay) data

Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.

Scheduled jobs for backup, and created alerts for error reporting.

Solving Tickets on Daily Basis for Production Issues.

Performed Backups, Restores of databases using Lite Speed tool.

Checking Database Health by using DBCC Commands.

Supporting production team & developers while being On Call DBA.

Department of Developmental Disabilities (DODD) March 2015 – Aug 2016

Columbus, Ohio

SQL Server DBA

The Ohio Department of Developmental Disabilities (DODD) oversees a statewide system of supports and services for people with developmental disabilities and their families. DODD does this by developing services that ensure an individual’s health and safety, encourage participation in the community, increase opportunities for meaningful employment, and provide residential services and support from early childhood through adulthood.

Environment:

MS SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008R2/2010, SSRS, SSIS

Responsibilities:

Manage and administer SQL server 2005\2008\R2\2012 servers

Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2016

Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster

Experience on working No SQL Graph databases using Neo4J for performance tuning in Queries and Schema level.

Worked on good standard T-SQL queries by using different store procedures, Triggers, Indexes, Views.

Configured Active Directory to create users and login groups to access failover clustering

Deployment of databases, jobs from pre-production to production

Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers

Worked on moving SQL databases to DR location on Azure Cloud.

Implemented change data capture to reduce load duration in SSIS packages for Migration Process for Development of Data Ware house Design Star Schema Design Method.

Upgradations of sql server versions and applying patches and hot fixes

Adding nodes to already existing clustered servers as a part of data load\High availability

Configured Transactional Replication and Log Shipping with SQL Server Management

Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012.

Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Worked on VTFS and TFS( Team Foundation Servers)

Used ETL to implement the slowly changing Dimensions (SCD) in data warehouse. Expert knowledge in developing multidimensional databases (MDX, DAX) using SSAS. Experience in OLAP cubes using SSAS for data mining with Hierarchies, Star and Snow Flake Schemas of Data Marts.

Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning

Used DBCC and DMV commands for day-to-day troubleshooting tasks

Import data across multiple instances using BULK INSERT and BCP Utility

Involved in Capacity Planning, Database Normalization and De-normalization process

Optimize the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application

Disaster Recovery Planning, Testing and analyzing and continuous update of documentation

Aetna with Tek org June 2011 – Aug 2014 Hyderabad, India

SQL DBA

Tek org is a full-service IT global outsourcing company. It is our goal to ensure that our clients receive the multiple benefits of world-class infrastructure, deep domain knowledge and streamlined processes combined with speed of design and implementation at the best cost.

Environment: SQL Server 2005(Enterprise Manager, DTS, IIS(Internet Information Service) Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2003 Advanced Server.

Responsibilities:

Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.

Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.

Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.

Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.

Scheduled the backups for Databases and Transaction log. Performed restoration operations.

To set up SQL Server configuration settings.

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Contact this candidate