Senior Azure Data Engineer

SQL, DBIS, Azure, PostgreSQL
Full Time
$80,000 - $100,000

Job Description

Hi

 

Greetings from Photon !!!

 

Photon is the largest and fastest-growing provider of Mobile-First Digital Experiences. We work with 40 of the Fortune 100 companies like Walgreens (Best Retail app of the year at SXSW, Webby award winner, r app), KeyBank, Olive Garden and L'Oréal. We also help innovative, well-funded startups like Songza (acquired by Google), Xtify (acquired by IBM), and Siri (acquired by Apple).

 

Core highlights

  • We redefine digital transformation for 40 of the Fortune 100 companies
  • We power over 750 million digital touchpoints every day
  • We employ over 4,300 trained Web, Mobile & Omnichannel engineers across the world

 

We define digital presence today as the confluence of three layers

  • Personalized Digital Experiences on the front end
  • API and Microservices in the middle tier
  • Big Data Platforms powering these digital experiences on the back end

 

Our unique value proposition

  • We deliver compelling Digital Experiences with creative front-end design integrated into enterprise architecture on the back-end. 
  • We serve as our customers’ innovation partner by combining ever-changing consumer behavior and digital knowledge with unique insights into existing and emerging technologies to develop a range of innovative digital solutions.

 

We believe that the digital revolution ahead is about empowering new ways of human-machine interactions and delivering compelling personalized experiences to meet and satisfy ever changing customer experiences. It has become a prerequisite to integrate digital at the core of business to invent, develop and deliver disruptive digital innovations. Connect with us to learn how to achieve business efficiencies, reduce operational costs, attract new customers, become more agile, and achieve next-gen customer experiences. 

 

 

 Project : DBIS - Data Platform Modernization and migration to Azure

Role: Senior Azure Data Engineer

Platform: Azure 

Location : Norwalk .Connecticut

Rate: 55-60/hr

No OPT/CPT/H4 EAD

 

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

 

 

Mandatory Skills

 

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

 

 

Preferred competencies:

Azure SQL Server certifications like : 

Azure Data Engineer Associate ( DP - 200 & 201 ) 

Exam - 70-765 ( Provisioning SQL Databases ) 

Exam - 70-462 ( Administering Microsoft SQL Server 2012/2014 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

 

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 Azure’s DevOs and Azure boards


Gundi Shashidhar
Human Resources
Email:gundishashidhar@photoninfotech.net
Desk: 408-404- 3301 Ext 9025
www.photon.in

 

Dice Id : 10462843
Position Id : 6604689
Originally Posted : 1 month ago
Have a Job? Post it