Senior Cloud Data Platform Administrator (Azure & Snowflake) | W2 Only | Fully Remote |
Chicago, IL - USA
Job Summary
Job Role: Administer and modernize cloud-first data platforms (Azure and Snowflake) with secondary support for onpremises SQL Server focusing on centralized automated deployments secure operations (including HIPAA/PHI) performance/availability and continuous improvement through automation to increase efficiency and reliability.
Job Description:
Administers and supports cloud-first data platforms (Azure and Snowflake) including Azure Data Factory (ADF) Azure SQL Database/Managed Instance Azure Cosmos DB Azure Database for PostgreSQL MongoDB and Snowflake; provides support for on premises SQL Server.
Centralizes standardizes and executes deployments for SQL Serverrelated components including SQL code (DDL/DML stored procedures) SQL Agent jobs SSIS packages SSAS models SSRS reports and supporting BI/analytics tools (Tableau Alteryx).
Designs implements and maintains automated CI/CD pipelines and release processes for databases pipelines and analytics artifacts across environments emphasizing repeatability auditability and change control.
Builds and operates deployment automation and administrative tooling using scripting and programming (e.g. PowerShell Python) enabling self-service and reducing manual effort.
Monitors tunes and optimizes database and warehouse performance across platforms (SQL Server Azure data services Snowflake) ensuring capacity planning cost/performance efficiency and stable SLAs.
Implements and validates backup/restore high availability and disaster recovery replication and data protection controls for on prem and cloud environments; performs regular testing and documentation of recovery procedures.
Operates and governs data ingestion/integration pipelines including ADF orchestration and Coalesce-based data modeling for the Snowflake EDW ensuring reliability lineage and deployable version-controlled models.
Manages security access controls secrets and auditing across data platforms and tooling; ensures proper handling of highly sensitive PHI in compliance with HIPAA and partners with security/compliance stakeholders to meet policy and regulatory requirements.
Leads incident response troubleshooting root-cause analysis and problem management for production and critical environments; participates in on-call support as required and maintains runbooks deployment guides and operational documentation.
Drives continuous improvement using an automation-first AI-enabled approach by applying standardization templates and intelligent tooling to improve developer/analyst experience increase deployment velocity and reduce operational risk.
Experience:
Cloud Data Platforms (Primary): 8 to 10 years administering and supporting enterprise data platforms with primary focus on cloud services (Azure data services and Snowflake) and support for onpremises SQL Server.
Centralized Deployments & DevOps: 5 years building and operating standardized release processes and CI/CD pipelines for database ETL/ELT and analytics artifacts with strong source control and change management discipline.
Reliability & Performance: Proven experience operating missioncritical data systems including performance tuning monitoring/alerting capacity planning incident response and resilient backup/restore and DR practices.
Governance & Security: Experience implementing access controls auditing and secure configuration across data platforms partnering with security/compliance stakeholders and supporting HIPAA-regulated environments.
Skills:
Cloud data platform administration: Hands-on administration of Snowflake and Azure data services (Azure SQL DB/MI) including security performance tuning cost management and operational support; supports onprem SQL Server.
Cloud database services: Working knowledge administering and operating Azure Cosmos DB Azure Database for PostgreSQL and MongoDB (security monitoring performance/capacity and troubleshooting).
Azure Data Factory (ADF): Build/support ADF orchestration with production monitoring alerting and troubleshooting.
Snowflake administration: Manage warehouses roles/grants resource monitors performance tuning and cost management for a modern cloud EDW.
Data modeling & ELT tooling: Use Coalesce (or similar) to build modular version-controlled models; strong understanding of dimensional modeling and data quality/lineage concepts.
Release engineering for data platforms: Ability to package and deploy SQL code SQL Agent jobs SSIS packages SSAS models and SSRS reports via CI/CD with repeatable promotion across environments; familiarity deploying/refreshing downstream analytics tools (e.g. Tableau Alteryx).
Automation & scripting: Proficiency with PowerShell and Python to automate operational tasks (deployments monitoring user/access provisioning and routine maintenance); able to evaluate and apply AI-assisted tooling safely and appropriately.
Job Description:
Administers and supports cloud-first data platforms (Azure and Snowflake) including Azure Data Factory (ADF) Azure SQL Database/Managed Instance Azure Cosmos DB Azure Database for PostgreSQL MongoDB and Snowflake; provides support for on premises SQL Server.
Centralizes standardizes and executes deployments for SQL Serverrelated components including SQL code (DDL/DML stored procedures) SQL Agent jobs SSIS packages SSAS models SSRS reports and supporting BI/analytics tools (Tableau Alteryx).
Designs implements and maintains automated CI/CD pipelines and release processes for databases pipelines and analytics artifacts across environments emphasizing repeatability auditability and change control.
Builds and operates deployment automation and administrative tooling using scripting and programming (e.g. PowerShell Python) enabling self-service and reducing manual effort.
Monitors tunes and optimizes database and warehouse performance across platforms (SQL Server Azure data services Snowflake) ensuring capacity planning cost/performance efficiency and stable SLAs.
Implements and validates backup/restore high availability and disaster recovery replication and data protection controls for on prem and cloud environments; performs regular testing and documentation of recovery procedures.
Operates and governs data ingestion/integration pipelines including ADF orchestration and Coalesce-based data modeling for the Snowflake EDW ensuring reliability lineage and deployable version-controlled models.
Manages security access controls secrets and auditing across data platforms and tooling; ensures proper handling of highly sensitive PHI in compliance with HIPAA and partners with security/compliance stakeholders to meet policy and regulatory requirements.
Leads incident response troubleshooting root-cause analysis and problem management for production and critical environments; participates in on-call support as required and maintains runbooks deployment guides and operational documentation.
Drives continuous improvement using an automation-first AI-enabled approach by applying standardization templates and intelligent tooling to improve developer/analyst experience increase deployment velocity and reduce operational risk.
Experience:
Cloud Data Platforms (Primary): 8 to 10 years administering and supporting enterprise data platforms with primary focus on cloud services (Azure data services and Snowflake) and support for onpremises SQL Server.
Centralized Deployments & DevOps: 5 years building and operating standardized release processes and CI/CD pipelines for database ETL/ELT and analytics artifacts with strong source control and change management discipline.
Reliability & Performance: Proven experience operating missioncritical data systems including performance tuning monitoring/alerting capacity planning incident response and resilient backup/restore and DR practices.
Governance & Security: Experience implementing access controls auditing and secure configuration across data platforms partnering with security/compliance stakeholders and supporting HIPAA-regulated environments.
Skills:
Cloud data platform administration: Hands-on administration of Snowflake and Azure data services (Azure SQL DB/MI) including security performance tuning cost management and operational support; supports onprem SQL Server.
Cloud database services: Working knowledge administering and operating Azure Cosmos DB Azure Database for PostgreSQL and MongoDB (security monitoring performance/capacity and troubleshooting).
Azure Data Factory (ADF): Build/support ADF orchestration with production monitoring alerting and troubleshooting.
Snowflake administration: Manage warehouses roles/grants resource monitors performance tuning and cost management for a modern cloud EDW.
Data modeling & ELT tooling: Use Coalesce (or similar) to build modular version-controlled models; strong understanding of dimensional modeling and data quality/lineage concepts.
Release engineering for data platforms: Ability to package and deploy SQL code SQL Agent jobs SSIS packages SSAS models and SSRS reports via CI/CD with repeatable promotion across environments; familiarity deploying/refreshing downstream analytics tools (e.g. Tableau Alteryx).
Automation & scripting: Proficiency with PowerShell and Python to automate operational tasks (deployments monitoring user/access provisioning and routine maintenance); able to evaluate and apply AI-assisted tooling safely and appropriately.
HR
Xlysi LLC Expert Portal Solutions251 Milwaukee Ave Buffalo grove IL 60089
Web :
E-mail:
Our training portal registration:
Experience:Senior IC
About Company
Transform your business with our cloud services. We offer digital transformation solutions, software development, and consulting services.