About Me
Hello! I'm Ryan Ozora, a technical consultant specializing in database systems based in Jakarta, Indonesia and Tangerang, Indonesia. With over 5 years of experience as a Database Administrator and Data Engineer, I’ve worked with various companies and government agencies to architect robust database servers, maintain the performance of database servers, and troubleshooting problems on database servers.
My passion lies in building efficient, secure, and high-performance data systems that empower decision-makers and support business growth.
Education
2016-2020
Institut Teknologi Bandung
(Bandung Institute of Technology)
Bachelor's Degree in Industrial Engineering
Graduated with Cum Laude Distinction
GPA: 3.74 of 4.00
2021-2023
Universitas Padjadjaran
(Padjadjaran University)
Master's Degree in Business Law
Graduated with Very Satisfactory Distinction
GPA: 3.59 of 4.00
Experience
🛠️ Technical Consultant (Database SQL Server)
Mitra Integrasi Informatika (PT MII) — Jakarta, Indonesia
📅 Oct 2023 – Present
Tech Used: Microsoft SQL Server, T-SQL, SSMS, PowerShell, CloudSQL GCP, Azure SQL, Performance Monitor, Virtual Machine,
Windows Server Failover Cluster
- Architect and maintain high-performance SQL Server infrastructures across on-premise and cloud environments - Perform preventive maintenance, monitoring, and troubleshooting for production database systems - Create and optimize scripts for health checks, reporting, and automated tasks - Support database migrations, upgrades, and cloud transitions - Provide hands-on technical consulting and issue resolution for enterprise clients
🗄️ Database Administrator
Xtremax — Indonesia (Remote/Cloud-based)
📅 Jan 2022 – Sep 2023
Tech Used: Microsoft SQL Server, Power BI, Data Warehousing, Python, MySQL, PostgreSQL, Cloud Platforms (AWS, Azure, GCP), PowerShell
- Managed and deployed database services on AWS, Azure, and GCP - Built CI/CD pipelines for data operations and cloud provisioning - Developed end-to-end BI solutions, from SQL queries to Power BI dashboards - Automated routine DBA tasks using PowerShell and Python - Optimized data pipelines and supported multiple client data projects
🔍 Business Intelligence Intern (BI Engineer)
Toyota Astra Motor — Jakarta, Indonesia
📅 Jan 2020 – Aug 2020
Tech Used: Microsoft SQL Server, DAX, Power BI, Data Modeling, ETL
- Designed and implemented new Data Warehouse tables in Microsoft SQL Server - Created SQL queries for KPI calculation and performance analytics - Built ETL pipelines connected to Power BI via ODBC - Created real-time Power BI dashboards with DAX for interactive business monitoring
🧪 Data Analyst Assistant (Research Lab)
Institut Teknologi Bandung (ITB) / Bandung Institute of Technology
📅 Feb 2018 – Oct 2020
Tech Used: R, Python, SQL, C++, Excel VBA, MySQL, Academic Research
- Assisted academic research and workshops in Data Science and Analytics - Supported lab sessions in Python, R, Excel VBA, SQL - Coordinated events such as data workshops for students and professionals - Contributed to research in decision systems and data visualization
