Anandkumar N S

About Anandkumar N S

As an experienced Database Administrator, I specialize in managing Oracle and PostgreSQL environments. I have strong expertise in applying patches using dbascli and opatchauto for Oracle Grid Infrastructure and Database homes, ensuring minimal downtime while maintaining up-to-date systems. My experience with Oracle Real Application Clusters (RAC) ensures high availability and scalability for critical systems. Additionally, I manage Oracle Data Guard, performing switchover and failover operations for disaster recovery and business continuity.I manage Oracle Exadata Database Services through the Oracle Cloud Console, handling resource scaling, such as memory, CPU, and storage upgrades. I ensure Exadata environments are optimized, patched, and aligned with performance standards, delivering high availability and performance.In addition to Oracle technologies, I provide support for PostgreSQL environments, managing database clusters, performance tuning, and high availability solutions using Enterprise Failover Manager (EFM). This expertise enables me to ensure resilience and uptime across both Oracle and PostgreSQL platforms.I excel in performance tuning, using AWR and ADDM reports to diagnose system bottlenecks and applying SQL Tuning Advisor recommendations to enhance query performance. I also design and implement backup and recovery solutions with RMAN, integrated with Dell EMC DD Boost and Oracle Zero Data Loss Recovery Appliance (ZLRA), ensuring data protection and fast recovery.I manage large-scale database migrations and data transfers using Oracle Data Pump utilities (expdp/impdp), ensuring smooth export and import operations. I also leverage Oracle Enterprise Manager (OEM) for monitoring, performance management, and issue resolution, ensuring database health and optimization.With expertise in both Oracle and PostgreSQL, I am committed to providing high-performance, highly available, and secure database environments. My proactive approach ensures systems remain stable, scalable, and aligned with business goals.

Experience

1. System Engineer

   Tata Consultancy Services

   Nov 2024 — Present · Bengaluru, IN

   Managing Exadata Database Service via the console, performing resource scaling operations such as memory, CPU, and storage uplift• Performing Oracle Exadata Cloud database patching using dbascli commands and Patching using opatch auto.• Analyzing AWR, ADDM reports, and using SQL Tuning Advisor for database performance tuning.• Executing Data Guard switchover and failover operations.• Managing OEM (Oracle Enterprise Manager) monitoring, administration, target, and agent management.• Handling backup and recovery operations with DDBoost solutions for RMAN.• Performing database export and import using Data Pump utility (expdp/impdp).• Providing support for EDB PostgreSQL, including-> Starting and stopping database clusters-> Modifying database parameters-> Managing EFM (Enterprise Failover Manager) high availability solutions.

Education

• PES College of Engineering, Mandya

  BE - Bachelor of Engineering

  2016 — 2020