Description

You will own the development, optimization, and maintenance of complex data infrastructure.

Responsibilities

• Develop, optimize, and maintain complex SQL queries, stored procedures, triggers, and packages for Oracle and SQL Server.
• Build and optimize ETL/ELT pipelines for large-scale batch and streaming data processing.
• Perform query tuning using execution plan analysis, statistics review, and optimizer hints.
• Develop Python scripts for automation, performance testing, and data validation.
• Integrate Python applications with databases and internal systems.

Required Skills

• Strong proficiency in SQL (Oracle / SQL Server).
• Advanced experience in PL/SQL for stored procedures, triggers, and packages.
• Solid Python programming experience.
• Hands-on experience with query tuning and execution plan analysis.
• Strong understanding of database internals (indexing, caching, memory management).
• Experience in performance profiling tools (AWR, ASH, Explain Plan, Query Store).
• Familiarity with ETL/ELT pipeline optimization (batch vs. stream processing).
• Knowledge of partitioning, sharding, and parallel query execution strategies.
• 16+ years of professional experience.

Preferred Skills

• Experience with cloud platforms (AWS, Azure, GCP).
• Familiarity with containerization using Docker and Kubernetes.

Key Skills

Education

Bachelor's degree