Installation of mysql 12c,19c on RHEL 7
Installing, configuring mysql server software and related products.Implementing mysql security
Good experience in Installation and Administration of mysql database server on Linux.
Having expert knowledge in Configuring and maintaining RMAN.
Expertise in implementing backup & recovery strategy for databases using RMAN.
Experienced in taking regular online and logical Backups.
Having good Knowledge in mysql architecture.
Having good experience with the tools like data pump (Expdp & Impdp) and traditional export/import
Good experience in Table space management, User management.
Periodic Checking of account status for expiry and lock.
Creating different users and granting them appropriate privileges and roles.
Configured database to Archive log mode.
Monitor the growth of database to ensure the smooth running of daily activities.
Monitoring of alert log files and trace files and periodic purge.
Configured listener on Server side and tnsnames on Client side.
Monitor database and application performance on regular basis and schedule/execute optimization procedures as required.
Allocation of storage space to databases and Planning future storage requirements.
Planning and Creating Database required for Production, Development and Test Usage.
Plan and implement Backup and Recovery strategies in various environments.
Testing and Implementing Restore procedures for Complete and Incomplete Recovery.
use of mysqldmp to backup and restore
exercises for various environments with different approaches applicable.
Exhibit the traits like Self confidence, self starter, Curiosity, Result oriented.
Compatible in team environment and also to work well independently.
Ability to interact effectively with people, Sincere and committed.
Monitoring and Supporting databases in a 24x7 environment.
Build, installed, and administration of mysql on different O.S.