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.
Qualifications:
- Bachelor’s degree in information systems, computer science or related field. Minimum of three years’ experience with Microsoft SQL Server in large, business critical environment or any combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job.
- Must possess and maintain a valid driver’s license under the laws of the State of Ohio. Microsoft Certified Solutions Expert (“MCSE”), Microsoft Certified: Azure Data Engineer Associate, Azure Database Administrator Associate or equivalent preferred.
- Strong design, implementation, and administrative knowledge of MS SQL (version 2008 and beyond).
- Strong experience with data modeling, migration and conversion.
- Experience with SSIS, SSAS, SSRS.
- Experience with MS-SQL preferred, and experience with PostgreSQL a plus.
- Experience with Power BI and ability to analyze large datasets preferred.
- Ability to develop and maintain effective working relationships with stakeholders, including employees and the general public.
- Ability to speak and write clearly, concisely and persuasively using correct grammar, spelling and punctuation with ability to communicate one-on-one or in group settings.
- Ability to perform work with a high degree of accuracy and organization.
- Management skills and strong business acumen, including problem solving, vision, ability to manage multiple programs and meet deadlines, collaboration, leadership, decision making and ability to analyze diverse facts and develop clear and concise reports and recommendations.
- Ability to work cooperatively with others.
- Proficiency in software programs including all Microsoft Office programs.
- Mature professional attitude and considerable discretion, including ability to manage confidential information.
- Ability to perform with considerable independence and initiative.
- THIS IS AN ONSITE POSITION, NOT REMOTE
Salary: $78,478 – $98, 098 annually (Internal equity considerations and the average salary of the peer range will be reviewed/considered before making a final offer)
Work Days: Monday – Friday
Filing Deadline: Open until filled
To Apply: Please visit our career site at www.clevelandmetroparks.com or copy and paste the following link into your web browser:
