Mohan Reddy

Mohanreddyyadamuridb

• Having Experience in performing DBA activities among ORACLE RAC and ASM around 14+ years.
• Having experience in a 11G/12c/18c/19c database with pluggable and container database concepts.
• Having Experience in MS SQL Server Log Shipping, Database Mirroring, Always-ON, Clustering configuration 4+ years
• Having Experience in MySQL Database Administration and install software (PHPMyAdmin) around 3+ years
• Having Experience on PostgreSQL Enterprise Database Administration (PGAdmin) around 4+ years
• Ample Experience in RAC setup, performance tuning and backup administration & DB administration.
• Ability in Creation of oracle DB users, oracle roles and profiles, granting privileges etc.
• Maintaining physical and logical backups via User Managed& RMAN Backups and Recoveries.
• Installation and configuration of Oracle 11g,12c & 19C on Linux/OEL, Sun Solaris, Hp-Ux & windows.
• Using utilities exp, imp, expdp/impdp, RMAN, sqldev, logminer, dbv & Oracle Grid Control OEM. 
• Monitor DB space utilization and foretell about upcoming growth using Enterprise Manager.
• Expertise working on medium & large projects encompass noble conduct in prof/personal.
• Knowledge in UNIX installation and configuration, Shell scripting, commands and automation.
• Experience in Installation of oracle DB server/client software, Database Creation, Upgrade & Migration.
• Database Cloning, Data Guard, RAC with ASM, Install em-agents, OEM Grid, Streams & Golden Gate Software.
• Experience in BCV Concepts Production (primary) To Mirror (secondary) instead of logical/physical Standby DB’s.
• Closely monitor the critical Prod databases using OEM Performance graph, DB alert logs, and Oracle Cluster logs.
• Monitor CPU usage, Memory usage, DB size usage, Archive destinations, Oracle Base destinations usage.
• Check Server level wait I/O, load avg, tps, redo sync data file sync & all related to performance tuning & stuff.
• Skills in Third party backup tools using GUI VERITAS Netback up, Hp data protector, Networker and Tivoli.
• Having Involvement in Oracle Apps DBA (EBS suite Applications) about 4+ years of knowledge.
• Space Management, Database security, Performance Management, troubleshooting, Database Migrations
• Using Enterprise dB Migration Tool Kit (MTK) and EDB Replication server for migration from oracle to PostgreSQL
• MySQL Replication for High Availability, MySQL Asynchronous/Semi-synchronous replication.
• MySQL 5,8 Administration, MySQL Workbench, MySQL Enterprise Monitor, SQL logs
• MySQL NDB Cluster Installation, Administration, Percona XtraDB cluster implementation with Proxysql load balancer
• Partaking trained for IBM DB2, Microsoft SQL SERVER, MYSQL and Postgress SQL Administration Activities. 
• Knowledge in Oracle Cloud computing concepts, Exadata, Oracle Virtualization, big data, Greenplum & MongoDB etc.
• Hands on experience in 12c database, OEM Grid, 12C Express & Golden Gate technologies.
• Having experience working overseas like Singapore (UBS, GLOBALFOUNDRIES), Kuala Lumpur and Indonesia.
• Installation of 12c database and 12C centralized Grid/Agents for new and existing databases without Downtime.
• Have been given corporate training for Oracle DBA, ASM, RAC, Data guard & Oracle 12C DB and OEM.
• Experience in Oracle Real Application Testing using Capture /Replay & simulating load and oracle sql tuning Analyser.
• Oracle Cloud Infrastructure 2018 Certified Architect Associate & Microsoft Certified: Azure Administrator Associate
• Working experience with API interfaces (JMS Adapter, ActiveMQ, JBOSS, WebSphere, SOAP, SFTP)
• Knowledge on CCM & experience to plan-works scheduling for changes implementations and deployments

• Post-Graduation in Master of Computer Applications (MCA)from Osmania University-HYD-IND-2007
• Graduation in Bachelor of Science in MPCS (BSC) from Sri Venkateswara University-TPT-IND-2004