Specialist - System Management

Bachelor in any stream with good communication skill having relevant experience of minimum 710 years

Database Administration Manage and maintain Oracle databases 11g 12c 19c on LinuxUnix platforms

Performance Tuning Monitor and optimize database performance troubleshoot issues and implement indexing strategies

Backup and Recovery Develop and implement backup and recovery strategies using RMAN Recovery Manager and data replication

Security and Access Control Manage user access roles and privileges ensuring database security and compliance

Database Maintenance Perform routine maintenance tasks including patching updating and troubleshooting

Storage Management Manage disk space storage and archiving

Troubleshooting Identify and resolve database errors crashes and other issues

Collaboration Work with developers IT teams and stakeholders to ensure database alignment with business requirements

Documentation Maintain accurate documentation of database architecture configurations and procedures

Upgrade and Migration Plan and execute database upgrades and migrations

Design and Implementation

Advanced configuration and Troubleshooting

Analysis of technical issues and permanent fixsolution

Implementation of RAC

Implementation of ASM

Implementation of Data Guard for database failover between Data centre and DR site perform switchover failover activities

Database recoveries and identifying and fixing database corruption

Designing database for High Availability

Designing a Strategy to Maintain and Manage Databases

Work on the performance issues related to Clustering Create logical diagrams to figure out the loop pools in the database designs and functionality

SQL tuning and optimization

Administering Basic and Advanced replication

Administer a VLDB

Transport data across platforms

DBRelated Software Evaluation

Administer 3rd Party DBA Tools

Facilitate TrainingEducation

Qualifications

Good exposure to OEM Oracle Enterprise Manager

Good understanding of new features of 19c database

Knowledge of PDBCDB is preferable Knowledge of RAC configuration and troubleshooting of CRS will have added advantage

Certification OCP Certification 11G12c19c

Additional Knowledge on MS SQL will be a value add