Skip to content
View Rikajo90's full-sized avatar

Block or report Rikajo90

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Rikajo90/README.md

Hi, I'm Rika Afriyani 👋

🗄️ Junior Database Administrator | SQL Server Specialist
📍 Bekasi, Indonesia | 🌏 Open to Remote Opportunities

🧰 Tech Stack

Database SQL Server T-SQL PostgreSQL

Tools SSMS SSIS DBeaver Grafana

Infrastructure Windows Server VMware Always On AG

💼 What I Do

  • 🔁 High Availability — Managing 3-node Always On Availability Groups (AAG), failover monitoring, and replica synchronization
  • ⚙️ ETL & Integration — Deploying and troubleshooting SSIS packages for SAP S/4HANA integration
  • 🛡️ Database Security — Credential rotation, login management, and role-based access control across 20+ databases
  • 📊 Monitoring & Reporting — Daily health checks, backup validation, SQL Agent job monitoring
  • 🔧 Environment Management — DEV → STG → PRD deployment, database migration scripting
  • 💾 Backup & Recovery — Automated backup strategies, NFS/NAS storage management, retention policies

📁 Featured Projects

Repository Description
🤖 Database-Automation-Scripts Production-ready SQL Server scripts for backup, monitoring & maintenance
🔍 SQL-Query-Optimization Real-world query optimization case studies with before/after metrics
🗂️ Database-Schema-Designs Schema designs for E-commerce, Healthcare & Inventory domains

📈 GitHub Stats

Rika's GitHub Stats

📫 Let's Connect

LinkedIn Email GitHub

💡 Currently expanding skills in SQL Server AAG administration and seeking remote DBA opportunities.

Pinned Loading

  1. Database-Schema-Designs Database-Schema-Designs Public

    Collection of database schema designs for various business domains - E-commerce, Healthcare, Inventory Management

  2. SQL-Query-Optimization SQL-Query-Optimization Public

    Real-world SQL query optimization case studies with before/after performance metrics and best practices

  3. Database-Automation-Scripts Database-Automation-Scripts Public

    Collection of SQL Server automation scripts for backup, monitoring, and maintenance tasks

    TSQL

  4. SQL-Server-AAG-Playbook SQL-Server-AAG-Playbook Public

    Practical guide for SQL Server Always On Availability Groups - setup, monitoring, troubleshooting, and maintenance