DBA โ DMS S6 Services
- ๐จ๐ฆ Canada
- On-site
- Mid level
- 8 months ago
- SCADA
- Data Modeling
- GIS
- Disaster Recovery
- RBAC
- ETL
- Oracle
- Microsoft SQL Server
- SQL
- Python
- PowerShell
- Windows
- Linux
- Docker
- Kubernetes
- AWS
- RDS
- Azure SQL
Job Title: DBA โ DMS S6 Services
Location:Remote
About the Role
We are seeking an experiencedDatabase Engineer / DBA to manage and support critical database infrastructure forGridOS ADMS and DMS S6 integration services. This role is responsible for thedesign, implementation, performance tuning, and 24/7 reliability of databases supporting real-time operational technology (OT) applications.
The ideal candidate will have strong experience working withhigh-availability, high-performance database systems in real-time environments such asSCADA, EMS, or ADMS.
Key Responsibilities
Database Architecture
-
Design and optimizedatabase schemas, tables, indexes, and stored procedures for high-volume, low-latency applications.
Performance Tuning
-
Monitor database performance, identify bottlenecks, and implementquery optimization, indexing, and partitioning strategies.
Data Modeling
-
Collaborate with integration teams to model data structures forDMS S6 and enterprise systems such asGIS, Historian, and AMI/MDM.
High Availability & Disaster Recovery
-
Implement and manageHA/DR solutions including replication, mirroring, and clustering to ensure24/7 system availability.
Security & Compliance
-
Enforce strict database security policies, manageRBAC, and ensure compliance withcybersecurity standards (e.g., NERC/CIP).
Maintenance & Operations
-
Perform regularpatching, upgrades, backup/recovery, and capacity planning.
-
Act as an SME to diagnose and resolvedata integrity issues, performance degradation, and system faults in production.
ETL & Messaging Support
-
Design and support database components forETL pipelines and streaming platforms (e.g., Kafka).
Required Qualifications
-
5+ years of hands-on experience as aDatabase Engineer / DBA in high-availability environments.
-
Strong expertise inenterprise RDBMS:
-
Oracle
-
Microsoft SQL Server
-
-
Direct experience withreal-time systems:
-
SCADA
-
EMS
-
ADMS
-
-
AdvancedSQL skills and scripting experience inPython and/or PowerShell.
-
Experience managing databases onWindows and Linux platforms.
Preferred Qualifications
-
Experience withReal-Time Historian databases:
-
OSIsoft PI
-
Client Historian
-
-
Familiarity withcontainerization (Docker, Kubernetes).
-
Experience withcloud databases:
-
AWS RDS
-
Azure SQL
-
-
Knowledge ofutility data models (CIM) or SCADA data structures.
DBA โ DMS S6 Services ยท Info Way Solutions LLC