Rama Chandra Rao Gandikota
Hyderabad
Summary
Seeking a position to utilize my skills and abilities in the Information Technology Industry that offers professional growth while being resourceful, innovative and flexible.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead Database Administrator
Wipro Limited
02.2021 - Current
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in database migration from MyISAM format to InnoDB storage engine to increase performance and betterment of integrity constraints
- Expertise in Backend Query development
- Scheduling and Monitoring Pentaho ETL
- Experience of MongoDB replication configuration, configuring backups, Installation, upgradation, user management
- Configuring Percona Monitoring and Management(PMM)
- Preparing standard documentation for critical tasks like DR drills, version upgrades and Migrations
- Preparing standard documentation for Disaster Recovery plan
- Clients Handled: Equitas Bank, Trent, CanaraHSBC, Aditya Birla Group, Punjab National Bank, DSP
Senior Database Administrator
ISSQAURED Inc
10.2020 - 02.2021
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
- Expertise in Backend Query development
- Scheduling and Monitoring Pentaho ETL
- Configuring Sphinx Reindexing
- Configuring Percona Monitoring and Management(PMM)
- Project Handled: Illumina, Booking
Senior Database Administrator
Pole To Win
03.2020 - 10.2020
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Expertise with Shell Script for Linux
- Experienced in Database optimization and developing stored procedures, Triggers, Joins, Views, Unions : MySQL, MySQL Workbench, Razor SQL
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in snapshot, import/export, db optimization with the help of explain plan
- Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
- Expertise in Backend Query development
- Scheduling and Monitoring Pentaho ETL
- Configuring Sphinx Reindexing
- Configuring Percona Monitoring and Management(PMM)
- Dealing with SQL injection and suggesting developers aware of threats on application
- Preparing Standard DR plans documentation for every project
- Project Handled: Side, LMS, G1
MySQL Database Administrator
Navigant BPM PVT LTD
05.2019 - 03.2020
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Expertise with Shell Script for Linux
- Experienced in Database optimization and developing stored procedures, Triggers, Joins, Views, Unions : MySQL, MySQL Workbench, Razor SQL
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in snapshot, import/export, db optimization with the help of explain plan
- Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
- Expertise in Backend Query development
- Scheduling and Monitoring Pentaho ETL
- Configuring Sphinx Reindexing
- Configuring Percona Monitoring and Management(PMM)
- Project Handled: RevRemit, RevApp, RevReport, RevIndex, Pitstop, NavAudit
MySQL Database Administrator
Easypay PVT LTD
04.2017 - 11.2018
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Expertise with Shell Script for Linux
- Experienced in Database optimization and developing stored procedures, Triggers, Joins, Views, Unions : MySQL, MySQL Workbench, Razor SQL
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in snapshot, import/export, db optimization with the help of explain plan
- Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
- Expertise in Backend Query development
- Expertise in Automated Jobs according to client's requirement
- Strong MariaDB RDS skills on AWS Based servers
- Project Handled: Flash Sales grocery portal for Metro, Wow for online grocery App, Paisa Nikal for Yesbank Based Server, RKB 2.0 for Yesbank Based Server
MySQL Database Administrator
ABV Infotech Pvt Ltd
06.2013 - 04.2017
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
- Strong MySql skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment
- Proficient writing shell scripts as well as knowledge in general systems administration tasks
- Expertise with Shell Script for Linux
- Experienced in Database optimization and developing stored procedures, Triggers, Joins, Views, Unions : MySQL, MySQL Workbench, Razor SQL
- Experienced in Performance Tuning, Client/Server Connectivity, and Database Consistency Checks using different Utilities
- Expertise in snapshot, import/export, db optimization with the help of explain plan
- Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints
Education
B Tech - ECE
ADAMS Engineering College
M.P.C -
Board of Intermediate Education
S.S.C -
Triveni Talent School
Skills
- MySQL server
- MYSQL workbench
- MySQL Command line
- SQLYog Ultimate
- Razor SQL
- Shell Script
- Data Dictionaries
- Database design and implementation
- Data Migration
- Back-up and recovery
- Windows XP
- Windows 7
- Windows 8
- Windows 81
- Windows 10
- Windows Vista
- Ubuntu
- Centos
- Percona Monitoring and Management tool
- Sphinx Re-indexing tool
- Pentaho ETL
- Service Now Ticketing tool
- MongoDB Server
Accomplishments
- Stood at first place in Annual District Dance & Curriculum Activities(Khammam District)
- Conducted dances classes in School and College Activities
Languages
English
Hindi
Telugu
Achievements And Certification
- Received 'Best Appreciations' & 'Best Performer' from Clients
- Certified on MS Office Tools and Raspberry Pi Conducted training sessions in Schools and Institutes
Hobbies and Interests
- Dancing
- Watching Movies and Cricket
- Internet Surfing
Personal Information
- Father's Name: Venkata Rao Gandikota
- Mother's Name: Neetha Devi Gandikota
- Date of Birth: 08/20/92
- Gender: Male
- Marital Status: Married
Certification
Oracle Certified Professional, MySQL 8.0 Database Administrator
Timeline
Lead Database Administrator
Wipro Limited
02.2021 - Current
Senior Database Administrator
ISSQAURED Inc
10.2020 - 02.2021
Senior Database Administrator
Pole To Win
03.2020 - 10.2020
MySQL Database Administrator
Navigant BPM PVT LTD
05.2019 - 03.2020
MySQL Database Administrator
Easypay PVT LTD
04.2017 - 11.2018
MySQL Database Administrator
ABV Infotech Pvt Ltd
06.2013 - 04.2017
M.P.C -
Board of Intermediate Education
S.S.C -
Triveni Talent School
B Tech - ECE
ADAMS Engineering College
Similar Profiles
Sachi KumbhareSachi Kumbhare
Business Analyst at Wipro LimitedBusiness Analyst at Wipro Limited
Veera Prasad BeerellyVeera Prasad Beerelly
Automation Practice Head at Wipro LimitedAutomation Practice Head at Wipro Limited
Gurudatta MishraGurudatta Mishra
Technical Lead at Wipro limitedTechnical Lead at Wipro limited
ARAVIND BETHAPUDIARAVIND BETHAPUDI
Project Manager at Wipro LimitedProject Manager at Wipro Limited
ARAVA ANANTHA RAOARAVA ANANTHA RAO
Information Security Manager at Tata Consultancy ServicesInformation Security Manager at Tata Consultancy Services