Oracle Database Administrator
Current● Supported team for Oracle Financial production database from 12c to 19c, ensuring seamless transition to the latest version.● Efficiently migrated production Financial database to ODA 11x, boosting performance by nearly 20% and reducing size by 4TB.● Spearheaded migration of internal Production Reporting and Archival DBs from VMs to ODA, consolidating onto high-performance engineered systems.● Developed APEX-based internal application for SiteOps monitoring of orders, Hybris jobs, and EBS concurrency from production databases, enabling real-time visibility into critical business processes.● Managed deployment of database changes during SAP hybris new app/web releases.● Executed backups and restores to ensure database availability and recoverability, swiftly restoring data as per business needs.● Conducted database refreshes from production to development/test environments using duplication and gold copies.● Provided support to PL/SQL developers to optimize code efficiency and performance, facilitating code deployments and user account management for new joiners.● Supported Oracle Functional team during month-end closing of Financials, Payables, Receivables, and General Ledger, ensuring timely and accurate financial reporting.● Applied upgrade patch, maintenance and interim (opatch) patches on the databases.● Leveraged Oracle Enterprise Manager for monitoring, alerts, and database administration. Set up rules and groups for robust operations management and line of business.● Managed database administration, production support, installations, configurations, migrations, tuning, and incident management.● Designed and implemented functions for DBMS policies and data redaction into PROD DBs for data security enhancements.
