I need this assignments to be done each module between 2 to 3 pages. there are six module all together. It is due by 01/20/2018 but it would be great if you give me the first module by 1/13/2018. Than

IT 349: Final Project Guidelines and Rubric

The final project for this course is divided into two parts: configuration and optimization recommendations, and a job aid.

As a database administrator, it is essential that you understand the foundational concepts of data, database management, and database maintenance. While each database tool may appear different, the same concepts stretch across tools. Thus, your success in this course will be contingent on your ability to apply foundational database administration concepts to a specific database, as well as perform the common maintenance tasks necessary for improving functionality and ensuring security and integrity of data.

Your assessment for this course requires you to place yourself in the role of a database administrator as you evaluate an existing database environment and make recommendations for configuration and optimization. Additionally, you will create a job aid that will be used to onboard new database administrators This will allow for a practical approach to applying database administration concepts and performing essential administration and maintenance tasks. Refer to the prompt below for the specifics. You will need to download your database from this link and import it into the environment located on your virtual desktop to complete this final project.

The project is divided into five milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules Two, Three, Four, Five, and Six. The final product will be submitted in Module Seven.

In the final project, you will demonstrate your mastery of the following course outcomes:

• Configure relational database environments to align to a defined set of business requirements

• Perform common database maintenance and administration tasks on various database management systems that improve functionality

• Optimize databases for scalability and performance based on the business environment and in accordance with business needs

• Perform database backups and successfully restore data operations in accordance with best practices in database administration

• Manage secure database by performing common security administration and access procedures

Imagine that you are a database administrator for SNHU Car Parts and Accessories. Currently, the organization has a relational database running on Microsoft SQL Server. The company sells car parts and accessories out of its Manchester, NH, location and through its online e-commerce website, and is thinking about expanding to other areas of the country.

You have recently been promoted to senior database administrator and have been tasked with two projects. Knowing that the business is planning on growing and expanding, you have been asked by the information technology (IT) director to:

1. Support the business’s initiatives by recommending methods for configuring and optimizing the existing database environment to ensure scalability and reliable performance as the business grows, and to align with the following business requirements:

   1. Optimize the database/website to support ongoing growth

      1. Recommend a scalable solution

      2. Define security standards

      3. Include user tracking and an auditing system iv. Provide order fulfillment and order tracking

   2. Website should be able to support 100 simultaneous users

   3. Include search functionality

   4. Render website content in multiple languages

   5. Meet ADA requirements

2. Create a job aid that will be used to onboard new database administrators when you are unable to devote your attention to their training.

Final Project, Part I: Configuration and Optimization Recommendations

Analyze the existing database environment, located on your virtual desktop. As the IT professional, make recommendations that will allow the database environment to align to the specified business requirements while also ensuring scalability and reliability of performance as the business grows.

Specifically, the following critical elements must be addressed:

1. Introduction:

   1. Provide an overview of the scenario, including an analysis of the organization, the current state of the business environment, and any industryspecific information you feel is relevant. Be sure to describe the business environment in terms of what might be important for consideration in the recommendations you will make to improve the database environment, providing specific examples to support your claims.

   2. Are there any particular assumptions or conclusions that you have made about the scenario, the business environment, and the database environment that are important to note? What led you to these assumptions and conclusions? Provide specific detail to support your considerations.

1. Business Requirements and Needs: Given what has been provided in the scenario, discuss the specific business requirements that need to be met by the database, as well as the business needs that exist. Remember that the business needs may not always be included in the requirements, as often businesses establish requirements without full knowledge of future growth or technological aspects. Part of your job is to plan ahead and make educated predictions on what the business needs may be in the not-so-distant future. Establish the business needs in correlation with the defined requirements, and explain your conclusions.

1. The Existing Database: Where is the current database falling short of expectations, needs, and requirements? Explain your conclusions with scenariospecific context and specific examples. Some things to consider include but are not limited to the performance speed of various aspects, the quality or reliability of the program, and the impacts of certain functions or programs on the database environment.

1. Configuration: Recommend ways to configure the database environment so that it aligns with the defined business requirements. How do you know that your recommendations will meet these requirements? Be sure to support your recommendations with relevant sources and examples.

1. Performance: You have established the business requirements and the needs as informed by your analysis of the given scenario. Given the information you have gleaned and your predictions for future needs, outline your recommendations for ensuring continued performance quality. In other words, what will need to happen to maintain or even improve the levels of performance, and why do you feel these steps are necessary and will be successful? What evidence exists to support your conclusions?

1. Scalability: Given the information you have gleaned from the scenario and the predictions you have made about the future of the business, what is your recommendation for ensuring scalability? Specifically, as the business grows and expands, how do you know that your recommendations will allow the database environment to grow in a manner that will meet the business’s needs? What evidence supports your recommendations?

Final Project, Part II: Job Aid

Create a detailed job aid to help train the new database administrators that the company will hire. You will be working your way through the following tasks to create process documentation that new hires can follow.

There are two options for submission, both of which will apply to the itemized prompt listed below. Please view the Guidelines for Submission for more information on the submission expectations and rubric that will be used to evaluate submissions of both option types at the end of this document.

The first option is a written job aid that contains screenshots to illustrate the processes/tasks and written explanations to highlight the purpose, importance, and steps necessary for successful completion in alignment with the company’s needs and standards. In assembling the job aid, you should provide written instructions to facilitate understanding of each process and a table of contents to make finding each appropriate process easier.

The second option is more technology dependent, but would allow for non-written submissions. This option requires the use of a tool, such as Jing, that enables you to record yourself working through each designated task while capturing your verbal explanation of steps and importance of processes. While you may use another tool, Jing has full IT support and is free, while many other tools are not. The SNHU Help Desk will not be available to assist you with the use of a tool for this option; therefore, Jing is highly recommended. Should you run into difficulties that you cannot address, it is your responsibility to revert to option 1 in order for your submission to be on time. Late submission because you were not successful in using a tool for option 2 will result in the normal late penalties established for this course.

Specifically, your job aid should include the following critical elements, most of which are tasks common to the database administration scope of responsibilities:

1. Introduction: This is where you will inform the audience of general business requirements/standards for database administration that currently exist for the organization. Specifically:

   1. Communicate the properties of the database (size, location, file names) visually and verbally/in writing.

   2. When are the peak use hours of the database? Explain how you determined this, why it matters, and what to do if peak hours change.

   3. What backup software does the company use? Why? What relevance does this hold for the new team members?

1. Administration, Optimization, and Configuration: There are several tasks that the average database administrator will need to be able to perform. Attend to the performances listed below by walking your audience through each task, providing a visual representation of the process, a written/verbal explanation of the steps, their relevance, and when a new administrator might need to perform the task:

   1. Create new tables, views, and stored procedures. As you create the tables, views, and stored procedures, be sure to include identifiable information, such as your name, your imaginary employee ID number, and so on. Be sure to communicate any particular standards that new tables need to meet in order to ensure data integrity and consistency across your database.

   2. Create a copy of the database. Where is the data stored? Should you have a copy in a remote location? Why? c) Detach and attach a database to the environment

1. 1. Import data from external sources (i.e., flat files, Excel, and extracting data)

   2. Baseline the database (use the SQL Profiler): Why does this matter?

   3. Set the database to grow automatically by a certain percentage. Provide your justification.

1. Maintenance, Backup, and Recovery

   1. Determine the timeframe for committing and truncating the database log files.

   2. Back up the database. How often should the database be backed up? Why?

   3. Explain how to monitor disk utilization of the server.

1. Security

   1. What security groups are present? Who has access to the database? How do you know this, and where do you go to gather this information? b) Include how to add/remove users and groups

c) Assign database permissions to users in groups

Milestone One: Database Optimization Recommendations, Part I

In Module Two, you will submit a two- to three-page paper that provides an introduction addressing the specific business scenario identified for the final project. Specifically, you should:

• Analyze the business environment

• Identify assumptions

• Establish requirements and needs

• Analyze existing database

Discuss the roles of staff, vendors, consultants, and the organization in making the database improvement process successful. This milestone will be graded with the Milestone One Rubric.

Milestone Two: Database Optimization Recommendations, Part II

In Module Three, you will submit a two- to three-page paper discussing configuration and performance monitoring. Provide recommendations for configuring the database to meet the needs of the organization. Also, discuss how the performance will be monitored to ensure quality control. Provide support that is professional, scholarly, and reputable within the industry. In preparation for the final submission, begin to consider how the database could be scalable as the organization grows. Please note that this milestone will not be submitted as part of the final project submission. This milestone provides an initial overview of the key concepts that will later be introduced as part of the final requirements.

This milestone will be graded with the Milestone Two Rubric.

Milestone Three: Job Aid, Part I

In Module Four, you will submit a two- to three-page paper that provides an introduction for a new employee in the organization. Specifically, you should:

• Communicate the properties of the database

• Identify peak hours

• Identify software used for backup

This milestone will be graded with the Milestone Three Rubric.

Milestone Four: Job Aid, Part II

In Module Five, you will submit a two- to three-page paper that provides a new employee with an in-depth description of the administration of a database. Specifically, you should explain the steps required to:

• Create tables, views, and stored procedures

• Copy a database

• Attach and detach a database

• Import data from external sources

• Use SQL Profiler to correctly baseline database

Be sure to support your analysis with strong explanations, professional resources, and established industry concepts and practices. This milestone will be graded with the Milestone Four Rubric.

Milestone Five: Job Aid, Part III

In Module Six, you will submit a two- to three-page paper that provides a new employee with an in-depth description for the continuation of administration and ongoing maintenance of a database. Specifically, you should:

• Explain steps required to set database to grow automatically

• Determine correct timeframe to commit and truncate the database log

• Perform backup of database

• Describe how to monitor disk utilization

Be sure to support your analysis with strong explanations, professional resources, and established industry concepts and practices. This milestone will be graded with the Milestone Five Rubric.

Final Project Submission: Configuration and Optimization Recommendations and Job Aid

In Module Seven, you will submit your final project. It should be a complete, polished artifact containing all of the critical elements of the final product. Your final submission should reflect the incorporation of feedback gained throughout the course, specifically the feedback received from Milestones One through Five. Your submission should also include the following critical elements not previously addressed in the milestones:

• Recommend methods for ensuring scalability of the database

• Identify user groups and how to locate information

• Demonstrate how to add and remove users and groups  Assign database permissions to users in groups

The final submission should reflect a solid understanding of the needs and qualities of a database environment. The configuration and optimization recommendations will be graded using the Final Project Part I Rubric. The job aid will be graded using the Final Project Part II Rubric.

Guidelines for Submission: The configuration and optimization recommendations must follow these formatting guidelines: double spacing, 12-point Times New Roman font, and one-inch margins.

Guidelines for Submission: There are two submission options for Part II of the final project:

1. Written job aid featuring screenshots (or embedded videos) of performance tasks, as well as written explanations and answers to critical elements.

1. Use of recording tool, such as Jing, to record yourself performing each task. Jing will allow you to record the activities you perform on your computer, while also recording your verbal explanations to files that are up to five minutes in length. The use of Jing requires an updated Flash driver, as all files will be saved as Flash files. Any issues that you may run into will have to be dealt with by Jing’s IT support, not the SNHU Help Desk. If you run into difficulty and feel you cannot use this option, please continue with the first option. It is your responsibility to make sure you complete and submit your assessment on time.