RAMAN KUMAR
*****.******@*****.***
203-***-**** Certification ID: 14218678
PROFESSIONAL SUMMARY
Around 9 years of experience in Architecture, Administration and DevOps using SQL server 2005/2008/2008R2/2012/2014/2016/2017 systems in Azure and AWS OLTP and OLAP environment.
Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
Worked on setting up Jenkins for deployments over lower environments like UAT’s, Stage, QA and Dev machines
Implemented side by side and In place Migration (Data center) of MS SQL server 2005 to 2008R2/2012/2014/2016 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 DR Disaster Recovery and HA 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.
Implemented Data center migration with cross platform implementation on AWS EC2 instance using DMS.
Hands on experience in implementing Managed Service Accounts MSA’s on SQL services.
Good Knowledge on using Power shell commands for Server performance.
Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
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.
Knowledge on DB2 data warehousing concepts using Linux\Unix.
Auditing of database for user’s transaction, login, database action and removing orphan users.
Cleared HIPPA certification for PHI related compliance.
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, DataBricks, 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.
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:
Azure Cloud, VM, MDOS, Windows NT/2008/2010/2012R2/2016/2019
Databases:
MS SQL Server 2017/2016/2014/2012/2008, No SQL
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
Jenkins, Bamboo, Boomi, Spotfire, Lite speed, Fog lite, Red gate, Web services, SQL sentry, DbAmp.
Languages:
T-SQL, SAS, XML, Python, Power Shell, Linux & Unix.
Education: Bachelor of Technology, JNTUH and Master of Science from UNH in ITM.
PROFESSIONAL EXPERIENCE
FedEx Services Nov 2018 – Till date
Memphis, TN\Remote
SQL DBA
FedEx delivers for its customers with transportation and business solutions. FedEx serves more than 220 countries and territories around the globe with shipment services.
Environment: MS SQL Server 2008R2/2012/2014/16/17, Azure PaaS, Windows 2008/2010/2012R2/2016/2017 SQL, MS Access, ETL, TFS, Spotfire, Unix, Idera, Spot light, DbAmp.
Responsibilities:
Migrating Datacenter and SQL Databases from Sql server 2008R2 to Sql server 2014\2016 on Azure Platform using DMA.
Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
Analyzing long running slow queries and fine tune the same to optimize application and system performance.
Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
Migrating into Hadoop and Salesforce cloud for flexible, cost- effective, reliable, scalable, high-performance and security
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 working with Database Synchronizations and HUB - MEMBER Topologies.
Experience in identifying root cause analysis and fixing the Windows/IIS Web Server/FTP Related issues.
Experience working with Performance Metrics and Plan Management.
Implementation of Active Directory, SQL server logins, Roles and Authentication modes as a part of security policies
Work on weekly Issues reports which are generated as a part of infrastructure setup
Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
Configured Database mail, linked servers.
Extensively worked on Transparent Data Encryption (TDE) and Auditing
Performance tuning of databases by windows performance monitor and SQL Profiler
Used Index tuning wizard to redesign and created the indexes for better performance
Lumeris Health care Feb 2018 – Nov 2018
St louis, Missouri
DEVOPS\SQL DBA
Lumeris is a value-based care managed services operator for health systems and providers seeking extraordinary clinical and financial outcomes. Recognized nationally by KLAS in 2018 for Value-Based Care Managed Services, Lumeris aligns providers and payers across populations with technologies, processes, behaviors and information to achieve high-quality, cost-effective care with satisfied consumers — and engaged physicians.
Environment: MS SQL Server 2008/2008R2/2012/2014/16, Windows 2003/2007/2010/2012R2, SQL, MS Access, ETL, TFS, Azure RDS, Jenkins, Fog light.
Responsibilities:
Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
Migrating Databases from Sql server 2008R2 to Sql server 2016\2017.
Provide 24*7 Application availability using Auto scaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
Installation of packages, patches, maintenance on production application.
Analyzing long running slow queries and fine tune the same to optimize application and system performance.
Deploy, monitor and manage applications in Azure cloud using Team foundation server (TFS) into Development, Test and Production web and application server environment.
Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database.
Migrating into Azure cloud for flexible, cost- effective, reliable, scalable, high-performance and AD Group security
Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
Automating backups using python scripts to transfer data in DR bucket.
Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
Creating alarms in Cloud and production environments watch service for monitoring server’s performance, CPU Utilization, disk usage etc.
Identified and resolved database PTO performance tuning and Optimization issues, database capacity issues and other distributed data issues.
Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
Experience in installing, configuring and deploying Jenkins.
Experience building infrastructure as code.
Creating scripts that generate reports to proactively monitor the environment
Migrating databases to datacenters to Azure(cloud) and DataBricks, while maintaining them on daily activity basis
Extensive experience PHI related issues and handling them with emergency rebases.
Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for HA High Availability
Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers
Created a discussion group for cloud support team in shared point and maintained all documentations in SharePoint.
Key member of a Managed Services team that installs, configures and maintains Software, Databases and Web applications.
Experience working with Agile/Scrum environment.
BCBS\Anthem Health Care Aug 2016 – Feb 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/16, 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.
Involved in Data center migration with cross platform implementation on AWS No SQL Red shift EC2 instance using DMS.
Installed SQL Server 2014 HADR Failover cluster.
Worked on Azure SAAS and PAAS platforms.
Worked on Cross Database Platform Migrations from SQL to Teradata, Oracle, Redshift AWS, Netezza and DB2
Worked on various ASP.NET 2.0 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.
Migrating Databases from Sql server 2008 to Sql server 2014\2016.
Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
Extensive experience with clinical (Patient, Pay) data
Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
Identified and resolved database performance issues, database capacity issues and other distributed data issues.
Experience in ETL Migrating Assistant DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
Analyzing long running slow queries and fine tune the same to optimize application and system performance.
Used Power BI, DB2 using Unix for data warehousing concepts
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) Sept 2015 – Aug 2016
Columbus, Ohio
SQL Server DBA\Developer
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, No SQL, Windows 2003/2008R2/2010, SSRS, SSIS
Responsibilities:
Managed and administered SQL server 2005\2008\R2\2012 servers
Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
Create various reports using data sources including Oracle, AWS- Redshift.
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.
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 DR Transactional Replication and Log Shipping with SQL Server Management
Implementation of SQL server logins, Roles and Authentication modes as a part of AD security policies
Work on weekly Issues reports which are generated as a part of infrastructure setup
Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
Configured Database mail, linked servers.
Extensively worked on Transparent Data Encryption (TDE) and Auditing
Performance tuning of databases by windows performance monitor and SQL Profiler
Used Index tuning wizard to redesign and created the indexes for better performance
Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
Write T-SQL Scripts for database backup jobs and daily/weekly jobs
Tune slow running queries using SQL Server Profiler for PTO issues
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 June 2011 – Aug 2014 SQL Data Engineer
Trend Set IT 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 HA Backup plan and DR disaster recovery strategies
Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.