DBA Senior (SQL Server & Databricks)

DBA Senior (SQL Server & Databricks)

+5 to 8 years in database administration Verifiable experience with SQL Server Enterprise +2-3 years in Big Data / Databricks platforms Systems Engineering, IT or related Technical Skills

SQL Server (Core)

• Advanced SQL Server administration (2012 – 2022)

• High availability configuration:

• Always On Availability Groups

• Failover Clustering

• Replication (Transactional, Snapshot, Merge)

• Performance tuning:

• Query optimization

• Indexing strategies

• Execution plans

• Security:

• Roles, permisos, encryption (TDE)

• Audits and compliance

• Backup & Recovery:

• Estrategias PITR (Point-in-Time Recovery)

• Backup automation

• Troubleshooting:

• Blocking, deadlocks, waits analysis

Databricks / Big Data

• Development in Apache Spark (PySpark / SQL / Scala)

• Manejo de Delta Lake

• Pipeline optimization in Databricks

• Medallion Architecture (Bronze / Silver / Gold)

• Integration with:

• Azure Data Factory / Synapse

• APIs and external sources

• Manejo de clusters:

• Autoscaling

• Cost optimization

• Data governance:

• Unity Catalog

• Data lineage

Data Engineering & Integración

• ETL/ELT pipelines

• Data modeling:

• OLTP and OLAP

• Star/Snowflake schema

• Data migration:

• On-prem → Cloud

• Workflow orchestration

• Manejo de grandes volúmenes (Big Data)

Cloud (Deseable / Clave)

• Azure (preferente):

• Azure SQL

• Azure Data Lake

• Azure Databricks

• AWS (deseable):

• S3 + Databricks

• Infraestructura como código (IaC) básico

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

Responsabilidades

• Manage and monitor critical SQL Server instances

• Design high availability and DRP strategies

• Optimize database and query performance

• Implement data pipelines in Databricks

• Manage Data Lake storage

• Lead cloud migrations

• 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

• Complex problem solving

• Communication with technical and business stakeholders

• Technical leadership

• Working under pressure (critical environments)

• Proactivity and ownership