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.