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: