Description

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

This role is on-site.

Responsibilities

• Develop and optimize 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 AWR, ASH, OEM, and Query Store to identify bottlenecks.
• Execute load testing and benchmarking using Python or JMeter.
• Develop Python scripts to automate data validation and pipeline orchestration.

Required Skills

• 5+ years of professional engineering experience.
• Strong proficiency in SQL for Oracle and SQL Server.
• Advanced PL/SQL experience for stored procedures, triggers, and packages.
• Solid programming experience in Python.
• Hands-on query tuning, execution plan analysis, and optimizer hints.
• Deep understanding of database internals: 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.

Preferred Skills

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

Key Skills

Education

Any Gradute