Закрыт

Need consultant for Oracle and Mysql

Hi we need consultant for Oracle and Mysql below is the requirements.

Oracle Database:

Server Monitoring: Examine Database environment to detect issues and make necessary recommendations

to improve overall performance

Periodic Housekeeping of Database logs and trace files

Uptime Management: Primary responsibility to achieve 99.90% uptime of Database server and reduce unplanned downtime.

The same will be done by:

1. Daily monitoring and alerts.

2. Ensure backup strategy in place. The information on the same should be readily available.

3. Plan for recovery in case of failure and ensure minimum downtime

Space Management: No Application Outages due to space crunch.

Performance Management: Monitor performance variables of the system, including DISK I/O, CPU utilization.

As well as database SGA related hit ratios.

Rollback segment/Undo segment contention, unbalanced index growth.

Resource Management: Monitoring system utilization against database and parameters.

(E.g.) user limit, process limits etc. Ensure no database/Application Outages.

Backup & Recovery management: Backup and recovery Policy

1. Designing backup and recovery policy for the site.

2. Ensuring the back-up is done as defined in the Backup policy

3. Contingency test for backup

Reports: Detailed activity report for every planned activity

Monthly Service Report / Equivalent

MySQL Database:

Server Monitoring: Examine Database environment to detect issues and make necessary recommendations

to improve overall performance

Periodic Housekeeping of Database logs and trace files

Uptime Management: Primary responsibility to achieve 99.90% uptime of Database server and reduce unplanned downtime.

The same will be done by:

1. Daily monitoring and alerts.

2. Ensure backup strategy in place. The information on the same should be readily available.

3. Plan for recovery in case of failure and ensure minimum downtime

Space Management: No Application Outages due to space crunch.

Performance Management: Monitor performance variables of the system, including DISK I/O, CPU utilization.

Monitor Database log file as well operating system logs for potential issues Resolution for errors and warnings that could affect database operations and performance.

Evaluating patches required on MYSQL as well as Operating Systems

Manage the database security with help of users, roles, profiles, and responsibilities.

1. Auditing and generating audit reports.

2. Implementation of corrective Action

Backup and recovery Policy

Designing backup and recovery policy for the site.

Ensuring the back-up is done as defined in the Backup policy

Contingency test for backup.

Навыки: Oracle, Управление базами данных, SQL, Разработка баз данных, Программирование баз данных

О клиенте:
( 1 отзыв ) pune, India

ID проекта: #32317092

4 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹10100

sankargan88

Dear Client, Thank for posting. I have gonethrough your requirement and i am interested to work on this as i have an experience of 12+ years in both Oracle and MySQL Database. Worked in Development, Administration an Больше

₹11000 INR за 7 дней(-я)
(1 отзыв)
2.3
Avouri

Hi , Greetings from team avouri, I read your requirement and it suits for my team skill sets, I have DBA experts team having more than 10 yrs of experiences in all ORACLE DB versions (RAC,EXADATA ,SECURITY, Ris Больше

₹9800 INR за 7 дней(-я)
(0 отзывов(-а))
2.8
vikasyadav305

Hi, I am having 10 years of experience in oracle and mysql database. Text me to discuss further on requirements.

₹9800 INR за 1 день
(0 отзывов(-а))
0.0
siva143166

Hello, From the description, you are looking for support to handle the routine maintenance activities to have a stable environment. I have experience in maintaining, monitoring and handling the performance issue in Больше

₹9800 INR за 7 дней(-я)
(0 отзывов(-а))
0.0