Kumar Y
Summary
Database Administrator with 14+ years of experience in Data Engineering, Data Analytics, and Database Administration. Skilled in building ETL/ELT Data Warehousing pipelines and proficient in Azure and Oracle cloud technologies. Expertise in leading Big Data and database technology projects from requirements gathering to solutions delivery. Managed projects utilizing multiple data technologies such as Oracle Database, MS SQL Server, MySQL, and Hadoop. Strong database administration skills including capacity planning, schema designing, backup strategies, performance tuning, and high availability. Experienced in end-to-end Database/Data Warehouse lifecycle management. Knowledgeable in ETL installation, configuration, development of mappings and transformations, and workflow design. Proficient in reporting/analytics with dimensional modeling and report development. Experienced in coordinating teams across multiple geographical locations.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Database Administrator
Concentrix
09.2014 - Current
- Oracle database creation and cloning of production, test and development instances
- Monitoring databases for capacity and performance and providing user support
- Tuning Oracle SQL queries, Oracle SGA Components for the Data warehouse and OLTP instances
- Tablespace Management, User Management and Network Management
- Configure Standby databases for disaster recover site
- Creating and scheduling UNIX shell scripts for automation of various database activities
- Creating, splitting, merging and dropping partitions
Database Lead
Prokarma
10.2010 - 09.2014
- Lead a team of 30+ members consisting database architects, DBAs, SQL developers, and BI/ETL developers
- Gathering requirements for database objects, PL/SQL code and ETL process by collaborating with client application teams, and business analysts
- Member of a DBA team managing 700+ non-RAC databases and 100+ RAC databases which include development, test and production databases
- Database schema design, normalization, data modeling, and providing enhancements as per new features of applications
- Upgrade (10g to 11g) and migration (HP-UX/AIX to Linux) of Oracle databases
- Reviewing and approving database changes to production, impact analysis, and ownership of change management
- Mentoring team members, skill assessment, and providing training as needed
- Writing and reviewing technical specification documents for PL/SQL and ETL development tasks
- Managing escalation of Oracle, MS SQL Server administration teams
- Catalyst for innovative solutions as head of COE team of data technologies
- Moderated articles/white papers authored by subject matter experts
- Building POCs on Hadoop/Big Data technologies and assisting marketing team to materialize project contracts
Education
Master of Business Administration -
Symbiosis University of Technology
Bachelor of Technology - Computer Science and Information Technology
JNTU
Skills
- Database Administration
- Backup and recovery
- Performance Tuning
- NoSQL Databases
- Patch management
- Data Modeling
- Relational Database Management
- Relational databases
- Database documentation
- Big data technologies
- Database monitoring
- Security report management
- Capacity Planning
- Data Migration
- Agile Methodology
- Data integration
- Writing queries
- Systems administration
- Database analysis
- Disaster Recovery
- Database Management
- Linux Operating System
- Continuous Process Improvement
Certification
- Cloudera Certified Administrator for Apache Hadoop (CCAH)
- Oracle database 10g Administrator Certified Associate
Skillmatrix
Oracle, Microsoft SQL Server, Postgres, DB2, Teradata, MySql, Hbase, MangoDB, Cassandra, Oracle, Azure, AWS, Shell, Python, R, Bash, PLSQL, T-SQL, Perl, Installation, LVM, RAID, RPM/Yum, Apache, Configuring DNS, DHCP, iptables, Informatica Power Center, Snowflake, OBIEE, Tableau, Building cluster using Cloudera/Hortonworks distributions, MapReduce, YARN, Hive, Hbase, Spark, VMWare Workstation, Virtual Box, CA Erwin, Enterprise Architect
Timeline
Database Administrator
Concentrix
09.2014 - Current
Database Lead
Prokarma
10.2010 - 09.2014
Master of Business Administration -
Symbiosis University of Technology
Bachelor of Technology - Computer Science and Information Technology
JNTU
Similar Profiles
Yaswanth VasudevanYaswanth Vasudevan
Application Support Engineer at ConcentrixApplication Support Engineer at Concentrix
OMOLABAKE GANIYUOMOLABAKE GANIYU
Technical Support Representative at ConcentrixTechnical Support Representative at Concentrix
Ashwanth NairAshwanth Nair
Senior Operations Representative at ConcentrixSenior Operations Representative at Concentrix
Hadi Al-YasinHadi Al-Yasin
Customer Service Agent at ConcentrixCustomer Service Agent at Concentrix
ABHISHEK JAINABHISHEK JAIN
software development, Database Administrator & Manage 13 Government Medical College Database at ITSC Technologies Pvt. Ltdsoftware development, Database Administrator & Manage 13 Government Medical College Database at ITSC Technologies Pvt. Ltd