Rahul Bhola

Served as Staff and Technical Leader for CTG, driving the company’s cloud-first database strategy and aligning database modernization with enterprise business goals. Spearheaded end-to-end Oracle-to-AWS RDS migration programs, ensuring enterprise-grade reliability, security, and business continuity with zero major incidents during cutovers. Architected and governed enterprise-wide disaster recovery and high-availability frameworks using AWS RDS Multi-AZ and Oracle Golden Gate, achieving mission-critical 98% uptime SLA compliance. Lead the 2024 Tax Season Load Program, orchestrating end-to-end ecosystem readiness and leading cross-functional teams to establish performance benchmarks for peak 2024 tax filing traffic, ensuring resilient scalability under record-breaking demand. Championed cloud cost optimization, implementing AWS Auto Scaling and Cost Explorer initiatives that delivered double-digit annual savings without compromising performance for Database Ecosystems. Advanced automation through Terraform-based Infrastructure as Code (IaC), institutionalizing consistent database provisioning, configuration, and compliance while accelerating delivery velocity. Governed enterprise patching and RDS version upgrades, aligning execution with AWS compliance mandates while minimizing disruption to mission-critical services. Elevated operational excellence by refining enterprise-wide monitoring and alerting frameworks using AWS CloudWatch and Performance Insights, cutting incident detection times by 40%. Acted as senior escalation point and on-call leader, ensuring seamless resolution of complex production incidents, safeguarding customer trust during high-volume business periods.

Responsibilities: • Lead the ongoing migration of 3 applications from Oracle 11gR2 to 12c, leveraging Exadata systems for optimized performance, and coordinate high availability and disaster recovery planning using Real Application Clusters (RAC) and Oracle Golden Gate. • Manage installations and configurations of Oracle 9i, 10g, 11g, and 12c RAC on various operating systems, including Solaris, and Linux Servers, ensuring stability and efficiency. • Perform database instance and SQL query performance tuning, utilizing diagnostic tools such as SQL Trace, TKPROF, and Oracle AWR for optimal execution plans and resource utilization. • Develop, manage, and audit database security standards, user permissions, and privileges in conjunction with the corporate security team, maintaining integrity and compliance. • Administer Oracle Golden Gate, conducting requirement analysis, product evaluations, and delivering presentations to the team for informed decision-making. • Set up and maintain Data Guard configurations for standby databases, including Data Guard broker operations and switchover/failover procedures for live production servers. • Employ Oracle Enterprise Manager (OEM) 12c/13c Cloud Control for extensive monitoring of database server resources, achieving a holistic view of the database environment. • Implement database security best practices, including Oracle Database Vault, and enforce data access restrictions using roles, profiles, and access controls. • Conduct audits to monitor and report on suspicious database activities, enabling object auditing, privilege auditing, and network auditing for increased security vigilance. • Implement Transparent Data Encryption (TDE) for tablespaces in Oracle 12c environments, managing encryption keys and wallets effectively. • Lead large data warehouse projects, implementing Advanced Compression and Archival strategies for transient data, optimizing storage and retrieval processes.

• Implemented Golden Gate for uni-directional replication includes installation, configuration, and troubleshooting. • Database upgrades from 10g to 11g. • Performance tuning of database instance and SQL queries using Diagnostic tools • Environment Refresh and support for critical Applications using (RMAN/ Data pump) • Handling annual DR exercise with switchover / switchback operations for Oracle 11g servers

Responsibilities : •. Engineered a robust Grid Infrastructure with OEM 12c, involving the installation and configuration of a 3-node Oracle Management Service (OMS) for load balancing and a RAC-based OEM repository for centralized management. • Utilized Oracle Enterprise Manager (OEM) 12c for comprehensive monitoring of database server resources, ensuring optimal performance and resource allocation. • Executed the installation and configuration of Oracle RAC versions 9i, 10g, 11g, and 12c across diverse operating systems, including Solaris, and Linux Servers • Directed the planning, coordination, and execution of over 10 application database upgrades, ensuring smooth transitions across development, testing, and production environments. • Configured and monitored Oracle Golden Gate replication for seamless data transfer from Solaris Oracle 10g to 11g on Exadata Linux servers, including meticulous installation and production database monitoring. • Upgraded Oracle Golden Gate installations to version 11.2.1.0.31, maintaining currency with the latest replication functionality. • Conducted weekly database cloning from 11gR2 RAC to standalone systems, supporting application testing, pre-production verification, and operational needs. • Led annual Disaster Recovery (DR) exercises, managing switchover and switchback procedures for both non-RAC 10g and 11gR2 RAC environments to ensure business continuity. • Applied Patch Set Updates (PSUs) using rolling and non-rolling patching strategies to maintain security and functionality without compromising uptime. • Facilitated data migrations from non-Exadata to Exadata X2-8 machines, utilizing a physical standby database on the target server for data integrity and minimal downtime. • Established and managed standby databases with Data Guard, including Data Guard Broker configurations and switchover/failover operations ensuring high availability. • Performed advanced performance tuning of database instances and SQL queries

• Delivered level 2 technical support for Oracle 11g RAC with ASM, addressing complex backup, recovery, and disaster recovery operations across HP-UX, Red Hat Linux, and Solaris servers. • Orchestrated and supported migrations and upgrades from Oracle 10g to 11.2.0.4 RAC databases, streamlining transitions on HP-UX and Linux servers to enhance database performance and resilience. • Managed installations and configurations of Oracle RAC for versions 9i, 10g, 11g, and 12c, customizing solutions for a range of operating systems, including Solaris, Windows, and Linux servers, to meet diverse operational requirements. • Provided specialized support for Oracle Golden Gate, overseeing the setup, continuous monitoring, and troubleshooting of replication processes between 10g on Solaris and 11g databases on Linux servers. • Conducted proactive monitoring and performance tuning of SQL queries and jobs in a 24/7 high-availability environment, utilizing OEM 11g and Autosys to maintain optimal server performance across 10g, 11gR2, and 12c databases. • Implemented and maintained Oracle standby databases across more than 40 distinct database environments, ensuring robust data protection and high availability. • Led the auditing process to monitor for suspicious database activities, enabling and managing object auditing, privilege auditing, and network auditing to uphold strict security standards. • Engineered multiple environments to support comprehensive functionality testing, created a pilot environment that mirrored production for in-depth testing, and devised detailed migration plans for transitioning production clusters to new setups. • Provided database consulting and engineering expertise to development teams, advising on database monitoring, backup scripting, performance tuning, authoring support and training materials, and evaluating new database technologies to drive innovation within the company.

• Served as technical lead for High Paced project with AT&T by implementing Agile Methodology. Supervising the onshore and offshore team and to guide team to review functional & business documents to develop test plan and managed testing efforts for project's testing phases. • Supported development effort by SQL tuning and optimizing ETL procedures and removing load and query performance bottlenecks. • Adept at authoring Test Strategy, Test Plan, Test Cases and Scripts for system testing based on the business & system Requirement with experience covering Mainframes systems such as WFA DI/ WFA DO and Network Testing of devices such as Ericsson FTTN, 7450 Switches and Routers. • Led the upgrade and optimization of Oracle 9i/10g databases for AT&T’s enterprise applications, ensuring state-of-the-art data management. • Delivered SQL and ETL optimizations for AT&T development teams, resolving performance issues evidenced by diagnostic reports. • Produced regular performance reports, providing AT&T management with actionable insights for strategic planning. • Applied HP QC, JIRA, and QTP expertise in AT&T’s Agile and Waterfall projects, contributing to the successful delivery of key milestones.

• Installation , configuration and Administration of Oracle 9i/10g servers • Schema Refresh using traditional exp/ imp and RMAN utility. • Maintenance of Back-up (both cold & hot) with a well laid down back-up & recovery strategy • Performance tuning of queries consuming Excessive Resources by modifying the query with joins, indexes and table portioning. • Monitoring Server health and setting up alerts using grid OEM 10g. • Supported development effort by SQL tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan/ Stats pack / ASH / ADDM reports. • Preparing the Daily and weekly status reports. • Strong hands on tools as HP QC, JIRA and QTP in Agile and waterfall models of SDLC.