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, IndiaXII (CBSE) - undefined
Kendriya Vidyalaya
Singtam, East SikkimX (CBSE) - undefined
M.S. Vidya Mandir
Siwan, BiharSkills
Sql-Developer
Export/Import
RMAN
TKPROF/SQL Trace
Ad utilities
adpatch
ADOP
FNDCPASS
FNDLOAD
OAM
OEM11g and 12c
Salse Force
Jira Ticketing tools
orapki
openssl
etc …
OEL 6,7
RHEL 5,6,7
Solaris
IBM-AIX 60
Windows
SQL
Basis of PL/SQL programming
Oracle 10203
11106
11203
11204
12203
19c
SQL DBA
Oracle 10203
11106
11203
11204
12203
19c
SQL DBA
Oracle 9i and 10g application server
SSO
OAM
SSL
ECC
OCI
Possesses abilities in providing technical support client in 24/7 environment
Sound conceptual knowledge base of Oracle Application Cloning in single as well as multimode platform
Very good Exposure in applying Application, Cluster and Database patches in single and multimode with focus on accomplishment of the company’s mission & profitability targets
A keen communicator with dynamic relationship building analytical & problem-solving abilities
Ability to control nerves under pressure at Critical Issues and provide solution as soon as possible
Proven skill of follow ups and monitoring of raised service request (SR) with Oracle Global Customer Service Team
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