Database Developer

Description

Tacoma Public Schools

Expected Start Date: As soon as possible

FTE: 1.0

Hours per day: 8

Salary Level: Ranges from $53.02/hr to $68.72/hr based on verifiable education and like experience.

Examples Of Duties

This position plans, designs, develops, builds, tests, implements, and maintains databases written in Microsoft structured query language (SQL) Server to meet the needs of District staff, students, and community; participates in the architecture, security, and performance tuning of enterprise data warehouse; conceptualizes, documents, and communicates solutions to meet department goals and District objectives.

ESSENTIAL JOB FUNCTIONS

1. Designs, develops, and implements optimized database systems based on customer requirements; ensures solutions specifications are valid, testable, and meet District needs; serves as subject matter expert and end-user liaison.

2. Performs space management and capacity planning for database systems; performs data back-up and archival on a regular basis.

3. Develops database tables and data dictionaries; ensures data quality and integrity of databases; identifies any issues related to database performance and provides corrective measures.

4. Create complex functions, scripts, stored procedures, and triggers to support application development; investigates and resolves complex application issues.

5. Tests databases, reviews test results, and performs bug fixes; troubleshoots database-related issues in a timely fashion; evaluates existing databases, defines, and recommends improvements for performance efficiency, back-up, and recovery specifications.

6. Ensures data solutions are built for performance, fault tolerance, and security; develops security procedures to protect databases from unauthorized usage.

7. Installs, implements, tunes, maintains, upgrades, and may decommission, as necessary, SQL Server installations.

8. Designs, tests, develops, and deploys SQL Server Integration Services (SSIS) ETL packages in support of the District's enterprise warehouse and data marts to meet current and future business data needs; collaborates with other stakeholders to build robust, maintainable, sustainable, high performance ETL process.

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, on a temporary basis.

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, climb, and/or be mobile, and move/lift heavy objects up to 60 pounds.

Minimum Qualifications

Education and Experience

Associate degree in computer science, computer engineering, information science, or related field; or compatible vocational and/or technical training; Bachelor degree, preferred; 5 years working experience as a SQL Server developer; or three years of continuous work experience in database design and development; experience and knowledge of public school environment, preferred; 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 Solutions Associate (MCSA), 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 Analysis Services (SSAS) tabular model, or Power BI data sets.

Knowledge of Microsoft SQL server as well as locking, indexing, and error handling.

Knowledge of principles, practices, and techniques of system analysis, and programming.

Knowledge and understanding of data warehouse design methodologies.

Knowledge of source control tools and protocols, such as Git (version control system) and Visual Studio Team Services (VSTS).

Skill in collaborating with staff to make the most informed decisions about current state of District collaboration tools and applications.

Skill in system/process orientation.

Skill in developing and organizing high-quality documentation.

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.

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 for 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 design and facilitate technical training.

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.

Supplemental Information

This job description is not an employment agreement or contract. District administration has the exclusive right to alter this job description at any time without notice. The statements contained herein reflect general details as necessary to describe the primary functions of this job, the level of knowledge and skill typically required and the scope of responsibility, but should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned including work in other functional areas to cover absences or relief, to equalize peak work periods or otherwise balance the workload.

Tacoma Public Schools does not discriminate in any programs or activities on the basis of sex, race, creed, religion, color, national origin, age, veteran or military status, sexual orientation, gender expression or identity, disability, or the use of a trained dog guide or service animal and provides equal access to the Boy Scouts and other designated youth groups. The following employees have been designated to handle questions and complaints of alleged discrimination:

• Civil Rights Coordinator: Renee Trueblood, 253-571-1252, civilrights@tacoma.k12.wa.us
• Title IX Coordinator, Elementary: Christa Erolin, 253-571-1318, cerolin@tacoma.k12.wa.us
• Title IX Coordinator, Secondary: Wayne Greer, 253-571-1191, wgreer@tacoma.k12.wa.us
• 504 Coordinator, Elementary: Jennifer Herbold, 253-571-1096, jherbol@tacoma.k12.wa.us
• 504 Coordinator, Secondary: Megan Nelson, 253-571-1003, mnelson@tacoma.k12.wa.us

Mailing address: P.O. Box 1357, Tacoma, WA 98401-1357.

Closing Date/Time: 9/20/2023 11:59 PM Pacific