SENIOR SYSTEM ADMINISTRATOR
Idemia Identity And Security
Total years of experience :13 years, 9 Months
Installed Oracle 12c Two Node Real application cluster (RAC) on Oracle Linux 7.4 and migrated
database from Oracle 11g to Oracle 12c.
Upgraded an Oracle Data Integrator from ODI 11.1.1.7.0 to ODI 12.2.1.2.6.
Installation and administration of multiple Operating systems Oracle Linux, RedHat, CentOS,
Solaris and Windows server for Production as well as Development Environments.
Configuration of RAID Controller in the BIOS Setup Utility.
Applying OS Hardening Policy To increases the overall security of the system.
Oracle software installations, Database creations, Managing Users, its Roles and security
management.
Responsible for administrating and managing all around 50 instances, which include Production,
Staging, Test and Development. In addition, administrating ASM, RAC database instances.
Created necessary Tablespaces and placed the Application Tables and Indexes in separate
tablespaces.
Configured RMAN and Scheduled INCREMENTAL backup.
Installation and configuration of Wildfly/JBOSS in Windows & Unix platforms
Scheduled to zip the application server log and purge application log using SHELL scripts.
Installed and configured IBM MQ on UNIX platform.
Installation of multiple operating systems like window XP, 7 windows 2003/2008, Windows Vista.
Oracle 9i, 10g installation and configuring database.
Pro-actively monitored the database and its files growth rate and actively added adequate space for the datafiles and in respective disk groups (Raw devices).
Generating statspack or AWR report from database and analyzing the report.
Taking backups and moving the backup copies and archived logs to the backup destination, periodically clearing the archived log files.
Moving schema objects from one logical storage device to another logical storage.
Created new users, roles and assigning role to users then maintained user accounts.
Identifying locks, detecting the locked and blocked object’s session.
Planning and scheduling HOT Backups and COLD Backup using RMAN and Logical Backups (with Export/Import).
Banking Production and Standby Database monitoring and support.
Oracle software installations, Database creations, Managing Users, its Roles and security management.
Responsible for administrating Single instance databases and administrating ASM, RAC database instances and Physical standby database.
Configured Oracle Dataguard 11g (Physical Standby Database) for Treasury application.
Performance Management through analyzing the AWR report and ADDM report.
As part of team, which works on identifying the defects and performing the Root Cause analysis to avoid repeated, issues in future.
Analyzing important Transactional tables and indexes in Particular intervals.
Identifying locks, detecting the locked and blocked object’s session.
Rebuild Index to rectify segment fragmentation.
Moving the tables and index to particular tablespace and recompiling invalid objects.
Manually registering the archive log files in Physical standby whenever required.
Perform data Backup/ Recovery using RMAN and Logical backup.
B.E (ECE) from Vel’s Srinivasa College of Eng & Tech in 2010, Anna University.
Higher Secondary completed at T P Government Higher Secondary School, Karikal, thro’ TN State Board (2006) .