General DBA Responsibilities!!!

Q: What was your responsibility in the previous company?
Ans: I was responsible for managing the space -- i. e Monitoring the growth of the datafiles and resolve space related issues.
-> Troubleshooting the issues related to backup failures.
-> creating policies for taking backups.
-> Recovering database in situations and preparing standby servers.
-> Taking Logical and physical backups adhering strictly to the policies.
-> creating database on demand.
-> Allocate and manage system privilege.
-> Plan and implement backup policies & strategies.
-> Minimize datbase down time and in situations contact Oracle corp. for technical support.
DBA Responsibilities:
User Management:
Oracle Account Management Policy contains the following parts:
• Account Locking • Password Aging and Expiration • Password History • Password Complexity Verification

Database House Keeping Activities

DBA Responsibilities:

As a DBA, my responsibilities are :

We have production systems and non-production (Development, Testing, QA ) systems.

1. Health Check - of database servers. I use monitoring scripts for database health checkup.
2.Code Migration - With time the enhanced facilities and technical upgradation of modules are done through code migrations from development instances to Production systems.
3.Address daily/Weekly Space requests.-Monitor and add spaces as when required.
4. Manage Redo - Monitor Archive log files and troubleshoot if programs eror out due to it.
5.Manage Printers

* Review and design database structures to support business requirements including logical and physical database modeling;
* Install, configure and maintain database instances, creates various database objects, creates users with appropriate roles and levels of security.
* Recommend and implements database security policies that are consistent with security guidelines;
* Recommends and implements database backup and recovery strategies that meet recovery and availability requirements;
* Mentor DBA team members and developers, and delegates appropriately;
* Provide DBA support and technical expertise for multiple applications in development, test, QA and production environments;
* Troubleshoots and documents database problems and resolutions;
* Lead database projects and manages resources required for successful completion of the project and
* Support all database platforms.
* Strong experience in all aspects of database administration is required.