CIS 515 Student Response
See attached
Discussion post responses.
Respond
to the colleagues posts regarding:
Information professionals with adequate skills are required to maintain the business continuity of database services in an organization. Identify and assess at least three professional skills that would be required to be successful database administrators.
Give your opinion on what the critical nature of a database administrator’s role is to IT industry organizations. Support your answer with specific examples of functions and responsibilities they perform.
LP’s post states the following:Top of Form
Question:
Information professionals with adequate skills are required to maintain the business continuity of database services in an organization. Identify and assess at least three professional skills that would be required to be successful database administrators.
Answer:
Database administrators (DBA) must have strong organization skills, a high level of technical skills, and good Interpersonal Skills to manage large databases and the people that are using the data.
Well-organized data makes access easier for users and improves database performance and increased productivity (Hughes, 2020). DBAs must understand how computers store and retrieve data and how to build computer databases. They must also understand the technical aspects of database organization, and how database organization affects the computer and network performance (Hughes, 2020). They must be able to solve technical problems that are caused by database design or malfunction. When an event occurs that affects a database, the DBA must be involved to ensure minimal data loss. They must also be able to work with a diverse group of people. This will take strong communication skills to provide database assistance. They must be able to communicate with programmers and systems technicians to ensure that applications access a database properly (Hughes, 2020).
Question:
Give your opinion on what the critical nature of a database administrator’s role is to IT industry organizations. Support your answer with specific examples of functions and responsibilities they perform.
Answer:
A DBA is the overseer of the data, the gatekeeper, the oracle. They have to work currently with IT to ensure the correct access is granted to the correct users or the principle of least privilege. System DBAs oversee technical aspects of database administration which includes code debugging and software upgrades (Best Value Schools Staff, 2019). Application DBAs focus on the management of specific applications that working with the database (Best Value Schools Staff, 2019). Typical duties for a DBA include securing and restoring data, creating new user permissions, testing modifications, merging old databases, and conducting performance-tuning support. DBAs continually monitor their database systems to ensure efficient, error-free functioning.
References
Best Value Schools Staff. (2019). What Does a Database Administrator Do? Retrieved from Best Values Schools: https://www.bestvalueschools.com/faq/what-does-a-database-administrator-do/
Hughes, A. (2020). Skills Needed by a Database Administrator. Retrieved from Chron:
https://work.chron.com/skills-needed-database-administrator-10356.html
TT’s post states the following:Top of Form
Information professionals with adequate skills are required to maintain the business continuity of database services in an organization. Identify and assess at least three professional skills that would be required to be successful database administrators.
Database administrators (DBA)s need strong organizing skills to manage large/small databases. A well-structured database makes data access easier for users and performance. Likewise, a poorly organized database will result in slower access to data and wasted productivity. Administrators also organize the procedures that affect the database, collaborate on installation software. As well as backup and recovery procedures to protect this data in case of a disaster in the data center to prevent days of downtime and financial loss for the company.
This requires technical skills to work with the computers that house data. DBAs should understand how data is stored and retrieve, and how to develop databases. Understanding the technical features of the database, and how database structure affects the computer and network performance. DBAs must be able to solve technical problems that are caused by database design or malfunction. When an event occurs that affects a database, the DBA must be involved to ensure minimal data loss.
A good DBA possesses good communication skills for providing help with technical issues, between programmers and systems technicians to ensure that demands for access to a database remain accurate. Communicating with users is also important to ensure that all data requirements are met when designing the database.
Written communications are extremely important in communicating major points to individual audiences.
Hughes, A. (2020). Skills Needed by a Database Administrator. Retrieved from Chron: https://work.chron.com/skills-needed-database-administrator-10356.html
Give your opinion on what the critical nature of a database administrator’s role is to IT industry organizations. Support your answer with specific examples of functions and responsibilities they perform.
A database administrator’s (DBA) main job is to guarantee that data is available, protected from loss and corruption, and access to the user`s as needed.
Skills to collaborate with software installations and configurations of new Oracle and SQL Server databases. Setting up hardware and install software and making updates as required. In situations where new servers are needed, the DBA will set up and handle the transfer of data from the old server to the new server.
In the case of a server failure or another type of data Loss, a DBA uses established backup and recovery plans and procedures set up to restore lost information to that system.
A need to be familiar with the weakness of their software used and the organization`s overall system to minimize any risk the DBA`s must monitor system performance.