SIVARAM MALAYAPPAN

Database Operations & Infrastructure

• Administered and supported 200+ Oracle databases (11g/12c/19c) across Dev, QA, and Production environments, spanning standalone and RAC cluster configurations.
• Led migration of 50+ databases from RHEL 7 to RHEL 8 leveraging Data Guard, ensuring minimal downtime and zero data loss during switchover.
• Performed RMAN point-in-time recovery for operational and man-made data issues, coordinating closely with platform and application teams to validate recovery readiness and minimize business impact.

Data Management

• Conducted performance troubleshooting and tuning across production databases, resolving bottlenecks to ensure optimal system performance.

User & Access Management

Cross-Functional Collaboration & Governance

• Collaborated with database, network, platform, and governance teams from multiple service providers to ensure seamless project delivery.
• Maintained strict adherence to change management and governance processes for all database and infrastructure changes, achieving zero escalations on a life sciences project with stringent compliance requirements.

• Executed Oracle Database upgrades from 12c to 19c with minimal downtime, enhancing system reliability during transition; participated in upgrading Oracle Database Appliance (ODA) image from 12.1.2.10 to 12.2.1.4.
• Installed, configured, and administered Oracle Database 11g, 12c, and 19c across Linux and Windows platforms, supporting production, development, and QA environments.
• Managed and monitored Oracle RAC databases and ASM storage to ensure high availability and optimal performance in clustered environments, directly supporting critical business operations.
• Configured and administered Oracle Data Guard environments (Physical and Logical Standby) to support high availability and disaster recovery.
• Applied Oracle Patch Updates (PSU/RU) to Database and Grid Infrastructure (12c/19c) to maintain security compliance and system stability.
• Executed RMAN backup, restore, and recovery operations (full and incremental) in production environments, and performed database cloning using RMAN, user-managed, and Rubrik backups.
• Implemented database security controls including user access management, role-based privileges, and resource profiles.
• Performed SQL performance tuning using SQL Tuning Advisor, SQLT, AWR, and ASH reports, implementing targeted solutions via SQL profiles, indexes, and plan baselines to improve query efficiency.
• Deployed shell scripts for database monitoring and automation in Linux environments.
• Participated in Oracle database migration from on-premises to AWS EC2 environments.
• Configured and monitored AWS CloudWatch alarms for database and infrastructure monitoring; monitored Amazon RDS performance and prepared periodic health and performance reports.