CiTi BOCES is seeking a skilled and experienced Database Administrator to join our team. As a Database Administrator, you will be responsible for providing lead technical support for all database applications in development and production within the organization. This position plays a crucial role in ensuring the efficiency, security, and availability of our database systems.
Responsibilities:
- Oversees data administration, web connectivity, physical structure, SQL (system query language) and applications, and architecture and database analysis;
- Reviews database design and integration of systems, including servers, etc. and makes recommendation regarding enhancements and/or improvements;
- Establishes and maintains security and integrity controls;
- Provides appropriate consulting, interfacing, and standards relating to database management and monitors transaction activity and utilization;
- Prepares and/or reviews activity, progress, and performance reports;
- Plans and coordinates the administration of 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;
- Develops project plans for implementing data warehouses and plans projects and oversees the tactical aspects of data warehouse implementation and maintenance;
- Diagnoses, resolves, and implements measures to prevent problems for 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;
- Collaborates with system administrator and technology team on capacity planning strategy and processes;
- Assists new application development teams in determining complex database environment requirements;
- Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools;
- Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools such as database dictionaries.
Qualifications:
A. Graduation from a regionally accredited or NYS registered college or university with an associate’s degree in computer science, information technology, or closely related field and technical certification in System Query Language (SQL) administration; OR
B. Graduation from a regionally accredited or NYS registered college or university with an associate’s degree in computer science, information technology, or closely related field and two years of experience designing and troubleshooting databases; OR
C. Graduation from high school or possession of an equivalency diploma and four years of experience described in “A” above; OR
D. An equivalent combination of training and experience as defined by the limits of “A,” “B and “C” above.