SAINATH KURAPATI

• Reduce operational cycle time and drive simplification through implementation to automation solutions
• Partner with Oracle ERP application teams, shared services, core technology peers and Oracle in design, development, implementation and operational support of Oracle ERP technology solutions
• Manage architecture and operations activates to ensure ERP compute infrastructure is used efficiently and produces a long – term business benefit.
• Assist complex solution sizing of Oracle ERP technology components (O/S, Infrastructure, Database, Application, HA/DR, Backup)
• Strong verbal and written communications skills.
• Support Mission critical production environment along with Validation, Test and Development environments
• Supporting Oracle EBS 12.2.x Database 19c RAC and Data Guard Databases along with other applications and databases
• Automating routine DBA tasks using python, shell scripts
• Provide solution to improve system Performance tuning/optimization
• Oracle DB & eBusiness Suite (EBS) cloning, Patching, Upgrade
• Backup & Restore of Database and Applications
• Maintain and Support to Keep DR system in sync with prod
• Manage AWS infrastructure including architecting AWS along with networking.
• Expert in Oracle MSCA and Partner solutions.
• Configured SSO for Oracle EBS 12.2.11.
• Enabled TLS and Loadbalancer on AWS for EBS 12.2.11.

• Built exacs databases on OCI.
• Expert in installing and supporting Goldengate on OCI.
• Upgrading databases to newer version on OCI.
• Creating and configure VCN and establish cross tenancy communication using VCN
and RPC.
• Expert in setting VCN CIDR, Route tables, Security lists, policies etc.
• Working experience using and developing terraforms.
• Working experience on creating and managing Autonomous databases(ATP,ADW) on
OCI.
• Experienced on enabling Database management feature.
• Experienced on enabling Database management feature.
• Good knowledge on Networking.
• Expert in configuring OEM for EXACS and Autonomous databases and setting alerts.
• Expert in patching cloud databases

• Built and maintained network infrastructure consisting of Windows, Linux and virtual products.
• Collaborated with clients to determine need and devise appropriate software and hardware solutions.
• Contributed to requirements gathering and analysis for design and production projects.
• Performed root cause analysis to provide resolutions for production issues.
• Configure and maintain network services, including backup and recovery and maintaining web servers in Linux environment.
• Optimizes system operations and resource utilization and performs system capacity analysis and planning.
• Oracle eBusiness Suite and associated Technical Stack patch analysis, planning and application.
• Maintain and develop backup/recovery process for Oracle eBusiness Suite installations, using RMAN, BCV or scripts for online and offline backups and disaster recovery.
• Provide support to developers with trouble-shooting and performance tuning, including SGA analysis, latch contention analysis, disk subsystem tuning and SQL tuning of Oracle and custom views and queries.
• Develop and improve procedures for monitoring (Enterprise Manager) and proactive intervention, preventing customer impact.
• Install, configure, patch, and, clone RAC and non-RAC Oracle databases.
• Created document management protocols and presented to management for review.

• Environment: Oracle R12 (12.2) Applications DBA with Weblogic, OAM, OID, DMZ, Perform daily administration support for EBS 11i ,R12,R12.2.
• Handson experience with SAML 2.0, WS-Trust, OAuth2.0, OpenID Connect.
• Perform daily troubleshooting for Weblogic.
• Expert on Oracle Cloud Infrastructure.
• Perform Lift and Shift of EBS 12.1 and 12.2 to OCI using Cloud Manager.
• Expert in Designing OCI security rules, creating compartments, grouping resources, administering OCI related jobs.
• Expert in IDM integration.
• Expert in database and middle tier performance.
• Responsible for multiple application support.
• Expert in DMZ, SSL setup.
• Expert on WebAdi with EBS 12.2 and 12.1.
• Expert in Mobile Application design and support.
• New Environments Build/Setups Integrating E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM ) Worked on DMZ setups to E-Business Suite Worked on Standby site setups for both applications and databases Interact with Network/OS teams on network setups and load balancer setups.
• Failover capabilities testing of E-Business Suite and database Design Cloning strategies.
• Setting up E-Business Suite with Oracle Access Manager/OID to achieve Single Sign-On (SSO) Capabilities.
• Worked with Oracle Utility products implementation project as a DBA lead.
• Responsible for the complete Architecture setup for CG client.
• Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
• Involving in Database and Application performance issues including Weblogic issues.
• Configuring DB alerts using Crontab.
• Database restoration and recovery using RMAN.
• Configuring RMAN backups.
• Oracle 11gR2 RAC installation.
• Oracle Database installation, Maintenance and support.
• Hands on working experience on 12.2environments.
• Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node.
• RAC to Non RAC and RAC to RAC using Rapid Clone.
• Expertise in Oracle Apps 12.2 Patching using ADOP.
• Working in an Oracle AppsR12.2 Implementation project with Exadata and Exalogic architecture.
• Support of Oracle Utility Products DBA Support.
• Installed and Configured Oracle Databases 11gR2 and Oracle Utility Applications CCB, WAMS, MDM.
• Installed and Configured ASM, Migrated Non-ASM Databases to ASM.
• Implemented Oracle RAC.
• Installed and Configured Oracle Dataguard Physical Standby.
• Installed and Configured Oracle Weblogic for Oracle Utility Applications.
• Experience in Oracle Weblogic Clustering.
• Did a complete setup of the servers at Data Center.
• Performing Database/Schema level Refreshes using expdp/impdp and RMAN.
• Automated the process of Daily Schema Level Refresh from Production DB to Replica DB.
• Involved in Configuring OEM.
• Monitoring the Databases.
• Automated the Daily Health check report.
• Configured SQL Plan Management.
• Oracle 11gR1, 11gR2, RMAN, OEM Grid Control 12c, Data Guard.
• Responsibilities: Perform daily administration support for database backups, performance tuning and monitoring Responsible for multiple application support.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Tablespace Point In Time Recovery using RMAN.
• Performed BCP testing with and without using Broker.
• Performed 24.
• On-call production DBA.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Authored and coded logical and physical database descriptions.
• Managed quality assurance program, including on-site evaluations, internal audits and customer surveys.

• Environment: Oracle 11gR1, 11gR2, RMAN, OEM Grid Control 12c, Golden Gate 10.0, Data Guard, Exadata Responsibilities: Worked as 24.
• 7 oncall Production support DBA Perform daily administration support for database backups, performance tuning and monitoring Performed refreshes, responsible for application support.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Worked on ASM Builds and Cluster Builds.
• Supported Goldengate in Exadata environment.
• Oracle R12 (12.2,12.1) Applications DBA skills including upgrade, platform migrations, tuning, and management of complex 24×7 environments.
• Oracle Applications in the DMZ.
• Oracle Applications Integration with OID and OAM.
• Oracle EBS R12.1/R12.2 & 11gR2/12c DBA skills for management of complex 24x7 environments and installation, upgrade, load balanced application server, and disaster recovery experience.
• Expert in Oracle Weblogic.

• Environment: Oracle 11gR1, 11gR2, RMAN, OEM Grid Control 12c, Golden Gate 10.0, Data Guard.
• Responsibilities: Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Perform daily administration support for database backups, performance tuning and monitoring Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Standby database setup via 10g data guard for database Disaster Recovery.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Online/Offline Database Backups and managing database recovery with RMAN.
• Performance tuning via OEM, STATSPACK/AWR for 9i/10g/11g.
• Maintenance tasks like bouncing the production database, services through veritas.
• Effective in gathering the statistics for pinning the objects.
• Resolving listener and tnsnames.ora issues.

• Responsible for both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Perform daily administration support for database backups, performance tuning and monitoring Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc. Standby database setup via 10g data guard for database Disaster Recovery.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN. Performance tuning via OEM, STATSPACK/AWR for 9i/10g/11g.
• Maintenance tasks like bouncing the production database, services through veritas.
• Effective in gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.