Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.

The responsibilities include

Daily

• Backups—these are usually incremental or cumulative, weekly fulls, and logs are archived and e-mailed to DBA upon failure
• Database Alert Logs—such as ERROR,FATAL automatic notifications through e-mail, pagers
• Operating System Filespace, CPU and I/O statistics—depends on system admin support
• SQL Tuning Sets—Top 5 to 10 SQL statements
• Tablespace growth—Extension, Partition Management, Temporary Tablespace.
• Replication—Log Shipping/Application in Synch
• Alert logs—intrusion detection, removal of unused accounts
• New account creation—should be at least partially automated
• Personnel security changes—At least 24 hours notice
• Migrate schema and code changes or ad hoc SQL updates
• Large table growth, coalescing a tablespace
• Keeping a log of daily changes to the database—publishing it for certain IT staff

Weekly

• Backups—usually full
• Cloning for non-production databases—automated or scripted
• Tablespace growth—daily rolled up to weekly
• Patches/Upgrades—Milestone updates

Monthly

• Cloning for non-production databases—automated or scripted
• Monitoring tablespace growth—weekly rolled up to monthly
• Trends and forecasts—CPU utilization, I/O stats, logons
• Password changes in production—sys, system, schema.
• Practicing recovery scenarios

Quarterly

• Database upgrades
• Monitoring tablespace growth—monthly rolled up to yearly

Yearly

• Tablespace growth—yearly report
• Trends and forecast rollups
• Attend PostgreSQL conferences—regional or national pgconf groups
• PostgreSQL upgrades with planned downtime.
• Software licensing and warranty renewals
• Hardware evaluation and replacement
• SSL Certificate renewals.