JYOTI R. PAL
Navi Mumbai
Summary
Dynamic Oracle DBA with excellent technical expertise and a knack for problem-solving. Dedicated to contributing to the success of organizations through effective database management. Seeking a challenging position to further career goals.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Oracle Database Administrator (DBA)
Tata Consultancy Services Ltd.
Navi Mumbai
06.2021 - Current
- Performed routine database monitoring, tuning, and optimization to ensure optimal performance. Completed SCD and CSR reviews of the database in order to safeguard the database from any vulnerabilities.
- Provided 24/7 support for production databases, including on-call rotation.
- Upgraded the databases from older versions to newer ones while ensuring minimal downtime.
Education
Bachelor of Engineering - Information Technology
Bharati Vidyapeeth College of Egineering
Navi Mumbai06-2021
HSC - Science With IT
D. Y Patil Jr. College
Navi Mumbai06-2017
SSC - English Education
Guru Gobind Singh Education Academy
Nerul, Navi Mumbai06-2015
Skills
- Oracle Architecture
- DB Upgradation
- Transparent Data Encryption
- Database vault
- Cache fusion
- Dataguard
- Split Brain syndrome
- Backup & Recovery
- RMAN
- Import/Export Datapump
- Goldengate Replication
- RAC installation
- GI concepts
- OCR & Voting Disk
- Tablespace management
- User management
- Roles & Privileges
- Index rebuild & Re-org
- Physical standby
- Snapshot standby
- Oracle network files
- ASH/AWR/ADDM reports
- Redhat Linux administration
- OS Patching & Upgradation
- Oracle Enterprise Manager
- Disaster Recovery Planning
- ASM Management
Certification
Oracle Certified Associate (OCA) - Oracle Database Administrator
Accomplishments
- Received Star of the month award thrice for technical excellence in TCS.
- Received appreciation from Client (SBI Bank) for excellence work.
Roles And Responsibilities
- Experience in Database and ASM upgradation from 12c to 19c version.
- Experience in Database Migration from HP-UX to RHEL OS.
- Experience in Database Migration from non-ASM to ASM database.
- Experience in implementation of TDE at tablespace level and column level.
- Experience in implementing Database vault on oracle 19c database.
- Experience in Data guard configuration and managing Standby databases.
- Experience in carrying out DR drill activity using graceful switchover and switchback method.
- Experience in Auto/Manual Patching for PSU patches on Grid and RDBMS patching.
- Experience in using OEM console for Database monitoring and maintainance.
- Experience in RAC installation and setup of RAC database.
- Experience with GI concepts as server pools, Cache Fusion, Split Brain syndrome shared storage.
- Experience about Tablespace management, user, role & profile management.
- Established database backup/recovery strategy for different databases.
- Experience in removing fragmentation from database objects by performing reorg and Index rebuild.
- Experience in converting the Physical standby to Snapshot standby mode and vice versa.
- Knowledge for configuring oracle network files tnsnames.ora, listener.ora, sqlnet.ora files.
- Worked for performance tuning by analyzing ASH/AWR/ADDM reports and required action for query performance improvement.
- Along with Oracle, cross skilled with Redhat Linux administration as well, Performed OS Patching and OS upgradation from RHEL7 to RHEL 8 along with basic OS troubleshooting.
Disclaimer
I hereby declare that the above written particulars are true to the best of my knowledge and belief.
Timeline
Oracle Database Administrator (DBA)
Tata Consultancy Services Ltd.
06.2021 - Current
Bachelor of Engineering - Information Technology
Bharati Vidyapeeth College of Egineering
HSC - Science With IT
D. Y Patil Jr. College
SSC - English Education
Guru Gobind Singh Education Academy
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services