Amtex Systems Inc. · 1 week ago
Data Warehouse Architect
Maximize your interview chances
Amtex Systems is a global company established in 1997, headquartered in New York. They are seeking a Data Warehouse Architect who will be responsible for designing and implementing data warehousing solutions using Azure technologies, ensuring optimal performance and security of database deployments.
CRMInformation Technology
Actively Hiring
Insider Connection @Amtex Systems Inc.
Get 3x more responses when you reach out via email instead of LinkedIn.
FFF
& 2 connections
FFF
& 2 connections
Previously@undefined and...
FFF
& 2 connections
@undefined and...
Responsibilities
5+ years proven experience working with Azure Databricks, Azure SQL, and other relational database technologies supported in Azure
Strong experience with relational and/or dimensional data modeling
Experience with Azure Data Factory, Azure Data Lake, Azure Data Explorer, Azure Event Hubs, Spark Pools, Dedicated/Serverless SQL Pools, PowerBI, Azure Landing Zones, Azure Networking Services, AAD/EntraID
Strong familiarity with NoSQL technologies such as Azure Cosmos DB is a plus
Experienced with Azure geo-redundancy, HA/failover, Datasync technologies
Experienced with log-shipping and database disaster recovery
Strong experience with performance tuning and optimization (PTO)
Strong expertise and experience with Azure DevOps tools in an Azure production setting.
Strong experience with Azure Data Studio, Visual Studio database management/projects/design capabilities, Azure CLI, and Powershell
Azure Database Administrator will need to have expertise in T-SQL and Stored Procedures.
Experience with SQL Server versions 2005 – 2022 is a plus
Experience running and troubleshooting SSIS packages
Experience with Oracle, either in Azure or on-prem, is a plus
Strong and current familiarity with Azure platforms and services, including Azure App Services, Azure API Management, Azure Monitor, Azure Application Insights, Azure SQL, etc.
Familiarity and hands-on experience with Infrastructure as Code (IaC) tools such as Terraform is a plus
Familiarity with programming languages such as Visual Studio, C# or Python and data constructs such as JSON or XML is strongly desired
Strong understanding of security best practices for Azure database deployments, including, access controls, IAM, data encryption (TDE), Azure key vaults and masking.
Awareness of FedRAMP, FISMA, and/or Zero Trust Architecture strongly desired.
Experience with CI/CD pipelines and deployment automation using tools like Azure DevOps
Experience with Agile methodologies
Excellent problem-solving skills and a proactive approach to identifying and resolving issues
Strong teamwork and communication skills, with the ability to collaborate effectively with cross-functional teams
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
5+ years proven experience working with Azure Databricks, Azure SQL, and other relational database technologies supported in Azure
Strong experience with relational and/or dimensional data modeling
Experience with Azure Data Factory, Azure Data Lake, Azure Data Explorer, Azure Event Hubs, Spark Pools, Dedicated/Serverless SQL Pools, PowerBI, Azure Landing Zones, Azure Networking Services, AAD/EntraID
Experienced with Azure geo-redundancy, HA/failover, Datasync technologies
Experienced with log-shipping and database disaster recovery
Strong experience with performance tuning and optimization (PTO)
Strong expertise and experience with Azure DevOps tools in an Azure production setting
Strong experience with Azure Data Studio, Visual Studio database management/projects/design capabilities, Azure CLI, and Powershell
Azure Database Administrator will need to have expertise in T-SQL and Stored Procedures
Strong and current familiarity with Azure platforms and services, including Azure App Services, Azure API Management, Azure Monitor, Azure Application Insights, Azure SQL, etc.
Strong understanding of security best practices for Azure database deployments, including, access controls, IAM, data encryption (TDE), Azure key vaults and masking
Excellent problem-solving skills and a proactive approach to identifying and resolving issues
Strong teamwork and communication skills, with the ability to collaborate effectively with cross-functional teams
Preferred
Strong familiarity with NoSQL technologies such as Azure Cosmos DB
Experience with SQL Server versions 2005 – 2022
Experience running and troubleshooting SSIS packages
Experience with Oracle, either in Azure or on-prem
Familiarity and hands-on experience with Infrastructure as Code (IaC) tools such as Terraform
Familiarity with programming languages such as Visual Studio, C# or Python and data constructs such as JSON or XML
Awareness of FedRAMP, FISMA, and/or Zero Trust Architecture
Experience with CI/CD pipelines and deployment automation using tools like Azure DevOps
Experience with Agile methodologies
Company
Amtex Systems Inc.
Amtex Systems was officially started in 1997 by Sunny Pokala with its headquarters in Wall Street, New York, and currently has offices across four continents.
Funding
Current Stage
Late StageLeadership Team
Recent News
2024-04-06
Company data provided by crunchbase