dnapasin

• Led migration of Oracle 19c databases on Windows Servers to AWS RDS Custom for Oracle on Redhat Enterprise Linux (RHEL), reducing provisioning time by 85%, infrastructure costs by 50%, and enhancing scalability. • Architected and managed Oracle environments on AWS EC2 and RDS Custom with high availability, automated RMAN / snapshot backups and IAM-based access control. • Implemented Oracle Enterprise Manager Cloud Control 13c on AWS EC2, reducing incident response time by 40% and centralizing platform diagnostics. • Deployed Oracle RAC and Restart H.A. services on RHEL and SPARC Solaris on-prem, cutting failover time to under 60 seconds and improving H.A. consistency. • Created and maintained multitenant databases on AWS RDS Custom for Oracle, improving resource utilization by 30% and supporting tenant isolation for business-critical application environments. • Implemented Oracle Active Data Guard for DR and analytics, achieving <30s failover RTO and offloading 90% of analytic load. • Enforced end-to-end encryption using TDE and TLS, satisfying HIPAA and CJIS audit mandates. • Automated DBA operations using sql, plsql, bash scripts and Ansible workflows, saving 25+ hours/month and significantly reducing manual intervention.

• Led the successful upgrade and migration of Oracle RAC databases for the County of San Diego (CoSD) ConnectWellSD Program, enhancing system performance and reliability. • Upgraded Oracle RAC from 11.2.0.4 to 12.2.0.1 and deployed Oracle Restart on SPARC Solaris and Redhat Linux platforms, enhancing system resilience and reducing support risk. • Deployed Oracle GoldenGate 19c Microservices in RAC architecture, enabling for real-time source data extractions designed for Audit Vault Database Firewall auditing and policy monitoring requirements. • Implemented Oracle RMAN Duplicate using active database cloning strategies, reducing environment refresh times by 50% and enabling near real-time reporting. • Configured Oracle TDE, Data Masking, and VPD to secure sensitive data, achieving HIPAA and CJIS compliance with zero audit findings. • Installed and administered Oracle Enterprise Manager 13c, configuring incident rule sets and monitoring templates to standardize alerting and reduce resolution time by 50%. • Tuned performance using AWR, ADDM, ASH, and SQL Monitor, improving system throughput and reducing query execution times by up to 90%.

• Led Oracle database upgrade from 11.2.0.4 to 12.2.0.1 for CoSD Probation Case Management System (PCMS), reducing legacy support risk and aligning with modernization goals. • Deployed Oracle Restart 12c with ASM on SPARC Solaris, enabling high availability for standalone databases and improving recovery readiness. • Architected and implemented OEM Cloud Control 13c on RHEL 7, standardizing monitoring and reducing incident response time by 50%. • Automated RMAN backups, database refresh using RMAN Duplicate, Data Pump, cutting recovery and environment provisioning time by 40%. • Tuned performance using AWR, ADDM, ASH, SQL Monitoring tools, achieving up to 60% improvement in query response times and resource efficiency.

• Led Oracle RAC database builds, implemented Transparent Data Encryption (TDE) for CoSD ConnectWellSD Program, achieving HIPAA compliance and securing sensitive data across IBM Master Data Management and Oracle SOA application environments. • Designed and implemented SQL Server 2012 AlwaysOn Availability Groups for CoSD HHSA systems, ensuring 99.99% uptime and minimizing failover disruptions. • Upgraded Oracle 10.2.0.4 to 11.2.0.4 on SPARC Solaris as well as cross-platform migration from SQL Server 2008 R2 Failover Cluster Instance (FCI) to SQL Server 2012 AlwaysOn high availability architecture, consolidating infrastructure and reducing support overhead by 40%. • Managed Oracle database backup/recovery using RMAN and performance tuning utilizing AWR, ADDM, and SQL Monitoring, reducing backup times by 40% and improving query performance by up to 60%. • Developed automation scripts with PL/SQL, SQL*Loader, and bash/batch scripting, streamlining maintenance and saving 30+ hours monthly in manual effort.

• Supported Oracle RAC and standalone environments for San Diego County agencies. • Delivered backup, recovery, tuning, and 24/7 support using RMAN and performance tools.

• Led cross-platform migration from Oracle 10g to SQL Server 2008 R2 FCI, improving reliability by 40% and ensuring H.A. compliance across CoSD HHSA and Enterprise Document Processing Platform (EDPP) systems. • Installed and managed Oracle Enterprise Manager Cloud Control 12c on Solaris, reducing incident response times by 50% through centralized monitoring and diagnostics. • Automated DBA tasks using PL/SQL, SQL*Loader, and bash / batch scripting, saving 20+ hours/month and reducing manual errors. • Executed performance tuning using AWR, ASH, and SQL Monitor, boosting system performance by up to 80% and reducing query latency. • Configured Oracle 11g Active Data Guard to support SSRS reporting, offloading 95% of analytics load and enabling real-time reporting.

• Maintained 400+ Oracle databases globally across SAP, Siebel, Cognos, and Data Warehouse systems. • Designed and executed RMAN, BCV, and Flashback recovery strategies. • Developed custom shell/PLSQL scripts and authored internal documentation.