DBA - PowerDB Administrator

Location: Hybrid - Dallas

Department: Information Technology

Reports To: Product Owner

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.

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

Qualifications and Skills

• 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

EQUAL OPPORTUNITY EMPLOYER | DRUG-FREE WORKPLACE

Shermco is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status. Shermco is a drug-free workplace.

NO AGENCIES PLEASE