Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Interests
Timeline
Hi, I’m

Deb Kumar Payra

It Analyst(Oracle Database Administrator)
Bangalore
Deb Kumar Payra

Summary

I have 5.2 years IT experience in database production and development environments out of total 4 years working as a Successful Oracle Database Administrator. I'm one of Oracle DBA working for It Analyst at Tata Consultancy Services | DB Migration | Upgradation | Data Guard | RAC | ASM | Golden Gate | Exadata | Patching in both production and development environment with knowledge in Performance Tuning, High Availability and Disaster Recovery. Proficient in an assortment of technologies including Oracle 11g, 12c, 18c,19c Linux.

Overview

5
years of professional experience
12
years of post-secondary education
3
Certifications
3
Languages

Work History

Tata Consultancy Services
Bangalore

IT Analyst(Oracle Database Administrator)
06.2022 - Current

Job overview

  • 19c grid Installation (use one disk from RECO Diskgroup to use in Response File)
  • ASM Diskgroup Creation.
  • 11G Rdbms Installation.
  • 19C Rdbms Installation (this we are doing now itself to overcome lib issue while connecting to ggsci).
  • Listener Addition (remove 1521 port listener and add specific port listener).
  • Modify Scan listener name and add port for specific scan listener.
  • Golden Gate ACFS5 File System creation.
  • GG Installation and then Start Manager.
  • GG VIP Creation (End point: filesystem will be available only on one node)
  • 11g ADG Build.
  • Prepare Forward Extract and Pumps param files.
  • Add and Start the extract and Pumps.
  • Prepare the replicat param file on your Target.
  • Activate the Standby Database
  • Preupgrade Steps: Execute preupgrade tools from 19c home and fix the recommendations.
  • Actual Upgrade, once done proceed with postupgrade_fixup.sql execution also which was reported in Pre-Upgrade.
  • Create CDB with small template.
  • Plugin PDB with the Procedure.
  • Fix the violations and make sure Restriction mode is NO.
  • reset params at the PDB level.. PDB pfile should be empty.
  • working on with Data Validation with source.
  • Add and Start the Replicats with Proper RBA and Seqno.
  • Add the Database to OEM.
  • object comparison with source.
  • Shared Standby Build from 19c CDB/PDB.

Path Infotech Limited
Noida

Consultant ORACLE DBA
05.2021 - 06.2022

Job overview

  • Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately.
  • Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
  • Hands on experience in Oracle Database Installation, Configuration, Maintenance, Cloning, Patching on Windows, Linux & Unix .
  • Handling database alerts regarding tablespace utilization, blocking session, long running sessions, and invalid objects mount point utilization and reported in alert log.
  • Ability to detect and troubleshoot ORACLE database related CPU, memory, I.O, disk space and other resource contention.
  • Working with ASH, AWR, ADDR Reports to see Top SQL which are causing performance issues, buffer busy, latches and enqueues, cluster related findings, I/O related findings.
  • Good experience of Backup and Recovery (Oracle RMAN, Import/Export and Datapump) .
  • Good experience in Oracle Database monitoring, troubleshooting and performance tuning.
  • Well versed in using database tools (Tkprof, AWR, Statspack, ADDM, Opatch, ASMCMD, SRVCTL, CRSCTL etc.
  • Experience in engineered system (like Exadata, Exalogic, ODA etc) maintenance, OS upgrade, patching, database management.
  • Good working knowledge of job scheduling in Unix environment and monitoring scripts/tools.
  • Working knowledge on public cloud like Oracle Cloud.
  • Patching in Oracle 11g, 12c and also applying Rolling Patch in ORACLE RAC environment.
  • Coordinated with project management staff on database development timelines and project scope.

SHA Infotech Solution Pvt Ltd
KOLKATA

Oracle Database Administrator
04.2018 - 05.2021

Job overview

  • Complete knowledge about Database upgrade from Oracle10g to 11G, 11g to 12C
  • Experience in database migrations two node RAC Configuration in Oracle Database 12c grid with 11g Database (expdp / impdp methods).
  • Configuration two node RAC Configuration in Oracle Database 12c Release 2 version.
  • Configuration of Physical Standby server in Data guard.
  • Details knowledge of Oracle architecture.
  • Working with Tablespace.
  • Listener and TNS configuration.
  • Configuring Parameter file and SP file.
  • Experience in indexing, integrity checks, patching and updating statistics.
  • Excellent knowledge of data backup, recovery, security, integrity AND SQL.
  • Automation of Database backup using shell script.
  • Duplicating database on same Host also different Host using RMAN.
  • User, Role, Profile management in database.
  • Password less File transfer configuration.
  • Physical and Logical Database backup and recovery under different scenario.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Created and implemented database designs and data models.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
  • Created scripts and processes for data integration and maintenance.

SHA Infotech Solution Pvt Ltd
KOLKATA

Sql. Data Analyst
07.2017 - 03.2018

Job overview

  • Developing Data Analytics report using jasper soft studio as per business requirement.
  • Responsible for providing automated and self-service reporting solutions, and developing data visualizations for business users.
  • Implement changes to DB design when supported by impact analysis.
  • Assist in design, analysis and development of data architectures for relational database.
  • Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
  • Increased customer satisfaction by resolving .
  • Developed team communications and information for meetings.
  • Conducted research, gathered information from multiple sources and presented results.
  • Created plans and communicated deadlines to ensure projects were completed on time.
  • Recommended data standardization and usage for protection of data integrity.

Education

University Of Calcutta
Kolkata

B.COM from Accountancy
06.2012 - 05.2017

University Overview

Belghoria Jatindas Bidhyamandir (W.B.C.H.S.E)
Kolkata, WB

Higher Secondary from Accounting And Business Management
04.2010 - 05.2012

University Overview

Dakshineswar High School (W.B.B.S.E)
Kolkata, WB

Secondary
02.2005 - 04.2010

University Overview

Skills

    Oracle (11G, 12C, 18C,19C)

undefined

Certification

Oracle Cloud Infrastructure Foundations 2020 Certified Associate.

Accomplishments

Accomplishments
  • Developed and Maintained Database of 500 GB to 9TB and maintained multiple product lifecycle environments, from development to mission-critical production systems.
  • Identified and established automation of repetitive processes to minimize error.
  • Performed database tuning and performance tuning of queries consuming resources or slow running queries.
  • Upgrading of new COA (Control Office Application) hardware and software installation is going on over Indian Railway (CRIS).
  • Installing oracle 11g database software along with installing oracle database. Exporting full back up from the 10g database and Importing to new 11g database.
  • Run the script for validating the objects in the new database. Installing RAC 12g Grid software and 11g database.
  • Resolved product issue through consumer testing.
  • Disk Addition in ASM Diskgroup .
  • Migration Old server to New server .

Interests

Outdoor Games

Listening Music

Travelling

Timeline

Oracle Certified Foundations Associate

07-2023
IT Analyst(Oracle Database Administrator)
Tata Consultancy Services
06.2022 - Current
Consultant ORACLE DBA
Path Infotech Limited
05.2021 - 06.2022

Oracle Autonomous Database Cloud 2019 Certified Specialist.

08-2020

Oracle Cloud Infrastructure Foundations 2020 Certified Associate.

05-2020
Oracle Database Administrator
SHA Infotech Solution Pvt Ltd
04.2018 - 05.2021
Sql. Data Analyst
SHA Infotech Solution Pvt Ltd
07.2017 - 03.2018
University Of Calcutta
B.COM from Accountancy
06.2012 - 05.2017
Belghoria Jatindas Bidhyamandir (W.B.C.H.S.E)
Higher Secondary from Accounting And Business Management
04.2010 - 05.2012
Dakshineswar High School (W.B.B.S.E)
Secondary
02.2005 - 04.2010

Similar Profiles

  • Vrunda Chindhade

    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 Basu

    Sreya BasuSreya Basu

    Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)

  • Arun V

    Arun VArun V

    Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services

  • Naimish Agnihotri

    Naimish AgnihotriNaimish Agnihotri

    Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services

  • Muskan Jain

    Muskan JainMuskan Jain

    Associate – Bid Management at Subex Ltd.Associate – Bid Management at Subex Ltd.

CREATE PROFILE
Deb Kumar PayraIt Analyst(Oracle Database Administrator)