Position Title: Database Administrator, CAS Administrative Operations

Posting Number: P220125

Employer: State

Salary Range: $75,000 - $85,000

FTE: 1.00

Position Summary:

• Coordinate activities to maintain and further develop the department's centralized data repository to facilitate aggregation and reporting of market data in collaboration with the Assistant Dean of Planning and Analytics.
• Extract, validate, and integrate large data sets from various sources in electronic and non-electronic formats to facilitate reporting and analysis.
• Maintain, evaluate, design, review and implement database management standards to better serve the needs of the department/organization, including the maintenance of user access and security.
• Collaborate with members of other CAS departments/divisions, including but not limited to Finance, Human Resources, Information Technology, Marketing and Communications and Enrollment on data sources, web application and governance.
• Regularly identify opportunities and develop enhancements to the team's data repository and supporting software. Continually look for opportunities to enhance the data and reporting capabilities of the team; ensuring easy and fast access to data for Planning team members.
• Develop, secure, and maintain database tools used to gather and combine data for all CAS entities.
• Creating and implementing data security and recovery controls. Effectively manage all data across the platform and communicate all projects / feedback to the necessary parties.

Minimum Qualifications:

• Bachelors Degree in Computer Science, Information Systems or equivalent.
• Three year's experience in database design and management including: Database installation and configuration, data security, user creation and maintenance, database backups and recovery, database performance tuning and optimization, data transformation and loading, and querying and reporting.
• Possess SQL certification in MySQL, MSSQL or other.
• Project management experience.
• Expert knowledge of SQL Server/ T-SQL, scripting languages including Unix shells and PowerShell, and the principles of web-based technologies.
• Excellent communication and technical writing
• Excellent problem solving and analytical skills

• Operating Systems, including Linux, Windows, and Macs
• Data feeds: APIs, data taxonomy
• SQL Server/T-SQL
• Experience with Qualtrics Survey software, Tableau Data visualization software and a high-level programming language – C++, Java, C#, Python, Javascript
• Scripting languages – Unix Shells, PowerShell
• Current tech stack – MS SQL, Oracle and/or MySQL

Preferred Qualifications:

• Masters Degree
• Five or more years' experience in database design and management including: Database installation and configuration, data security, user creation and maintenance, database backups and recovery, database performance tuning and optimization, data transformation and loading, and querying and reporting.

Deadline for Applicants: 09/06/2022

Quicklink for Posting: 34185