SQL Developer

We are seeking a skilled SQL Developer / Database Engineer to join our team. In this role, you will be responsible for designing, implementing, and optimizing complex SQL queries and database solutions. This position requires a highly analytical and detail-oriented person with deep knowledge of SQL and database management principles. Experience with Amazon Redshift is a plus, as we aim to continue enhancing our data infrastructure in cloud environments.

Key Responsibilities:

• SQL Development and Optimization: Develop, test, and optimize complex SQL queries and stored procedures for data retrieval and processing.
• Database Design and Management: Work closely with application developers and data analysts to design, structure, and optimize databases for efficiency and performance.
• Data Integration and ETL Processes: Collaborate in the development of data integration solutions, ensuring smooth ETL (Extract, Transform, Load) processes between various systems and databases.
• Database Performance Tuning: Proactively identify performance bottlenecks and apply indexing, partitioning, and query optimization techniques to improve database performance.
• Data Security and Integrity: Ensure high levels of data security, integrity, and availability in database design and implementation.

Required Skills and Qualifications:

• Expertise in SQL: Proven experience in SQL development, with advanced proficiency in writing, debugging, and optimizing SQL queries.
• Database Experience: 5+ years of experience working with relational databases such as PostgreSQL, MySQL, or Oracle.
• Strong Understanding of Database Design: Experience in database design, indexing, partitioning, and normalization.
• ETL and Data Transformation: Hands-on experience with ETL processes and data transformation techniques.
• Performance Tuning: Skilled in database performance tuning and query optimization.
• Data Security Practices: Knowledge of data security principles, including roles, permissions, and encryption.

Nice-to-Have Qualifications:

• Amazon Redshift Knowledge: Experience with or understanding of Amazon Redshift architecture, data warehousing, and performance optimization techniques.