RICHARD

Chennai, Tamil Nadu
Email: [email protected]


CAREER OBJECTIVE

To work in a demanding and responsible position applying my knowledge and skills as a Lead Oracle DBA and skillfully accomplish projects involving Database management with an extensive use of Oracle technology

WORK EXPERIENCE
Oracle Database Administrator

Planosoft Technologies Pvt Ltd – Chennai, Tamil Nadu – July 2013 to Present

  • Installation and implementation of Oracle binary on Linux Operating Systems.
  • Creation and maintenance of Oracle 10g And 11g databases as per the requirement.
  • Good knowledge in Oracle Architecture and its components.
  • Monitoring Database performance and troubleshooting LISTENER issues.
  • Export / Import of Tables, Schemas and database using EXPDP/IMPDP and EXP/IMP utilities.
  • Experienced in implementing and monitoring RMAN backup scripts and recovery techniques.
  • Cloning database from Production to Testing, using RMAN with or without catalog database
  • Experienced in Database Migration from Oracle 10g to Oracle 11g.
  • Involved in generation and analysis of AWR, ADDM, ASH and Query Execution plan.
  • Check the Alert Log file errors and take the necessary actions.
  • Gathering Schema level statistics and Table level statistics using DBMS_STATS Procedure in non-business hours
  • Monitor the session level locks on tables and releases the locked sessions.
  • Worked along with Oracle support team by raising Service Request for updates.
PROJECT HANDLED

Data Tools & Utilities: SQL*Loader, RMAN, Putty, DBCA, AWR, ADDM, SERVENO
Duration: Dec 2016 – Till Date
Responsibilities:

  • Different versions of Oracle installations and configuration.
  • Configuration and implementing the DR (Stand by) databases.
  • Check sync status between primary and standby database.
  • Configuring and installing Golden gate and performed column level replication.
  • Performing full, incremental backups and recovery using RMAN.
  • Active Database cloning using RMAN.
  • Creation of oracle users, oracle roles, granting privileges and profiles etc.
  • Backing up of Archive Log files and monitoring space in that mount point.

Environment: RHEL 5, Oracle 10g, 11g.
Duration: Nov 2014 – Dec 2016
Responsibilities;

  • Provided regular DBA support for the Oracle databases.
  • Oracle 10g and 11g Installation.
  • Created Cloning Database.
  • Database administration, managing tablespaces, objects, disk space.
  • Creation of oracle users, oracle roles, granting privileges and profiles etc.
  • Logical Backup of Databases using Export and Import Utility.
  • Performing full, incremental backups and recovery using RMAN.
  • Monitoring the unwanted User Session and killing them if needed.
  • Backing up of Archive Log files and monitoring space in that mount point.

Environment: RHEL 5, Oracle 10g
Duration: Sep 2013 – Nov 2014
Responsibilities:

  • Oracle Installation.
  • Maintaining Backup strategies and documentation.
  • Creation of schema and related objects.
  • Creation of oracle users, oracle roles, granting privileges and profiles etc.
  • Managing redo logs, checking alert log and trace files for database performance.
  • Monitoring the scheduled backups.
  • Resolving Network issue in database (Listner, Tnsname)
EDUCATION
  • Bachelor of Engineering in Engineering From Jayaram College Of Engineering And Technology – 2010
SKILLS
  • CLONING (4 years)
  • DATABASE (4 years)
  • DATABASE ADMINISTRATOR (4 years)
  • DATABASES (4 years)
  • ORACLE (4 years)
ADDITIONAL INFORMATION
  • RDBMS: Oracle 10g And 11g
  • Key Skills: Data Guard, EXP/IMP, Data pump, Patching, RMAN Backup/Recovery, Upgrade, Migration,

Declaration:

I hereby declare that the information furnished above is true to the best of my knowledge.

Date:
Signature:

Categorized in: