SQL Database Administrator (Job ID: 6721) Expected Start Date: April 2019 FTE: 1.0 Hours per day: 8 Salary Level: PT-8 $36.54 - $45.98. Salary placement is based on verifiable LIKE experience. Union/Days per year: Professional Technical, 260 work days, 12 month Benefits: This job has the full range of benefits offered by Tacoma Public Schools. Summary: This position ensures availability and performance of the databases (DBs) that support various business applications throughout the District; maintains project schedules and tasks related to DB maintenance functions; monitors structured query language (SQL) server jobs and their performance; conceptualizes, documents, and communicates solutions to meet department goals and District objectives. JOB DESCRIPTION 1. Monitors and maintains DBs and middleware for efficiency, performance, backups, and standby data replication for applicable technologies; proactively watches the DB systems to ensure minimum downtime; performs DB performance evaluations; makes recommendations to improve performance. 2. Collaborates with other information technology (IT) staff related to application performance, tuning designs, metadata definitions, and infrastructure recommendations; works closely with key stakeholders supporting District initiatives and projects. 3. Manages, monitors, allocates physical DB storage for DB systems; watches DB redundancy modes, log file sizes, clustering, mirroring, and overall DB size to minimize disk space usage; performs capacity planning and monitoring of individual DB growth; assists users to determine database requirements. 4. Plans, coordinates, and performs environment cloning/copying of production environments to test and development environments for data migration between systems. 5. Performs DB queries and analysis; carries out report development utilizing SQL server; performs architecture, installation, upgrades, patching, and documentation of DBs and application technology stacks. 6. Recommends DB architectures for both transactional and analytical systems; implements technologies such as DB job automation and scheduling. 7. Maintains project schedules and tasks related to DB maintenance functions; coordinates scheduling and implementation with the corresponding stakeholders; provides event monitoring for up/down DBs status and other reported errors; reports any issues and outages to the applicable administrator or designee. 8. Administers change control process for production moves. 9. Evaluates and makes recommendation on new tools, products, and features related to the DB environment; develops plans for District DB capacity growth; works with data stewards to determine enterprise strategic DB needs. 10. Provides training and education to key stakeholders; provides technical support to developers on use of specific DB platforms and the design, programming, and development of applications that will interface with DB platforms; assists stakeholders with application compatibility and interoperability testing. 11. Performs patch testing and installation to SQL server DBs; coordinates all SQL server DB upgrades; reports functionality with deliverables; provides reports to District stakeholders on progress of tasks assigned; ensures critical items are escalated, as appropriate. 12. Provides estimates of required time and resources for completion of assigned projects or tasks to appropriate District staff and/or administrators, and stakeholders; provides project status reports; records actual time used. 13. Develop and maintain technical documentation including policies, procedures, and standards to support system operations; including, but not limited to, ensuring test procedures are defined, documented, and implemented for all DBs, backups, fail-over, and recovery. OTHER JOB DUTIES: 1. Maintains and updates knowledge and skills required for success in the position by participating in professional development activities as needed or assigned. 2. Assists appropriate department staff during peak workloads and absences; provides backup assistance for other technical support staff for special projects when assigned. 3. Performs related duties as assigned. 4. Regular, reliable, predictable attendance or physical presence is an essential job requirement and critical to the performance of the work. CONDITIONS: Experiences frequent interruptions; exposed to video display; may work in confined areas; may be required to work extended and/or irregular hours; required to travel to District sites; exposed to confidential information; required to bend, squat, stoop, kneel, crouch, walk, twist, bend, climb, and/or be mobile and move/lift heavy objects up to 60 pounds. JOB REQUIREMENTS EDUCATION AND EXPERIENCE: Associate’s degree in computer science, information systems, technology engineering, or related field or compatible vocational-technical training; Bachelor’s degree, preferred; five years of experience with database administration, implementation, migration, and upgrades; experience with relational databases, working in Windows environments, and writing SQL queries; or any combination of experience and training which provides the applicant with the knowledge skills and ability required to perform the work. LICENSES/SPECIAL REQUIREMENTS: Valid Washington driver’s license with access to personal transportation. SQL Server Database certification, preferred. Microsoft Certified Database Administrator (MCDBA), preferred. Proof of training and/or certification, required, if applicable. Fingerprints and successful WSP and FBI background clearance/sexual misconduct clearance. KNOWLEDGE, SKILLS, AND ABILITIES: Knowledge of and expertise with Structured Query Language (SQL) objects, stored procedures, views and functions. Knowledge of SQL language, SQL server integration services (SSIS), SQL server reporting services (SSRS), transact SQL (T-SQL) queries. Knowledge of SQL server locking, indexing, and error handling. Knowledge of principles, practices, and techniques of system analysis, programming languages, and activities. Knowledge of business practices in multiple departments. Skill in oral and written communication. Skill in presentation and interpersonal communication. Skill in Microsoft SQL server technologies. Skill in solid SQL scripting. Skill in Windows/SQL server DB upgrades. Skill in SQL server database performance tuning and security. Skill in attention to detail. Skill in analytical thinking and problem solving. Skill in SQL server backup and recovery planning, administration, and implementation. Ability to effectively coach and mentor peers. Ability to take the initiative to learn and research new concepts, ideas and technologies to automate or enhance existing systems. Ability to organize, prioritize, execute tasks and meet deadlines with effective follow through. Ability to work independently, exercise good judgment and make decisions. Ability to take ownership or problems and/or issues and follow through with resolution. Ability to obtain, exchange, and clarify information and communicate technical information to technical and non-technical personnel. Ability to analyze complex problems. Ability to learn new languages as required. Ability to maintain confidentiality. Ability to participate effectively as a team member. Ability to facilitate meetings and follow up with resulting action items. Ability to demonstrate reasonable, reliable, and regular attendance. Ability to multi-task. Ability to establish and maintain effective working relationships with a variety of people in a multi-cultural, diverse socio-economic setting.