Pramodh Reddy Email & Phone Number

Oracle Administration:- Managed Oracle12c and Oracle11g databases on Exadata Engineered Systems, supporting OLTP and OLAP applications.- Led database migrations from 12c to 19c across multiple OS platforms and upgraded databases from 11g/12c to 19c.- Optimized performance in Very Large Databases (VLDB) using Advanced Partitioning and Advanced Compression techniques.- Extensive experience in setting up and maintaining cloud infrastructure for Oracle databases, including migrations between on-premise data centers and cloud environments (AWS, Oracle Cloud).- Automated database maintenance using Shell and PL/SQL scripts, resolving complex issues in both development and production Oracle databases.Oracle GoldenGate Administration:- Installed, managed, and patched Oracle GoldenGate on 12c (12.1 and 12.2), upgrading to version 12.3 across multiple hosts.- Developed Shell scripts to monitor GoldenGate replication environments and implemented replication for critical data auditing.- Migrated and optimized Oracle databases on AWS, ensuring high availability, performance tuning, and robust backup/recovery procedures.Datastax Administration:- Migrated SQL Server databases to Datastax clusters for ePayments OLTP applications, enhancing system performance and scalability.- Managed Datastax databases, including the creation of tables, views, and SOLR indexes, and set up role-based access control, encryption, and session management for database security.- Implemented disaster recovery solutions and developed robust backup, recovery, and restore processes using Datastax OPS Console.Environment: Oracle Exadata 12c, SQL, PL/SQL, Oracle GoldenGate 12c, Oracle Enterprise Manager Grid Control 13c, Linux Redhat, AIX, Shell Scripting, ASM Filesystem, Exadata X4-X6, Datastax.

PostgreSQL Administration:- Provided 24x7 PostgreSQL database support, including administration, backup/recovery, schema maintenance, performance tuning, and space management.- Installed, configured, and maintained PostgreSQL servers, applying updates, maintenance packs, and patches.- Delivered on-demand support for database refreshes by cloning production databases to lower environments for testing.- Implemented high availability solutions, including Load Balancing, using pgcluster, pgpool, pgbouncer, and repmgr.Oracle Administration:- Managed Oracle12c and Oracle11g databases on Exadata systems for OLTP/OLAP applications, ensuring optimal performance and reliability.- Created and managed database objects (datafiles, transaction logs, tables, views, indexes) and implemented Advanced Partitioning/Compression in VLDB environments.- Installed and maintained Oracle12cR2/11gR2 RAC environments with disaster recovery solutions using Physical Dataguard on ASM Filesystems. Oracle GoldenGate Administration:- Managed cross-platform database migrations and upgrades for Oracle/SAP HANA/DB2 databases using Oracle GoldenGate.- Installed, upgraded, and managed Oracle GoldenGate on 12c, implementing unidirectional replication for production systems.- Led GoldenGate projects, including heterogeneous replication between Oracle, SAP HANA, DB2, and Hadoop environments.- Utilized KAFKA and GoldenGate for streaming data across RDBMS for real-time reporting and auditing purposes.- Configured and monitored multi-directional GoldenGate replication and optimized performance through scripting and proactive monitoring.Environment: PostgreSQL9.6–10.1, Oracle Exadata 11g/12c, SQL, PL/SQL, Oracle GoldenGate 12c, Peoplesoft9.x, Oracle Enterprise Manager Grid Control 12c, Linux Redhat Server, AIX, z/OS, Shell Scripting, ASM Filesystem, Exadata X4–X6, Bigdata, Hadoop.

- Managed 115 Oracle production, testing, and development databases with a team of 3 DBAs.- Led migration and upgrade projects, including Oracle8i/9i to Oracle10g and cross-platform migrations from SUN OS to Linux RHEL.- Implemented Oracle10g RAC with disaster recovery (Physical Dataguard) for high availability and scalability, using custom scripts for RAC node addition.- Developed and maintained fully operational scripts for DR site creation (Physical/Logical Dataguard).- Designed and implemented Grid Control for enterprise monitoring and management, working collaboratively with 5 DBAs.- Optimized database performance using advanced partitioning, backup/recovery strategies, and tools like RMAN, TKPROF, and STATSPACK.- Automated cloning processes with cronjobs for production databases, streamlining weekly and monthly refreshes.- Migrated Oracle databases from SUN OS to RHEL, improving efficiency with RMAN scripts for Endian transport.- Installed and patched Oracle8i/9i databases (300GB - 600GB), and optimized database performance through export/import processes, index creation, and query analysis.- Enhanced database performance using tools such as EXPLAIN PLAN, HINTS, and TKPROF, ensuring optimal query performance.- Set up and configured Oracle 10g databases on Sun Solaris and Linux environments, supporting both production and development environments.Key Tools & Technologies: Oracle10g, Oracle8i/9i, RMAN, RAC, Physical Dataguard, Sun Solaris, Linux RHEL, Grid Control, TKPROF, EXPDP/IMPDP, Transportable Tablespaces, Shell Scripts, PL/SQL.