What are the responsibilities and job description for the SQL Developer I position at Clayton County Public Schools?
Applicants: Please ensure that you upload all necessary documents and include all relevant information related to the position you are applying for. Please make sure that you are reading the job description in its entirety to align your documents and relevant information with the requirements.
POSITION SUMMARY:
The SQL Developer I provides technical support for District database environment, including oversight, development, organization, assessment, and implementation. Creates, maintains, and update reports and data files for all key databases systems running mission critical processes. Works with database administrators to ensure operational efficacy through monitoring and planning for future expansion data requirements and data modeling with the use of business intelligence tools. Review workflow charts developed by business analysts and programmers. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Assist in troubleshooting operational and development errors to ensure confidentiality, integrity, and availability for critical district data. This position reports to the Coordinator of Business Information Systems.
KEY RESPONSIBILITIES:
Design and document database architecture using logical and physical data modeling tools and utilities. Create, test, and execute data management languages. Analyze and sustain capacity and performance requirements. Monitor systems and platforms; oversee backup, clustering, mirroring, replication, and failover. Train and develop technical staff to better utilize on-line processing databases environment. Design and execute the test scripts and test scenarios.
Perform daily system monitoring and backup operations, verify the integrity and availability of all hardware, server resources, systems, and key processes; review system and the application log. Collaborate with database administrators, developers, and subject matter experts to execute the technical vision and analyze tradeoffs between usability and performance needs. Act as a liaison between the business units, technology teams, and support teams.
Develop, design, and maintain Extraction Transformation Loading (ETL) solutions to seamlessly integrate District infrastructure. Develop, design, deliver, and maintain enterprise-reporting methods utilizing District Data Warehouse. Develop, design, and maintain database solutions using SQL, functions, procedures, views, and other RDBMS techniques.
Investigate, document, and recommend new solutions to improve the District Technology. Assist database administrators securing access, with the application, data loads; storage and performance strategies, and implementations.
All others duties as assigned and necessary to perform the above services.
KEY JOB REQUIREMENTS
Bachelor’s degree in a Computer Science or a Database Management related field preferred. Associates or Technical Degree in a related field required.
Minimum of three (3) years of experience writing and executing queries on Relational Database Management Systems (RDBMS) using Microsoft SQL Server. Demonstrates an understanding of database administration, including database structures, theories, principles, and practices. Experience in an K12 academic environment is preferred.
Requires district coordination; makes decisions and recommendations, which affect District employees, students, parents, and constituents.
Current industry certifications in Microsoft or Oracle database systems preferred.
Critical Thinker: independent judgment, critical thinking, and problem solving is required to meet expectations and achieve organizational goals.
Requires excellent interpersonal skills, regular, frequent contact with internal personnel of influence and decision-making responsibility to discuss issues of moderate importance; requires occasional contact all levels of district leadership.
Requires excellent written and oral communication skills.
Apply, recommend, and implement technology solutions to improve the effectiveness of district objectives.
Normal office setting.
Moderate travel across the district with occasional travel for off-site training.
Light duty - On most occasions sitting at a desk or table; intermittently sitting, standing, or stooping.
Light lifting of 25 lbs. or less.
NOTE: This is a grade 27, 225 day position that pays for experience up to a Step 8.
Salary : $63,027 - $77,488
