SQL Server Admin with SQL, data modeling, normalization, SSMS, Oracle/Postgres/MySQL, change management, versioning, DR, tuning, backup/recovery and data warehouse/data lake experience

Job ID: UT-65164 (90090916)

SQL Server Admin with SQL, data modeling, normalization, SSMS, Oracle/Postgres/MySQL, change management, versioning, DR, tuning, backup/recovery and data warehouse/data lake experience

Location: Salt Lake City UT (USBE)
Duration: 3 years

1. Degree Candidate must possess a bachelor’s degree in a Computer Science or related field, or equivalent experience
2. SQL Experience Candidate must demonstrate experience with writing efficient SQL
3. Data Modeling and Normalization Skills Candidate must demonstrate skills in the process of data modeling and normalization for promoting data integrity
4. DB Tools/Utilities Knowledge Candidate must demonstrate knowledge of DB Tools/Utilities (e.g., SSMS)
5. Relational Database Knowledge Candidate must demonstrate knowledge of multiple Relational Databases (i.e., SQL Server, Oracle, Postgres, MySQL)
6. SQL Server Application Understanding Candidate must demonstrate strong understanding of how to maximize SQL Server application scalability, performance, recoverability, and maintainability
7. Problem-Solving & Analytical Skills Candidate must demonstrate problem-solving and analytical skills
8. Interpersonal Skills Candidate must demonstrate ability to communicate in written and verbal form, work in a team setting, and apply negotiation skills as well as the ability to maintain good relations with users, developers, operations, and the information security team
9. Organizational Skills Candidate must demonstrate the ability to organize tasks and prioritize
10. Flexibility and Adaptability Candidate must demonstrate ability to be flexible and adaptable
11. Reporting and Analytics Structures Experience Candidate must demonstrate experience in building reporting and analytics structures such as data warehouses and data lakes

The Utah State Board of Education (USBE) is working on a comprehensive modernization initiative to replace our legacy systems, referred to as the Utah Schools Information Management System (USIMS). Working for the USBE is a rare opportunity to use a combination of the latest technologies, best-of-breed software packages and custom development to deploy a refreshed code base and associated reporting applications and reports. We are looking for an experienced System Administrator to join our team. In this position, you will serve as the development and production DBA.
To be a successful candidate, you will need to understand how to maximize scalability, performance, recoverability and maintainability; analyze and solve problems; and have the ability to communicate effectively with a wide range of people in various roles.

Responsibilities:
• Contribute to creating a scalable, maintainable and usable database environment to support software development efforts and application requirements
• Contribute to the automation of database change management processes
• Translate logical data models into a physical database implementation
• Work in cooperation with the development teams to provide tools to facilitate database testing and data refresh
• Mentor development teams on the proper methods for efficient data access and modification logic in software systems
• Support the application of source code management for versioning, impact analysis, testing and promotion of database code
• Develop a Disaster Recovery Plan to recover from database failure with minimal data loss and downtime
• Monitor database performance and provide recommendations and resolutions for identified issues for development, test and production environments
• Maintain the integrity of database environment through change management, automated backups, recovery processes and security audits
• Ensure data is appropriately secured such that only the required users have access
• Build reporting structures as data warehouse or data lakes

http://innosoul.com/wp-content/uploads/2019/09/E-RTR-2.doc

65164 skills.docx

Leave a Reply