Samiyappan Ganesan

Having 9 years of experience in IT industry mainly comprising of Database Administration Postgresql DBA and Oracle DBA, AWS.
Having hands on experience in Installation, Administration and Troubleshooting of Postgresql 11/12/13, Oracle 19c/18c/12c/11g/10g for Clusters, Non - cluster and ASM. Database in production, development and Testing Servers. Experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Configured Disaster recovery databases using Data guard
Experience in Installation, configuration of PostgreSQL 11/12/13 databases.
Automated Backups, Data pump, cloning, space management, database security, cloning, migration AWS RDS, AWS EC2 and documentation. Proficient in supporting databases running on UNIX, O.E.L, R.H.E.L, Centos
Installing database security patches, backup and recovery operations.
Experience on Restore/Recover of PostgreSQL cluster databases in AWS RDS.
Experience on  upgrade of PostgreSQL databases.
Having experience on DMS.
Have performed the Disaster Recovery test.
Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
Having sound analytical and problem solving skills and has ability to co-operate with a team. Experienced in the field of effectively handling oracle utilities such as RMAN, Export/Import and Data Pump etc.
Have maintained Dataguard, RAC databases on EXADATA environment.
Having working knowledge on Refresh, Cloning, Upgrade, Patches on standalone as well RAC.
Have log analysis using pgbadger tool and query tuning.
Worked extensively on Performance tuning of Queries. 
 

Having 9 years of experience in IT industry mainly comprising of Database Administration Postgresql DBA and Oracle DBA, AWS.
Having hands on experience in Installation, Administration and Troubleshooting of Postgresql 11/12/13, Oracle 19c/18c/12c/11g/10g for Clusters, Non - cluster and ASM. Database in production, development and Testing Servers. Experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Configured Disaster recovery databases using Data guard
Experience in Installation, configuration of PostgreSQL 11/12/13 databases.
Automated Backups, Data pump, cloning, space management, database security, cloning, migration AWS RDS, AWS EC2 and documentation. Proficient in supporting databases running on UNIX, O.E.L, R.H.E.L, Centos
Installing database security patches, backup and recovery operations.
Experience on Restore/Recover of PostgreSQL cluster databases in AWS RDS.
Experience on  upgrade of PostgreSQL databases.
Having experience on DMS.
Have performed the Disaster Recovery test.
Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
Having sound analytical and problem solving skills and has ability to co-operate with a team. Experienced in the field of effectively handling oracle utilities such as RMAN, Export/Import and Data Pump etc.
Have maintained Dataguard, RAC databases on EXADATA environment.
Having working knowledge on Refresh, Cloning, Upgrade, Patches on standalone as well RAC.
Have log analysis using pgbadger tool and query tuning.
Worked extensively on Performance tuning of Queries. 
 

BE, Computer science and Engineering