Database Engineer

Description of Project

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.

Desired Qualifications

• 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.