Archana MG

Supported and maintained critical databases for Scandinavian Airlines, Swissport Airlines, and Cullina, ensuring 99.999% availability and seamless operations. Performed database installation, upgrades (Oracle 11.2.0.2 to 19c), patching, migrations, schema refreshes, and performance monitoring for Oracle and MS SQL databases, including Oracle RAC and DataGuard environments. Created and implemented a comprehensive migration plan for Oracle databases, including transitioning on-premise databases to Azure Cloud, laying the foundation for modernization initiatives. Enhanced query performance through regular statistics gathering, significantly reducing query execution times and improving overall system efficiency. Acted as on-call support to meet critical SLAs, resolving database issues promptly and ensuring uninterrupted service during disaster recovery drills and server patching activities. Collaborated directly with clients to handle issue resolution, requirements gathering (Cullina), change management, and reporting, earning client appreciation for consistent excellence. Coordinated with cross-functional teams, including development, access management, and server infrastructure teams, to execute complex deployments and troubleshoot database errors effectively. Conducted training and knowledge-sharing sessions for junior colleagues, fostering a culture of learning and collaboration. Proactively monitored database performance using SolarWinds alerts, ensuring servers operated at peak efficiency and resolving performance bottlenecks. Earned recognition from client development and management teams for exceeding expectations in SLA compliance, performance improvements, troubleshooting, and innovative suggestions.

Supported ETL processes and analytics workloads for NetApp and H-E-B, ensuring seamless database operations and high availability. Optimized query performance for OLAP workloads, reducing query execution time from 30 minutes to 10 minutes, enhancing efficiency and meeting data load SLAs. Configured Oracle GoldenGate for real-time data replication from multiple source systems to OLAP environments, managing extract, pump, and replicate processes while troubleshooting lag, data conflicts, and process failures. Performed database refreshes and schema updates using NetApp filers and snapshots, enabling quick reporting database clones and efficient resource utilization. Monitored and tuned database performance using TOAD, AWR reports, and Unix commands, identifying bottlenecks and improving resource contention. Configured alerts for long-running queries, resource-intensive jobs, and GoldenGate processes, ensuring proactive issue resolution. Ensured SOX compliance by implementing role-based access control (RBAC) for GoldenGate users and capturing DML changes in Oracle audit logs. Collaborated with client database teams, server teams, and CyberArk teams to ensure smooth operations and address complex database requirements. Earned recognition from clients and management for consistently meeting SLAs, reducing downtime, and optimizing query performance.

Installed and configured Oracle Database 11g on IBM AIX, ensuring optimal performance and seamless operations. Performed RMAN backups and database cloning to support business continuity using RMAN backup and recovery methods. Migrated tables from Oracle to MySQL databases after creating and configuring MySQL environments to support cross-platform data operations. Installed and configured Oracle Application Express (APEX) 5.1 on AIX, streamlining application development and database integration. Developed shell scripts for automating database instance shutdown alerts and creating database users, enhancing operational efficiency. Managed database users, tablespaces, datafiles, database links, and tables to ensure data integrity and availability. Handled import/export operations for schemas, tables, and full databases using Oracle Data Pump, supporting smooth data migrations. Installed and configured Oracle Database Client 11gR2 on AIX systems, enabling application compatibility and user access. Troubleshot and resolved database-related errors reported by internal teams, leveraging a strong foundation in RDBMS principles to maintain system reliability.