Database Engineer - Azure

Where You Will Work:Our corporate office is located in the Denver Tech Center. Our office spans the top two floors of the building and features expansive views of the mountains and the downtown skyline. AIR values relationships and the benefits from working side by side with teammates, therefore this position will be in-office 3-5 days a week to support the team.What You Will Do:As a Database Engineer, you will be responsible for administering our on-premise and Azure data and analytics platform, which includes MS SQL, Azure Synapse, Azure Data Factory, Data Lake, and reporting as part of AIR Communities’ technology ecosystem. You will ensure the smooth operation of these systems, focusing on uptime and performance. You will drive innovation and change by implementing automation and leveraging artificial intelligence tools and methods to add value. As a technical expert in our data and analytics ecosystem, you will support AIR Communities' operations, analytics, and reporting teams. Your role will involve tuning our environments to run faster and reducing cost run rates as our data volume grows.Essential Functions: Work with stakeholders (Business partners, Infrastructure and Operations teams) to ensure smooth and secure operations of Azure data and analytics platform including Azure Synapse, ADF, Power BI etc.Oversee data warehouse and analytics platform performance on both on premise and Azure from implementation, maintenance to enhancements and ongoing operationsManage various Azure data pipelines, job schedules and systems to ensure performance and uptimeMaintain up-to-date platform documentation and provide technical support to database, application and business intelligence (BI) developersServe as primary liaison between the company and Managed Services vendor regarding all database related activityPerform maintenance, including upgrades and system patching, and troubleshooting activities for data stores and BI platforms in Azure and on-premEnsure metadata (data catalog) are tracked for all data objects in the platformPerform system monitoring and performance analysisPerform ongoing security controls audit and review to ensure complianceReview system application logs and identify potential issues and improvementsParticipate in capacity planning, cloud cost analysis and cloud resources optimizationProvide after-hour system and application support, whenever necessaryDevelop and implement various work plans for projects