DBA & SQL Developer
Description
Company Overview:
Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer a multitude of opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries.
Currently, we are seeking a DBA & SQL Developer with a strong English and Spanish level to join our team. Here are the challenges that our next warrior will face and the requirements we look for:
Position Title: DBA & SQL Developer
Location: Remote (LATAM)
What you will be doing:
This role combines database administration (DBA) and SQL development skills, ensuring the project’s databases are robust, efficient, and secure, while also developing queries, procedures, and optimizing data access for security for users and roles at the database level.
- Manage and monitor the performance of project databases: staging databases for transformations and final productive DWH Databases.
- Design and implement database schemas and structures for the Data Warehouse.
- Analyze and rewrite inefficient queries to improve database performance.
- Write and optimize complex SQL queries for data extraction and analysis.
- Create stored procedures, functions, views, and other database objects.
- Perform backups, restoring procedures, and disaster recovery tasks, aligned with our DevOps and infrastructure teams.
- Implement security measures to protect data aligned with our cybersecurity department.
- Develop and implement a role and responsibilities matrix to segregate functions, optimizing and securing data access, for users' security and roles at the database level.
- Collaborate with ETL Developers and Data Engineers to ensure smooth data integration.
- Implement user roles, permissions, and encryption to secure sensitive data.
- Diagnose and resolve database-related issues, including deadlocks and performance bottlenecks.
- Maintain clear documentation for database structures, configurations, and processes.
Requirements & Qualifications
To excel in this role, you should possess:
- Main Skills:
These are the must-haves that are essential for this position.
- DBA experience with Database Management Systems (DBMS): SQL Database Azure Microsoft and PostgreSQL:
- Perform backups, restoring procedures, and disaster recovery tasks.
- Advanced knowledge of SQL (joins, subqueries, window functions, indexing, etc.).
- Data Integration Knowledge: Basic understanding of ETL processes and working with large datasets.
- Cloud-based Data Warehouse platform: nice to have experience with Snowflake
- Experience with PostgreSQL
- Microsoft Fabric, Microsoft Analytics Platform System (APS), Microsoft Azure Synapse Analytics
- SQL Development and Performance Tuning:
- Experience with SQL Optimization.
- Writing and optimizing SQL queries, stored procedures, functions, and triggers.
- Tools like SQL Server Profiler, Oracle SQL Developer, or pgAdmin for query optimization and database performance monitoring.
- Backup and Recovery:
- Tools like SQL Server Management Studio for disaster recovery, RMAN (Oracle), pg_dump (PostgreSQL).
- ETL Tools: SSIS (SQL Server Integration Services), Apache Airflow, Matillion AWS, or Pentaho
- Experience using Git, GitHub, Azure Repos, or other version control systems for database scripts and procedures.
- Understanding of GDPR, HIPAA, or other data privacy regulations to maintain compliance.
- Secondary Skills:
These are additional skills that will help you succeed in this role.
- [Additional qualifications or preferences]
Why you will love Lean Tech:
- Join a powerful tech workforce and help us change the world through technology
- Professional development opportunities with international customers
- Collaborative work environment
- Career path and mentorship programs that will lead to new levels.
Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.