Two small businesses, Apex Computer Parts and City Computer Supply Co., have mer

Question

Two small businesses, Apex Computer Parts and City Computer Supply Co., have merged into a single entity, keeping the name of City Computer Supply Co. The new company will begin with combined sales exceeding that of all other companies competing in the region, making it a medium-sized business. Each parent company had small IT departments without clear employee structure, even though much of their business management was heavily dependent on relational database management systems. Apex's system was developed and maintained in Microsoft Access over the past six years, whereas the system in the premerger City Computer Supply Co. was 10 years old and was developed and maintained using Microsoft SQL Server. The Board of Directors and the CEO of the new company set out some of the business objectives that directly relate to a new Information Systems Division and have appointed a new chief information officer. Since it is clear that the combined City Computer Supply Co. will need a solid IS/IT base with a more clearly defined structure, the CIO has contracted you to assist her in the planning and implementation of the new department, and specifically to consult on hiring a new database administrator and other staff as needed to meet the business objectives and to manage the transition to a fully operational department. The Board and CIO set out the following business objectives for the new department: Combine all data into a single centralized system. Streamline all software applications to properly support all business functions of the merged company. Protect all business information as the valuable assets they represent. Vigilantly monitor and maintain all informational assets. Minimize any threats to the business' informational assets from loss by any means and from breaches of confidentiality. Ensure the integrity of all information owned by the business. Constantly optimize the information system software. Develop and implement all information policies, procedures, and standards. Plan for future implementation of data warehousing and data mining operations. Research and write a 2–3 page paper that covers the following: Analyze the roles and responsibilities of the database administrator in the context of stated business objectives. Describe the education and experience requirements you would require of applicants to the database administrator position. Describe how the existing skills of database administrator applicants will be vetted to ensure the best candidate is chosen.

Explanation / Answer

To create and implement a data warehousing and data mining operations for the organization.

-----------------------------------------------------------------------------------------------------------------------------------

we must Develop and implement all information policies, procedures, and standards of data warehousing and data mining operations..

- Developing a Database team mission statement that will be used in an company or in an organizational with there goals
- In order to make the Database team more successful we should try to Learn to identify, understand, and manage customers.
- In order to have better understand business goals we should Identify market forces that drive the business in present days.
- we always make sure of business and there Understanding on doing business and how business leaders develop strategy
- Make more informed purchase decisions to Apply analysis on Database vendors
- Understand the hackers and attacker motivations and techniques in all aspects
- Understand assets and process of business that are most valuable to the business.
- Learn the strategic planning of kill chain and threat intelligence in Database level.

The purpose of data warehousing and data mining operations.

-------------------------------------------------------------------------------------

- Saving and securing all the business data of a organisation or a big company.
- In order to align security with the corporate culture we should Understand the values and culture of your organization
- Understand the current Strengths and the Weaknesses, and Opportunities, and Threats in the business.
- Identifying what needs to be done in the company or in an organisation.
- Identifying what should be done first in business.
- Approaches to obtaining funding
- Promoting the work of the Database team
- Developing effective metrics and Dashboards in the business
- Learning to innovate with the business so that it will be useful to business development

Plan for future implementation of data warehousing and data mining operations.
---------------------------------------------------------------------------------------------------------

- we must know the data warehousing and data mining operations we must understand how to review, write, assess, and support security policy and procedures.
- we must know the understand about the data warehousing and data mining operations.
- we must know the how to Establishing acceptable bounds for behavior in the company where we use the data warehousing and data mining operations.
- we must know the Leading the employees to do the right thing in data warehousing and data mining operations.
- we must know How policy protects people, organizations, and information in data warehousing and data mining operations
- we must know the Relationship of mission statement to policy in data warehousing and data mining operations
- we must know the Policy versus procedure in data warehousing and data mining operations.
- we must know the Policy needs assessment in data warehousing and data mining operations.
- we must know the Governing policy
- we must know the Issue-specific policy
- we must know the Positive and negative tone
- Policy review and assessment process
- we must know the Role of psychology in implementing policy
- we must know the Organizational culture

Identify the scope for each test and identify any special considerations that need to be addressed who are working in the data warehousing and data mining operations
-------------------------------------------------------------------------------------------------------------------------

- We all must know about the Leadership of developing the organisation.
- we should Creating and Developing the entire working team.
- we should give them better Coaching and Mentoring the team
- we always maintain the Customer Service Focus
- we should rectify the Conflict Resolution
- We should maintain the Effective Communication
- Leading through Change
- There must be a Relationship Building within the team.
- Motivation and Self-direction
- There must be a effective Teamwork
- There must be Leadership Development

Describe the education and experience requirements you would require of applicants to the database administrator position.
--------------------------------------------------------------------------------------------------------------------------
- He must have the Knowledge on Installation of Database on Single Host and Multiple Host systems.
- He must have the Knowledge on Deploying delivery units of deploying different data transitions.
- He must have the Knowledge on Backups and recovery of a Database
- He must have the Knowledge on different Replication server on different database.
- He must have the Knowledge on User Creation, Assigning roles to users in the database level.
- He must have the Knowledge on Starting and Stopping Database.
- He must have the Knowledge on Configuring Database system properties.
- He must have the Knowledge on Monitoring Database.
- He must have the Knowledge on Database refresh and Database disaster management.
- He must have the Knowledge on installing Studios or UI to monitor the Database.

Describe how the existing skills of database administrator applicants will be vetted to ensure the best candidate is chosen
-------------------------------------------------------------------------------------------------------------------------------
The database administrator must know the recommendations of all Databases like ORACLE,MySQL and SQL server databases.

* The recommendations for securing the database that are unique to Oracle are:

- Oracle Database leads the industry in security.
- In any business environment or a company or a big organisation, it is very informative and secure that the database itself be well protected.
- Oracle Database Minimizing the costs of equipment, personnel, and training
- Oracle Database Minimizing delays and errors
- Oracle Database Maximizing rapid and thorough accountability.

* The recommendations for securing the database that are unique to MySQL are:

- MySQL is very secure database and it is used for Securing the servers in an company or organisation.
- MySQL can Disable or restrict remote access of end users.
- MySQL can prevent unauthorized reading from local files.
- MySQL can Lower database privileges
- The default administrator username on the MySQL server is “root”. So it can Change root username and password
- MySQL comes with a test database intended as a test space. It can be accessed by the anonymous user, and is therefore used by numerous attacks.
- MySQL can Remove Anonymous and obsolete accounts
- MySQL can Lower system privileges and it can increase database security with Role Based Access Control.

* The recommendations for securing the database that are unique to SQL Server.

- With help of SQL server we can encrypte the database backups.
- Using the SQL Server we can Secure the database backup folder by removing unwanted users.
- Using the SQL Server security best practice everyone should use Windows Authentication to connect to SQL Server for better security.
- Make the system administrator account's password complicated.
- By Using the SQL Server we can audit failed logins to SQL Server.
- By Using the SQL Server we can Turn off the SQL Server browser service
- By Using the SQL Server we can Disable features such as XP_CMDSHELL, OLE AUTOMATION, OPENROWSET and OPENDATASET
- By Using the SQL Server we can Decrease privileges for the SQL Server service account.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.