TELECOMMUTE Database Engineer

TALENT Software Services

United States

11 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Testing (Software) Query Performance Data Analysis Microsoft Azure Cloud Computing Information Systems Databases Data Transformation Data Security Data Transformation Services Data Warehousing Disaster Recovery

+18 more

Network Security SQL Azure Oracle Databases Windows PowerShell Role-Based Access Control SQL Databases Teradata SQL Backup and Restore Data Storage Technologies Azure Data Factory Cloud Monitoring Database Optimization Azure Powershell Data Lakes Non-relational Database Data Lakehouse Azure Resource Manager Databricks

Job description

The project involves modernizing the child welfare information system environment through the implementation of a Comprehensive Child Welfare Information System (CCWIS). The initiative includes consolidating data from 87 county databases into a centralized data lake for a new solution. The role will focus on Azure Databases and Data Lakes, with emphasis on the Data Lakehouse and its integrated data reserves.

Participate in the analysis, design, development, implementation, and potentially ongoing support of Azure Databases and Data Lakes.
Administer, maintain, and secure data to ensure efficient and reliable data storage solutions.
Collaborate with cross-functional teams to optimize data workflows and support data-driven decision-making.
Implement best practices for data security and integrity in Azure environments.
Provide mentorship to other Database Engineers.

The work is expected to be done remotely or in a hybrid model at specified offices.

Sample Tasks

Develop and implement relational and non-relational databases in Azure.
Develop and implement data transformations.
Ensure data access patterns are optimized.
Maintain necessary documentation.
Coordinate with necessary teams to meet security standards.
Implement disaster recovery solution.
Provide knowledge transfer.

Requirements

Experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
Experience with Databricks.
Experience with Oracle databases.
Strong experience developing and implementing data transformation solutions and cloud infrastructure integration.
Strong experience coding and testing programs and scripts to load data using Azure data load utilities.
Strong experience with CI/CD pipelines.
Experience with cloud computing concepts.
Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, and Azure CLI/PowerShell for infrastructure management.
Experience in mentoring others in the needed technologies.
Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
Experience with role-based access control, encryption, and network security.
Strong organizational and time management skills.
Desired 7 years’’ experience designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
Knowledge of data concepts, data modeling, schema design, and indexing strategies.
Knowledge of Azure SQL instances, managed instances, and elastic pools.
Knowledge of Data Warehouse Administration and Teradata Data Warehouse.