girl looking into her desktop
Back to search results

Cloud Data Warehousing Engineer

Charlotte, North Carolina;

Job Description:

Position Summary

Senior Cloud Data Engineer with more than 5 years database administrator experience on any RDBMS technologies like SQL Server / Teradata and or Microsoft Azure. Support multiple instances of Azure cloud databases including Synapse Analytics, CosmosDB, Azure SQL database, development/uat databases, Storage management, Archive, Restore, disaster recovery, security and the enterprise warehouse systems and business applications. Building and Installing new cloud database solution including setting access control security layer, DR setup, Manage/Monitor cloud database system performance, including workload management, query performance and tuning. Provide consulting on physical database implementations, Partitioning, Indexing, join methods, and data access paths. Works closely with Microsoft vendor support, Engineering, Operation, Production support to design and implement secure, available and performant data services on Azure cloud platform supporting a variety of applications on Data Warehouse platform. Implement and administer access policies in conjunction with corporate standards. Manage, design, develop, support and consult cloud shell/power shell process/scripts/tools for system management.

Required Skills: Must have these skills to be minimally qualified. Advanced working knowledge of MPP Database Architecture. Database physical implementation expertise. Advanced working knowledge of database administration on any RDBMS (SQL Server / Teradata preferred) including Security administration, High Availability, DR, Performance tuning and Workload management. Expert in advanced SQL (preferably T-SQL). Advanced design and development of Stored procedures (T-SQL preferred). Advanced knowledge of Data Warehouse design including 3NF/ Star Schema / Snow Flake design etc. Database performance tuning using Indexing, Partitioning etc. Experience on Agile development, SDM tools including JIRA, Bitbucket Repository, CI/CD Pipelines, Ansible, Change Management process using tools like Remedy etc. Strong Python scripting experience with working knowledge on Notebooks.

Desired Skills: Familiar with Cloud computing, Cloud Storage like Native Object Storage, Machine Learning etc. Familiar on Teradata database / Hadoop platform. Familiar with Cloud/Blob/object storage and file formats including Parquet. SSO onboarding using AD integration for authentication and authorization. Familiar with Apache Spark. Experience in implementing data solutions in Azure including Azure SQL, Synapse Analytics, CosmosDB, Apache Spark etc. Familiar on Data Lake Architecture Familiar on Azure RBAC roles. Familiar on Elastic computing especially on cloud platform

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Position Summary

Senior Cloud Data Engineer with more than 5 years database administrator experience on any RDBMS technologies like SQL Server / Teradata and or Microsoft Azure. Support multiple instances of Azure cloud databases including Synapse Analytics, CosmosDB, Azure SQL database, development/uat databases, Storage management, Archive, Restore, disaster recovery, security and the enterprise warehouse systems and business applications. Building and Installing new cloud database solution including setting access control security layer, DR setup, Manage/Monitor cloud database system performance, including workload management, query performance and tuning. Provide consulting on physical database implementations, Partitioning, Indexing, join methods, and data access paths. Works closely with Microsoft vendor support, Engineering, Operation, Production support to design and implement secure, available and performant data services on Azure cloud platform supporting a variety of applications on Data Warehouse platform. Implement and administer access policies in conjunction with corporate standards. Manage, design, develop, support and consult cloud shell/power shell process/scripts/tools for system management.

Required Skills: Must have these skills to be minimally qualified. Advanced working knowledge of MPP Database Architecture. Database physical implementation expertise. Advanced working knowledge of database administration on any RDBMS (SQL Server / Teradata preferred) including Security administration, High Availability, DR, Performance tuning and Workload management. Expert in advanced SQL (preferably T-SQL). Advanced design and development of Stored procedures (T-SQL preferred). Advanced knowledge of Data Warehouse design including 3NF/ Star Schema / Snow Flake design etc. Database performance tuning using Indexing, Partitioning etc. Experience on Agile development, SDM tools including JIRA, Bitbucket Repository, CI/CD Pipelines, Ansible, Change Management process using tools like Remedy etc. Strong Python scripting experience with working knowledge on Notebooks.

Desired Skills: Familiar with Cloud computing, Cloud Storage like Native Object Storage, Machine Learning etc. Familiar on Teradata database / Hadoop platform. Familiar with Cloud/Blob/object storage and file formats including Parquet. SSO onboarding using AD integration for authentication and authorization. Familiar with Apache Spark. Experience in implementing data solutions in Azure including Azure SQL, Synapse Analytics, CosmosDB, Apache Spark etc. Familiar on Data Lake Architecture Familiar on Azure RBAC roles. Familiar on Elastic computing especially on cloud platform

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21035658

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Jami Britt

Referral Bonus:

0