Job Profile: Database Administrator
Exp:3-5 years
Location: Nagpur
| Database Administration | |||
| Job Description | 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. | |||