Prem Kishan Gorityala

Prem Kishan Gorityala Email and Phone Number

Sr. Oracle DBA @ Oracle
Prem Kishan Gorityala's Location
Pea Ridge, Arkansas, United States, United States
Prem Kishan Gorityala's Contact Details

Prem Kishan Gorityala work email

Prem Kishan Gorityala personal email

n/a
About Prem Kishan Gorityala

11+ years of experience in the IT Environment as an Oracle Database Administrator.9+ years of experience in Golden gate.Extensive experience in Configuration and troubleshooting of Oracle Golden Gate 19c,12c and Oracle Streams.Experience in patching, upgrading of RAC and NON-RAC from 11g to 12c/19c.Skilled in dealing with ASM environment such as Installation, configuration, and conversion from NON-ASM to ASM environment.Expertise in converting database from NON-RAC TO RAC.Expertise on 19c/18c/12c/11g/10g RAC Installations, Upgrade to Grid 19c & Patch set Upgrades.Proficient with Physical & Logical Standby Database, Data Guard, DG broker, snapshot standby.Experienced in Disaster Recovery setup, Switchover, Failover and FSFO operations.Experience in setup and maintaining Database Security - SOX, auditing, TDE and SSL.Proficient in performance tuning, database optimization using Explain Plan, STATSPACK, SQL_TRACE, TKPROF.Performance Management, Partitioning of large table for better performance.Experience in upgrading database from 11g to 19c, Non CDB to CDBInstalled and configured oracle Pluggable (PDB) & container (CDB) databases on 19c/12c.Excellent experience in installing and configuring oracle RDBMS and oracle client softwares using SILENT INSTALLATIONS and SOFTWARE CLONING.Experience with Oracle 19c/12c/11g/10gRAC in manufacture, insurance, financial, telecom and banking industries in both Business Intelligence/Data warehouse Systems and OLTP Systems.Excellent experience in database migrations from standalone to 11gR2 ,12.1.0.2.0, 19c RAC & cross platform migrations.Excellent experience in implementing Data masking in Oracle 11g, 12c,19c databases.Expertise on installation & Configuring 11g ,12C ,13C OEM Oracle Grid Control, Quest central and Quest Fog light for databases.Experience in Writing Perl Scripting, Shell Scripting, bash scripting and Partitioning.Experienced in Developing Oracle 19c/12c/11g/10g PL/SQL Packages, Dynamic SQL, Triggers, Stored Procedures,Functions, DDL, and DML.Experienced in administration setup, data migration and data dictionary reconciliation.Oracle Database capacity planning, space management and storage allocation.Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN & HOT BACKUP methods.Experience working on various databases, such as Oracle, MongoDB, MySQL, and cloud technologies, such as AWS. In Depth knowledge of AWS Cloud service like Compute, Network, Storage and Identity and Access ManagementExperience working with GitLab, Jenkins, and AWS/Open stack.

Prem Kishan Gorityala's Current Company Details
Oracle

Oracle

View
Sr. Oracle DBA
Prem Kishan Gorityala Work Experience Details
  • Oracle
    Site Reliability Engineer
    Oracle Jan 2024 - Present
    Austin, Texas, Us
    View
  • Paypal
    Senior Oracle Database Administrator
    Paypal May 2018 - Jan 2024
    San Jose, Ca, Us
    Design, install, upgrade, maintain and tune Oracle 11g/12c/18c/19c Databases. Install and Configure Mission critical Oracle RAC 11g/12c/18c/19c clusters 2, 3 & 4 nodes. Installing the oracle databases by silent method and by using Perl & shell scripts to automate the process. Working and supporting complex Exadata Machines which have databases sizing over 300+ TB. Deep understanding about Exadata specified features such as Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache.Created 19c Multitenant databases and Pluggable DatabasesUpgraded databases from 11g to 19c and converted Non CDB to CDBPlugged in Non CDB database to 19c Multitenant. Performed the standalone and RAC upgrades from 11gR2 to 19c Develop data model, Oracle PL/SQL Queries, SQL Query tuning process, schema designing and validate user access on the database. Performance Maintenance for very highly complex databases which size over 300+ TB by analyzing the Explain Plan, AWR, ASH & ADDM Reports and optimization, define bottlenecks and manage testing and production implementation.Monitored the Health check of Productions databases over 50+ Size over 300 TB and ADG databases over 100+ size over 300 TB to 1 Pb.Patching the Complex RAC Clusters and databases with Zero or minimal Down time using rolling fashion method. Supporting complex Golden Gate replication and performance related issues to avoid the downtime or reduce the impact to minimal. Develop complex shell scripts for automation of database migration, upgrades, backups, administration, and maintenance tasks. Capacity planning, design and tune memory, system parameters to improve database and application performance. Design and implementation of Goldengate, Data Guard Replication technologies for real-timeBuild local and remote disaster recovery sites to provide high database availability and optimum site reliability. Implement database security options using Oracle Database Vault, Transparent Data Encryption (TDE)
    View
  • At&T
    Senior Oracle Database Administrator
    At&T Jan 2015 - May 2018
    Dallas, Tx, Us
    Installed and configured 2 & 3 node RAC cluster databases on Exadata x2-2 & x6-2 server.Managing, troubleshooting, and resolving oracle database, RAC, and applications issuesInstalled and configured Oracle 12C Release 2 Container (CDB) & pluggable (PDB) databases on Linux.Upgraded the Oracle 11gR2 databases to 12c databases on the AIX, Red hat Linux platform & Exadata.Performed the cross-platform data copy of 230TB data from Solaris to Linux environment using the Transportable Table space method TTS.Implementation of High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden GatePerformed the switch over and fail over scenarios for the ADG production databases on Quarterly Basis for 11g & 12c Databases.Expert in configuration and troubleshoot Golden Gate replication issues for high availability mission critical oracle databases.Expert in planning/implementing backup/recovery strategies using RMAN and without RMAN.Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, cluster, and system management.Configured Oracle Advanced Security Encryption Disk, Table & network level Encryption for the databases.Supported Amdocs billing Software applications on 12C databases on the AIX & HP Platform.Resolved performance issues by analyzing AWR, ASH & ADDM reports.Performance monitoring using OEM grid 13c, 12c & 11g.Flash Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).Created users and allocated appropriate table space quotas with necessary privileges and roles for Oracle databases.Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator.
    View
  • Allianz
    Senior Oracle Database Administrator
    Allianz Jan 2014 - Dec 2014
    Munich, De
    Database Migrations from non-Exadata to ExadataConfigured the Golden Gate for the mission Critical RAC ClustersConfigured PDB and CDB on Oracle 12C & Supported People Soft applications.Performed RMAN cloning using Active database feature in 11gR2 databases.Installed and configured Physical standby databases for 11gR2 databases.Configured the Active Data Guard and Data guard Broker. Configured Oracle Advanced Security data encryption and integrity features. Automated the Oracle database backup using Shell Scripting.Supported oracle databases for people soft, Sap applications, ATG Ecommerce applications and Siebel CRM.Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator.
    View
  • Lexisnexis
    Oracle Database Administrator
    Lexisnexis Dec 2012 - Dec 2013
    New York City, Ny, Us
    Installed and configured 2, 3 & 4 node oracle 10g and 11gR2 RAC on Red hat Linux 5 for databases upto 3TB on ASM. Performed Database Refreshes from Production to Test and Development environments using Clone process by RMAN Duplicate. Implemented data masking on columns having sensitive data using OEM.Installed and configured oracle standalone 11gR2 databases using Oracle Database Configuration Assistant (DBCA) and through silent Installations Method.Resolved performance issues by analyzing AWR & ADDM reports.Upgraded and Migrated Database from 10g to 11g and applying patches whenever required.Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications
    View
  • Jpmorgan Chase & Co.
    Oracle Database Administrator
    Jpmorgan Chase & Co. Oct 2012 - Dec 2012
    New York, Ny, Us
    Installed Oracle 10g/11g Databases and Applied PSU security Patches when Needed.Configured Oracle 2 Node RAC Clusters and worked on Node Eviction and cluster related issues.Configured the Active Data Guard and Performed the switch over and fail over scenarios on Quarterly Basis.Configured Golden Gate and worked on trouble shooting the Golden issues using the Log dump Utility.Performed data refreshes in UAT, DEV environments using Data Pump and Traditional Export & Import MethodMonitoring Tablespaces alerts, CPU usage, Health check of Databases and RAC Clusters.Resolved performance issues by analyzing AWR & ADDM reports.Database optimization using Explain Plan, STATSPACK, SQL_TRACE, TKPROF
    View

Prem Kishan Gorityala Education Details

  • Suny New Paltz
    Suny New Paltz
    Electrical And Electronics Engineering
  • Jawaharlal Nehru Technological University Hyderabad (Jntuh)
    Jawaharlal Nehru Technological University Hyderabad (Jntuh)
    Electronics And Communications Engineering

Frequently Asked Questions about Prem Kishan Gorityala

What company does Prem Kishan Gorityala work for?

Prem Kishan Gorityala works for Oracle

What is Prem Kishan Gorityala's role at the current company?

Prem Kishan Gorityala's current role is Sr. Oracle DBA.

What is Prem Kishan Gorityala's email address?

Prem Kishan Gorityala's email address is pg****@****pal.com

What schools did Prem Kishan Gorityala attend?

Prem Kishan Gorityala attended Suny New Paltz, Jawaharlal Nehru Technological University Hyderabad (Jntuh).

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.