Summary
Overview
Work History
Education
Skills
Websites
Certification
Career Abstract
Areas Of Exposure
Country Of Residence
Career Statement
Personal Information
Timeline
Generic

Pravin Kunwar

Senior Database and Application Administrator
Noida

Summary

Organised and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level [Job Title] position. Ready to help team achieve company goals.

Overview

9
9
years of professional experience
4
4
Certifications

Work History

Sr. Oracle APPS DBA

Rackspace Technology
04.2016 - Current
  • Working as a dedicated Oracle Database, Oracle EBS Application and Oracle Cloud Administrator
  • Responsible for Production and all non-production EBS application and database smooth functioning, good performance and availability round the clock
  • Supported Oracle Team for WSP On-Premise to OCI EBS migration
  • Built from scratch All non-production EBS system in OCI
  • Managed and supported Standalone Databases running on windows platforms
  • Completed an in-depth SQL Administration Training in February 2024 and ready to take responsibility on SQL Database administration and achieved a certificate
  • Developed a good understanding and managing a group of seniors DBAs over past few years for a 24/7 system support.

Sr. APPS DBA

Bahwan CyberTek
07.2015 - 03.2016
  • Monitor, Support and Maintain Oracle EBS 12.2.4 systems
  • Upgraded EBS 11.5.10.2 to R12.2.4 with SSO, DMZ iSupplier, OHS external servers, PCP Multi-node application end-to-end
  • Implemented fresh 12.2.4 EBS-VCP module, Demantra, APCC and ASCP oracle latest technologies and integrate them as a Single unit
  • Cloned and patched 8-nodes 12.2.4 environments as per system requirements
  • Code Migrations 12.2.4 EBS - VCP - ASCP - APCC - DEMANTRA- AGILE PLM - GRC systems per audit standards coordinating with change management
  • Check performance degradation with any session either of database or from EBS applications and tune it accordingly
  • Proven experience with SR-Support co-ordination
  • Quiet good hands on ADOP utility
  • Basics of 12c Golden Gate with activities like start-up shut-down, motor and support Data replication.

Sr. Oracle DBA

Tek Systems (Allegis Group)
02.2013
  • Worked as Senior Oracle DBA to support and manage multiple US client’s Oracle DB, Oracle EBS and other oracle applications of different versions
  • Worked in a very high multi-tasking and complex 24
  • 7 environment on changing shift
  • Have an experience in EBS (12.1.3) on-premises to Oracle Cloud PaaS Migration
  • Support, tune, implement, upgrade, clone and maintain various versions of oracle databases (Oracle 19c/12c/11g) in OCI and on-premises across multiple flavors of Unix flavors (RHEL/OEL/Solaris)
  • Hardcore experience in implementing/upgrading/migrating Oracle Databases and EBS from on premise to OCI
  • Able to do patching, cloning and any other regular maintenance work for database and ebs allocation in OCI
  • Adequate understanding of Oracle Advanced technologies like 19c RAC, SSL (certificates), SSO integration with EBS, WebLogic, EBS DMZ server
  • Implemented Office 365 Workflow, Transparent Data Encryption (TDE), Java Web Start (JWS), Mobile Apps, Enterprise Command Center (ECC), HugePges, Excel4Apps (GLWand) etc.

Sr. APPS DBA

Srei Sahaj e-Village Ltd (A Srei Infrastructure Finance)
- 01.2013
  • Responsible for 24
  • 7 availability of Oracle Database and Oracle Application servers
  • Ensuring error prone and consistent Database RMAN backups taken at every night
  • Writing Packages, Procedures, Triggers as per requirements through PL/SQL
  • Install and maintain Oracle Application in complex environment such as Single node and Multi node installation
  • Experience and proficient in Adconfig, Adctrl, Adrelink
  • Creating users and assigning the Responsibilities using System Administration module of Oracle Applications
  • Managing security levels as per the organization norms by changing the passwords of apps, applsys and custom schemas on request
  • Involving in cloning the Oracle Production EBS (DBtier-1 & Apps Tier-1) to 2 node RAC DB tier and 2 node Apps tier and enable forms load balancing
  • Responding to various types of oracle engine alerts and end users’ issues and respond accordingly
  • Applying oracle application and database patches as per oracle apps functional team requirements or to fix application bugs adpatch/opatch/runinstaller
  • Monitoring all processing concurrent requests and take necessary action against long running, pending standby and completed with error
  • Gathering heterogeneous Oracle ERP and Portal databases reports at times as per business team requirements.

Oracle DBA/Apps DBA Lab Co-ordinator

4BS institute
  • Database Upgradation 9.2.0.3.0 to 9.2.0.8.0 and further to 10.2.0.4
  • Applying Patches to ORACLE EBS (11i) as per requirement
  • Ensuring that EBS is up and running
  • Troubleshooting logging issue for EBS & portal DB
  • Cloning/refreshing of database as and when required for UAT and TEST DBs
  • Oracle Installation 9i/10g/11gR1 on Linux
  • Tablespace and datafiles management
  • Regular Monitoring Alert Log Files on day-to-day Basis
  • Creation of Oracle Database as per requirement
  • Managing the space, monitoring the free space etc
  • Monitoring and Reorganizing Tablespaces/Tables/Indexes
  • Managing undo segments, control file and Redo Log Files
  • Recovery and maintaining the Control files
  • Maintaining Archive logs and their spaces for routine administration
  • Involved in database backup strategies and recovery scenarios
  • Managing tablespace and user’s profiles for availability of Database
  • Maintaining logical and physical structure of the Database
  • Performing the daily checking routines by monitoring the alert log, trace files of the Database
  • Granting Appropriate Privileges and roles to the users.

Education

Bachelor of Engineering B.E - Computer Science and Engineering

Dr. Babasaheb Ambedkar Marathwada University
Aurangabad, India

XII (CBSE) - undefined

Kendriya Vidyalaya
Singtam, East Sikkim

X (CBSE) - undefined

M.S. Vidya Mandir
Siwan, Bihar

Skills

Sql-Developer

undefined

Websites

Certification

Oracle Certified Professional (OCP)

Career Abstract

A dynamic professional with 13 plus years of exposure in Oracle Core Databases and Enterprise Business Suite installation, upgradation & administration.

Areas Of Exposure

  • Understanding of Oracle Cloud Infrastructure concepts and architecture.
  • End to end experience on 12.1.3 ebs and 12c db upgrade to 12.2.6 ebs and 19.11 DB.
  • Knowledge of Oracle Gid, Database and EBS Backup.
  • Strong Oracle EBS, RAC, Database and Linux Operating System Architectural Concept across multiple versions.
  • Sound Experience in installation of Oracle RDBMS (9i, 10g & 11gR2,12c, 19c), Oracle 10g& 11gR2 RAC Cluster, Oracle EBS 11.5.9, 11.5.10.2, 12.0.4, 12.1.3, 12.2.3, 12.2.4, 19c (standalone, shared appltop, shared application tier).
  • Hard Core experience of Oracle RAC and standalone database Upgradation from 10.2.0.1 to 10.2.0.4, 11.2.0.3 to 11.2.0.4 and further 12.2.0.1 to 19.11.
  • Analyzing Database and EBS Performance and tune it accordingly using various tools like Oradebug, Sql –Trace, TKproof, and AWR reports, Explain Plan, top, vmstat, free, iostat, OEM etc.
  • Good Knowledge of Oracle PL/SQL programming language.
  • Knowledge of Oracle Workflow, PCP, Load balancer, DMZ node, SSL (ebs and Java Code Sign Certificates) and SSO.
  • Hardcore upgrade experience on Oracle EBS 11.5.10.2 to 12.2.4.
  • Good working exposure with Oracle Global Support Team and other technology shareholders to create, follow up end to end and close Service Requests.
  • Well versed with EBS and DB various types of Cloning and patching based on requirements.
  • Worked on like Oracle GRC, Demantra 7.3., WebLogic 11g, 12c and Agile PLM 9.3.3.

Country Of Residence

India

Career Statement

To obtain a position that will enable me to utilize my strong educational and professional background, communication skills, and ability to work well with people.

Personal Information

Date of Birth: 01/04/89

Timeline

Sr. Oracle APPS DBA

Rackspace Technology
04.2016 - Current

Sr. APPS DBA

Bahwan CyberTek
07.2015 - 03.2016

Sr. Oracle DBA

Tek Systems (Allegis Group)
02.2013

Sr. APPS DBA

Srei Sahaj e-Village Ltd (A Srei Infrastructure Finance)
- 01.2013

Oracle DBA/Apps DBA Lab Co-ordinator

4BS institute

Bachelor of Engineering B.E - Computer Science and Engineering

Dr. Babasaheb Ambedkar Marathwada University

XII (CBSE) - undefined

Kendriya Vidyalaya

X (CBSE) - undefined

M.S. Vidya Mandir

Similar Profiles

CREATE PROFILE
Pravin KunwarSenior Database and Application Administrator