Description

You own the development, optimization, and maintenance of complex SQL 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 detailed performance profiling using tools like AWR, ASH, OEM, and Query Store to identify bottlenecks.
• Execute load testing and benchmarking using Python, JMeter, or similar tools.
• Develop Python scripts to automate data validation, performance testing, and pipeline orchestration.

Required Skills

• 5+ years of professional experience in a relevant engineering role.
• Strong proficiency in SQL for Oracle and SQL Server.
• Advanced experience writing PL/SQL for stored procedures, triggers, and packages.
• Solid programming experience in Python.
• Hands-on experience with query tuning, execution plan analysis, and optimizer hints.
• Strong understanding of database internals, including indexing, caching, buffer pools, and memory management.
• Experience with performance profiling tools (AWR, ASH, OEM, EXPLAIN PLAN, Query Store).
• Familiarity with ETL/ELT pipeline optimization for batch and stream processing.
• Knowledge of partitioning, sharding, and parallel query execution strategies.

Preferred Skills

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

Key Skills

Education

Any Gradute