Database Administrator Enterprise Data Engineer

Responsibilities

The Database Administrator/Enterprise Data Engineer designs and maintains enterprise data architecture while managing legacy data migration and validation. They also administer databases, optimize performance, and develop reporting pipelines to support mission-critical applications.

Requirements

Candidates must have a bachelor's degree in a technical discipline or equivalent experience in database administration and data engineering. Proficiency in SQL, ETL/ELT processes, and data platform management is required to support complex data environments.

Skills

• Database administration
• Data engineering
• Enterprise data architecture
• ETL/ELT pipelines
• SQL
• Power BI
• Data migration
• Data modeling
• Data warehousing
• Performance tuning
• Data security
• System integration
• Data quality
• Telemetry
• Cloud platforms

Benefits

• 401(k)
• 401(k) matching
• Flexible schedule

About this role

Benefits:
401(k)
401(k) matching
Flexible schedule

Database Administrator (DBA) / Enterprise Data Engineer
Estimated Level of Effort: 75–80 hours per month

Position Summary
The South Carolina Department of Probation, Parole, and Pardon Services (SCDPPPS) supervises individuals placed on probation, parole, and other community-release programs. SCDPPPS relies on custom, mission-critical applications while modernizing its core Offender Management System (OMS).

The Database Administrator (DBA) / Enterprise Data Engineer supports the development, integration, security, modernization, and sustainment of these applications and their supporting data environments. The position designs and maintains enterprise data architecture; manages legacy-data migration and validation; enables reporting, telemetry, and analytics; and administers and optimizes databases supporting OMS, PIC, PAC, IIMS, SSO, and other assigned systems.

Reporting Relationship
Reports to the Program Manager, Chief Information Officer, Data Architect, or designated technical lead.

Key Responsibilities

Enterprise Data Architecture and Engineering

Design, develop, and maintain an enterprise data warehouse, data lake, or comparable data platform supporting structured, semi-structured, and unstructured data.
Define data models, schemas, metadata, integration patterns, storage approaches, and lifecycle-management practices.
Establish standards for data ingestion, transformation, storage, access, retention, lineage, cataloging, quality, and security.
Develop and maintain scalable ETL/ELT pipelines for batch, near-real-time, and real-time data processing.
Design secure, reliable interfaces among enterprise applications, reporting platforms, analytics tools, and data repositories.
Legacy Data Migration and Validation

Plan, execute, document, and support migration of legacy data to the enterprise data environment.
Assess source-system structures, data quality, business rules, integration dependencies, and technical constraints.
Develop data mappings, transformation rules, migration procedures, reconciliation methods, validation criteria, and rollback plans.
Migrate and validate data associated with OMS, PIC, PAC, IIMS, SSO, and other assigned applications.
Perform data profiling, cleansing, standardization, deduplication, reconciliation, and exception resolution to ensure data accuracy, completeness, consistency, and integrity.
Produce validation results, discrepancy logs, remediation recommendations, and migration-completion documentation.
Business Intelligence, Reporting, and Telemetry

Develop and maintain Power BI reporting pipelines, semantic models, datasets, dashboards, and reports.
Implement telemetry-based reporting to support visibility into application activity, system health, performance, and operational metrics.
Develop real-time and near-real-time ingestion workloads for reporting, monitoring, analytics, and decision support.
Optimize reporting data models, refresh processes, queries, and dashboards for performance, security, accuracy, and usability.
Work with stakeholders to define reporting requirements, key performance indicators, data definitions, and dashboard enhancements.
Database Administration and Performance Management

Perform database design, configuration, administration, maintenance, optimization, and operational support for assigned databases and data platforms.
Monitor database health, availability, capacity, storage, performance, query efficiency, replication, backups, and telemetry.
Resolve performance issues through indexing, query tuning, partitioning, caching, archiving, configuration improvements, and capacity planning.
Execute database-maintenance activities, including backup and recovery validation, integrity checks, statistics maintenance, patch coordination, and monitoring.
Implement and maintain database security controls, including role-based access control, least-privilege access, authentication, authorization, encryption, auditing, and logging.
Required Qualifications

Bachelor’s degree in computer science, information systems, data engineering, software engineering, or a related technical discipline; equivalent experience, education, training, or certifications may be considered.
Experience in database administration, data engineering, data architecture, or a related technical role.
Experience designing or supporting enterprise data warehouses, data lakes, lakehouses, or comparable platforms.
Experience developing ETL/ELT processes, data pipelines, transformations, and system integrations.
Experience with legacy data migration, mapping, profiling, cleansing, reconciliation, validation, and remediation.
Proficiency with SQL, relational database design, normalization, indexing, query optimization, backup and recovery, and performance tuning.
Experience developing Power BI data models, datasets, dashboards, reports, and refresh pipelines.
Knowledge of data quality, governance, metadata, lineage, security, and access-control principles.
Ability to manage competing priorities and deliver reliable support within an estimated commitment of 75–80 hours per month.
Preferred Qualifications

Experience with Microsoft Azure, Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Databricks, AWS, Google Cloud Platform, or comparable cloud data platforms.
Experience implementing streaming, event-driven, telemetry, or real-time data-ingestion solutions.
Experience with data cataloging, master-data management, and data-governance tools.
Experience supporting public-sector, regulated, criminal-justice, or security-sensitive environments.
Familiarity with DevOps, DataOps, CI/CD, source control, automated testing, and infrastructure-as-code practices.
Relevant cloud, database, data-engineering, or Power BI certifications.
Work Schedule and Requirements

This is a part-time position requiring an estimated 75–80 hours per month. Duties may include recurring operational support, planned migrations, rep...

About Leyden Solutions Inc

Information Services · 11-50 employees · headquartered in Pinehurst · founded 2020