A Database Administrator (DBA) plays a critical role in managing and maintaining an organization's databases, ensuring their availability, security, and optimal performance. The tasks of a DBA can be categorized into daily, weekly, and monthly responsibilities. Here's an overview of each:
Schedule some of the below jobs for an easy and peaceful Dba job.
1. Schedule a cronjob for every hour to Check the Database Availability.
2. Schedule a cronjob for every hour to clean the trace files like .trc,.trm,.xml,.aud files.
3. Schedule a cronjob for every hour to check file system alerts
4. Schedule a cronjob for every hour to check free space in tablespaces
5. Schedule a cronjob for every hour to clean the trace files like .trc,.trm,.xml,.aud
6. Schedule a cronjob after business hours to take Rman incremental backup
7. Schedule a cronjob after business hours to gather the specific schema stats
8. Schedule a cronjob to check space on all the mount points
9. Schedule a cronjob on weekends to take full export
10.Schedule a cronjob on weekend to take rman full backup
11.Schedule a cronjob to gather the dictionary stats, system stats
12.Schedule a cronjob for schema refresh as per the client requirement
13.Schedue a cronjob to check the Goldendale extract, manager,replicat process
14.Configure alerts on your business mail and monitor them
15.Configure OEM if you are managing, supporting multiple Linux, Aix, Solarix and Sql servers
16.Configure ServiceNow, Jira, Remedy or SolarWinds or any ticketing tool if you are working on a big MNC client.
1.https://www.servicenow.com/ 2.https://www.bmc.com/it-solutions/remedy-itsm.html# 3.https://www.solarwinds.com/company/contact-us.
Daily Tasks :
1.Check the mails from your team, application teams team
2.Monitor the alert mails
3.Participate in a daily meeting with your team members to discuss the daily issues and weekend tasks and plan accordingly
4.Update the daily issues like P1,P2 call and other issues in a share point
5.Working on Adhoc requirement from application team like Password reset, query long running, Killing session, generating report, creating a
table, Updating/Inserting/Deleting a data on table, gathering stats, creating a new user, permission issues etc.
6.Work with OS team for any OS level issues
7.Working on Db pending tasks
8.Maintaining a proper documentation
Weekly Tasks:
1.Applying patches on databases as per oracle requirement
2.Installing, Creating and configuring new database builds
3.Adding new storage disk to the existing disk groups
4.Participate in a weekly meeting and track it in a share point
Monthly Tasks:
1.Create a plan for Dr Test on production and standby database
2.Schema refresh from production to development for application testing
3.Schema migration from one Linux server to another Linux server
4.Working on tables defragmentation
5.Create partitions on big tables
6.Check the database growth and update in share point and discuss with team
7.Working with auditing team
Note: For all the above weekly and monthly task need to get the approval from application team and Centre for advisor board(CAB)
Remember that the specific tasks and frequency may vary depending on the organization's size, the complexity of the database environment, and the nature of the applications relying on the databases. Good organization, attention to detail, and proactive monitoring are essential qualities for a successful DBA to manage these tasks efficiently.
Enjoy the work and do like me if you like this article!!!
