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)

Data Management

Rac

Data Guard

Performance Tuning

Oracle database(Standalone, Rac, Datagurad installation and configuration)

Oracle Database Upgradation

Golden Gate

Exadata

Patching

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

CREATE PROFILE
Deb Kumar PayraIt Analyst(Oracle Database Administrator)