Specifications include, but are not limited to:Provide weekly monitoring and administration of 33 Oracle databases, 10+ MySQL, and 300+ MSSQL databases and POSTGRESQL as needed. 1. Review Oracle and SQL alert logs 2. Review critical database performance factors 3. Check database storage 4. Provide monthly report on the “health” of each of the databases 5. Provide monthly itemized report of activities performed (and by whom) during billing month 6. Maintain data integrity and tune databases for optimum performance and high (24/7) availability, within the limitations/requirements of each ERP or Public Safety applications (e.g. PeopleSoft 8.9, JDE EnterpriseOne 8.10, Intergraph Police Systems, and others) 7. Ensure successful backup and restoration strategies: (a) Write scripts to maintain physical standby databases (b) Write scripts to backup all databases to centralized backup location 8. Perform database installations and subsequent upgrades to higher versions as needed 9. Install patches and bug fixes 10. Provide assistance to City staff with database “refreshes” on nonproduction databases
