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

• Associate’s degree in Computer Science, Information Systems, or a related field, or equivalent experience.
• Proven experience as a Programmer or Software Developer.
• Frontend Development:

• Strong proficiency in SQL, including advanced query writing and optimization techniques.
• Strong proficiency in JavaScript/TypeScripe
• Expertise in React.js with hooks and context management
• Experience with modern CSS frameworks (Tailwind CSS, Bootstrap)
• HTML5 and CSS3 expertise, including responsive design
• Knowledge of frontend build tools (Webpack, Vite)

• Backend Development:
  • Python development expertise
  • Experience with web frameworks (Django, FastAPI, etc.)
  • RESTful API design and implementation
  • Database design and management (SQL)
  • Experience with ORM frameworks (SQLAlchemy, Django ORM)
  • Understanding of server architecture and deployment
• Familiarity with database management systems (DBMS) such as MySQL and SQL
• Experience with data modeling, database design, and implementation.
• Knowledge of database normalization, indexing, and transaction management.
• Strong troubleshooting and debugging skills in database environments.
• Ability to work effectively in a team environment and collaborate across different departments.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills, both verbal and written.

Preferred Qualifications

• Knowledge of programming languages such as Python, API, HTML5, Javascript, or Power Shell for integrating with database applications.
• Build, refine, and optimize datasets in Power BI, incorporating complex DAX calculations and KPIs.
• Familiarity with Power Apps and Power Automate
• Familiarity with writing DAX expressions
• GraphQL implementation experience
• WebSocket development
• Message queue systems (RabbitMQ, Kafka)
• Experience with real-time data processing

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