This is an on-site position based in guadalajara, mexico.
*sr dba architect*
*job title*: senior database architect
*location*: maxico
*job type*: full time
*key responsibilities*:
- *database architecture & design*: architect and design scalable, high-performance, and cost-efficient database solutions using *azure cosmos db and sql server*.
- *data modeling*: develop and implement relational and nosql data models to support business requirements.
- *performance optimization*: optimize database performance through indexing, partitioning, sharding, and query tuning.
- *security & compliance*: ensure database security, backup, disaster recovery, and compliance with industry standards.
- *cloud & hybrid solutions*: implement *cloud-native* and *hybrid* database solutions leveraging *azure synapse, data factory, and other azure services*.
- *data governance & etl*: define data governance policies and build etl pipelines using *azure data factory, databricks, and synapse analytics*.
- *automation & monitoring*: develop automation for database deployments, schema changes, and monitoring using azure devops and infrastructure as code (iac).
- *troubleshooting*: identify and resolve database performance issues, failures, and bottlenecks.
*required qualifications*:
- *8+ years* of experience in *database architecture, administration, and development*.
- *expertise in azure cosmos db, sql server, and azure data services*.
- strong understanding of *nosql, distributed databases, and multi-model databases*.
- experience with *etl tools (adf, ssis) and big data processing (databricks, synapse analytics)*.
- proficiency in *t-sql, stored procedures, indexing, and query tuning*.
- knowledge of *security best practices, rbac, encryption, and compliance frameworks*.
- hands-on experience with *azure devops, ci/cd pipelines, and infrastructure as code (terraform, arm templates)*.
- strong analytical and problem-solving skills with a deep understanding of *data warehousing and analytics*.
- excellent communication and leadership skills.
*preferred qualifications*:
- experience in *medallion architecture, delta lake, or lakehouse architectures*.
- familiarity with *kafka, event hubs, or real-time streaming architectures*.
- certification in *microsoft azure data & ai*.
tipo de puesto: tiempo completo
sueldo: $70,* - $85,* al mes
tipo de jornada:
- turno de 8 horas
puede trasladarse/mudarse:
- *, rinconada santa rita, jal.
: trasladarse al trabajo sin problemas o planear mudarse antes de comenzar a trabajar (deseable)
experiência:
- database architecture: 7 años (obligatorio)
- azure cosmos db: 7 años (deseable)
- sql server: 7 años (deseable)
- azure data services: 7 años (deseable)
idioma:
- inglés (obligatorio)
lugar de trabajo: empleo presencial