Ganesh Kumar Redddy Singam
Oracle DBA, Exadata DMA, ODA, Postgres, MySQL DBA
Hire this person
Send a job offer directly to this candidate
About
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
Experience
- Supporting 4000+ databases with a team of 12 resources.
- Monitoring database alerts on availability, wait events, database contention
- Monitoring the RECO usage on DB Nodes.
- Creating and dropping GRPs in database
- RMAN refresh when full database is requested.
- Building standby databases / RAC databases on project basis.
7.
Managing Exadata
Grid disks, Cell disks.
- Creation of indexes / recommending indexes to customer
- Monitoring RMAN incremental backups daily, weekly full backups and weekly full database logical backups using datapump.
- Working on automation of some of the tasks including running the data modification requests.
- Working on shell scripting and troubleshooting already existed scripts.
- Monitoring the Materialized Views and their auto refresh daily.
- Monitoring the goldengate process and starting the Replicat, Extract or Manager when they get stop.
- Syncing the standby / DR databases when there is huge gap
- Creating and monitoring the dataguard broker for already existing standby databases.
- Creating SQL Plan and SQL Patch where ever applicable.
- Findings RCAs for Exadata DB Node restarts, Database restarts
- Projects related to Oracle Autonomous database in OCI Gen2 for Fusion Applications.
19.
Configuring
MySQL 8.0 databases for some customers
- Moving data from External files to MySQL database tables
- Configuring indexes in MySQL where necessary
22.
Configuring
Oracle TDE and Datavault to Oracle databases
- Administering OCI Compute resources and VMs.
24.
Administrating Goldengate
Microservices for critical table replication
25.
Administrating
Oracle 23ai migrated databases
- Performing online table migrations between tablespaces
- Creating partitions with new partition in another tablespace when tablespace reached 1023 datafiles
- Oracle RDBMS Patching and GI Patching
- Working on OCI Services and OCI DBaaS Service Offerings
Education
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
