DASTHAGIRI BAKSH

As a Database Advisor at FedEx, I provide technical leadership in designing, implementing, and managing high-performance Oracle Database solutions in cloud and on-premises environments. My focus is on streamlining operations, ensuring high availability, optimizing performance, and improving disaster recovery capabilities while integrating DevOps practices to enhance operational efficiency.

• Database Administration & Support: Administered and optimized Oracle Exadata and RAC environments, ensuring high availability and disaster recovery.Led daily operations, including performance tuning, patching, and security management across production and non-production environments.
• Cloud Integration: Played a key role in integrating Oracle databases with Oracle Cloud Infrastructure (OCI)and AWS RDS/EC2 for scalability and improved resource management. Led cloud migration projects to move on-premises databases to the cloud with minimal downtime, enhancing business continuity and reducing operational costs.
• DevOps Automation: Implemented DevOps practices such as CI/CD pipelines for automating database updates and patching procedures using Jenkins, Terraform, and Ansible. Automated backup and recovery routines, which resulted in reducing manual interventions by 40%.
• Performance Optimization & Monitoring: Utilized Oracle Enterprise Manager (OEM), AWR, ASH, ADDM, and SQL Tuning Advisor to monitor and fine-tune database performance. Reduced query response times by optimizing indexing and partitioning strategies, improving overall system performance by 30%.
• Disaster Recovery & High Availability: Led the design and implementation of high availability solutions using Oracle Data Guard and GoldenGate for real-time data replication and failover, reducing RTO and RPO to meet business-critical SLAs. Conducted frequent disaster recovery testing to ensure seamless failover during critical outages
• Capacity Planning: Spearheaded capacity planning initiatives, utilizing data growth trends and resource utilization metrics to forecast future database requirements. Proactively managed storage, memory, and compute resources to optimize cost-efficiency
• Database Security: Implemented and maintained Oracle Transparent Data Encryption (TDE) and Advanced Security options to ensure data security and regulatory compliance across all production systems.
• Team Leadership & Mentoring: Provided leadership and mentoring to a team of Oracle DBAs and DevOps engineers. Facilitated knowledge-sharing sessions on best practices in database performance tuning, cloud adoption, and disaster recovery strategies
• Incident & Problem Management: Acted as the escalation point for critical database issues, diagnosing and resolving complex performance and availability challenges. Reduced mean time to resolution (MTTR) by 20% through effective troubleshooting, proactive monitoring, and collaboration with cross-functional teams
• Database Downtime Reduction: Reduced database downtime by 35% through improved backup strategies and automating recovery processes with RMAN and Flashback technology.
• Cloud Migration Success: Led the migration of critical Oracle databases from on-premises to Oracle Cloud Infrastructure (OCI), resulting in 30% cost savings on infrastructure and improved scalability for FedEx's global operations
• CI/CD Automation: Automated CI/CD pipelines for database updates and patches, reducing manual intervention by 40% and improving deployment speed, reliability, and consistency.
• Enhanced Performance: Improved query performance by 30% through index optimization, partitioning strategies, and SQL tuning.This resulted in a more responsive database environment and enhanced end-user experience.

KEY ACHIEVEMENTS:

• Designed and implemented robust disaster recovery solutions using Oracle Data Guard and GoldenGate, ensuring minimal downtime and data integrity across geographically dispersed data centers.
• Led the successful migration of multiple on-premises Oracle databases to Oracle Cloud (OCI) and AWS environments, reducing infrastructure costs by 30% and increasing scalability.
• Integrated database environments with DevOps pipelines using tools like Git, Jenkins, and Terraform, enabling continuous delivery and automated provisioning of resources.
• Configured and managed Oracle Real Application Clusters (RAC) to ensure high availability and load balancing for mission-critical applications, improving uptime to 99.99%.

Environment:

Oracle Exadata, 19c, RAC, Oracle Data Guard, GoldenGate, RMAN, Oracle Enterprise Manager (OEM) 13c, AWS EC2/RDS, OCI (Oracle Cloud Infrastructure), Linux (RHEL), Shell scripting, Jenkins, Terraform, Ansible.

• Design and implementation of CI/CD pipelines for various Oracle-based applications, improving deployment frequency and stability
• Integrated Docker and Kubernetes for containerized applications and databases, enhancing the efficiency of environment provisioning and scaling
• Managed AWS EC2 instances and Oracle Cloud resources using Terraform and Ansible, automating infrastructure provisioning and configuration management
• Conducted SQL query optimization and performance tuning to ensure efficient execution of critical applications within the DevOps pipeline
• Ensured database consistency and availability by integrating Oracle GoldenGate for data replication across multiple regions
• Automated system monitoring using Prometheus and Grafana, tracking key performance metrics for both infrastructure and databases
• Managed infrastructure components including virtual machines, storage devices, networks.

KEY ACHIEVEMENTS:

• Design and implementation of CI/CD pipelines for various Oracle-based applications, improving deployment frequency and stability, resulting in a 30% reduction in deployment time and a significant increase in release consistency
• Integrated Docker and Kubernetes for containerized applications and databases, enhancing the efficiency of environment provisioning and scaling, which led to a 40% improvement in resource utilization
• Managed AWS EC2 instances and Oracle Cloud resources using Terraform and Ansible, automating infrastructure provisioning and configuration management, reducing manual intervention by 50% and accelerating infrastructure deployment by 60%
• Conducted SQL query optimization and performance tuning to ensure efficient execution of critical applications within the DevOps pipeline, leading to a 25% improvement in query performance
• Ensured database consistency and availability by integrating Oracle GoldenGate for data replication across multiple regions, achieving 99.99% uptime and seamless disaster recovery capabilities
• Automated system monitoring using Prometheus and Grafana, tracking key performance metrics for both infrastructure and databases, which enabled proactive issue resolution and a 15% reduction in system downtime
• Managed infrastructure components including virtual machines, storage devices, and networks, ensuring a robust and scalable environment that supported high availability and performance for mission-critical applications

Environment:

Oracle 19c/12c, AWS, Jenkins, GitLab, Docker, Kubernetes, Terraform, Ansible, Oracle GoldenGate, Oracle RAC, AWR, RMAN, Red Hat Linux.

• High Availability Solutions: Administered and optimized Oracle RAC (Real Application Clusters) to ensure high availability and load balancing for large-scale, mission-critical applications.Implemented Oracle Data Guard to provide synchronous and asynchronous replication for disaster recovery, reducing recovery time objectives (RTO) by 40%.
• Database Performance Optimization: Performed comprehensive performance tuning using AWR (Automatic Workload Repository), ASH (Active Session History), ADDM (Automatic Database Diagnostic Monitor), and SQL Tuning Advisor to resolve bottlenecks and enhance database performance.Optimized queries indexed frequently accessed columns, and partitioned large tables to improve query execution times by over 25%.
• Database Migrations & Upgrades: Led large-scale database migrations and upgrades from Oracle 11g to Oracle 12c, handling complex schema changes, application compatibility testing, and data integrity checks.Successfully reduced downtime by 50% by leveraging GoldenGate replication and Oracle Data Guard for near-zero downtime migrations.
• Exadata Performance Tuning: Fine-tuned Exadata storage cells by configuring Hybrid Columnar Compression (HCC) and Smart Scan to optimize I/O performance and reduce storage costs for large transactional and analytical databases. .Implemented flash cache configurations to accelerate database query performance
• Data Security & Encryption: Implemented Oracle Transparent Data Encryption (TDE) to encrypt sensitive data at rest, ensuring compliance with regulatory standards. Regularly audited and validated encryption settings to guarantee data security across production databases
• Database Troubleshooting & Support: Provided 24/7 production support for mission-critical Oracle databases in high-availability environments.Diagnosed and resolved complex performance issues related to I/O bottlenecks, SQL performance, locks, and deadlocks, significantly reducing downtime and service disruptions
• Database Monitoring & Alerts: Configured Oracle Enterprise Manager (OEM) to monitor database performance, alert thresholds, and health checks. .Created custom monitoring scripts and dashboards to detect early signs of issues, reducing unplanned outages by 35%
• Capacity Planning and Resource Management: Conducted capacity planning for Oracle databases to predict and accommodate future growth. Managed resource allocation for database storage, memory, and CPU, ensuring optimal performance even during peak workloads.
• Automation of Routine DBA Tasks: Automated routine DBA tasks such as table/index maintenance, database patching, and data migration using PL/SQL, shell scripting, and Oracle Scheduler, significantly reducing manual intervention and improving operational efficiency.
• Collaboration with Development Teams: Worked closely with the application development teams to optimize database schemas and design efficient data models. Provided performance insights on SQL queries, ensuring that database structures and code aligned with best practices
• Disaster Recovery Testing: Led disaster recovery (DR) exercises to test Oracle Data Guard failover capabilities and database recovery procedures. Improved recovery procedures, ensuring that critical data could be restored to full functionality within defined RTOs.

KEY ACHIEVEMENTS:

• Successfully led the migration of 50+ mission-critical databases from Oracle 11g to Oracle 12c with zero data loss and minimal downtime by leveraging GoldenGate and Data Guard for replication and failover.
• Optimized Exadata performance by configuring Hybrid Columnar Compression and smart scan, reducing storage costs and improving query response time by 20%.
• Enhanced data security by implementing Oracle TDE encryption and ensuring compliance with industry standards.
• Improved database backup reliability by implementing RMAN backup automation and flashback technologies, achieving 99.9% reliability.

Environment:

Oracle 11g/12c, Exadata, RAC, Data Guard, ASM, RMAN, GoldenGate, Toad, AWR, ASH, ADDM, Oracle Enterprise Manager (OEM), PL/SQL, Shell Scripting, Linux (RHEL/Oracle Linux), AIX, Solaris

• Database Performance Optimization: Spearheaded performance tuning efforts across Oracle Exadata and Oracle RAC environments.Utilized AWR, ASH, ADDM, and TKPROF to identify bottlenecks and optimize SQL queries, indexing strategies, and partitioning schemes, improving query performance by up to 30%.
• High Availability and Disaster Recovery: Designed and implemented Oracle RAC clusters and Oracle Data Guard for high availability and disaster recovery across geographically dispersed data centers, ensuring 24/7 uptime for mission-critical applications.
• Exadata Optimization: Managed and optimized Exadata environments, implementing Hybrid Columnar Compression (HCC) to improve performance and reduce storage costs for large data sets. Led the implementation of smart scan and storage tiering features to further enhance database efficiency.
• Database Migration Projects: Led several database migration projects, including upgrading Oracle databases from Oracle 10g to 11g/12c and Oracle RAC migrations, with zero downtime using GoldenGate and Data Guard for data synchronization and replication.
• Backup & Recovery Strategy: Implemented comprehensive backup and recovery strategies using RMAN and Oracle TSM, ensuring fast and reliable backup solutions for high-availability environments. Configured flashback and incremental backups to reduce recovery time
• Capacity Planning and Database Scalability: Performed capacity planning for Oracle databases, ensuring sufficient disk space, CPU, and memory resources for scaling workloads. Utilized Oracle Enterprise Manager (OEM) and custom scripts for proactive resource management and forecast capacity needs
• Oracle GoldenGate Implementation: Managed and optimized Oracle GoldenGate for real-time data replication and cross-platform synchronization, ensuring high availability and zero data loss during system migrations or failover operations.
• Security and Compliance: Implemented Oracle Database Vault, Transparent Data Encryption (TDE), and Data Redaction for enhanced security, ensuring compliance with internal data protection policies and external regulations like GDPR and PCI-DSS.
• Collaboration with Development Teams: Worked closely with development teams to design efficient database schemas, optimize stored procedures, and improve SQL performance, resulting in faster query responses and reduced system load.
• Disaster Recovery Testing: Led disaster recovery (DR) exercises to test failover procedures and recovery times, ensuring the ability to restore databases to full functionality with minimal downtime and no data loss.

KEY ACHIEVEMENTS:

• Reduced database downtime during migrations by 50% through the use of GoldenGate replication and RAC failover configurations.
• Spearheaded the performance optimization project that improved query response times by up to 30%, enhancing user experience for Apple’s critical applications.
• Implemented Exadata storage optimizations, reducing operational costs by 20% while maintaining high performance for large-scale data sets.

Environment:

• Oracle Exadata, 12c/11g, Oracle RAC, Data Guard, GoldenGate, RMAN, OEM, AWR, ASH, ADDM, Toad, Linux (RHEL/Oracle Linux), Shell scripting, AIX, HP-UX.

• Supported large-scale Oracle database environments, managing backup & recovery using RMAN, Data Pump, and Oracle Data Guard
• Provided on-call support and led troubleshooting efforts to resolve database performance issues and downtime
• Assisted in database migrations, patching, and upgrades from Oracle 9i/10g to 11g, ensuring minimal disruption to critical services
• Environment: Oracle 10g/11g, RAC, Data Guard, RMAN, Linux