Blutic India Pvt Ltd

We are looking for a Senior Data Engineer/Developer with over 10+ years of experience to be a key contributor to our data-driven initiatives. This role is 'primarily' focused on development, involving the design and construction of data models, writing complex SQL, developing ETL processes, and contributing to our data architecture. The 'secondary' focus involves applying your deep database knowledge to performance tuning, query optimization, and collaborating on DBA-related support activities on AWS environments (RDS, Redshift, SQL Server, Snowflake). The ideal candidate is a builder who understands how to get the most out of a database platform.Key Responsibilities Data Development & Engineering (Primary Focus):

·      Design & Development: Architect, design, and implement efficient, scalable, and sustainable data models and database schemas.

·      Advanced SQL Programming: Write sophisticated, highly-optimized SQL code for complex business logic, data retrieval, and manipulation within MySQL RDS, SQL Server, and AWS Redshift.

·      Data Pipeline & ETL Development: Collaborate with engineering teams to design, build, and maintain robust ETL processes and data pipeline integrations.

·      Automation & Scripting: Utilize Python as a primary tool for scripting, automation, data processing, and enhancing platform capabilities.

·      CI/CD Ownership: Own and enhance CI/CD pipelines for database deployments, schema migrations, and automated testing, ensuring smooth and reliable releases.

·      Solution Collaboration: Collaborate with application engineering teams to deliver scalable, secure, and performing data solutions and APIs.

Database Administration & Optimization (Secondary Focus):

·      Performance Tuning: Proactively identify and resolve performance bottlenecks, including slow-running queries, indexing strategies, and resource contention. Use tools like SQL Sentry for deep diagnostics.

·      Operational Support: Perform essential DBA activities such as supporting backup/recovery strategies, contributing to high-availability designs, and assisting with patch management plans.

·      AWS Data Management: Administer and optimize AWS RDS and Redshift instances, leveraging knowledge of DB Clusters (Read Replicas, Multi-AZ) for development and testing.

·      Monitoring & Reliability: Monitor data platform health using Amazon CloudWatch, xMatters, and other tools to ensure high availability and reliability, tackling issues as they arise.

Architecture & Mentorship:

·      Contribute to architectural decisions and infrastructure modernization efforts on AWS and Snowflake.

·      Provide technical guidance and mentorship to other developers on best practices in database design and SQL.

Required Qualifications & Experience

·      10+ years of experience in a data engineering, database development, or software development role with a heavy focus on data.

·      Expert-level SQL programming skills with extensive experience in MySQL (AWS RDS) and Microsoft SQL Server ,Redshift and snowflake

·      Strong development skills in Python for Lambda / glue development on

·      Hands-on experience designing and optimizing for AWS Redshift

·      Proven experience in performance tuning and optimization of complex queries and data models.

·      Solid understanding of ETL concepts, processes, and tools.

·      Experience with CI/CD tools (e.g., Bitbucket Pipelines, Jenkins) for automating database deployments.

·      Experience managing production data environments and troubleshooting platform issues.

·      Excellent written and verbal communication skills, with the ability to work effectively in a remote team.

Preferred Skills (Nice-to-Have)

·      Understanding of Data Governance

·      Experience with Snowflake, particularly around architecture, agents, data sharing, security, and performance.

·      Knowledge of infrastructure-as-code (IaC) tools like CloudFormation.

Work Schedule & Conditions

·      This is a 100% remote, long-term opportunity.

·      The standard work week will be Wednesday through Sunday.

·      Your designated days off will be Monday and Tuesday.

·      You must be willing to work partially overlapping hours with Eastern Standard Time (EST) to ensure collaboration with the team and support during core business hours