Role: Devops
Location : Remote
Rate :$60/hr
Debug reported issues thoroughly and resolve them, including technical issues
Research performance issues & recommend solution
Troubleshoot database related problems
Backup & Restore per Client including adhoc backup/restore requests
Day-To-Day:
Ensure 100% Availability of Databases and Real Application Clusters
Check database log, view trace file, checking for error message
Check log file and trace file record alert and trace errors in the file
Check invalid database objects
Attend to day-to-day user requests
Determine the most expensive queries of a database by generating appropriate reports
Monitor (through the system's performance/server performance parameter) the decline in performance of the database; if any, find cause, and resolve
Monitor the growth of the amount of data
Maintain DR environments
Ensure the validity of backups
Planned:
DB install
DB Refresh
DB upgrade to higher or latest version
Maintain and Create Standby database using appropriate tools(s)
Plan and schedule backups/restores
Allocate system storage & plan future database storage requirements
Application and DB users' password change
User management (Create, Drop, Privileges)
Support during application license update
DB or Application support during power maintenance
Support during OS patching activity
Support during app Team patching or maintenance
Test Disaster Recovery solutions
Location : Remote
Rate :$60/hr
Debug reported issues thoroughly and resolve them, including technical issues
Research performance issues & recommend solution
Troubleshoot database related problems
Backup & Restore per Client including adhoc backup/restore requests
Day-To-Day:
Ensure 100% Availability of Databases and Real Application Clusters
Check database log, view trace file, checking for error message
Check log file and trace file record alert and trace errors in the file
Check invalid database objects
Attend to day-to-day user requests
Determine the most expensive queries of a database by generating appropriate reports
Monitor (through the system's performance/server performance parameter) the decline in performance of the database; if any, find cause, and resolve
Monitor the growth of the amount of data
Maintain DR environments
Ensure the validity of backups
Planned:
DB install
DB Refresh
DB upgrade to higher or latest version
Maintain and Create Standby database using appropriate tools(s)
Plan and schedule backups/restores
Allocate system storage & plan future database storage requirements
Application and DB users' password change
User management (Create, Drop, Privileges)
Support during application license update
DB or Application support during power maintenance
Support during OS patching activity
Support during app Team patching or maintenance
Test Disaster Recovery solutions