You were recently hired as a database administrator for CSUG

You were recently hired as a database administrator for CSU-Global Campus. During grade reporting, CSG-Global cannot afford to have any downtime. You have been asked to develop a plan for monitoring SQL Server databases. Address these aspects of the project in your discussion post: Develop a prioritized list of daily tasks in the order in which they should be performed to monitor the database. Identify and explain tasks that you can automate. Explain the benefits of establishing a baseline to benchmark the performance of SQL Server.

Solution

Answer :-

database administrator for CSU-Global Campus :

This position is responsible supporting the advancement of CSU Online goals and daily operations through the use of application and database development, data systems management, data reporting and report development, along with outstanding customer service. This position will work with staff across the organization to support business applications and processes, enhance existing applications, expand reporting capabilities, and ensure applications perform as expected.

This position relies on both technical capability (troubleshooting, analysis, software development, and administration) as well as functional capability (effective and efficient communication, documentation, technical support, and training). Hands-on software development, and implementation of business logic is critical to the success of this position.

The right candidate will contribute to a dynamic environment and work closely with other members of the Research & Analytics team, which is comprised of database engineers, web and applications developers, instructional designers, and learning analysts, to develop cutting-edge solutions for database applications, business intelligence and learning analytics, data visualization, and digital reporting tools.

Some after-hours and weekend work is required. This position reports to the Manager of Information Technology for CSU Online.

Required Job Qualifications :

1) B.S. degree in Computer Information Systems, Computer Science, or closely-related field from an accredited institution.

2) Evidence of effective written communication skills.

3) Evidence of personal initiative and ability to independently pursue solutions.

4) At least two years professional experience in the following:

5) Development of advanced SQL and T-SQL statements, stored procedures, queries, and triggers to support data management, analysis, and reporting.

6) Development and administration of SQL Server environment; 2008 or higher.
Implementation of online and database-driven applications and services including experience providing technical

7) and business process support.Monitor and manage user access and security to database applications and data reporting tools.

Preferred Job Qualifications :

1) Application development in Microsoft Access and Office.

2) Experience with managing data in a Higher Education environment.

3) Report development and administration using SQL Server Reporting Services or other online reporting solution.

4) Strong communication and customer service skills.

5) Ability to manage multiple requests and deadlines, as well as communicate task and project progress to organization staff.

6) Software development using Microsoft .NET technologies.

7) Experience with CRM applications .

Diversity Statement :

1) Reflecting departmental and institutional values, candidates are expected to have the ability to advance the Department’s commitment to diversity and inclusion.

2) Essential Duties

3) Job Duty Category

4) Application and Database Administration

Duty/Responsibility :

1) Support business operations through the creation, enhancement, and ongoing support of SQL Server tables, views, stored procedures, queries, SQL jobs, ETL processes, SSIS packages, SSRS reports, and the applications that use them.

2) Support the use of Salesforce CRM application, including data flows and ETL processes.

3) Support and enhance line-of-business applications built on Microsoft Access database.

4) Maintain and administer multiple database servers; including installation, maintenance, upgrade, performance optimization, security management and testing, and integration with external applications or services.

5) Conduct functional, performance, and security testing of databases and related applications.

6) Develop and support data integration, integrity, security, and system performance across information systems using good database design techniques, system monitoring, security auditing, and data analysis.

7) Participate in the definition and implementation of disaster recovery and business continuity plans for internal and cloud based servers.

Background Check Policy Statement :

Colorado State University (CSU) strives to provide a safe study, work, and living environment for its faculty, staff, volunteers and students. To support this environment and comply with applicable laws and regulations, CSU conducts background checks. The type of background check conducted varies by position and can include, but is not limited to, criminal (felony and misdemeanor) history, sex offender registry, motor vehicle history, financial history, and/or education verification. Background checks will be conducted when required by law or contract and when, in the discretion of the university, it is reasonable and prudent to do so.