Rakesh Pamidipati

Current Project : Wellsfargo (CEDT )

April 2024 -Present

Role: Application Production Support | Incident Management | Automation

• Created, monitored, and closed incidents using the ServiceNow tool, ensuring adherence to agreed SLAs.
• Proactively performed daily cleanup activities in applications to reduce ticket volumes and enhance system performance.
• Conducted proactive monitoring of both production and non-production environments to ensure smooth operations.
• Monitored application server performance using tools like Putty, Informatica, and Autosys for job
• scheduling.
• Accepted, resolved, and raised incidents/service requests through ServiceNow as per user/system requirements and SLAs.
• Designed and implemented reports, dashboards, and alerts in tools such as Grafana, Splunk, Thousand Eyes, and AppDynamics to proactively monitor application performance.
• Extracted and analyzed backend server logs to identify errors, performed root cause analysis, and provided timely resolutions.
• Actively participated in P2/P3 incident triages, quickly identifying root causes and restoring incidents within the defined timeframe.
• Identified bugs and recurring failures in the production environment, documented them in Confluence, and tracked them for resolution.
• Generated and published incident and performance reports to clients to keep them informed of system
• health and progress.
• Built and maintained runbooks, SOPs, KEDB, and other documentation for recurring issues to streamline future troubleshooting.
• Conducted System Health Checks and generated/distributed Ready for Business (RFB) reports on a daily basis to ensure production stability.
• Created SQL queries to interface with the DBMS, ensuring accurate data retrieval and reporting.
• Executed deployment activities using tools like UCD and Harness, including patching and versioning tasks to maintain system stability.
• Actively monitored database performance, performing necessary actions to optimize queries, indexing, and overall database efficiency.
• Took responsibility for resolving and addressing critical issues or queries raised by clients or users in the
• production environment, ensuring minimal downtime and optimal service.

Previous Project : Charles Schwab

June 2021-April 2024

Role: Oracle Database Administrator

• performing various tasks like database installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.
• Data Guard,RMAN, Backup And Recovery, RAC, Migration, Upgrades.
• Database Migration using different methods like Datapump Export & Import,Rman Cloning, DB link currently working with 19c migrations.
• Working on 2 node RAC module and standby database build.
• Data guard setup & Fast track failover setup.
• 11g & 12c Upgradation including manual and auto upgrade.
• Remediation and patching .
• OEM , Agent installation, Self PDB creation tool knowledge.
• Backup and database recovery management.
• Interaction with client on regular basis and performing go-live activities.
• Change request creation using remedy tool.
• Management of workorders and decommission.

• Database migrations from 10g, 11g to 12c using , RMAN and EXPDP/IMPDP
• Database migration using expdp/impdp,Rman,Standby .
• RAC and ASM configuration setups on Linux servers
• Creating and converting databases to 12c
• Implementing and Monitoring the RAC (2 node) on Production database
• Migrated the Databases from Non ASM to ASM (11g R2 to 12c)
• Working on Datagurd (Physical standby ) setup for new 12c databases
• Configuring, Adding Node, ASM and SRVCTL and other utilities
• Capacity Planning and monitoring the database growth on the basis of periodic reports
• Working on Performance issues like Database related and query related
• Working with customer to understand their requirements and capacity planning's to build
• Working on Production CR's (Change Requests) and PBI (Problem Identification Tickets)
• Managing Hot and Cold Backups, Exports, Imports and RMAN
• Preparing Standard Operating Procedures for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers
• Extracting Data & loading data Between the database cross platforms, data loading using network links & Working with data pump jobs
• Incremental backups, Archive backups, RMAN BACKUPS scripts catalog and Without catalog, Standby creation, Duplicate database and recoveri
• Acted as technical consultant to vendors for complex database-related issues, systems and implementation projects.
• Evaluated complex business problems and communicated alternative solutions to users and staff.
• Carried out performance testing and evaluation to confirm data security, privacy and integrity.