DBA daily routine and checks (rework in progress)
Regular maintenance is an important part of the an Database administrator's duties to maintain the data systems supported by the Institute for Informatics, Data Science and Biostatistics (I2DB). There are variety of regular tasks that should reviewed daily and scheduled based on impact and then coordinated with Team Leads and I2DB's leadership.
Prioritizing Impacts
-
Priorities assigned by Team Leads and I2DB's leadership
-
System failures/errors that would impact the usability of I2DB platforms and prevent/degrade users ability to perform Research activities or perform work tasks. Priority of impact usually means Production has priority over QA and Dev environments
System/app notifications
These are the alerts, generally received by email and Teams channels these need to be reviewed first thing each day as they can impact on going project tasks or platform operations.
- RDC Database logs
- RDC ETL monitoring
- MDCLone Azure systems
- REDCap MySQL databases
- SPARC Automation
- MARs Automation
- SOURCE automation
- GIC Database
other systems
This is a list of systems that have insufficient or no current alerting and need to manually looked at couple days as they can impact on going project tasks or platform operations.
- RDC Databases Storage (attach doc)
- MDClone Hadoop/Cloudera
- PEDscreen Database
project based tasks
These are a list of tasks that are not necessarily daily but need to be done once or more per week.
-
RDC
- Database changes
- ETL Control and troubleshooting (attach doc)
- ETL run scheduling (attach doc)
- Job control (attach doc)
- Database User Management
- storage management
- backups/snapshot management
- capacity planning
-
MDClone
- Database changes
- Extract Control and troubleshooting (attach doc)
- Extract monthly run (attach doc)
- Extract validation (attach doc)
- Hadoop storage/node planning
-
REDCap
- MySQL database support (attach doc)
- storage capacity planning
- Application upgrades (database changes)
-
Misc.
- Scripting support
- database connection troubleshooting
- process enhancements