BENADICT.A

adldr1@r.postjobfree.com

+91-995*******

PROFESSIONAL SUMMARY

** .* ***** ** ** Experience as an Oracle Database Administration.

The IT career path includes experience in both Development and Production environments in Various OS platform. (Experience in Banking, Healthcare and Insurance Domain)

Expertise in Database Monitoring Activity, Security, RMAN, Export/Import and Supporting Oracle Databases 9i,10g,11g,12c, Backup and Restore, Performance Tuning & Trouble shooting.

Experience in Data Guard (Physical and Logical Standby Database).

Experience in RAC, ASM, Data Guard. (Physical, Logical, Active Data Guard), Golden Gate.

Experience in Oracle Support processes for technical requests with Meta Link.

Strong Adaptability, faster understanding with higher potential to learn and grab things.

Excellent ability to work both independently and in teams.

CERTIFICATION

ORACLE CERTIFIED ASSOCIATE in Oracle10g Database Administration.

EDUCATIONAL DETAILS

B.TECH-Information Technology from Anna University.

TECHNICAL SKILLS

Operating Systems

Linux, IBM-AIX, Solaris, HP-Unix, & Windows NT

Databases

Oracle 9i and 10g,(10g RAC),11g(RAC),12c

Languages

SQL,

Tools

Putty, PL/SQL Developer, Toad, Winscp, OEM,Remedy,Jira,Golden Gate

Oracle Utilities

Recovery Manager (RMAN)

Export/Import

Datapump

STATSPACK

AWR,ADDM

TkProf

DBCA

Lsnrctl

PROECT DETAILS

Title : Allsec Technologies (Quess Corp)

Role : Manager

Duration : Nov 2019 to Till date

Environment : Oracle 11g,12c, RMAN, Data Guard,

Linux, Windows NT

RESPONSIBILITIES:

Database Creation, Database Administration

RMAN backup configuration.

Configured Active Data Guard.

Monitoring Backups on all the databases & Restoring data on the need basis

Refreshes of non-production databases for testing, development, etc.

Troubleshooting performance issues

Support of internal development including promotion of custom objects through dev/test/prod and assistance in developing custom objects, and general database administration.

Refresh of Test /Dev. System

Maintenance of standby DB environment.

Monitoring the database from OEM 12c.

File System Maintenance & Backup Monitoring and troubleshooting issues if any.

Handled team and ability to manage individual tasks assigned by management.

Maintaining all the objects of the database.

Worked with table and index partitions.

Rebuild Index to rectify segment fragmentation.

Monitoring the database for CPU utilization.

Monitoring the database growth, Re-Organization of Tables.

Cloned and created Databases for development activities.

Have done capacity planning as per the database growth.

Cloning Databases using RMAN Backup.

Feb 2019 to July 2019 with Fujitsu Consulting India Pvt Ltd, as Technical Service Engineer Expert.

Title : HCL Technologies

Client : Standard Chattered Bank

Role : Associate Consultant

Duration : May 2017 to Jul 2018

Environment : Oracle 10g,11g, RMAN, RAC, ASM, Data Guard, Golden Gate, IBM-AIX, Linux, Windows NT

RESPONSIBILITIES:

Installation & creation of Oracle Database and Database Administration.

Performing Logical Backup of entire database using Datapump & Physical Backups (cold and hot).

Data Refresh using Export/Import at Table, Schema & Database level.

Perform database cloning, exp/imp to setup identical databases in development environments.

Implementing RMAN – Configuration, Backup & Recovery and administration.

Recovering lost objects using RMAN.

Generated and analyzed AWR and ADDM reports and monitored statistics for performance tuning of the database.

Analyzing the SQL query using explain plan.

Resizing the datafiles of the tablespace if required.

Proactively checking the alert log of Production Databases.

Following change management process for any configuration changes that are done on database.

Checking the failed backups and troubleshooting.

Monitoring Golden gate process and restart the process if required.

Checking the golden gate error logs and troubleshooting issues if any.

Cloning Databases using RMAN Backup

Implementing RMAN Backup and Configuration.

Monitoring Tablespaces usages and their actions.

Implementing shell scripts for statistics gathering and other similar kind of jobs.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora

Migration of data to various environments

Refreshing the test databases from the production backup using hot backup, cold backup, RMAN

Title : Aricent Technologies

Client : Viavi

Role : Technical Leader

Duration : Jun 2016 to Dec 2016

Environment : Oracle 10g, 11g,12c,Rman, Solaris,HP-

UNIX, Liunx, Windows NT

RESPONSIBILITIES:

Database Creation, Database Administration

Responsible for logical and physical databases design, implementation and maintenance on UNIX and NT

Installed, upgraded and patched Oracle software.

Developed some Unix Shell scripts to automate database operation and database monitoring.

Implemented database refresh with the hot backup using DUPLICATE.

Refreshing development/test database from production using Export/Import.

Created Unix Shell scripts to automate database operation.

Monitoring Backups on all the databases & Restoring data on the need basis

Refreshes of non-production databases for testing, development, etc.

Support of internal development including promotion of custom objects through dev/test/prod and assistance in developing custom objects, and general database administration.

Maintaining all the objects of the database.

Cloned and created Databases for development activities.

Have done capacity planning as per the database growth.

Monitor physical and logical backup.

Recovering lost objects using RMAN.

Generated and analyzed AWR and ADDM reports and monitored statistics for performance tuning of the database.

Implement and Maintain database security (Create and Maintain users and roles, Assign privileges).

Planning for Backup and Recovery of database information.

Making structural changes to the databases.

.

Title : Wipro Technologies

Client : Catholic Healthcare Initiatives

Role : Lead Administrator

Duration : Aug 2014 to Jun 2016

Environment : Oracle 9i,10g,11g,12c,RAC,DataGuard, IBM-AIX,Solaris,HP-

UNIX, Liunx, Windows NT

RESPONSIBILITIES:

Installation of Oracle Database Software

Database Creation, Database Administration

RMAN backup configuration.

Monitoring Backups on all the databases & Restoring data on the need basis

Refreshes of non-production databases for testing, development, etc.

Troubleshooting performance issues

Support of internal development including promotion of custom objects through dev/test/prod and assistance in developing custom objects, and general database administration.

Refresh of Test /Dev. System

Maintenance of standby DB environment.

Monitoring the database from OEM 12c.

File System Maintenance.

Backup Monitoring.

Maintaining all the objects of the database.

Worked with table and index partitions.

Rebuild Index to rectify segment fragmentation.

Monitoring the database for CPU utilization.

Monitoring the database growth, Re-Organization of Tables.

Cloned and created Databases for development activities.

Have done capacity planning as per the database growth.

Monitor physical and logical backup.

Configured Dataguard for implementation.

Monitoring the database for CPU utilization.

Recovering lost objects using RMAN.

Generated and analyzed AWR and ADDM reports and monitored statistics for performance tuning of the database.

Analyzing the SQL query using explain plan.

Troubleshooting of Data guard Issues .

Implement and Maintain database security (Create and Maintain users and roles, Assign privileges).

Planning for Backup and Recovery of database information.

Monitoring and tuning from instance to query level by OEM, EXPLAIN PLAN, STATSPACK, ANALYZE, DBMS_STAT, TKPROF and so on.

Monitoring the unwanted User Session and killing them if needed.

Resizing the datafiles of the tablespace if required.

Proactively checking the alert log of Production Databases.

Following change management process for any configuration changes that are done on database.

Checking the failed backups and troubleshooting.

Cloning Databases using RMAN Backup.

Implementing shell scripts for statistics gathering and other similar kind of jobs.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora

Title : Adecco India Pvt Ltd

Client : Hewlett Packard-United India Insurance Co Ltd, Chennai

Role : DBA Support

Duration : Oct 2011 to July 2014

Enivornment : Oracle 10g,RAC, Data Guard, HP-UNIX, Windows NT

RESPONSIBILITIES:

Involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.

Installation & creation of Oracle 10g Database.

Performing Logical Backup of entire database using Datapump & Physical Backups (cold and hot).

Data Refresh using Export/Import at Table, Schema & Database level.

Perform database cloning, exp/imp to setup identical databases in development environments.

Implementing RMAN – Configuration, Backup & Recovery and administration.

Recovering lost objects using RMAN.

Generated and analyzed AWR and ADDM reports and monitored statistics for performance tuning of the database.

Analyzing the SQL query using explain plan.

Troubleshooting of Data guard Issues (Physical and Logical Standby Database).

Analyze the index if necessary rebuild or Coalesce index to rectify segment fragmentation.

Implement and Maintain database security (Create and Maintain users and roles, Assign privileges).

Monitoring and tuning from instance to query level by OEM, EXPLAIN PLAN, STATSPACK, ANALYZE, DBMS_STAT, TKPROF and so on.

Monitoring the unwanted User Session and killing them if needed.

Resizing the datafiles of the tablespace if required.

Proactively checking the alert log of Production Databases.

Remove the unwanted and temporary files from the backup location to make space for the backup.

Monitoring day-to-day Backup files and Space utilization.

Monitoring the database growth, Re-Organization of Tables.

Raising Oracle TAR for solutions to critical problems.

Managing the Physical & Logical objects of the Databases.

Configuring the backup retention policy as per the client specification.

Following change management process for any configuration changes that are done on database.

Checking the failed backups and troubleshooting.

Cloning Databases using RMAN Backup.

Implementing RMAN Backup and Configuration.

Monitoring Tablespaces usages and their actions.

Implementing shell scripts for statistics gathering and other similar kind of jobs.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora

Migration of data to various environments

Refreshing the test databases from the production backup using hot backup, cold backup, RMAN

Creation and modification of database objects.

Applying Oracle binary patches using opatch utility.

Decommissioning of the databases.

Title : Globalsoft Infotech

Client : Algrain Pvt Ltd.

Role : ORACLE DBA

Duration : Mar 2008 to Oct 2011

Environment : Oracle 9i,10g, Linux,Windows NT

RESPONSIBILITIES:

Checking alert logs and dump files to check for any problems related to the database.

Creation of tablespaces, Adding or resizing data files.

Monitoring the Database growth.

Creating and Administering tablespaces, Users and indexes.

Creating users and Granting specific privileges and roles.

Taking hot Backups and cold Backups.

Export and Import of Tables, Tablespaces and Full Databases.

Monitoring the unwanted User Session and killing them if needed.

Monitoring the datafile location growth and request the space whenever needed.

Monitoring the table growth, database growth, current users, and system resource usage and so on.

Checking the free space available for the tablespace and adding the space.

Remove the unwanted and temporary files from the backup location to make space for the backup.

Proactively monitoring the database's health and taking preventive or corrective action as required.

Creation and modification of database objects.

Remove the unwanted and temporary files from the backup location to make space for the backup.

Decommissioning of the databases.

Housekeeping on servers (i.e.) clearing unwanted log files, trace files and archive log files.

PERSONAL DETAILS

Name : Benadict.A

Date of Birth : 01.06.1984

Nationality : Indian

Passport Number : N5568087

Passport Expiry Date : 30/12/2025

Languages Known : Tamil, English

Communication Address : Door No: 8/140, Plot No : 42,

Kalaingar Karunanidhi Road,

Kannadhasan Street,

Santhosapuram,

Chennai-600073

Contact this candidate