What are the responsibilities and job description for the APPLICATIONS DEVELOPER position at Columbus City Schools?
Job Title: DATABASE ADMINISTRATOR
Salary: $44.65 Hourly
Job Type: Full Time
Location: Columbus, Ohio
Department: IT
Definition:
This job posting is for a noncompetitive position and will create a new list. The hiring department will conduct a preliminary review of your application to determine who to interview. It is the responsibility of all applicants to provide a complete list of relevant work experience (previous and current) on the application. Resumes will not be accepted in lieu of listed work experience.
This is not a remote position.
Under general direction, is responsible for designing and implementing new database systems, and maintaining and modifying existing databases to optimize performance, security, and integrity, using a variety of contemporary products; performs related duties as required.
Examples of Work (Any one position may not include all the duties listed nor do the examples cover all the duties that may be performed):
Installs and upgrades the database server and database management and diagnostic software.- Applies patches or service packs to assigned database servers and resolves associated issues.
- Allocates system storage and plans for future storage requirements.
- Creates primary database storage structures after application design has been completed; creates primary objects (tables, views, indexes) for applications.
- Creates and modifies procedures, packages, and triggers as required to support applications and process automation.
- Modifies database structure from information received from application developers and/or programmers; tests and corrects database errors and refines changes; performs database tuning where possible.
- Enrolls users and maintains security; establishes user access levels and monitors usage.
- Plans backup and recovery of database information; maintains archived data; backs up and restores databases; performs data integration or migration from one system to another.
- Prepares and maintains accurate documentation and administrative information, records, and reports of database maintenance, modifications, and enhancements.
- Coordinates with system administrators to ensure efficient resource utilization.
- Participates in Districtwide information technology projects.
- Develops maintenance applications to support automated database management.
- May participate in professional activities to remain knowledgeable regarding developments in the field of database management.
DEPARTMENTAL PREFERENCES
- Implements and follows data warehouse best practices and development processes, including conceptual/logical/physical dimensional data modeling, data flow diagrams, design scalability for the future, ETL architecture, source to target mappings, automation through ETL and stored procedures, data validation, quality assurance, and monitoring/alerting.
- Experience in Microsoft Technologies SSAS, SSIS, SSRS, SSMS, SQL/T-SQL, Power BI, Azure, and Azure DepOps
- Open Source Database Technologies PostgreSQL, Mongo, MySQL and Talend is a plus.
Minimum Required Qualifications:
Possession of bachelor’s degree with significant coursework (twenty-one (21) semester hours or thirty-two (32) quarter hours) in computer science, engineering, mathematics, or a closely related field, and three (3) years of experience in enterprise database management.
Substitution(s): Additional years of the specified experience may substitute for the educational requirement on a year-for-year basis.
Knowledge, Skills, and Abilities:
Thorough knowledge of the principles of relational databases including data instrumentation, normalization, and standardization; thorough knowledge of enterprise database administration; considerable knowledge of SQL; considerable level of skill in database tuning; general knowledge of underlying operating systems such as UNIX, Linux, Windows, etc.; general knowledge of data modeling; general knowledge of systems application and development; general knowledge of compiled database procedures (in SQL); general knowledge of the principles, methods, and techniques of computer programming, including testing and debugging; general level of skill in database backup and recovery; general level of skill in production database; ability to analyze, plan, and design databases; ability to recognize and correct technical errors and problems; ability to perform database maintenance and enhancement; ability to communicate instructions clearly, both orally and in writing; ability to communicate technical terms at a level appropriate to the audience; ability to maintain records and prepare reports; ability to develop and maintain good working relationships.
Test/Job Contact Information:
This job posting is for a noncompetitive position. The candidates that successfully complete the application process will be used to create a NEW eligible list. The hiring department will then conduct a preliminary review of your application to determine who to interview. It is the responsibility of all applicants to list all relevant work experience (current and previous) on the application. Resumes will not be accepted in lieu of listed work experience. Unless otherwise indicated, any year of required experience is based on 12 months of full-time employment. Anything under 35 hours/week (or seasonal work) will be prorated. Please be sure that the job experience and education information in your profile is up to date and accurate before submitting your application.
Prior to application completion, please attach an OFFICIAL transcript or copy of degree indicating field of study, if applicable.
The qualifications listed above are intended to represent the education, experience, skill, and ability levels typically needed to successfully perform the essential duties contained in this job description. Columbus City Schools (CCS) is an equal opportunity employer and does not discriminate against individuals regardless of race, sex, sexual orientation, religion, national origin, age, gender identity or expression, ancestry, familial status, military status or disability in its educational programs, activities, and employment policies. CCS fully supports the hiring and employment of individuals with physical or mental disabilities who meet the job qualifications, so long as the individuals are able to perform the essential duties of the position with or without reasonable accommodation.
Salary : $45