Kusnandar
Rohim

Oracle DBA IT Consultant for TV & Radio Broadcasting clients across Indonesia and Asia. Managing Oracle 11g, 12c, and 19c databases for production, non-production, and disaster recovery environments. Providing Oracle Database training to clients in Asia.

Providing IT solutions for clients, building relationships with partners and clients, preparing quotation and proposal documents, monitoring Sales Stage Cycling for IT projects, and coordinating with internal divisions for new projects.

Preparing Technical Documentation, DFD, BRD, Functional Specification Documents, UML (Use Case & Sequence Diagrams), UAT Specifications, and Sprint Planning. Handling microservices architecture & network topology for PPOB and Channel Banking systems.

Gathering data, analysis, mockup, ERD and database deployment for HR Portal, Employee Portal, and KPI across all divisions. Designing business processes and SME system flow for Fintech. Managing teams of System Analysts, UI/UX, IT QA, Development, and Operations.

Migration of HRIS system for over 2,000 employees using Laravel 8 & MySQL. Migration of Garment ERP using Laravel 9 & PostgreSQL. Developing data integration via API to external systems and mentoring the IT development team.

Leading Data Center production team 7x24 hours (Helpdesk, Technical Support, Network, DCO, DBA, Application Support). Implementing DRC for database & application replication with 99.8% SLA. Ensuring 20 million transactions/month ran stably for 6+ years.

Preparing ISO 27001, implementing IT Assessment & Governance Policy, developing BCP Planning, managing monthly Capacity Planning, and preparing daily, weekly, and monthly Data Center reports for BOD and BOM.

Data center maintenance, backup & recovery strategy implementation, Storage Area Network maintenance, system monitoring tools development using PHP, J2SE & Bash Script, and integration of all Data Center systems.

Joined as IT staff for system integration and database administration. Building the technical foundation that became the basis for career development over the next 12+ years at the same company.

Maintenance, operational, and development of Data Center used for Switching and Transaction Data Center. Supporting enterprise-scale system implementation for major clients in the national energy sector.

Performance tuning of Oracle 10g OLTP database to handle high transactions (target 300 TPS). Ensuring the database server could sustain high transaction loads without restart, supporting hundreds of simultaneous connections with a minimum open cursor of 3x the number of active connections.

Leading Data Warehouse & BI Reporting development using Oracle 10g, OLAP, and OWB 10g with a data volume of 237 million population records, producing 66 aggregate reports and 10 individual national-scale data reports.

Managing MSSQL Server 2000/2005 and Oracle 9i databases in production, non-production, and disaster recovery environments. Performing monitoring, backup & recovery, performance tuning, and supporting ERP applications for mining operations.

Handling projects in the Enterprise and Government Divisions, including projects for regional government agencies (Batam, West Java, Central Kalimantan), national corporates in the energy sector, and information system projects for national law enforcement agencies.