Software Developer

The Oak Ridge Schools Technology Department is seeking a skilled and detail-oriented full stack developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining front and back-end applications, including database connections, ensuring their optimal performance, security, and integrity. The Software Developer will collaborate closely with other IT professionals to create and optimize complex solutions that support various applications and business processes.

Key Responsibilities

• Design, develop, and maintain applications, ensuring high performance, scalability, and security.
• Write optimized SQL queries, stored procedures, triggers, and functions to manipulate and retrieve data.
• Work closely with Application Engineer and Administrator to integrate databases into applications and optimize queries.
• Perform database tuning and performance optimization to ensure efficient data retrieval and storage.
• Ensure the accuracy, integrity, and security / resiliency of all data within the database systems.
• Work closely with Microsoft Systems Engineer to develop and maintain database backups, recovery plans, and disaster recovery procedures.
• Ability to mine data from existing software packages via ODBC, JDBC, CSV, API, etc.
• Collaborate with the Applications Team to define database structure, data types, and relationships for new or existing systems.
• Troubleshoot and resolve database-related issues, performance bottlenecks, and data inconsistencies.
• Implement and maintain database security measures, ensuring compliance with industry standards and regulations.
• Write and maintain documentation related to database systems, configurations, and procedures.
• Work with Microsoft Systems Team on regular database audits and compliance checks.
• Stay up-to-date with emerging database technologies, trends, and best practices.
• Maintain comprehensive data dictionaries, documentation, and source control for all software solutions.
• Work closely with the Applications Team to develop and document data warehouse collections and datasets needed for BI solutions.
• Analyze and troubleshoot application errors, implementing robust solutions.
• Maintain, enhance, and upgrade existing applications to align with current standards.
• Write, optimize, and maintain clean, reusable, and efficient code.
• Collaborate with functional teams and end-users to gather detailed requirements and provide progress updates, fostering an iterative development approach.
• Stay informed about changes to Oak Ridge Schools policies and state / federal regulations, ensuring compliance within software systems.
• Research emerging technologies and lead initiatives to integrate innovative solutions.
• Other duties as assigned.

Required Qualifications

Python development expertise

Preferred Qualifications

Salary and start date to be determined based upon board approval.