Lahiru Sathsara

I’m an aspiring Data Engineer with hands-on Oracle database administration experience, now applying it to real-time data pipelines and ETL orchestration. I build scalable workflows using Apache Kafka, Apache Spark, PostgreSQL, and Cassandra, grounded in strong SQL performance tuning.

In production DBA work, I focused on reliability and operational rigor—monitoring and maintaining high availability (99.9% uptime), automating RMAN backup/restore, and using Linux shell scripting to reduce manual intervention. I also analyzed system logs and operational datasets with SQL to pinpoint performance bottlenecks, anomalies, and trends.

I’m comfortable orchestrating end-to-end data flows and designing data architecture that matches workload needs. In my F1 real-time pipeline, I implemented Kafka-based ingestion from the OpenF1 API, built a polyglot persistence setup (PostgreSQL + Cassandra), containerized services with Docker Compose, and started a Spark Structured Streaming layer for real-time race analytics.

I also like turning data into decisions through analytics and visualization. From Airflow-orchestrated weather ETL with quality checks to dashboarding with Streamlit, Power BI, Tableau, and Apache Superset, I prioritize data accuracy, efficient reporting, and operational reliability throughout delivery.