Raihan Afsar

About Raihan Afsar

Oracle Certified Database Administrator (OCA & OCP) with over 6+ years of experience, currently as Oracle APPS DBA & Oracle DBA with an IT organization of high repute, preferably in GULF/India / USA / Europe The wealth of expertise includes Oracle 10g11g,12c,19c and Oracle E-Business Suite: 11i (11.5.10.2) & R12 (12.1.3, 12.2.4) Database Administration, providing on-going support to the largest Database environment in infrastructure services. Hands on experience in Oracle 10g,11g,12c,19c Database Administration, Provided 24x7 Remote/on-call production supports Excellence hands on experience in database installation, Manual Database creation,Database and Application Cloning and patching(adop and adpatch) Created Development and Cloned instance of Test and Dev databases. As Oracle Apps DBA, giving support for various products of different Applications versions 11.5.10.2, R12.1.3, R12.2.4. ASM configuration and add disk group. Creating users and Add responsibilities to the users. Managing user’s information like creation of users and managing their roles, profiles and privileges. Creation and maintenance of database, space management and configuring database listeners Database health checkups and monitoring alert logs. Purging the old trace / log files and temp files. Hands-on in implementing backup and recovery strategies using Hot/Cold backup, RMAN, Logical (Import/Export). Configured Oracle VM servers for different instance like DEV, TEST, UAT serverListener configuration, configuring net service name, Instance configuration and management.Performing various starting and shutdown activities Had done various projects using RMAN for Backup and recovery, planned & scheduled physical (hot/cold) & logical backup. Hands on experience in Export/Import and Data pump. Experience in Scheduling Scripts using crontab Excellence hands on experience in User Management and Space Management. Experience in management tools like Oracle Enterprise Manager, TOAD and SQL DeveloperASM configuration and add disk group. Knowledge in Data Guard, managing Physical & Logical Standby Databases, Manual Switchover & Failover activityKnowledge in RAC Cluster ware, IP’s, CRVCTL & SRVCTL tools, Start-up process of RAC Cluster Ware.

Experience

1. Custom Software Engineering Senior Analyst

   Accenture

   Sep 2024 — Present · Kolkata, IN

   Oracle Core DBA | Database Administration | Performance Tuning | High AvailabilityExperienced Oracle Database Administrator with over 5 years of expertise in managing mission-critical Oracle environments. Skilled in installation, configuration, and administration of Oracle databases across RAC and standalone setups. Proven ability to ensure high availability, security, and optimal performance for enterprise systems.Core Competencies:Oracle Database Installation & Upgrades (11g, 12c, 19c)RAC & ASM Configuration and ManagementBackup & Recovery using RMANPerformance Tuning (SQL, Instance, and Storage)Patch Management and PSU/CPU ApplicationData Guard Setup and Disaster Recovery PlanningUser Management and Security HardeningTroubleshooting and Root Cause AnalysisDay-to-Day Activities:Monitor database health and performance using OEM and custom scripts.Perform proactive capacity planning and space management.Apply patches and perform version upgrades to maintain compliance.Manage backups and validate recovery strategies using RMAN.Configure and maintain Oracle RAC and ASM for high availability.Implement and monitor Data Guard for disaster recovery.Collaborate with application teams for query optimization and schema changes.Ensure database security through user management and auditing.Respond to incidents and resolve critical issues within SLA.

Education

• Aliah University, Kolkata

  Bachelor of Technology, Computer Science

  2014 — 2018