Two 100 word responses apa 1 reference

Two responses 100 words each so 200 total at least. Respond don’t make similar must be a real response.

1st. Finally, one that sort of falls into my experience level. The roles played by database developers and database administrators is very much like the roles of a software developer and a systems admin. Hell, it’s a lot like any developer versus admin role, to be perfectly honest.

A developer designs, creates, and works within the database. The admin is generally in charge of maintaining, monitoring, and upgrading the system and the hardware running the database. A developer can go to the admin and say they will need more memory or processing power for the next evolution of the database to take place, and the admin will look into upgrade options or, if needed, find a new system capable of supporting the developer’s needs. The developer is the one you call if a line in the program isn’t pulling what it should, the admin is who you call if the system won’t even power up.

It should be noted that some companies require the dev to be the admin as well. My job, which is centered on a type of database, requires a separation in the positions. Our devs concern themselves with the program itself, while my shop takes care of the hardware used to access the information. Neither shop could, or are allowed, to do the others job, but we do maintain constant dialogue with one another to ensure the entire process is working as it should. Luckily I also get to interact with the customers who pull data from the database to do their job (aircraft mechanics). Aircraft mechanics are typically a very fun group of people to interact with once they know you aren’t the reason they are being forced to use laptops instead of paper.

⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀⚀

2nd The main difference between a database administrator and a database developer is the administrator “performs the day-to-day task of maintaining the database environment to ensure its availability and that it runs smoothly using database tools to monitor, fix and maintain the physics of the database software and the hardware on which it runs” (Technical Recruiting Book.com, 2010). The developer “designs and creates new ways of using a software application” (Technical Recruiting Book.com, 2010).

To name a few specifics about the database administrator, they can do things such as determine privileges related users accessing the database. For example, take a database that houses inventory for a business as well as financial information related to its customers. The database administrator can ensure that only certain people have access to the customer’s financial records. A database administrator can also be in charge of disaster planning where they create a disaster recovery plan “to ensure data availability if a disaster occurs” (Pratt & Adamski, p. 262). They can also be responsible for archiving information which can get tricky as they need to ensure all avenues are in compliance with data retention laws and regulation.

Database Developers can develop, enhance or troubleshoot software. For example if there is a bug in a database the developer might come up with a solution to fix it. They can also build they database that the database administrator maintains. An example of when the two come together can be during a testing phase. Normally testing is done in a testing environment; however, once testing complete the database administrator does have to grant access to the database developer to allow them to move their updates to the production environment. Both parties can work together to ensure the updates go smoothly so the production environment is not negatively impacted.

Matt

References

Database Developer vs Database Administrator. (2010). In Recruiting Technical Skills. Retrieved from http://technicalrecruitingbook.com/blog/2010/12/database-developer-vs-database-administrator/

Pratt, P. J., & Adamski, J. J. (2012). Concepts of Database Management (7th ed., pp. 262). Boston, MA: Joe Sabatino.

"Is this question part of your assignment? We can help"

ORDER NOW