This position is responsible for providing technical support for all database applications in development and production.   Employee manages database administration and assists in capacity planning. The Assistant Database Administrator develops web-based applications as required to support the priorities of the organization and their database systems.  

PRIMARY WORK ACTIVITIES: 

• Participates in data administration, data design, web interface development (PHP and similar scripting languages), SQL (system query language) and applications, and architecture and database analysis;
• Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements;
• Establishes and maintains security and integrity controls;
• Provides appropriate consulting, interfacing, and standards relating to database management and monitors transactional activity and utilization;
• Prepares and/or reviews activity, progress, and performance reports;
• Maintains computerized databases, including relational databases to insure accurate appropriate and effective use of data including database definition, structure, documentation, long-range requirements, and operational guidelines;
• Diagnoses, resolves, and implements measures to prevent problems in applications and system software;
• Designs data storage and management processes for specific data warehouse projects;
• Works with data architects and other development team members to determine, establish, and maintain database facilities suitable for development of SQL application architectures;
• Assists new application development teams in determining complex database environment requirements;
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools such as data dictionaries.

KNOWLEDGE, SKILLS AND ABILITIES: Summary of full performance level characteristics. 

GOOD KNOWLEDGE OF:  principles, practices, and methods related to database management systems and administration; data administration policies and standards, data definition, modeling and logical design, database design, and quality control; web-based technologies and development tools. 

CiTi BOCES has an ongoing need for substitute custodial workers for the 2023-2024 school year. Applicants must be energetic, physically able, ability to read and understand directions. Must be able to work independently as well as in a team setting. Work hours will vary, predominantly late afternoon to evenings. 

The Center for Instruction, Technology & Innovation is currently hiring Registered Nurse substitutes for the 2023-2024 school year. Candidates must possess a valid Registered Professional Nurse license issued by New York State. Interested candidates must complete an application and attach copies of their current CPR/AED card and RN certificate.