Job description

**APPLICATIONS MUST BE FILED ONLINE AT: https://www.schooljobs.com/careers/ccsoh?keywords=database

At Columbus City Schools, we strive to make sure each student is highly-educated, prepared for leadership and service, and empowered for success as a citizen in a global community - but we can't do it without you!

As an award-winning school district in the award-winning city of Columbus, Ohio, we are proud of the work our more than 10,000 employees (including teachers, coaches, and administrators) do every day to change the lives of our students. With more than 46,000 students located in over 100 different schools around the city of Columbus, we know there's a position that's right for you.

RISE UP and apply to our exciting and impactful position detailed below!

POSITION OVERVIEW:

Under general direction, is responsible for maintaining one or more databases, designing and implementing new database systems, and modifying existing ones to optimize performance, security and integrity using a variety of contemporary products; performs related duties as required.

ESSENTIAL DUTIES:
The statements below are intended to describe the general nature and scope of work being performed by this position. This is not a complete listing of all responsibilities, duties, and/or skills required. Other duties may be assigned.

• Installs and upgrades the database server and the database management and diagnostic software.
• Applies patches or service packs to assigned database servers and resolves associated issues.
• Allocates system storage and plans 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, as necessary, 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.
• Maintains records and prepares reports of database maintenance, modifications and enhancements.
• Coordinates with system administrators to ensure efficient resource utilization.
• May participate in professional activities to remain knowledgeable regarding developments in the field of database management.

DEPARTMENT SPECIFIC DUTIES & QUALIFICATIONS:

• 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 SSIS is a plus.

MINIMUM QUALIFICATIONS:

• Possession of bachelor’s degree with significant coursework (16 semester or 24 quarter hours) in computer science, systems analysis, engineering, mathematics, or a closely related field.
• Three (3) years of experience in enterprise database management.
• Substitutions: Possession of valid professional database certification, such certifications offered by Microsoft or Oracle in database management (e.g., Oracle Database Administrator or Microsoft Certified Solutions Expert: Business Intelligence) or an additional four (4) years of experience in enterprise database management may be substituted for the bachelor’s degree.

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 underlying operating systems such as UNIX, Linux, Windows, etc..
• General knowledge of data modeling.
• General knowledge of system 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.

PHYSICAL/MENTAL DEMANDS AND WORK ENVIRONMENT:

• Tools/Equipment Use: Desktop PC with keyboard and mouse, laptop, scanner, calculator, software, desk, and adjustable chair.
• Posture: Prolonged sitting and standing; occasional stooping, bending, squatting, kneeling, bending, pushing, pulling and twisting.
• Motion: Frequent repetitive hand motions, including keyboarding and use of a mouse; occasional reaching
• Lifting: Occasional lifting and carrying (less than 10 pounds)
• Environment: Works in office setting; may require occasional irregular hours and/or prolonged hours.
• Attendance: Regular and punctual attendance at the worksite is required for this position.
• Mental Demands: Maintains emotional control under stress; works with frequent interruptions.

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.

**APPLICATIONS MUST BE FILED ONLINE AT: https://www.schooljobs.com/careers/ccsoh?keywords=database

Job Type: Full-time

Pay: From $41.28 per hour

Benefits:

• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Retirement plan
• Vision insurance

Schedule:

• 5x8
• 8 hour shift
• Day shift
• Monday to Friday

Work Location: One location

oacadventures.ca is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, oacadventures.ca provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, oacadventures.ca is the ideal place to find your next job.