Hasan AKSU

PrimeIT Bilişim A.Ş şirketinde Oracle Database Administrator

Istanbul, Istanbul, Türkiye

About

Experience

  • Oracle Database Administrator at PrimeIT Bilişim A.Ş
    Apr 2020 - Present · 6 yrs 3 mos

    • Database installation, configuration, and daily administration tasks on Oracle 11g, 12c, and 19c versions • Adding/removing nodes, cluster management, and failover scenarios within Oracle RAC architecture • Management of ASM disk groups, including capacity expansion and rebalancing operations • Configuration of Oracle Data Guard (physical and logical), including switchover and failover testing • Database migration on Exadata environments, HCC (Hybrid Columnar Compression) configuration, and performance monitoring • Performance analysis and bottleneck detection using AWR, ADDM, and ASH reports • SQL performance tuning using SQL Tuning Advisor and execution plan interpretation • Developing, testing, and automating backup strategies with RMAN • Backup and recovery solutions using Data Pump and Flashback technologies • Database version upgrades (DBUA/manual) and patching operations (PSU, RU) • Monitoring and alerting with tools such as OEM Cloud Control, PrimeON, Dbrunner, and Opscycle • Development of automation scripts for daily maintenance and monitoring using shell scripting • SQL/PLSQL code analysis and performance optimization in collaboration with development teams • User administration, authorization, role-based access control, and security policy management • Database cloning, export/import, and Data Pump operations • Partitioned table management and performance tuning for large-scale data sets • Experience in handling and optimizing CLOB/BLOB data types • Oracle GoldenGate installation, configuration, and bi-directional replication management • Monitoring and tuning of Extract, Pump, and Replicat processes; analysis of GoldenGate lag issues • 24/7 operational support experience with quick response to production incidents and root cause analysis