Job Description
We are looking for a skilled SQL Developer to join our data engineering team. The ideal candidate will have a strong background in designing and optimizing database systems, writing complex SQL queries, and managing ETL processes. This role requires a deep understanding of data structures, performance tuning, and collaboration across teams to support data-driven decision-making.
Key Responsibilities
- Design and implement database structures optimized for performance and scalability.
- Develop and maintain complex SQL queries, stored procedures, triggers, and functions.
- Optimize database performance through indexing, query tuning, and regular maintenance.
- Ensure data integrity, consistency, and security across multiple environments.
- Collaborate with cross-functional teams to integrate SQL databases with applications and reporting tools.
- Develop and manage ETL (Extract, Transform, Load) processes for data ingestion and transformation.
- Monitor and troubleshoot database performance issues.
- Automate routine database tasks using scripts and tools.
- Document database architecture, processes, and procedures for future reference.
- Stay updated with the latest SQL best practices and database technologies.
Required Skills
Strong proficiency in SQL and relational database concepts.Experience with performance optimization techniques (e.g., indexing, query tuning).Solid understanding of database schemas, normalization, and denormalization.Ability to retrieve, transform, and prepare data for analytics and reporting.Familiarity with ETL tools and data integration processes.Experience in scripting and automation of database tasks.Preferred Qualifications
Experience working with large and complex datasets.Exposure to cloud-based database platforms (e.g., Azure SQL, AWS RDS).Knowledge of data warehousing and BI tools.