Role Overview
We are seeking a **Senior SQL Developer \& ETL Engineer** with 5\+ years of experience for a 100% remote opportunity.
Please Note: This is not a pure data engineer role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high\-performance database logic with Python, ETL, Cloud.
If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.
Key Responsibilities1\. Database Architecture \& Schema Design
- Design, implement, and maintain robust relational database schemas.
- Architect optimal data models for both operational (**OLTP**) and analytical (**OLAP/Data Warehousing**) workloads.
- Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.
2\. Advanced Database Programmability
- Write, debug, and optimize highly complex **Stored Procedures, Functions, Triggers, and Views** to handle core business logic at the database level.
- Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.
3\. Performance Tuning \& Indexing
- Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B\-Tree, Clustered/Non\-Clustered, Partitioning).
- Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub\-second response times.
4\. Python \& Cloud ETL/ELT Pipelines
- Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
- Leverage **Cloud Data Platforms** alongside modern Python libraries to build efficient data movement workflows.
5\. Data Integrity \& Governance
- Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.
Required Technical Skills
- **Expert\-Level SQL \& DB Programmability (5\+ Years):** Mastery of writing server\-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like **PostgreSQL, SQL Server, Oracle, or MySQL**.
- **Advanced Database Optimization:** Deep, under\-the\-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
- **Python for Data Engineering (3\+ Years):** Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
- **Cloud Data Experience:** Hands\-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (**Snowflake, BigQuery, or Redshift**).
- **Data Modeling Methodologies:** Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.
Remote \& Soft Skills
- **Legacy Refactoring Mindset:** You genuinely enjoy opening up a massive, poorly optimized 500\-line legacy stored procedure and refactoring it for maximum efficiency.
- **Autonomous Execution:** Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
- **Asynchronous Communication:** Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
Nice\-to\-Haves
- Experience migrating legacy on\-premise infrastructure and stored procedures to modern cloud data warehouses.
- Familiarity with workflow orchestration tools like **Apache Airflow** or **Prefect**.
- Hands\-on experience with **dbt (data build tool)** for in\-warehouse transformations.
Pay: ₹296,003\.91 \- ₹1,377,609\.90 per year
Work Location: Remote