Haja Mohaideen H
***************@*****.***
SUMMARY
* ***** ** ********** ** the Information Technology industry and experience spans over technical and process oriented areas with special focus on Database Management.
Oracle 10g, 11g and 12c database implementation and administration.
Good team player, strong interpersonal skills.
Strong Adaptability, faster understanding with higher potential to learn and grab things.
Educational Background
B.E, Electronics and Communication Engineering, Jayaram College of Engineering & Technology, Thiruchirappalli (2009 -2013) with Aggregate [6.37 CGPA].
CCNA certified.
Experience Summary
Creation and Maintenance of Oracle Databases as per the requirement.
Creating Database storage structures (tablespace, datafiles) and objects like Tables, Indexes.
Install, monitor and maintain the main servers systems and applications.
Corrective Maintenance and Troubleshooting in System.
Good Knowledge in Oracle 10g, 11g and 12c Administration.
Good Experience in installation of Oracle on Linux Platforms.
Analyze and Rebuild Index to rectify fragmentation.
Enrolling new users and maintaining system security (Profiles), Roles, System and Object Privileges and Managing User Quotas.
Planning for Backup by using RMAN, User Managed and Export and Import.
Logical Backup of Databases using Export & Import Utility as well as using Datapump.
Configuration and implementation of Physical Standby Database for Disaster recovery (Data guard).
Checking the Archive log shipping between the Primary and the Standby (DR) databases and resolve the gap if found.
Creation of clone database without backup using RMAN active database for testing .
Generated and analyzed AWR and ADDM reports and monitored statistics for performance tuning of the database.
Check Alert Log errors and make necessary actions to rectify them.
Provided 24x7 on-call technical supports.
Experience in Oracle 12c, ASM and RAC Installation.
Experience in Migrating database from Non ASM to ASM.
TECHNICAL SKILLS
Specialized in ORACLE 12c, 11g and 10g Database Administration.
Knowledge in UNIX, LINUX and Windows Server.
Working knowledge in TOAD, WinSCP, Putty, NID, DBVerify and SQL Loader.
Strong Knowledge in SQL and DB Monitoring in AWR, ADDM, ASH and OEM.
Employment history
Software Engineer Feb 2015 to Jan 2018
Care IT Solutions Pvt. Ltd. (Chennai, India)
Roles and Responsibilities
Creation of Tablespaces, data files, users etc., for the project requirement.
Monitoring growth database, tablespace and disk level using shell script.
Check Alert Log errors and make necessary steps to rectify them.
Schemas refresh using Exp/Imp and datapump utility.
Backup on Tables, Schemas and Database using Expdp/Impdp and exp/imp.
Performed logical backups using exp/imp and Data pump.
Creating database links and materialized view to share the objects from one Database to another.
Restore and Recover the database using RMAN when required.
Creating catalog mode and register the database in RMAN.
Taking incremental level 0, level 1 backup using RMAN.
Implement Backup strategies using RMAN and User Managed Backups.
Creation of clone database using RMAN for testing.
Monitoring the unwanted User Session and killing them if needed.
Analyzing the SQL Query using Explain plan.
Generating and interpreting Database statistics using AWR.
Implementation of Dataguard and Resolving Related issues.
Checking MRP process to apply the redo data into standby database.
Perform switchover operation in Dataguard environment.
ASM configuration and adding Disk Groups.
Monitoring and adding the datafile in the ASM Disk.
Installation and monitoring the RAC node performance.
Managing schema objects, such as tables, indexes, and views.
Maintaining Control file, Redo log file, Data file and Archive log file.
Taking Cold Backups and Hot Backups.
Building index for new tables and rebuilding Index to rectify Index fragmentation.
To manage control file multiplexing and to trace the control file.
Adding log file groups and members into a group.
Analyzing Tables and Indexes to Rectifying Database Fragmentation.
Performing Backup and Recovery Using User Managed Backup.
Installation of Oracle 11g on Linux operating system.
Roles & Profiles, grant Privileges for users.
Configuring archive log mode for Databases.
Managing Undo and temporary Tablespaces.
Creating users as per requirement and also releases user level locks.
Personal profile
Name : Haja Mohaideen H
Father Name : Hameed S
Date of Birth : 29-09-1991
Sex : Male
Marital status : Married
Nationality : Indian
Languages : English, Tamil
Passport Number : H836496
Visa Type : Work Visa (With Transfarable)