Problem solving - Case Study Example

Database Administrator s Both jobs are for the senior database administrator. Both jobs are in New York. However, the job descriptions have similarities and differences. In relation to similarities, both jobs require the applicant to demonstrate engineering expertise for all the related database work. Both jobs stipulate that the candidates need to participate in on-call rotation making responses to alerts as well as system issues. Both jobs are permanent. The differences include, while the senior database administrator in Softworld needs to specialize in NoSQL/MySQL (Softworld, 2015), the job vacancy at Connections of New York require the applicant to demonstrate superior knowledge of Oracle database features, tuning and design methodologies (Connections of New York, 2015).

The other difference is that the senior NoSQL/MySQL database administrator is to be responsible for engaging in assembling, managing, and maintaining a heterogeneous database environment in the technical operations group (Softworld, 2015). On the other hand, the position of a senior oracle database administrator requires a person with proven technical and architect skills who have the ability to communicate effectively with developers along with other teams of database administrators (Connections of New York, 2015).

At Connections of New York the database administrator is tasked with managing and maintaining all Oracle production and non-production databases, design and fix the functioning of the backup and recovery on DBMS, optimize Oracle database resources for optimum database performance, maintaining Oracle availability on various platforms, carrying out short-term and long-term database analysis, creating database administration polices, mentoring database developers on new database technology, and finally, designing and implementing standards for monitoring (Connections of New York, 2015).

On the other hand, the database administrator at Softworld is responsible for ensuring data systems are operating smoothly, writing and performing DDL as well as DDL as needed, audit different databases to ensure integrity, carrying out upgrades, working with the data engineering team, and managing storage restructuring as needed, installing patches as required, and deal with database situations, such as queries run amok, replication, and stale stocks (Softworld, 2015). The average salary for a senior database administrator in New York is $ 122,271 annually, according to the United States Department of Labor.

ReferencesConnections of New York. (2015). Database Administrator Senior, Retrieved March 1, 2015, from https://www.dice.com/jobs/detail/Database-Administrator-Senior-Connections-of-New-York-New-York-NY-10001/10115962/342498Softworld. (2015). Senior database administrator, Retrieved March 1, 2015, from http://jobview.monster.com/Senior-Database-Administrator-NoSQL-MySQL-Job-New-York-NY-US-146571202.aspx?mescoid=1500130001001&jobPosition=4