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.
#J-18808-Ljbffr