Cloud DBA

JMS Technical Solutions

Buffalo, NY, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

dice.com

Tech stack

Microsoft Azure Backup Devices Cloud Computing Cloud Database Computer Networks Databases Information Engineering Data Infrastructure Extract Transform Load (ETL) Data Security Data Systems Information Lifecycle Management

+21 more

Key Management Microsoft SQL Server Network Architecture Role-Based Access Control Power BI Cloud Services Azure Data Lake SQL Databases SQL Server Agent Tableau (Software) Cloud Platform System Data Ingestion System Availability Snowflake SolarWinds (Software) Data Analytics Performance Monitor Qlikview Firewall Services Module Amazon Redshift Databricks

Job description

This position requires the person to reside in Buffalo, NY or surroundng area. Must be able to work on W2 without sponsorship. No 3rd party agencies.

Cloud Database Administrator

· 25% Cloud Data Platform Administration: Administer Azure Databricks workspaces, clusters, pools, permissions, and configurations. Implement governance, access controls, secrets management, and workspace policies. Ensure cost-efficient compute usage through autoscaling, cluster policies, and monitoring.

· 20% Data Infrastructure Reliability & Performance: Monitor performance of Databricks jobs, SQL warehouses, and underlying storage. Proactively tune clusters, SQL environments, and pipelines to ensure high availability. Maintain observability through monitoring platforms, SQL Server, Databricks Metrics, and alerting.

· 15% Data Backup, Recovery, & Resilience: Resolve data platform issues related to cluster performance, job failures, permissions, or integration points. Collaborate with data engineering and development teams to troubleshoot environment-level issues.

· 15% Database & Data System Security: Implement platform-wide security standards: SQL roles, Azure RBAC, network rules, Unity Catalog privileges. Support compliance and governance across cloud data services and SQL Server environments.

· 15% Troubleshooting & Operational Support: Diagnose and resolve database-related issues, working closely with the IT team to troubleshoot and minimize disruptions.

· 10% Documentation, Standards, & Best Practices: Maintain documentation of environments, policies, network architecture, data access patterns, and cluster standards.

Requirements

Managing SQL Server, SQL Agent jobs, SQL table and index maintenance, performance monitoring, and management
Experience with Cloud data platforms, such as Azure Data Lake, Azure Databricks, Snowflake, RedShift
Experience with cloud computing, Infrastructure-as-a-service, and cloud networking concepts
Experience with monitoring and observabilities tools such as SolarWinds and Azure Monitor
Understanding of data ingestion and transformation (ETL/ELT) concepts and data lifecycle
Experience with Data analytics platforms such as PowerBI, Tableau, Qlik

Job Specific Requirements

Demonstrable competency with backups, restores, and recovery models
Knowledge of cloud compute and networking concepts (VNet integration, private endpoints, firewall rules)
Sense of ownership and pride in your performance and its impact on Club’’s success
Strong time-management/organizational, interpersonal, & communication skills
Demonstrated curiosity and a strong desire to learn and adopt new technologies
Critical thinker and adept problem-solving skills while maintaining a team focused/collaborative mindset
Ability to follow established standards and contribute to continuous improvement
Clear written and verbal communication skills with a collaborative team approach