Sai S Kumar G
Mobile: +601********; E-mail: firstname.lastname@example.org
To learn and function effectively in an organization where I will be able to deliver to the maximum of my abilities by constantly upgrading my knowledge and skills while making a difference in whatever I do.
Summary of Skills:
Around 3 years of experience as Hadoop Administration and overall 5+ years of experience includes Cloud Microsoft SQL Database /Azure Administration.
Around 3 years of experience as Hadoop Administration
Experience with Cloudera Manager Administration also experience in Installing, Updating Hadoop and its related components in Single node cluster as well as Multi node cluster environment using Apache, Cloudera.
Good experience in UNIX/LINUX Administrator along with SQL Database administration in designing and implementing Relational Database model as per business needs in different domains.
Managing Microsoft Azure infrastructure and designing cloud-hosted solutions, specific Microsoft Cloud product suite experience.
Migrated services from a managed hosting environment to Microsoft Azure including service design, network layout, data migration, automation, monitoring, deployments, documentation, overall plan, cost analysis, and timeline.
Strong Knowledge in Hadoop storage Layer and processing layer like Map reduce and YARN framework.
Designing VM deployments by leveraging availability sets, fault domains, and update domains in Azure.
Designing Data and Networking Implementation, designing data security solutions for Azure services; determine when to use Azure Storage encryption, Azure Disk Encryption, Azure SQL Database security capabilities, and Azure Key Vault.
Hand in experience in Azure Big data Analytics including ADF V1 & ADFV2.
Experience on Power off/ Down the un-used VM's and Ability Restart/bounce the Azure components / clusters/ VM’s Manage & Azure subscription and profiles.
Provide technical administrative and configuration support for Microsoft Azure platform
MS SQL & Azure Administration:
Implemented Azure SQL Database Server according to the Azure SQL DB Pricing Tier.
Exported On premise SQL Database to SQL Azure
Implemented Server Level Security Features - Firewall rules, Logins & Master Database Roles.
Database -Level Security Features-Firewall Rules, Users & Database Roles.
Experience in Database activities like Installation, Configuration, Backup & Recovery, Database Security, Database creation and Maintenance, Disk Capacity Planning, Performance Monitoring and tuning and Troubleshooting and Documentation.
Experience in Always on HA on SQL 2012 servers.
Experience in DB restore on Log shipped VLDB is on different from PTC and FTC locations.
Hands-on experience in implementation, migration and upgrade projects (MS SQL 2000 to MS SQL 2005 and SQL 2005 to SQL Server 2008 & 2012)
Experience in Vulnerability Remediation on the servers.
Involved in DR Activities.
Hands on experience in Performance tuning on Database levels.
Hands on experience Maintaining and Troubleshooting Clustering
Experience in maintaining Mirroring, Replication and Log shipping.
Working as a senior Hadoop/Azure Administration in Conduent (Formerly Xerox International Services) from June 2017 to till date.
Worked as a Microsoft Azure Administrator (IAAS & PAAS)/SQL/Hadoop Administrator in NTT Data (formerly Dell International Services) from Feb 2013 to June 2017.
PG (MBA) completed from JNTU Kakinada.
: Windows Server 2003, 2008,2012,Oracle Enterprise Linux, CentOS
Databases & Azure DB
: MS SQL Server 2005,2008,2008R2,2012 &2016, Oracle 11G
: BMC Remedy OPAS V2 and OPASV3,ServiceNow,ATP,OSTicket
: Advance Monitoring & Mid-Level Monitoring tool,FogLight
: Symantec NetBackup, Avamar, TSM,Visual Studio 2015
Big data Tools : Azure Data Factory and Data Lake and Hive, HBase, SQOOP,
Azure Certified from the Microsoft (Implementing Microsoft Azure Infrastructure Solutions) –(Azure - 70-533)
ITIL V3Certified from the Axelos in Foundation Level.
SQL Server 2012 Administering Microsoft Databases - (MCSE - 70-462)
SQL Server 2008 Implementation &Maintenance (MCTS - 70432)
Conduent (Formerly Xerox Services ) June 2017 – Till Date
Microsoft Azure & Hadoop Administrator
Project #3 Leveraged Projects
Currently working as a part of BICC, which is supporting multiple Applications from financial and commercial Sectors. Experienced with data architecture, cloud based solutions. Provide Cloud Support like Azure application (SaaS), Platform (PaaS) and Infrastructure (IaaS), Azure SQL Data Warehouse, Azure function, Azure data factory
Responsible for Cluster maintenance, commissioning and decommissioning Data nodes, Cluster Monitoring, Troubleshooting, Manage and review data backups, Manage & review Hadoop log files Handling Hadoop Namenode and data node related issues.
Hands on experience in Importing and Exporting Data from Hadoop to SQL Database vice versa.
Deploy Hadoop High Availability on all nodes and handling Application related issue
Monitoring systems and services, architecture design and implementation of Hadoop deployment, configuration management, backup, and disaster recovery systems and procedures.
Verify the ETL status and handling ETL related issues
Take application and Name node backup on Tape drive
Hand on experience on Hadoop Cloudera Distributions
Created disaster recovery environment for company critical and essential databases.
Hand on experience in implementation of Azure Data Factory and Data lake creation and linked services and DM gateway.
Azure VM Deployment and Implementation of Azure Disk Encryption and Network Security Configuration for the VM’s and Managing Security in Azure VM.
Involved in Express Route configuration for Azure environment.
Involved in Migration from Oracle to SQL Azure.
NTT Data (Formerly Dell International Services) Feb 2013 – June 2017
Azure IAAS & PAAS/Hadoop /Database Administrator
Project #2 Leverage Projects Dec 2013 – June 2017
Worked as a part of leveraged team, which is supporting multiple customers from financial and commercial Sectors. Provide SQL Database /Hadoop Administration and Support for 2000, 2005 and 2008, 2008R2, 2012/2016 on Windows2000/2003 and Windows2008, Windows2012.Responsibilities includes assisting Microsoft SQL Server & Hadoop Administration Configuration, Administration, Implementation and troubleshooting SQL Servers.
Role : Database/Oracle Admin Advisor/Hadoop Administration
Environment: SQL SERVER 2000, 2005/2008R2, 2012 Windows 2003, 2008 server,OEL 11.0,Centos
Tools : TSM Backup, Symantec Net backup, Net IQ monitoring Tool, Mid-Level Monitoring Tool.
Hand on experience in Hadoop Distributions like Cloudera Hadoop distributions and Map Reduce and Storage & Processing Layer.
Involved in distributions like Cloudera Hadoop and Cluster deployment in Hadoop Environment.
Experience in configuration of SQOOP in HDFS to import data from SQL Servers and vice versa.
Hands on experience in Azure IAAS and PAAS components.
Experience in SQL Azure DB Administration, which includes Deployment &Configuration of security and Creating the Alerts and Maintenance plans.
Experience in Geo Replication on Azure Environment.
Responding to the alerts & service requests from the customers within the SLA norms. Using Remedy Ticketing Tool for Incident Management and Change Managements.
Experience in Always on HA and Mirroring and Log shipping.
Hands on Experience in applying latest Service packs and patches and Migration & Up-gradation from Existing SQL Server to New versions.
SQL Server Cluster Configuration and Maintenance (Active/Passive, Active/active)
Regular monitor of servers, which includes Backup Job Monitoring, configuration & troubleshoot all the issues on regular basis. Recovered the suspect and corrupted databases in SQL Server.
Performed Rebuild master and recovered the instance and experience in System database movement to another location in the server.
Performed Database restoration as per business requirement and recovering the databases during disaster recovery.
Implementation of SQL Logins, Roles and Authentication Modes as a part of user Support.
Check the disk space for the volumes with data files, log files, and Temp db.
Configuring and Maintaining Transactional Replication, Log shipping, Mirroring.
Maintain and troubleshoot Replication issues by continuous monitoring of replication
Performance tuning activities like verifying the Fragmentation and re-indexing the fragmented indexes.
Proactively monitor production databases and resolve LOCKING / BLOCKING and resource utilization
Hands on experience in trouble shoot slow Query performance at Server.
Creating weekly review of Leverage Projects of the servers to the customer about the status of the database.
Project #1 The Carlyle Group (TCG) Feb 2013 to November 2013
The Carlyle Group is a global alternative asset manager with $169 billion of assets under management across 125 funds and 177 fund of funds vehicles. Founded in 1987 in Washington, DC, Carlyle has grown into one of the world’s largest and most successful investment firms, with more than 1,625 professionals operating in 35 offices in North America, South America, Europe, the Middle East, Africa, Asia and Australia. We support all logical units and all applications Provide Database Administration and Support for 2000, 2005 and 2008 on Windows2003, 2008. Responsibilities include assisting Microsoft SQL Server customers with Configuration, Administration, Implementation and troubleshooting SQL Servers for all in house and Vendor applications.
Role : Database Admin SR Analyst
Environment : Microsoft SQL Server 2000/2005 on Win Server 2000/2005
Worked on L1 Activities like resolving disk space alerts, Job failure alerts managing security tasks like granting and revoke permission for users.
Installation of SQL2000, 2005 and Service packs.
Performing Database maintenance activities like Backups, Restoring etc.
Monitored SQL Server Logs, OS Logs for Troubleshooting the Issues.
Maintain database by analyzing index fragmentation and do re-organizing at regular interval.
Identifying and resolving Blockings and Dead Locks.
Maintenance and troubleshooting Log shipping.
Place: Malaysia (GSS Kumar)