Blue Ridge Power (BRP) is seeking a Senior Database Developer to join our team! At BRP, we are dedicated to leveraging cutting-edge technologies to drive data-driven decisions and deliver exceptional solutions. We're seeking a highly skilled Senior Database Developer with a robust background in Data Vault 2.0, Azure SQL Server management, Azure Data Factory (ADF), Azure Batch Accounts, and PowerShell to join our dynamic team. This is a unique opportunity to play a critical role in shaping our data infrastructure and contributing to impactful projects.

Senior Database Developer, you will be responsible for designing, implementing, and managing our database solutions, ensuring high performance, scalability, and reliability. You will lead efforts to integrate external data sources and manage data within our Azure environment. Senior Database Developer shall develop and optimize data pipelines and implement best practices in Data Vault 2.0 modeling.

This position can be remote, preferably within comfortable travel distance of one of our BRP office locations in Asheville or Fayetteville, NC, and any travel will be fully reimbursable. Competitive salary and annual bonus offered.

 What You'll Do:

• Database Management:
  • Manage and optimize Azure SQL Server databases, ensuring high availability, performance, and security. 
  • Perform routine database maintenance, including backups, restores, and performance tuning. 
  • Monitor and troubleshoot database issues, implementing solutions to enhance database performance and reliability. 
• Data Vault 2.0 Implementation: 
  • Design and implement Data Vault 2.0 models for scalable and flexible data warehousing solutions. 
  • Develop and maintain Data Vault 2.0 architecture, including Hubs, Links, and Satellites. 
  • Collaborate with leadership and stakeholders to align Data Vault models with business requirements and objectives. 
  • Optimize gold layer of data vault for Copilot integration. 
• Data Pipeline Development: 
  • Develop, deploy, and maintain data pipelines using Azure Data Factory (ADF) to facilitate ETL/ELT processes. 
  • Integrate data from various sources into Azure SQL databases, ensuring data integrity and consistency. 
  • Optimize data pipeline performance and troubleshoot issues to ensure timely data processing. 
• Infrastructure Automation: 
  • Utilize Azure Batch services to automate nightly jobs for automating Network Permissions  
  • Automate SharePoint sites using PowerShell PNP cmdlets 
• Collaboration and Leadership: 
  • Work closely with cross-functional teams, business SMEs, BI analysts, and application developers, to support data-driven projects. 
  • Lead database-related projects, ensuring alignment with organizational goals and timelines. 

Must-Haves:

• 7+ years in database engineering, with a strong focus on Azure SQL Server management. 
• Extensive experience with Data Vault 2.0 methodology and implementation. 
• 3+ years of demonstrated expertise in developing data pipelines using Azure Data Factory (ADF). 
• 5+ years of PowerShell experience.
• Proficiency in SQL, T-SQL, and PL-SQL. 
• Deep understanding of Azure SQL Server, including configuration, performance tuning, and security best practices. 
• Strong knowledge of Azure Data Factory (ADF) and its integration with other Azure services. 
• Familiarity with data modeling, data warehousing, and ETL/ELT processes. 
• Excellent problem-solving skills and attention to detail. 
• Strong communication and interpersonal skills, with the ability to collaborate effectively across teams. 
• Proven leadership and mentoring abilities.
• Must possess and maintain a current valid driver's license required.

Education and Certifications: 

• A Bachelor’s degree in computer science, Information Systems, or a related field or equivalent years of experience with appropriate MS certification is preferred. 
• A Master’s degree or relevant certifications is preferred. 

Working Environment and Physical Demands: 

• This position can be remote, preferably within comfortable traveling distance to one of our BRP office locations in Asheville and Fayetteville, NC. 
• Office visits may be required when needed. This could include travel up to 10%.  
• Must be able to sit/stand at a desk and utilize a computer, for extended periods.