Home

Satheesh Yaddlapalli - Oracle DBA & Cloud Database Architect

ysatheesh06@gmail.com

Location: Irving, Texas, USA

Relocation: Yes

Visa: H1B

Resume file: Satheesh_Yaddlapalli DBA_1785347702952.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Satheesh Yaddlapalli Oracle DBA & Cloud Database Architect | AWS Solutions Architect Professional Database Administrator (10g,11g,12C,18C, 19C, AWS, POSTGRES, ORACLE CLOUD, EXADATA, RAC, ASM, ORACLE GOLDENGATE, DATAGUARD, SQLSERVER, Oracle@AWS) PROFESSIONAL SUMMARY Results-driven Oracle Database Architect and Cloud Consultant with 18+ years of enterprise experience across healthcare, financial services, telecommunications, energy, and retail. Dual AWS Certified Solutions Architect (Professional & Associate) with deep hands-on expertise in AWS RDS, Aurora, DMS, and cloud-native database architecture. Proven track record engineering zero-downtime migrations from on-premises Oracle to AWS, OCI, and Azure managing production environments at 60+ TB scale under 24 7 availability commitments. Recognized for translating complex infrastructure challenges into measurable outcomes: 32% cloud cost reductions, 40 45% query performance improvements, and sub-2-hour migration cutover windows. Trusted technical lead for clients including T-Mobile, AmeriHealth, FedEx, British Gas, and Centrica. CORE COMPETENCIES AWS Solutions Architecture Oracle Exadata (X4 X9M), Oracle@AWS RAC / ASM / Grid Infrastructure AWS RDS / Aurora / DMS / SCT Data Guard & Goldengate Oracle Cloud Infrastructure (OCI) Zero-Downtime Cloud Migration Azure Database Administration RMAN / Backup & DR Architecture FinOps & Cloud Cost Optimization Performance Tuning (AWR/ADDM) Terraform / Jenkins / Kubernetes PL/SQL Optimization Database Security & Compliance Team Leadership & Mentoring TECHNICAL SKILLS Category Technologies & Tools Cloud Platforms AWS RDS Aurora EC2 S3 DMS SCT Lambda CloudWatch IAM VPC Secrets Manager Route 53 ELB Oracle Cloud (OCI) Microsoft Azure Oracle Database Oracle 8i 19c Exadata X4 X8M, X9M RAC ASM Data Guard (Physical/Logical Standby) GoldenGate RMAN OEM 12c/13c EBS R12 Cloud Databases AWS RDS for Oracle RDS for PostgreSQL Aurora PostgreSQL RDS Multi-AZ Read Replicas RDS Proxy Parameter Groups Option Groups Other Databases PostgreSQL 12 16 Aurora PostgreSQL MySQL SQL Server DB2 Migration Tools Oracle GoldenGate AWS DMS AWS SCT Ora-to-PG DataPump (expdp/impdp) SQL*Loader RMAN Cross-Platform DevOps / IaC Terraform Jenkins Kubernetes Python Bash/Shell Scripting Git CI/CD Pipelines Monitoring / Tuning AWS CloudWatch RDS Performance Insights AWR ADDM ASH TKPROF EXPLAIN PLAN OEM Grid Control STATSPACK OS / Platforms RHEL/CentOS Linux Sun Solaris 8 10 HP-UX 10/11 IBM AIX 5.x Windows Server 2012 2019 Tools & Ticketing SQL Developer TOAD pgAdmin Putty JIRA ServiceNow Remedy Rubrik PROFESSIONAL EXPERIENCE UST-Global December 2024 Present Senior AWS & Oracle Database Architect | Client: T-Mobile AWS Architecture & Cloud Engineering Designed multi-tier, highly available cloud database architectures applying the AWS Well-Architected Framework (Operational Excellence, Security, Reliability, Performance Efficiency, Cost Optimization) for enterprise clients across healthcare and logistics. Engineered multi-AZ VPC architectures with public/private subnet segmentation, NAT Gateways, Transit Gateways, and VPC Peering; implemented AWS PrivateLink for secure on-premises RDS access via Direct Connect and VPN tunnels. Architected IAM role hierarchies, resource-based policies, and SCPs enforcing least-privilege across 50+ roles covering RDS, Secrets Manager, KMS, and S3 achieving zero privilege escalation incidents. Designed cross-region DR using RDS Cross-Region Read Replicas and Aurora Global Database, achieving RPO < 1 second and RTO < 1 minute for business-critical workloads. Implemented Reserved Instance purchasing, Savings Plans, S3 Intelligent-Tiering for RMAN backups, and automated lifecycle policies reducing total cloud database spend by 32%. RDS & Database Engineering Provisioned and managed AWS RDS for Oracle (SE2/EE) in Multi-AZ and single-AZ configurations; configured Parameter Groups, Option Groups, and Custom DB Parameter Groups to mirror on-premises initialization parameters, ensuring application compatibility post-migration. Deployed RDS Proxy for Lambda-backed microservices at T-Mobile, eliminating connection pool exhaustion and reducing database connection overhead by 40% during peak traffic periods. Integrated AWS Secrets Manager for automated 30-day credential rotation across RDS Oracle and PostgreSQL instances, eliminating hardcoded passwords across 12 application services. Architected Aurora PostgreSQL clusters with writer/reader endpoints and Auto Scaling for read replicas, absorbing 3 traffic spikes without manual intervention for a multi-tenant SaaS application at FedEx. Managed RDS engine upgrades (Oracle 12.2 19c, PostgreSQL 13 16) via blue-green deployment patterns and pre-upgrade snapshot clone testing, achieving zero application downtime. Right-sized 8 over-provisioned RDS instances and implemented Reserved Instances for predictable workloads, achieving 32% reduction in monthly RDS spend. Configured RDS Performance Insights and CloudWatch dashboards with custom alarms; automated SNS alerting for threshold breaches, reducing MTTR by 35%. Cloud Migration & Database Modernization Engineered zero-downtime migrations of 10+ TB Oracle databases to AWS RDS using GoldenGate CDC replication and AWS DMS for initial loads; cutover windows held under 2 hours with pre- and post-migration data consistency validation. Led Oracle 12c Aurora PostgreSQL migration for AmeriHealth using AWS SCT; resolved 200+ incompatible PL/SQL objects, executed checksum reconciliation, and delivered 2 weeks ahead of schedule. Executed RDS Oracle Aurora PostgreSQL migration converting Oracle-specific features to PostgreSQL equivalents, reducing licensing spend by 35% while maintaining query response SLAs under 5 ms. Conducted SCT assessment reports for 5 Oracle databases; remediated high-complexity items including Oracle packages and CONNECT BY queries refactored to PostgreSQL recursive CTEs. Executed Oracle OCI migration using RMAN backup/restore with OCI Object Storage staging; configured OCI DB System with RAC and validated connectivity via FastConnect. Exadata & On-Premises Oracle Administration Administered Oracle Exadata X4 X8 Database Machines; implemented Smart Scan, Storage Indexes, Hybrid Columnar Compression, and IORM resource management, reducing analytical query response times by 40%. Planned and executed quarterly Exadata Bundle Patches across compute nodes, storage cells, InfiniBand/ROCE switches, and PDUs; reduced patch cycle duration by 50% through automated pre-check scripts and rolling parallel execution. Configured OEM 13c Fleet Management for centralized RDBMS patching governance across 6 Exadata clusters; built compliance rules enforcing security patch SLAs within 30 days of release. Architected RMAN incremental-merge backup strategies and Data Guard physical standby configurations across geographically separated sites; validated failover achieving RPO < 15 minutes and RTO < 1 hour. Performance Engineering & Automation Optimized high-volume PL/SQL packages using BULK COLLECT/FORALL, partition pruning, and SQL Profile pinning; reduced nightly batch runtimes by 30% and eliminated 5 recurring Sev2 incidents per month. Developed Python and shell scripts for RDS snapshot lifecycle management, CloudWatch metric export, GoldenGate lag monitoring, and RMAN validation reporting saving 20+ DBA hours per week. Authored Terraform modules for repeatable AWS RDS and Azure VM provisioning, covering instance creation, parameter groups, subnet groups, security groups, KMS key association, and CloudWatch alarms. Cognitive Data Intelligence LLC April 2023 December 2024 Senior Cloud & Database Consultant | Client: AmeriHealth, FedEx Managed installation, configuration, and administration of Oracle Exadata X4 X8 environments for enterprise clients, implementing best practices for performance optimization, high availability, and disaster recovery. Designed and implemented backup and recovery strategies using Oracle RMAN and Data Guard; delivered RPO/RTO targets meeting client SLAs across production and DR environments. Led Exadata patching and upgrade programs (compute nodes, storage cells, InfiniBand/ROCE switches, PDUs), ensuring minimal downtime and regulatory compliance. Coordinated Oracle ACS handover for new Exadata clusters; performed hardening, customization, and third-party software integration in collaboration with cross-functional teams. Conducted performance tuning including SQL optimization, database parameter tuning, and Exadata-specific optimizations, delivering significant throughput improvements. Executed Oracle to AWS RDS migration using DMS and SCT; led heterogeneous Oracle RDS to Aurora PostgreSQL migration for British Gas (United Kingdom). Provisioned Azure VMs for Oracle databases including networking, OS configuration, and database installation; evaluated Azure as an alternative cloud platform for Oracle workloads. Performed capacity planning and performance analysis to ensure Exadata systems met current and future business demands. Cognizant Technology Solutions October 2016 February 2023 Senior Associate Oracle DBA | Client: Centrica PLC, British Gas Online (UK) Designed and maintained a multi-tier Oracle estate (11g 19c) spanning production, UAT, staging, development, and DR environments; supported 30+ databases under 24 7 on-call coverage with 99.95% availability. Led Oracle to AWS RDS and Oracle to PostgreSQL migration programs using GoldenGate, DMS, and Ora-to-PG; delivered 15+ migrations over 6 years with zero data loss. Architected Oracle RAC clusters and ASM disk groups for new production environments; implemented Active Data Guard read offload, reducing unplanned outages by 60%. Implemented bi-directional GoldenGate replication between on-premises Oracle and cloud RDS, maintaining replication lag under 2 seconds across 15 TB of active data. Resolved Sev1 performance incidents on a 60+ TB OLAP system using AWR, ASH, ADDM, and SQL Plan Baselines; reduced average query execution time by 45% for month-end financial reporting. Configured DMS Full Load and CDC pipelines with SCT for Oracle PostgreSQL migration of the British Gas billing platform, including LOB handling and post-migration reconciliation validation. Administered Oracle EBS R12 across production and non-production; automated environment refresh via RMAN and shell scripts, cutting refresh cycle time from 8 hours to 2 hours. Built shell, SQL, and RMAN automation scripts for backup monitoring, alert log parsing, and tablespace management, eliminating 15 hours of manual DBA effort per week. Hewlett Packard Enterprise (HPE) January 2013 October 2016 Infrastructure Oracle DBA Lead | Client: Mondelez International, Luxottica Led Oracle 11g RAC administration for two multinational clients across Unix infrastructure, managing 15+ production databases with 99.9% uptime SLA. Installed and managed GoldenGate replication across geographically separated data centers, maintaining sub-second replication lag for business-critical reporting workloads. Performed Voting Disk, OCR, SPFILE, and ASM disk group migrations with zero data loss in live production environments; designed centralized RMAN Recovery Catalog with RTO < 4 hours and RPO < 15 minutes. Resolved performance regressions using Statspack, AWR, ASH, ADDM, and TKPROF; implemented SQL Plan Baselines to stabilize execution plans across production databases. Implemented Oracle Fine-Grained Auditing, user lockout policies, and password complexity profiles; maintained SOX compliance for both client environments. Delivered 8 Solaris-to-Linux platform migrations with zero incidents. Sistema Shyam Teleservices Ltd December 2009 January 2013 Data Center Lead Oracle DBA | Client: MTS (Mobile TeleSystems) Administered Oracle 11g RAC and GoldenGate replication supporting 20M+ subscriber transaction records; maintained 99.9% uptime for revenue-critical billing and provisioning systems. Managed multi-node RAC cluster health, ASM disk groups, OCR/Voting Disk maintenance, and cluster interconnect monitoring; performed rolling patches without service interruption. Maintained centralized RMAN Recovery Catalog for 10+ databases; tested and documented DR failover quarterly within agreed RTO windows. Executed Oracle CPU/PSU patches following ITIL processes; maintained runbooks and post-implementation review documentation. PIC Technology Solutions Pvt. Ltd. June 2007 October 2009 Systems Engineer Oracle DBA Supported Oracle 9i and 10g environments across development and production; performed health checks, alert log monitoring, backup/restore operations, and space management. Provided L1/L2 DBA support with structured root cause analysis documentation; reduced mean escalation time by 30%. CERTIFICATIONS & AWARDS Certification / Award Issuing Body Issued Status AWS Certified Solutions Architect Professional Amazon Web Services Apr 2026 Active (exp. Apr 2029) AWS Certified Solutions Architect Associate Amazon Web Services Apr 2026 Active (exp. Apr 2029) Oracle Database 19c OCP Oracle 2021 Active Oracle Database 11g OCA Oracle 2012 Active Oracle Cloud Infrastructure Foundations Associate Oracle 2023 Active Microsoft Azure Fundamentals (AZ-900) Microsoft 2022 Active ITIL V3 Foundation AXELOS / PeopleCert 2018 Active Eminence & Excellence (E&E) Recognition Award Cognizant 2020 EDUCATION Bachelor of Technology Computer Science Engineering Jawaharlal Nehru Technological University (JNTUH), India | 2006 Keywords: continuous integration continuous deployment user experience business intelligence sthree database hewlett packard microsoft mississippi procedural language Arizona