What are the responsibilities and job description for the Database Administrator (NOT REMOTE) position at Cleveland Metroparks?
The Database Administrator creates and maintains databases by identifying and solving database requirements supporting users. The Administrator provides planning, installation, configuration, administration, support and general consulting to development teams. (This position is NOT REMOTE)
Essential Functions:
- Regular and predictable attendance is expected and required. All Cleveland Metroparks employees must be prepared to work flexible schedules, including evenings, weekends, and/or holidays as required.
- Develop, implement, and schedule database management plans, programs, and utilities to maintain high levels of performance, availability, and efficiency of database management systems.
- Develop and administer assigned databases in a high availability environment including database clustering and replication, monitoring, database backup, restore and recovery processes, security, capacity management, data modeling and user access.
- Develop system specific specifications, back-up and recovery procedures, interrelationships of multiple IT specialties, database management principles and methodologies for data modeling.
- Perform database upgrades and conversions/migrations.
- Audit database systems and resolve performance issues, capacity issues, replication, security and other data issues.
- Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
- Provide consulting and technical support for application programmers, systems analysts, management, clients and users.
- Responds to and resolves production and application issues on an on-call 24-hour basis.
- Administers Power BI software, including creation of ad-hoc reports and data visualization services utilizing various data sources to internal stakeholders.
- Performs setup and configuration of standalone and clustered operational databases and data warehouses.
- Designs, implements, and maintains both logical and physical data models (creates entity relation diagrams, conducts data normalization, participates as needed in database design reviews, defines and changes physical database objects) based on business and technical requirements.
- Writes platform independent and platform specific scripts for ETL, data migration, data warehouse population, and job scheduling.
- Remains current with database technology developments and evaluates new database technologies for implementation.
- Develop, implement and document installation procedures, system monitoring procedures, database security policies, configuration change migration procedures, and database/data warehouse usage procedures and policies.
- Keeps direct supervisor promptly informed of key/significant issues or concerns.
- Carries out duties and responsibilities in a safe and efficient manner to maintain a safe work environment and surrounding area for oneself, co-workers and public. Responds to hazardous situations and/or potentially unsafe conditions by taking corrective action as capable and promptly notifying supervisory personnel.
- Updates and enhances own knowledge by involvement in continuing education for professional growth (i.e., attends relevant conferences, seminars, in-service trainings, and certification programs)
- Performs related duties as assigned or apparent, serves as backup for other potential info tech or data functions.
