DBA/SQLDBA Relational Database

  • Burlington, VT
  • Posted 1 day ago | Updated 6 hours ago

Overview

On Site
Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

ADS
Analytics
Business Cases
Collaboration
Communication
Data Collection
Data Engineering
Data Processing
Data Security
Database
Energy
Extract
Transform
Load
FOCUS
Management
Microsoft Power BI
Regulatory Compliance
Relational Databases
Reporting
SQL
SQL Azure
Storage

Job Details

Role: DBA/SQLDBA Relational Database

Location: Burlington, VT(Hybrid)

Duration: Long Term Contract

BACKGROUND:

The Public Service Department ( Department ) collects extensive energy data, but current processes are complex, manual, and inefficient, with no centralized system for management. Over the last several years the Department has been working to develop and implement a solution to streamline and, where possible, employ automation to support better internal management and external sharing of energy-related data. This has included working with an Agency of Digital Services ( ADS ) business analyst to refine the business case for this project and propose the architecture for a solution. Identified business requirements include:

Developing a robust data collection and management infrastructure, reducing Department staff hours on data processing and management

Creating or using existing State of Vermont data portals to share energy data

Reducing data reporting burden for key partners (i.e., utilities)

Leveraging existing State of Vermont infrastructure, when it makes sense from a feature and cost perspective

The ADS proposed solution includes one or more database(s) (i.e., operational database, reporting database) to support the storage and querying of a variety of datapoints. A well-designed SQL database integrated with an analytics platform (PowerBI) would enable the Department to automate data collection, ETL, and routine analysis, allowing staff to focus on deeper analysis and regulatory compliance. Further data engineering support would allow us to automate manual processes and to integrate data feeds from external sources to replace manual collection efforts where possible.

Qualifications Required

1. Proficiency in Azure SQL Database architecture and implementation.

2. Experience designing and optimizing relational databases.

3. Expertise in integrating Azure SQL with Power BI.

4. Knowledge of data security and compliance best practices.

5. Strong communication skills for collaboration with VT PSD stakeholders.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.