Manager Assistant

Oracle APPS DBA

EMAIL:adcp7a@r.postjobfree.com

MOBILE: 937-***-****

•Oracle linux Implementation Specialist Certified.(ORACLE TESTING ID:OC1559945)

•Oracle Certified Associate

•Oracle Weblogic Certified Associate

https://www.linkedin.com/in/sainath-kurapati-276983111/

Professional Summary:

7+ years of experience in Oracle database administration in Linux platforms. Experience include Installation, Upgradation, Migration, Memory Management, System maintenance, Cloning, patching, user support, TAR management, Database security, Troubleshooting database design, Documentation, Backup and Recovery and supporting Application deployment.

Areas of Expertise:

•Experience in Design, Development, Integration and Testing of Oracle EBS 11i,12.1.x,12.2.x.

•Expertise in Installations/upgrades, Migration and monitoring of Oracle EBS 11i,12.1.x,12.2.x. on Linux and Windows Environments.

•Installation/Upgrades: Oracle 11g, 12c,19c database Upgrades, Installation.

•Expertise in Monitoring of Oracle OEM 12c (12.1), Administration, configuration, OEM 11g/12c Installation, 11g OEM to 12c OEM Upgrades.

•worked on migrating EBS 12.1 and 12.2 versions on cloud using cloud manager on OCI.

•Expertise in using 12c, 11g features Active data guard/snapshot standby, and 10g Features DATA Pump, Flash back recovery, AWR, ADDM, while building database.

•Expertise on IDM Integration(OAM,OID)

•Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors and different versions of UNIX.

•Worked with projects/operations/professional services team and co-ordinated multiple tasks at hand with expertise and solid plan

•Experience with DMZ Setup, Load Balancer, Reverse Proxy.

•Experience with Weblogic, Troubleshooting, monitoring, install.

•Experience in bi-directional and broadcast replication from source to target Databases using Golden Gate.

•Upgraded existing, high available production Oracle databases by DBUA and manual upgrade method to PSU patch set updates 11.2.0.3, 11.2.0.4 from 11.2.0.1.

•Capable of tuning SQL using EXPLAIN PLAN, DB Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and tracing at user level and TKPROF.

•Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )

•Possess good leadership, excellent communication and time management and presentation skills with excellent technical, analytical, interpersonal, problem solving and organizational skills.

•Expert with Oracle Application Architecture and Oracle Application\Database support.

•Database design and data modeling background required

•Experience in database performance tuning required

•Experience in database backup and recovery required

•Experience in database upgrades required

•Experience in all aspects of the software development lifecycle including: requirements gathering, design, coding, testing and production support

•Experience in developing new and enhancing existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs

Technical Skill Set:

Databases: Oracle 12c/11g/10g

Oracle Tools: Enterprise Manager (OEM),

Operating Systems: Linux, Sun Solaris 8, Win NT 4.0.

Languages: SQL, PL/SQL, C, shell scripting, perl, awk, Html, DHtml, Java.

Application Tools: VMware, MS Office, MS Visio.

Professional Experience:

•Company : Leiutis Pharmaceuticals May’2012 – Dec’2012

Role : Jr. Oracle DBA

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.

•Company : Mansanto July’2014 – Oct’2014

Role : Jr. Oracle DBA

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.

•Company : Wellsfargo Nov’2014 – Nov’2015

Role : Oracle DBA

Environment: 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*7 oncall production dba.

•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.

•Company : Oracle Dec’2015 – Till Date

Role : Sr.Oracle APPS DBA

Environment: Oracle R12 (12.2) Applications DBA with Weblogic, OAM,OID,DMZ

Responsibilities:

•Perform daily administration support for EBS 11i,12.1,12.2.x .

•Perform daily troubleshooting for Weblogic.

•Expert in IDM integration.

•Expert in database and middle tier performance.

•Responsible for multiple application 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.

•Expertise on EBS Cloud on Both OCI and OCI-C.

Education & Training:

•Masters in science from Southern Illinois University Carbondale, IL, USA.

•Bachelor of Technology in Engineering from Jawaharlal Nehru Technological University, AP, India.

•Oracle linux Implementation Specialist Certified.

•Oracle Certified Associate

•Oracle Weblogic Certified Associate

•Workshop on working within a Team.

•Infrastructure Production Support.

Contact this candidate