DBA Senior (SQL Server & Databricks)

Role Summary

• Senior DBA (SQL Server & Databricks)
• +5 to 8 years in database administration
• Proven experience with SQL Server Enterprise
• +2-3 years on Big Data / Databricks platforms
• Systems Engineering, IT or similar

High availability configuration

• Always On Availability Groups
• Failover Clustering
• Replication (Transactional, Snapshot, Merge)

Performance tuning

• Query optimization
• Indexing strategies
• Execution plans

Security

Roles, permissions, encryption (TDE)

Audits and compliance

Backup & Recovery

PITR (Point-in-Time Recovery) Strategies

Backup automation

Troubleshooting

• Blocking, deadlocks, waits analysis
• Databricks / Big Data
• Development in Apache Spark (PySpark / SQL / Scala)
• Delta Lake Management
• Pipeline optimization in Databricks
• Medallion Architecture (Bronze/Silver/Gold)

Integration with

Azure Data Factory / Synapse

APIs and external sources

Cluster management

Autoscaling

Cost optimization

Data governance

• Unity Catalog
• Data lineage
• Data Engineering & Integration
• ETL/ELT pipelines

Data modeling

OLTP and OLAP

Star/Snowflake schema

Data migration

• On-prem → Cloud
• Workflow orchestration
• Management of large volumes (Big Data)
• Cloud (Desirable / Key)

Azure (preferred)

• Azure SQL
• Azure Data Lake
• Azure Databricks

AWS (desirable)

• S3 + Databricks
• Basic Infrastructure as Code (IaC)
• Tools
• SQL Server Management Studio (SSMS)
• Azure Data Studio
• Databricks Workspace
• Git (version control)
• PowerShell (automation)
• Azure DevOps/CI-CD

Monitoring

• Azure Monitor
• Log Analytics
• SQL Profiler / Extended Events

Responsibilities

• Manage and monitor critical SQL Server instances
• Design high availability and DRP strategies
• Optimize database and query performance
• Implement data pipelines in Databricks
• Manage storage in Data Lake
• Lead migrations to the cloud
• Define data modeling standards
• Ensure security, compliance and data quality
• Collaborate with Data Engineering and Analytics teams
• Mentor Jr/Mid profiles
• Soft Skills
• Analytical thinking
• Solving complex problems
• Communication with technical and business stakeholders
• Technical leadership
• Work under pressure (critical environments)
• Proactivity and ownership

Requirements

Technical Skills

SQL Server (Core)

Advanced SQL Server Administration (2012 – 2022)