Cloud DBA

JMS Technical Solutions
Buffalo, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Buffalo, United States of America

Tech stack

Azure
Backup Devices
Cloud Computing
Cloud Database
Computer Networks
Databases
Information Engineering
Data Infrastructure
ETL
Data Security
Data Systems
Information Lifecycle Management
Key Management
Microsoft SQL Server
Network Architecture
Role-Based Access Control
Power BI
Cloud Services
Azure
SQL Databases
SQL Server Agent
Tableau
Cloud Platform System
Data Ingestion
System Availability
Snowflake
SolarWinds (Software)
Data Analytics
Performance Monitor
QlikView
Firewall Services Module
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

Apply for this position