Database Administration Work Experience Work Location Certification Apply Database patches Create Tables Create Indexes Monitor system activities and logs Database Start-up and Shutdown User administration – roles, privileges, security, backup and restoration activities. 3-5 Yrs Nagpur Oracle Cloud Infrastructure Foundations 2020 Certified Or
Associate
SQL – MySQL for Data Analytics – BI Installation and reinstallation of Oracle / SQL and other databases.
Performance
Tuning. Backup solutions involving RMAN and veritas / Legato Database upgrades Performance tuning and security Management ( access privileges ) Capacity planning (Identify the usage pattern and suggest improvement in performance) and Change Management Configuring Database Replication Troubleshooting problems on Database, cluster and replication Fault Management and Data Management Process for data backup and restoration SQL Plus, PL/SQL and s hell scripting. Escalation to vendor and coordinate for incidents needing vendor support.
Database Space
Management.
Table Space
Management. Knowledge on queries/forms. Installation and reinstallation of Oracle / SQL and other databases.
Performance
Tuning.
Database Space
Management.
Table Space
Management.
Backup solutions involving RMAN and veritas / Legato Database upgrades Performance tuning and security Management ( access privileges ) Capacity planning (Identify the usage pattern and suggest improvement in performance) and Change Management Configuring Database Replication Troubleshooting problems on Database, cluster and replication Fault Management and Data Management Process for data backup and restoration SQL Plus, PL/SQL and shell scripting. Escalation to vendor and coordinate for incidents needing vendor support.
Apply
Database patches Create Tables Create Indexes Monitor system activities and logs Database Start-up and Shutdown User administration – roles, privileges, security, backup and restoration act ivities. Installation and reinstallation of Oracle / SQL and other databases.
Performance
Tuning.
Database Space
Management.
Table Space
Management. Backup solutions involving RMAN and veritas / Legato Database upgrades Performance tuning and security Management ( access privileges ) Capacity planning (Identify the usage pattern and suggest improvement in performance) and Change Management Configuring Database Replication Troubleshooting problems on Database, cluster and replication Fault Management and Data Management Process for data backup and restoration SQL Plus, PL/SQL and s hell scripting. Knowledge on queries/forms. Escalation to vendor and coordinate for incidents needing vendor support.