SUMMARY:

• A professional with 7 years of experience in Oracle DBA working in 24x7 support window handling multiple oracle databases.

• Proficient at analysing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting database issues

• Independently handling Clients Site technically and operations wise in executing work related to oracle database management

• Managing of Team and grooming of new member in the team

• Gathering client requirements and define a strategy to obtain the same

• Experience in Oracle Database Administration 11g/12c/19c

• Experience in RAC Database Administration 11g/12c/19c

• Experience on database installation in LINUX, HP-UX and Windows platform

• Documentation Report/Review – Site Documents, System Study, Backup Policy, Security Policy, Performance Management Document, Patch Management Document, Activity Report, Incident Report, Monthly Service Report

• Experience in Oracle Database installation, up-gradation and migration for Standalone & RAC environment • Database Tuning & query tuning when required

• Creating Data-guard for all major production databases for Standalone and RAC environment

• Experience in performing DR-drill activity for Standalone and RAC environment

• Proactive database monitoring through OEM .

• Shell scripting at OS level for all major production database to monitor critical alerts and backup status

• Performing Database maintenance activities like Stats gather, Index rebuild and Reorganisation

• Experience in Data-guard Administration for Physical, Active Data-guard and Logical standby database. .

TECHNICAL KNOWLEDGE:

✔                 Rdbms : Oracle 10g, 11g and 12c. Languages : Shell Script, SQL, PL/SQL

✔                  Tools & Utility : RMAN, Export & Import, Datapump.

✔                 High-end Technologies : Data Guard

✔                 Operating System : RHEL 5, OEL 5

CAREER CONTOUR:

Project 1: Confidential

Environment : Oracle 10g, OEL 5.0

Description: Yusen Logistics provides integrated freight forwarding services which include international transportation, domestic pick up/delivery, import/export customs clearance, documentation preparation and declaration, triangle shipment arrangement, palletizing, stuffing/unstuffing and any other required services.

Responsibilities:

● Installation of Oracle 10g on Linux platform.

● Creating users, tablespace, data files, tables, indexes, partitions as per requirement.

● Creation of oracle Roles, Granting Privileges and Profiles etc.,

● Check Alert Log errors and make necessary actions to rectify them.

● Frequent analysis of objects or schemas to improve the speed of the database.

● Rebuilding Index to rectify segment fragmentation.

● Export/Import of Tables, Table spaces and Full Databases.

● Using SQL Loader, NID.

● Monitoring the database for Memory and I/O utilisation.

● Monitoring the growth of database, tablespace, disk level.

● Monitoring the unwanted user session and killing them if required

● Backup and Recovery using RMAN

● Perform Hot & Cold Backup

● Maintaining the Control files

● Maintaining Redo Log files & Data files

● Managing Indexes, Data Integrity

● Segment Space & Extent management

● Media Recovery using a user managed backup process.

Project 2 : Confidential

Environment : Oracle 10g & 11g, Red Hat Enterprise Linux 5.0

Description: Tuck Sun Logistics Group latest website is structured to provide a brief insight into the organisation and its range of logistics services

Responsibilities:

● Installation of Oracle 11g & 12c on Linux platform.

● Checking MRP process which applies the redo data in to standby database.

● Performing Logical Backups through Export/Import and Datapump Utility.

● Refresh Schema and Database as per requirement.

● Performing Backup and Recovery using RMAN.

● Collecting and storing database statistics using AWR report generation.

● Monitoring the database growth, table space, disk level.

● Monitoring the database for Memory and I/O utilisation.

● Granting the necessary roles, privileges and profiles to the users.

● Implementing backup strategies – RMAN and User Managed Backups.

● Cloning the database from production to testing.

● Moved monitoring scripts to new servers tested and Implemented.

● Taking report of a bended Goldengate process.

● Done reperror in Goldengate replicates.

● Configured backups and stats jobs in OEM.

● Checking of backup mount points in daily basis.

● Moving and maintaining of archive backups based on the requirement