SQL Server Database Administrator

Apply now Job no: 558534
Work type: Staff
Location: Chancellor's Office
Categories: Unit 9 - CSUEU - Technical Support Services, Administrative, Probationary, Full Time

Join our team at the California State University, Office of the Chancellor, and make a difference in providing access to higher education. We are currently seeking experienced candidates for the position of SQL Server Database Administrator
. The CSU Chancellor's Office, located on the waterfront adjacent to the Aquarium of the Pacific in downtown Long Beach, is the headquarters for the nation's largest and most diverse system of higher education. The CSU Chancellor's Office offers a premium benefit package that includes outstanding health, and dental plans; a fee waiver education program; membership in the California Public Employees Retirement System (PERS);

and 15 paid holidays a year.

The anticipated salary hiring range is up to $127,332 per year, commensurate with qualifications and experience.

Flexibility to telecommute two days a week, with three days on-site at the main headquarters in Long Beach, California.

Comprehensive Health, Dental, and Vision Benefits

15 paid holidays a year

Tuition waiver education program (also applies to eligible family members)

Membership in the California Public Employees Retirement System (PERS)

CSU Classification Salary Range: $87,408 - $127,332 per year (Step 1 - Step 20);
Step placement will be determined based on relevant qualifications and professional experience.
Step placement upon appointment is not expected to exceed Step 20 ($127,332 per year).Future increases, including step advancement, are subject to contract negotiations.

The California State University, Office of the Chancellor, is seeking a SQL Server Database Administrator to provide Microsoft SQL Server database administration support to developers and application support personnel at the Chancellor's Office (CO). Tasks include conceptualizing, developing, and implementing complex database, application, and integration capabilities. Additional expectations include performing tasks related to security, administration, tuning and monitoring, backup and restoration, creation of data exchange and interchange mechanisms such as Boomi, SSIS and DTS packages, SQL and SQL Reporting support, data modeling and normalization.

This position will ensure that all in‑house and third‑party applications that are dependent on Microsoft SQL Server at the CO continue to demonstrate high levels of performance and reliability. The position will ensure that database access complies with the standards and policies of the CSU.

• Plan the migration of on‑prem Microsoft SQL databases to Azure databases and Azure managed instances and execute technical work to move databases and ensure proper operations.
• Designing and implementing database schema changes.
• Leading and performing SQL Server installations and upgrades.
• Setting up SQL Server and Azure SQL databases and Azure managed instances.
• Maintaining revisions/versions of SQL Server databases while ensuring compatibility of the revisions/versions with existing applications.
• Implementing and supporting SQL Reporting Services.
• Integrating SQL Reporting services with other tools such as Boomi, Service Now, and SharePoint.
• Developing and tuning complex SQL statements and views for reporting.
• Providing on‑call assistance for the IT Support Center (Help Desk) and responding accordingly to reports of trouble as presented (which may include evenings and weekends).
• Providing development and testing support to multiple application development and support teams.
• Working with data center and application teams to resolve problems, outages, or slowdowns.
• Providing runtime optimization, capacity management and planning, security administration, configuration, scheduling and execution of maintenance utilities.
• Configure and manage database monitoring tools to ensure performance against established standards regarding reliability and response time.
• Managing systems for high availability.
• Being responsible for backups and coordinating backups with the data center administrator.
• Effectively…