Database Administrator (On-site)

cmpcareers; Cleveland (OH); Hybrid; USD 90,000 - 120,000; Full time

Job summary

cmpcareers is seeking a Database Administrator/Data Engineer in Cleveland to manage MS SQL Server environments and Power BI reporting for internal stakeholders. You will design data models, perform ETL tasks, and maintain high‑availability systems while collaborating across departments.

The role requires 3+ years with SQL Server in enterprise settings, strong data modeling skills, and experience with BI reporting. Hybrid work options may apply; strong security and performance focus are essential.

Qualifications

• Bachelor’s degree in information systems, computer science, or related field.
• Minimum three years of experience with Microsoft SQL Server in a large, business‑critical environment.
• Preferred MCSE, Azure Data Engineer Associate, and Azure Database Administrator certifications.
• Strong data modeling, migration, and conversion experience.

Responsibilities

• Develops, implements, and schedules database management plans and utilities for high performance and availability.
• Administers databases in clustering, replication, backup/restore, security, and capacity management.
• Creates system specifications and data integration methodologies across IT specialties.
• Collaborates with departments to translate data needs into technical solutions and reports.
• Performs database upgrades, migrations, and ongoing maintenance.
• Audits performance, capacity, replication, and security; resolves related issues.
• Provides consulting and technical support to developers, analysts, and management.
• Responds to production issues on a 24‑hour on‑call basis.
• Administers Power BI and creates ad‑hoc reports for stakeholders.
• Sets up and configures standalone and clustered data warehouses.
• Designs data models, ER diagrams, and physical objects; reviews designs.
• Writes ETL scripts for data migration and job scheduling.
• Keeps up to date with new database technologies and evaluates tools for adoption.

Skills

MS SQL Server

Power BI

Data modeling

ETL development

Performance tuning

Database security

Backup and recovery

High availability

On-call support

Education

Bachelor’s degree in information systems or computer science

MCSE (preferred)

Azure Data Engineer Associate (preferred)

Azure Database Administrator Associate (preferred)

Tools

SQL Server Management Studio

SSIS

SSAS

SSRS

Power BI

PostgreSQL

Job description

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.

Education and Experience:

Bachelor’s degree in information systems, computer science, or a related field. Minimum of three years of experience working with Microsoft SQL Server in a large, business‑critical environment; or an equivalent combination of education, training, and experience that demonstrates the required knowledge and abilities.

Qualifications:

• Preferred certifications include:
  • Microsoft Certified Solutions Expert (MCSE)
  • Microsoft Certified: Azure Data Engineer Associate
  • Azure Database Administrator Associate
• Most possess and maintain a valid driver’s license.
• Advanced design, implementation, and administrative expertise with MS SQL Server (2008+).
• Strong background in data modeling, migration, and conversion.
• Experience with SSIS, SSAS, and SSRS.
• Proficiency with MS‑SQL; PostgreSQL experience preferred.
• Experience with Power BI and the ability to analyze large datasets.
• Strong communication skills, with the ability to convey technical information clearly and concisely to technical and non-technical audiences in both individual and group settings.
• Proficiency in Microsoft Office applications.
• High level of accuracy, organization, and attention to detail.
• Demonstrated management and business acumen, including problem solving, strategic thinking, multi‑project coordination, leadership, and decision‑making.
• Ability to build and maintain effective working relationships with internal and external stakeholders.
• Professional maturity, discretion, and the ability to handle confidential information.

Work Days:

Monday - Friday

Work Location:

This position is expected to work from Cleveland Metroparks Administrative Offices or other sites around the park district the majority of the time, but remote workdays may be accommodated on a case‑by‑case basis.

Application Deadline:

Open until filled