Phaniraj Patel Kandakatla

- Build and own mission-critical data pipelines and datasets supporting clients core business functionalities

- Provide comprehensive database support to application teams and Technology Services Group (TSG) operations teams, including the Network Operations Center

- Collaborate directly with cloud platform teams to integrate services at scale

- Create and maintain physical and virtual databases following established team standards and processes

- Enforce database standards and address inconsistencies

- Conduct routine database and system reviews to ensure optimal performance levels

- Identify database performance issues and provide improvement recommendations

- Follow through on recommendations and advocate for implementation as appropriate

- Apply database concepts including definitions, parameters, component placement, reorganization, access methods, and security configurations

- Collaborate with capacity planning, operations, application developers, and other TSG teams on performance and access issues

- Act as an early adopter of cutting-edge data technologies in cloud environments

- Deliver guaranteed service to both internal and external clients

- Maintain expertise across multiple database management systems on various operating systems

- Perform database software installation, upgrades, and patching

- Manage database infrastructure and oversee the creation and support of application databases

- Assist application groups with database design and development to meet current and future business requirements

- Participate in the logical database design process for strategic projects

- Provide specific guidance on infrastructure design to support applications

- Serve as an active member of development support teams on database projects

- Adhere to project timelines and meet all established deadlines

- Provide 24/7 support for production database environments

- Serve as primary administrator with on-call availability for database environment issues

- Deliver follow-up support and implement permanent resolutions for recurring issues

Environment: AWS Cloud Infrastructure, AWS RDS DB Clusters, AWS Aurora Postgres DB Clusters, AWS DynamoDB, AWS DevOps, AWS EC2, AWS S3, AWS Cloudwatch monitoring, Harness CI-CD, Terraform

- Certified as Oracle Autonomous Database Specialist 2019, Oracle Cloud Database migration & Integration Specialist 2021, Oracle Generative AI Professional 2024, Oracle Vector DB AI Search Specialist 2025, NVidia Real-time AI Applications specialist.
- Key vertical resource dedicated to Customer Database management, administration and migration projects from Onprem to AWS and OCI, standardizing security.
- Architected Database design for new and transitioning clients.
- Expert in H.A, Multi-cluster and D.R recoveries for databases both On-premise and Cloud.
- Maintain Production Databases with efficient Onprem/Cloud backup & restore strategy via Oracle RMAN.
- Automated D.R/Continuous recovery of 51 TB Onprem database as source with target cloud DbaaS via RMAN & Oracle ZDM via Golden gate approach.
- Deployed OEM 13c agents in Onprem, OCI DBCS server. Load tested Pre-Prod OCI DBCS server using OEM 13c via Source capture and implemented OEM Real Application Testing for shape capacity planning prior to Prod cutover.
- Sole participating member in 12c to 19c upgrade and triaging issues associated with the upgrade path related to code changes, 19c compatibility and isolating directory object creations suitable for 19c.
- Managing RAC Database cluster (12c,19c) in OCI Cloud.
- Plugged in 19c non-cdb as PDB in an existing 19c multitenant database. Resolved pluggable violations and made it OLTP read-write ready for applications functionality.
- Cloud native security workload - OCI Vault, SSL-TDE wallet rotation, Automated DB User-IAM security audit via OCI datasafe.
- Installed, upgraded Postgres Database servers from 9.6 to latest version to support in-house Zabbix monitoring system
- Modeled AI design perspective, scaling IOPS on the mounts hosting Vector database embeddings for efficient RAG.
- Setup and configured ChatBot using Streamlit via OpenAI API, GPT-4o LLM model, and framework using Vanna AI to fetch sales, customer information directly from the Oracle database.
- Transitioned from Shell scripts to Python, and crontab job scheduling to OCI function scheduling.
- Resolved several performance bottlenecks and Production issues not only limited to Oracle Database but also in respect to Oracle Weblogic servers, Zabbix app tuning on existing Postgres server parameters, and overall environmental compatibility Issues pertaining to SSL layered applications
- Experience using Terraform IaaS to provision, manage OCI DBCS, Compute instance vm's, Postgres clusters in Oracle Infrastructure Cloud.

- Setup and configured ChatBot using Streamlit via OpenAI API, GPT-4o LLM model, and framework using Vanna AI to

fetch sales, customer information directly from the Oracle database.

- Modeled AI design perspective, scaling IOPS on the mounts hosting Chroma Vector embeddings for efficient RAG.

- Experimenting with async-driven RAG to cope with response-prompt concurrency.

- Used Unsloth AI for training Mistral 7B instruct with confined documentation and localized the model card eliminating

need of API for RAG

- Hands on with Huggingface Smolagents Agentic driven framework for managed-code-tools agentic reporting pipeline to minimize workload on Oracle weblogic reports
- Automated server side database script deployments and integration with Github.
- Terraform state file management using remote OCI buckets
- Acting Database Team Lead in absence of DBA Manager
- Actively participating in DBA Oncall rotation schedule
- Engage offshore team on appropriate customer nightly workplan implementations, adjusting priorities and facilitate database best practices, pre-planned handoffs

Environment: AWS EC2, OCI UCM/Compute, AI RAG (Vanna,Smolagents,Mistral and gpt-40 LLM), OCI DBCS, Oracle 12c/19c, Oracle Multitenant architecture (CDB-PDB), OCI DbaaS/Autonomous DB, Postgres, Oracle 12c, Oracle RMAN, OEM 13c, Grid 19c, ASM, Oracle Fusion Middleware 12c, Terraform, OpenAI, gpt-4o, Github

- Implemented best architecture practices, facilitate robust documentation for maintaining the Database instances in a flexible fashion.
- Engaged as Primary Project level support/Customer success personnel for retail customers, upgrading database instances from 11.2.0.4.8 to 12.1.0.2
- Coordinating on engineering standards for AWS db systems with Salesforce security guidelines in place
- Gained thorough expertise in upgrading Active DataGuard Standby db instances both in 11g and 12c
- Engaged as Level-3 engineer in Database Disaster recovery scenarios
- Devised valid POC's for Standby database ADG recovery simulation using RMAN and NetApp hot backup of the Primary instances
- Successfully failed over Secondary database instances to Primary, in production rollback scenario's
- Managed PostgreSQL db servers, conducted upgrades from 8.3 to 11.8 version.
- Followed suitable workaround to overcome Postgres corruption at disk level, with zero downtime to customer
- Took ownership as key member from scratch in upgrading Oracle WebLogic/Fusion Middleware servers from 11g to
12c in planned maintenance's across our hosted customers
- Experienced in 11g RAC 2-node setup and configuration in Development environment
- Actively participated in RPM's engineered for Oracle WebLogic 12c installation, and shared inputs on fixing noticed internal bugs associated with the upgrade path's
- Prepared automated toolkit and scripts needed for nightly maintenance for Fusion Middleware and Oracle Dataguard instances

Environment: Oracle Database 11g/12c, Grid Control, Postgres Community/EnterpriseDB, Salesforce CRM, AWS, RHEL 6.6/6.8, ADG, Fusion Middleware 11g/12c

- Provided P0 support, troubleshooting to challenging high level issues regards to Performance tuning, Migrations, trace analysis, resource management

- Solely implemented Active DataGuard Standby setup, zero loss, realtime replication for 7 TB Production OLTP instance

- Designed and implemented proof of concept to facilitate testing functions, reports having challenges against Standby Instances

- Providing guidance related to environmental architecture and continual service improvement projects

- Documented and implemented Oracle to Postgres schema level migration in Production using EDB migration toolkit

- Sharing innovation in house, coordinating with Engineering and replication teams to further improve design of the overall product

Environment: Oracle 10g/11g/12c, OEM, EnterpriseDB, CRM, AWS, RHEL 5/6, ADG

- Retailnet Primary DBA with multiple high end retail customers and managing total 20 TB of VLDB

- Worked with Oracle 9i, 10g, 11g, and 12c database and application services, including installation, maintenance, and monitoring.

- Cross-platform migration using expdp/impdp, database administration and replication

- Upgraded several databases from Oracle 9i/10g to 11g/11.2.0.4.6.

- Oracle application server fusion middleware installations, patches and upgraded various Tomax Retail.net products

- Worked with Netapp snapshot/Traditional RMAN in implementing Hot/Cold backups and there after worked with Database refresh in a quarterly basis

- Implementing online Table reorganization, index rebuild and partitioning on customer specific tables on a periodic scale to effectively monitor the performance

- Alert log monitoring via Zabbix(Tomax monitoring service) on a regular basis

- Postgres SQL(EnterpriseDB) Database administration and schema design

- Troubleshooting database connectivity issues with OAS infra and middletier(Oracle apps,LDAP and Jboss)

- Deployed OEM cloud control 12c across the board.

- DB User management – Creating users, assigning roles, configuring DB links for external users and troubleshooting issues with generic DB user privilege/access issues

- Working with Tomax retailnet and Merchandise planning store operations

- Providing Oncall support for 24/2(every 3 weeks) and in normal business hours

Environment: Oracle 9i/10g/11g/12c, OEM, Cloud control agent, SQLPlus, OLTP, OLAP, Grid Control, RMAN, Snapshot, Jpos, Jboss, OAS 10gR2, Oracle TOAD 9.1.0.62, Database Cloning, CRM, Red Hat Enterprise Linux 4.0/5.8/6, Windows 2003/XP/7, Sun Solaris, Postgres SQL 9.x

- Worked as clean up Oracle engineer to migrate and upgrade existing environments and hand it over at the earliest date

- Installed Oracle 11gR2(11.2.0.2) Out of place upgrade on given servers

- Multiple schema management on several instances as per the client requirements

- Worked on Table partitioning.

- Created multiple Users and Granted permissions and privileges to the given users

- Secured several instances on Prod, Dev and Test servers based on corporate security guideline

- Implemented departmental backup processes on servers using RMAN and Cold Backup, D.R measures.

- Implemented stringent password securities for dba profiles on Prod/Dev/Test servers

- Coordinated with developers and testers on the Project time line and prioritize on going work

Environment: Oracle 9i/10g/11g, SQLPlus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX 6.1