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.