Need a 6 page (2500 words) reflection paper over topics covered in 10 weeks. This needs to be someone who has IT/DBA knowledge that can reflect on the topics and how the relate based on the paper requirements.
Database Systems Administration
Provide a reflection of at least 2500 words (or 6 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.
Provide a 2500 word (or 5 pages double spaced) minimum reflection.
This must be in a proper APA style 7 formatting and citations. If supporting evidence from outside resources is used those must be properly cited.
Share a personal connection that identifies specific knowledge and theories from this course.
Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.
You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.
Learned Topics need for Reflection Paper:
1. DBA Tasks
The objective of this lesson is to learn the:
· Role of a DBA
Advanced DBA Services (2011). Linux Vs Windows : For Oracle Database?Retrieved from http://orainvicta.com/?p=177
2. Creating an Oracle Instance
The objectives of this week are:
· To learn the different types of tablespaces – the permanent, undo and temporary tablespaces.
· Understand the tablespace architecture.
· Understand the layout and configuration of tablespaces in a database.
· Know how to resize and alter tablespaces and datafiles.
· Bigfile tablespaces
· Bigfile tablespace restrictions
3. Oracle Architecture
The objectives To learn and understand the Oracle architecture. This involves learning about:
· the Oracle logical storage structures
· the Oracle logical database structures.
After reading all the assigned readings including the lecture materials, you should be able to explain what an Oracle architecture is to others. You should also know the difference between a database and an instance, inlcuding the main features of an instance such as the System Global Area (SGA). You should be able to describe a:
· and a segment.
Also, you should be able to describe the different tables in Oracle, including the related indexes, and constraints.
Oracle Database 11g Architecture Diagram. Retrieved from: http://ss64.com/ora/syntax-architecture.html Oracle Architecture and Metrics Retrieved from: http://www.wilsonmar.com/1oraarch.htm Oracle Architecture in less than 10 minutes. Retrieved from: http://www.youtube.com/watch?v=yk8esAZKz4k
4. Creating an Oracle Database
The objectives of this week is: to learn how to create a database. By the end of the week, you should know:
· How to create an instance.
· How to create a database manually and also using scripts.
· How to create a database using oracle configuration assistant, oracle's graphical interface.
· How to create a database using sql commands.
· Additionally, you should also know how to create the initialization parameters, the spfile and the pfile.
By the end of the week, you should be able to:
· Describe an instance including all the initialization parameters that they contain.
· Demonstrate how to create an instance and a database.
· Demonstrate how to create an init.ora file, with just one command.
· Create a database with just one command.
Creating a database with the CREATE DATABASE Statement Retrieved from http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm Oracle 11g database creation. Retrieved from Creating Database in Oracle 12c Step-by-step
5. Installing an Oracle 12c Server Software
The learning objectives for the fifth week are:
· Learn how to correctly install the Oracle Database 11g Server Software.
· Learn about the pre-installation tasks, such as determining memory and disk requirements.
· Learn about the Oracle installation guide for mostly Unix/Linux systems.
· Learn about Oracle's Optimal Flexible Architecture.
· Understand the mount points and the necessary directories for installing Oracle Database 11g.
· Know the prerequisities which includes ascertaining that the necessary packages have been installed on the UNIX/Linux system before installing Oracle Database 11g.
By the end of the week:
· Be able to create the necessary directories for the installation of Oracle Database 11g.
· Understand the Optimal Flexible Architecture is and how to implement it.
· Be able to explain what the Oracle installation guide is.
· Be able to determine the memory and disk requirements by using Linux commands.
Installing Oracle Database 11g on Linux Retrieved from http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/dbinst/dbinst.htm 12c linux installation. Retrieved from https://www.youtube.com/watch?v=JzSMYvAoH4A
6. UNIX Commands
The learning objectives:
· Learn how to monitor an Oracle Database.
· Understand some features of Oracle database that can help you monitor the database, in particular the AWR.
· Learn the UNIX tools that can help monitor the database.
By the end of the week students should be able to use those tools to monitor the database.
Oracle Database 12c Release 2: Manageability and Real Application Testing Overview Retrieved from http://www.oracle.com/technetwork/database/manageability/real-application-testing-wp-12c-1896131.pdf
Getting AWR Report from SQLPLUS. Retrieved from: http://www.techpaste.com/2012/07/generate-awr-report-oracle-database/
7. Database Performance
· Learn the importance of application development for a DBA.
· Learn the overall design and implementation considerations that affect database performance.
By the end of the week, students should know how to improve performance in an Oracle Database.
Oracle® Database Performance Tuning Guide 11g Release 1 (11.1) Part Number B28274-02 Retrieved from http://docs.oracle.com/cd/B28359_01/server.111/b28274/toc.htm
Identifying and tuning queries that cause Oracle wait events. Retrieved from:http://www.youtube.com/watch?v=-UkcXMSqdXU&feature=related
8. More Database Tuning
· Overview of Tuning the database
· Tuning the application design, SQL, Memory, data manipulation, storage
· Involving the users in the design of the application
· Table design – Theory based designed tables vs. User based designed tables
· Tuning Memory usage – use of Automatic Workload Repository – also can use new
· initialization parameters MEMORY_TARGET
9. Security Administrations
· Know and understand security in Oracle database.
· Understand how security is a responsibility of a DBA at a database level.
· Learn and understand the terminology used, Authentication, Authorization, and Auditing.
· The students should also know how privileges and roles in Oracle play a big part in security.
10. Backup, Restore and Recovery
· To learn and understand backup and recovery of an Oracle database, learn the three common methods of backing up a database: export, online and offline
· Students should know how to backup using an OS environment like Unix/Linux.
· They should also know how to backup using RMAN.
· The students should also know how to use Oracle in archivelog and nonarchivelog.
· Finally the students should know the important files to backup in Oracle database.
By the end of the week the students should be able to describe the backup and recovery as it pertains to Oracle Database 11g. They should also demonstrate that they know how to actually backup and even recover a database.
Oracle® Database Backup and Recovery User's Guide 11g Release 1 (11.1) Part Number B28270-03 Retrieved from: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/toc.htm
Oracle DBA Justin – How to backup an 11g Oracle database hot # 1 of 4. Retrieved from: http://www.youtube.com/watch?v=28E37BUX6o8
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.