Senior Microsoft Power Platform Developer (SQL Server)

Astyra Corporation

Raleigh, NC

JOB DETAILS
SKILLS
Analysis Skills, Application Programming Interface (API), Automation, Business Skills, Business Support, Canvas, Cloud Applications, Cloud Computing, Communication Skills, Computer Science, Data Modeling, Data Quality, Database Administration, Database Design, Database Extract Transform and Load (ETL), Detail Oriented, Documentation, Environmental Health, Establish Priorities, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operations Processes, Performance Tuning/Optimization, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Public Health, Query Optimization, Requirements Management, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Software Development, Stored Procedures, Systems Administration/Management, Team Player, Time Management, Writing Skills
LOCATION
Raleigh, NC
POSTED
1 day ago
Job Description
Job Description
Senior Microsoft Power Platform Developer (SQL Server)
*This is a 1-year contract position
*This is a hybrid position – Local to Raleigh, NC only please
*We are not considering Corp-to-Corp (C2C) arrangements for this position

Description:

We are looking for a versatile and highly skilled Microsoft Power Platform Developer in the Division of Public Health, providing primary support for the Health Hazard Control Unit (HHCU) within the Environmental Health section. The primary purpose of the position is to lead the design, development, and governance of low-code and automation solutions, and to design, build, and support enterprise-grade applications and databases. This hybrid role supports business automation initiatives while ensuring the reliability, security, and performance of SQL environments across the organization.

Responsibilities:
  • Design, develop, and deploy applications using Power Apps (Canvas and Model-Driven), Power Automate, and Dataverse
  • Integrate Power Platform solutions with SQL Server, Microsoft 365, Azure, and external systems
  • Develop and maintain SQL Server databases, including schema design, performance tuning, and optimization
  • Create and maintain stored procedures, views, functions, triggers, and ETL processes
  • Design enterprise-ready data models and build secure connections between Power Platform solutions and SQL databases
  • Implement governance, ALM, and environment strategies for Power Platform solutions
  • Ensure data integrity, security, and compliance across applications and databases
  • Troubleshoot Power Platform errors, workflow failures, and database performance issues
  • Collaborate with stakeholders to gather requirements and translate them into technical solutions
  • Maintain documentation, diagrams, and operational procedures
  • Support modernization, automation, and cloud adoption initiatives

Preferred Qualifications:
  • Microsoft Power Platform Developer Associate (PL-400) or higher certification
  • Experience with Power BI, dataflows, and enterprise reporting
  • Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Required Skills/Knowledge/Experience:
  • Strong hands-on experience with Power Apps, Power Automate, Dataverse, and SQL Server – 7 years required
  • Expertise in T-SQL development, performance tuning, indexing strategies, and query optimization – 7 years required
  • Experience managing SQL Server instances on-premises and/or Azure SQL – 7 years required
  • Understanding of data governance, security roles, and DLP policies – 7 years required
  • Experience integrating databases with APIs, cloud apps, and third-party systems – 7 years required
  • Ability to interpret business needs and deliver scalable, maintainable solutions – 7 years required
  • Strong analytical and troubleshooting skills – 7 years required
  • Experience in MS Power Platform development and implementation – 7 years required
  • Proficiency in Power Apps, Power Virtual Agent, and Dataverse – 7 years required
  • Knowledge of SQL database structure – 7 years required
  • Strong problem-solving skills and attention to detail – 7 years required
  • Excellent verbal and written communication skills – 7 years required
  • Ability to work independently and as part of a team – 7 years required
  • Ability to prioritize tasks and manage time effectively – 7 years required

Education:
  • Bachelor’s degree in Computer Science, Information Systems, or related field – required
  • Microsoft Power Platform Developer Associate (PL-400) or higher – preferred
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC

About the Company

A

Astyra Corporation