Database Administrator (On-site)

Cleveland Metroparks; Cleveland (OH); On-site; USD 85,000 - 110,000; Full time

Job summary

Cleveland Metroparks is seeking a Database Administrator to design, implement, and maintain robust databases supporting critical operations. You will partner with stakeholders across the organization to ensure reliability, performance, and security of data systems, while leading data modeling, ETL, and BI reporting efforts.

The role emphasizes collaboration, proactive problem solving, and staying current with new database technologies to meet evolving needs of the enterprise.

Responsibilities

• Develops, implements, and schedules database management plans to ensure high performance and availability.
• Administers databases in high-availability environments, including clustering, replication, backup/restore, security, and capacity management.
• Develops system-specific specifications, backup and recovery procedures, and data modeling methodologies.
• Collaborates with departments to translate data needs into technical solutions and deliver outputs meeting business objectives.
• Performs database upgrades, conversions, and migrations.
• Audits database systems and resolves performance, capacity, replication, and security issues.
• Analyzes data relationships, data flow, storage requirements, and reporting capabilities.
• Provides consulting and technical support to developers, analysts, management, and users.
• Responds to and resolves production and application issues on a 24-hour on-call basis.
• Administers Power BI, including ad hoc reports and data visualizations for internal stakeholders.
• Performs setup and configuration of standalone and clustered databases and data warehouses.
• Designs and maintains data models, ER diagrams, normalization, and physical object changes.
• Writes ETL scripts for data migration, warehousing, and job scheduling.
• Stays current with emerging database technologies and evaluates new tools for potential implementation.
• Develops, implements, and documents installation procedures, monitoring processes, security policies, and change guidelines.

Job description

The Database Administrator plays a critical role in ensuring the reliability, performance, and security of the organization’s data systems. This professional designs, implements, and maintains databases that support business critical operations while actively partnering with teams across the organization.

Success in this role depends on strong collaboration and communication, engaging stakeholders to understand their needs, asking thoughtful questions, and approaching challenges with curiosity and creativity. As a strategic partner to development teams, the Database Administrator provides expert planning, installation, configuration, administration, and ongoing support. Through proactive analysis and innovative problem solving, they ensure that database environments remain optimized, scalable, and aligned with evolving organizational requirements.

Key Responsibilities:

• Develops, implements, and schedules database management plans, programs, and utilities to ensure high performance, availability, and efficiency.
• Administers databases in high ‑ availability environments, including clustering, replication, monitoring, backup/restore, recovery, security, capacity management, data modeling, and user access.
• Develops system ‑ specific specifications, backup and recovery procedures, and methodologies for data modeling and integration across IT specialties.
• Collaborates with departments across the organization to understand data needs, translate requirements into technical solutions, and deliver database or reporting outputs that meet business objectives.
• Performs database upgrades, conversions, and migrations.
• Audits database systems and resolves issues related to performance, capacity, replication, and security.
• Analyzes information needs, data relationships, data flow, storage requirements, and reporting capabilities.
• Provides consulting and technical support to application programmers, systems analysts, management, clients, and users.
• Responds to and resolves production and application issues on a 24 ‑ hour on ‑ call basis.
• Administers Power BI, including creation of ad ‑ hoc reports and data visualizations for internal stakeholders.
• Performs setup and configuration of standalone and clustered operational databases and data warehouses.
• Designs, implements, and maintains logical and physical data models, including entity ‑ relationship diagrams, normalization, design reviews, and physical object changes.
• Writes platform ‑ independent and platform ‑ specific scripts for ETL processes, data migration, data warehouse population, and job scheduling.
• Stays current with emerging database technologies and evaluates new tools for potential implementation.
• Develops, implements, and documents installation procedures, monitoring processes, security policies, configuration change procedures, and database/data warehouse usage guidelines.