What are the Duties and Job Resposiblities of Oracle DBA?
As a database administrator (DBA), your responsibility will be with the performance, integrity, and security of the database. You will participate in the planning and development of the database, as well as troubleshooting any problems on behalf of the users.
You will make sure that:
the data remains consistent across the entire database; the data is clearly identified by users who simultaneously access the data; Provides data protection and recovery control (ensuring that all data can be retrieved in an emergency) in a form that suits their needs.
As a database administrator, you need to:
Identifying user needs and monitoring user access, and monitoring performance and managing security settings to ensure responsiveness to front-end users, outline the conceptual design of the planned database, taking into account both the internal organization of the data and the availability of the front-end for end users; refine the logical design so that it can was converted to a specific data model, further refining the physical design in accordance with the system storage requirements, installing and testing new versions of the database management system (DBMS) that supports data standards, including data compliance Law on protection writes database documentation, including data standards , procedures and definitions for the data dictionary (metadata),controlling access permissions and privileges, develops, manages, and validates backup and recovery plans to ensure that storage and archiving procedures are functioning correctly, and perform capacity planning work. in close contact with IT project managers, database and multimedia programmers, regularly communicate with technical, application and operational personnel to ensure the integrity of the database and the security commission, as well as install new applications and tune existing applications to meet the objectives of aspect management database security and disaster recovery.
Perform capacity planning work. in close contact with IT project managers, database and multimedia programmers, communicate regularly with technical, application and operational personnel to ensure the integrity of the database and security commission, and install new applications and tune existing applications to meet the objectives of aspect management database security and disaster recovery.perform capacity planning work. in close contact with IT project managers, database and multimedia programmers, regularly communicate with technical, application and operational personnel to ensure the integrity of the database and the security commission, as well as install new applications and tune existing applications to meet the objectives of aspect management database security and disaster recovery.to be consistent with the security management and disaster recovery objectives of the database.to be consistent with the security management and disaster recovery objectives of the database. Database administration is key skill because you need to protect company’s important data.
DBA Tasks: What I have accomplished so far:
1) Install binaries. These can be both database binaries and client binaries.
2) Database design.
3) Create a database. Open the database for use / developers.
4) Create usage, manage users in the database. It’s about user permissions.
5) Back up your database frequently.
6) Performance tuning. Using AWR report in case of oracle
7) Database migration.
Transferring a database from one server to another. Maybe due to hardware problems or server decommissioning.
8) Correction of the database. No patching is required for bug fixes or additional functionality.
9) Updating the database. Update the database to have new features
10) Migration of the character set. Move the character set to a new one. This helps to support more languages.
11) Database of securities.
Database stores company’s important data and you need to manage very strong security for protecting data.
12) Planning storage and capacity. It includes keeping track of enough space available for the database to perform operations.
When there is something wrong with the database, dba must determine the cause of the problem using warning logs or trace logs.
This is a difficult task. You should perform recovery with minimal data loss.
15) Cloud Computing.
You need to learn about cloud computing to provide support or migrate database from on-prem to cloud.
As a DBA, you must be:
Patience: Some bugs are very sticky and require a lot of research to resolve. Some bugs / crashes are not even clear to the rdbms developer and are fixed automatically. As time said heals everything.
Focused: You must be very focused when doing dba tasks. One bad query or one bad step can destroy your database. I suggest avoiding parallel work for DBA tasks. Database Administrator DBA is a position well known as a company base. Since the DBA has full access to the company’s data, they are solely responsible for maintaining and manipulating the data according to the company’s needs. There are exclusive responsibilities of the database administrator. But in each company, the role will be slightly different depending on their access. So being an administrator is a pride.
Learning DBA is easy because gaining depth knowledge of this domain is not damn easy. You need to learn so many other skills like networking, system administration, cloud technology, data security, etc. Using daily learning from internet is the best option. You can stay connect with any good Oracle DBA Tutorials and knowledge sharing center. Only DBA Tips are not enough but you need to get database related latest news and technology.