Ganesh Kumar Redddy Singam

Myself, Ganesh currently working with Oracle India as Oracle and Exadata DBA. I am having total of 15 years of experience in Oracle, MySQL, Exadata, Goldengate, RAC, Postgresql, OCI, AWS

1. Supporting 4000+ databases with a team of 12 resources.
2. Monitoring database alerts on availability, wait events, database contention
3. Monitoring the RECO usage on DB Nodes.
4. Creating and dropping GRPs in database
5. RMAN refresh when full database is requested.
6. Building standby databases / RAC databases on project basis.
7. Managing Exadata Grid disks, Cell disks.
8. Creation of indexes / recommending indexes to customer
9. Monitoring RMAN incremental backups daily, weekly full backups and weekly full database logical backups
using datapump.
10. Working on automation of some of the tasks including running the data modification requests.
11. Working on shell scripting and troubleshooting already existed scripts.
12. Monitoring the Materialized Views and their auto refresh daily.
13. Monitoring the goldengate process and starting the Replicat, Extract or Manager when they get stop.
14. Syncing the standby / DR databases when there is huge gap
15. Creating and monitoring the dataguard broker for already existing standby databases.
16. Creating SQL Plan and SQL Patch where ever applicable.
17. Findings RCAs for Exadata DB Node restarts, Database restarts
18. Projects related to Oracle Autonomous database in OCI Gen2 for Fusion Applications.
19. Configuring MySQL 8.0 databases for some customers
20. Moving data from External files to MySQL database tables
21. Configuring indexes in MySQL where necessary
22. Configuring Oracle TDE and Datavault to Oracle databases
23. Administering OCI Compute resources and VMs.
24. Administrating Goldengate Microservices for critical table replication
25. Administrating Oracle 23ai migrated databases
26. Performing online table migrations between tablespaces
27. Creating partitions with new partition in another tablespace when tablespace reached 1023 datafiles
28. Oracle RDBMS Patching and GI Patching
29. Working on OCI Services and OCI DBaaS Service Offerings

BE in Computer Science from Osmania University, Hyderabad, India [2006-10]
M.Tech in Software Systems from BITS-Pilani, India [2013-2015] [Online Mode]
Oracle Certified Professional: 12c (OCP)
EXIN ITIL V3 Foundation Certified.
EXIN Cloud Computing Foundation Certified.
Oracle Certified Expert: Exadata X3 & X4 Administration (OCE)
Oracle Database Cloud Administrator Certified Professional
Oracle Database Cloud Service Operations Certified Associate
Nasscom Certified Python Developer
MySQL 8.0 Certified Professional Admin
Oracle Goldengate Certified Specialist: 12c
OCI Multicloud Professional Certification
OCI Foundation Associate Certified
OCI Architect Associate Certified