Photon Hiring | Azure Data Engineer / Database Architect | Norwalk , C

Job Overview

Hi – This is Ramkumar from Photon Infotech. We have an excellent opportunity for Senior Azure Data Engineer Database Architect at Norwalk , Connecticut. Please find the below URL to explore more about photon. https https .https https . https https .https https Role Senior Azure Data Engineer Database Architect Platform Azure. Project DBIS – Data Platform Modernization and migration to Azure Location Norwalk , Connecticut. Mandatory Requirements 5 + Years of hands on Database migration experience, from On-Prem Hybrid Cloud model to Azure 3 + Years of Data Engineering experience involving data conversion from SQL to various Open Source formats like MariaDB Postgres and hosting to cloud 1+ Year experience working with Azure Data Lake Service. Job Responsibilities Ability to work with DBIS team and follow architectural DB administration guidelines Hands On Data Engineering work involving – Data administration, migration to Open-Source formats like MariaDB and migration from On-Prem environment to Azure Ability to deploy DBs using Manual or Azure deployment templates Ability to provide Point of View on Scalability HA DR Security of current and future state DB Architectures Participate in Azure migration effort and consult on Online – Offline migration modes Ability to execute data migration to Opensource formats like MariaDB PostgreSQL Understanding of Azure AD entities and security principals Hands On implementation of Data Security using TDE ( Transparent Data encryption ), Object Level Encryption, Dynamic Data Masking Azure Key Vault Be able to monitor and report DB performance using built in tools like – Azure SQL Database Intelligent Performance and work with configuration parameters like AutoClose, AutoShrink, AutoGrowth DB administration activities like – Index management, tuning, Azure Storage and ability to automate tasks using Azure agent jobs, Optimize IOPS, IQPs Perform Table Query Optimization using IQP, DMVs etc Working knowledge of Azurersquos DevOs and Azure boards. Preferred competencies Azure SQL Server certifications like Azure Data Engineer Associate ( DP – ) Exam – 70-765 ( Provisioning SQL Databases ) Exam – 70-462 ( Administering Microsoft SQL Server Databases ) Exam 70-767 Implementing a Data Warehouse using SQL Exam 70-764 Administering a SQL Database Infrastructure MARIADB CERTIFICATION, EDB PostgreSQL Advanced Server Levels.