DBA - PowerDB Administrator

Shermco Industries, Inc.
Irving, United States of America
12 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 130K

Job location

Remote
Irving, United States of America

Tech stack

API
Artificial Intelligence
Business Analytics Applications
Automation of Tests
Cloud Database
Databases
Data Governance
Data Integration
ETL
Dataspaces
Data Structures
Python
Microsoft SQL Server
Powershell
Power BI
Salesforce
SQL Databases
Data Streaming
Systems Integration
Enterprise Data Management
Scripting (Bash/Python/Go/Ruby)
Azure
System Availability
Database Optimization
Change Tracking
Database Performance
Microsoft Business Central
Data Analytics
Software Version Control

Job description

We are seeking a PowerDB Administrator & DBA to manage, optimize, and scale our electrical asset data ecosystem, with a primary focus on PowerDB and supporting database platforms. This role is critical to ensuring the integrity, availability, and usability of electrical system data used for engineering studies, maintenance, compliance, and field operations.

This position bridges electrical engineering operations and enterprise data management, enabling accurate system modeling, reporting, and analytics across substations, switchgear, and distribution systems. Responsibilities

PowerDB Administration (Primary Focus) Administer and maintain PowerDB environments supporting electrical system modeling and studies

  • Manage data structures, libraries, and standards for equipment (breakers, transformers, relays, cables, etc.)

  • Ensure accuracy and completeness of one-line diagrams, asset metadata, and study data

  • Support engineering teams with data setup for arc flash, coordination, and short circuit studies

  • Establish governance for data entry, updates, and validation workflows

Database Administration (DBA)

  • Manage and optimize SQL Server (or equivalent) databases supporting PowerDB and related systems

  • Design, implement, and maintain data models, schemas, and indexing strategies

  • Monitor database performance, tuning queries and resolving bottlenecks

  • Ensure backup, recovery, and high availability strategies are in place

  • Support integrations with systems such as ERP (Business Central), CRM (Salesforce), and field platforms

Data Quality & Governance

  • Develop and enforce data standards for electrical equipment and system attributes

  • Perform data audits and cleansing activities to ensure accuracy and consistency

  • Implement validation rules to reduce errors from field and engineering inputs

  • Maintain version control and change tracking for critical system data

Integration & Automation

  • Build and maintain integrations between PowerDB and other enterprise systems

  • Develop automation scripts, ETL pipelines, and APIs to streamline data flow

  • Support digital initiatives such as AI-driven insights, predictive maintenance, and reporting automation

Reporting & Analytics

  • Enable reporting and analytics by ensuring clean, structured, and accessible data

  • Partner with BI teams to support Power BI dashboards and operational reporting

  • Provide datasets for compliance, audits, and customer deliverables

Requirements

  • 5+ years of experience in database administration (SQL Server or equivalent)

  • Hands-on experience with PowerDB, EasyPower, ETAP, or other electrical modeling databases

  • Strong understanding of electrical power systems (industrial, utility, or field services)

  • Experience with data modeling, ETL processes, and database performance tuning

  • Proficiency in SQL, scripting (PowerShell/Python), and data integration tools

  • Experience in electrical engineering services, field testing, or asset management environments

  • Familiarity with arc flash, coordination, and short circuit study data structures

  • Experience integrating with ERP (Business Central), CRM (Salesforce), or EAM systems

  • Knowledge of data governance frameworks and regulatory/compliance requirements

  • Exposure to Azure data services, cloud databases, or AI/analytics platforms

  • Quarterly travel required

Benefits & conditions

$120,000.00 - $130,000.00 /Yr.

Apply for this position