Senior Oracle DBA with 10+ Years of Enterprise Experience

PRANAY NALIMELA

Senior Oracle Database Administrator 10+ Years Oracle 19c/21c/23c · RAC · RMAN · Data Guard · OCI

609-***-**** • ***************@*****.*** • USA Immediate Availability PROFESSIONAL SUMMARY

Senior Oracle Database Administrator with 10+ years of enterprise experience managing, optimizing, and securing Oracle 19c, 21c, and 23c database environments across financial services and healthcare domains. Deep expertise in Oracle RAC, Data Guard, RMAN backup and recovery, advanced SQL performance tuning using AWR, ASH, ADDM, EXPLAIN PLAN, SQL Profiles and Baselines, high-availability architecture design, disaster recovery testing, Oracle security and access management, and 24x7 mission-critical production support. Maintained 99.99% uptime across 100+ production databases. Delivered 60% failover reduction, 45% performance improvement, and 35% cloud cost savings across enterprise environments. Oracle Certified Professional (OCP), OCI Architect Associate, and AWS Certified Security certified.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Senior Oracle Database Administrator Cisco Systems, USA Financial Services Jan 2025 – Present

• Install, configure, upgrade, and patch Oracle 19c RAC databases across development, staging, and production environments — executed zero-downtime upgrades from 12c to 19c across 30+ instances with full rollback planning.

• Monitor database performance across 100+ mission-critical production databases, conduct root-cause analysis, and resolve performance bottlenecks within SLA timelines maintaining 99.99% uptime.

• Perform advanced SQL tuning using AWR, ASH, ADDM, EXPLAIN PLAN, SQL Profiles, and SQL Baselines delivering 45% batch performance improvement across financial trading systems.

• Design and maintain RMAN backup and recovery strategies including full, incremental, and archive log backups with tested point-in-time recovery procedures and documented RTO/RPO targets.

• Design and manage Data Guard physical and active standby databases for disaster recovery — perform and document switchover and failover procedures reducing failover time by 60%. Oracle DBA: Oracle 19c, 21c, 23c, 12c, 11g, 10g · RAC · Data Guard (Physical & Active) · ASM

· RMAN · OEM 13c · GoldenGate · Data Pump · Partitioning · Compression Performance Tuning: AWR · ASH · ADDM · EXPLAIN PLAN · SQL Profiles · SQL Baselines · TKPROF · SGA/PGA Optimization · Index Design · Query Optimization Backup & Recovery: RMAN Full/Incremental/Archivelog Backup · Point-in-Time Recovery · Disaster Recovery Testing · RTO/RPO Design · Data Guard Switchover/Failover High Availability: Oracle RAC · Active Data Guard · GoldenGate Replication · ASM · Zero-Downtime Upgrades · Failover & Switchover · 99.99% Uptime

Security: TDE · RBAC · Unified Auditing · Data Masking · User/Role Management · SSL/ TLS · LDAP · SOX · HIPAA · Patch Management

Cloud: OCI Architect Associate · Oracle-to-OCI Migration · AWS (RDS, EC2, S3) · Oracle on Cloud · Zero Downtime Migration (ZDM)

Oracle EBS & Apps: EBS R12.1/R12.2 · Finance · Procurement · HR · Supply Chain · Oracle Fusion Cloud · AD Utilities · Cloning · Patching

Automation: Python 3.12 · Bash/Ksh Shell Scripting · Ansible · Terraform · Jenkins · Git · Liquibase · DBMS Scheduler

PL/SQL & Dev: Packages · Procedures · Triggers · Cursors · FORALL · BULK COLLECT · REST API · SOAP · ETL Design · Data Migration

OS & Infra: Linux (RHEL 7/8/9) · Solaris · AIX · Windows Server · VMware · SAN/NAS · WebLogic

Certifications: Oracle Certified Professional (OCP) · OCI Architect Associate · AWS Certified Security · Snowflake SnowPro Core (In Progress)

Methodologies: ITIL · Agile · CAB · 24 7 Production Support · SIT · UAT · SDLC · Data Governance · Change Management

• Implement Oracle security and access management including TDE encryption, RBAC, Unified Auditing, SOX- compliant audit mechanisms, and patch management across all production systems.

• Led Oracle-to-OCI cloud migration delivering 35% infrastructure cost reduction with zero data loss using Zero Downtime Migration (ZDM) methodology and GoldenGate replication.

• Automate routine DBA tasks, monitoring frameworks, and infrastructure provisioning using Python, Ansible, Shell Scripting, and Jenkins — reducing manual DBA effort by 50%. Environment: Oracle 19c/12c, RAC, ASM, Data Guard, RMAN, OEM 13c, AWR, ASH, ADDM, EXPLAIN PLAN, SQL Profiles, TDE, OCI, AWS, ZDM, GoldenGate, Python, Ansible, Jenkins, Git, Linux RHEL Oracle Applications DBA & EBS Techno-Functional SME CVS Health, USA Healthcare Enterprise Jul 2022

– Dec 2024

• Administered Oracle EBS R12 and Oracle DB 11g/12c environments supporting Finance, Procurement, and HR for large healthcare enterprise with 24x7 production support and strict SLA requirements.

• Performed advanced SQL tuning using AWR, ASH, EXPLAIN PLAN, and SQL Profiles, improving EBS database performance by 30% and meeting all critical payroll and financial SLA windows.

• Designed and maintained RMAN backup and recovery strategies with tested disaster recovery procedures and documented RTO/RPO targets across all environments.

• Implemented HIPAA-compliant TDE encryption, RBAC, data masking, Unified Auditing, and SSL/TLS security across all Oracle EBS database environments.

• Performed Oracle EBS R12 cloning, patching, and upgrades using AD utilities, reducing patching cycle time by 30% while maintaining full environment stability.

• Collaborated with development teams for schema design, index creation, query optimization, and data migration projects across Finance and Procurement workstreams.

• Managed Data Guard switchover and failover operations; administered WebLogic application servers with LDAP integration and performance monitoring.

• Troubleshot and resolved database outages, incidents, and performance issues proactively using OEM 13c monitoring and root-cause analysis methodology.

Environment: Oracle EBS R12.1/R12.2, Oracle DB 11g/12c, RAC, Data Guard, RMAN, OEM 12c, WebLogic, Linux, PL/ SQL, SQL, Shell, TOAD, Data Pump, TDE, SSL/TLS, LDAP Oracle Database Administrator LabCorp, USA Healthcare & Diagnostics Dec 2019 – Jun 2022

• Maintained 40+ Oracle 11g/12c databases in RAC and Non-RAC environments with 99.99% uptime and 24x7 mission-critical production support across distributed data centers.

• Performed expert-level SQL tuning using AWR, ASH, EXPLAIN PLAN, and SQL Baselines, reducing transaction processing times by 35% across high-volume healthcare systems.

• Designed and tested Oracle Data Guard physical standby databases for disaster recovery — documented switchover and failover procedures with tested RTO/RPO targets.

• Implemented partitioning and compression for datasets exceeding 8TB; automated maintenance, backup verification, and alerting using Unix shell scripting cutting manual effort by 45%.

• Applied CPU, PSU, and one-off patches to Oracle databases following CAB change management processes; performed pre and post-patch validation and rollback planning.

• Led root-cause analysis for production incidents and drove issues to full resolution with documented post- mortems, preventive measures, and SLA compliance reporting. Environment: Oracle 11g/12c, RAC, Data Guard, ASM, RMAN, OEM 12c, AWR, ASH, ADDM, Linux, Shell, PL/SQL, SQL, TOAD, Partitioning, Data Pump, Jenkins

Oracle PL/SQL Developer & Data Integration Specialist Cognizant Technology Solutions, USA Manufacturing

Jan 2018 – Dec 2019

• Designed and developed complex PL/SQL packages, stored procedures, triggers, cursors, and pipelined functions for ERP and SCM applications, reducing processing time by 50%.

• Performed logical and physical data modeling and source-to-target column mapping for Oracle ERP integrations across Supply Chain and Manufacturing platforms.

• Built REST API interfaces and SOAP web service integrations connecting Oracle ERP with third-party logistics platforms and enterprise systems.

• Applied FORALL, BULK COLLECT, and DBMS Scheduler automation to improve batch throughput and eliminate manual database tasks.

• Participated in data migration and conversion projects performing data quality management through full SIT and UAT cycles.

• Conducted peer code reviews and enforced database development best practices, coding standards, and technical documentation procedures.

Environment: Oracle 11g, PL/SQL, SQL Developer, TOAD, Linux, Shell, Materialized Views, Data Pump, REST APIs, SOAP, Git, ERP/SCM

Junior Oracle DBA Cognizant Technology Solutions, India PepsiCo — Finance & Logistics Jun 2015 – Dec 2017

• Provided 24x7 production support for Oracle 10g/11g databases across Finance and Logistics environments — incident resolution, escalation management, and root-cause analysis for critical production failures.

• Performed RMAN backup and recovery operations — designed and implemented backup strategies including full, incremental, and archive log backups with tested recovery procedures and documented RTO/RPO targets.

• Monitored database health, performance, and availability using Oracle Enterprise Manager (OEM) — proactively identified and resolved performance bottlenecks before business impact.

• Applied CPU patches, PSU patches, and one-off patches to Oracle 10g/11g databases — coordinated with change management teams and followed CAB approval processes.

• Administered user accounts, roles, and privileges — implemented RBAC security policies and maintained audit logs across Oracle environments.

• Performed tablespace monitoring, space management, and capacity planning — added datafiles, resized tablespaces, and resolved ORA errors proactively.

• Collaborated with application development teams to support schema changes, index creation, query tuning, and database object deployments within SLA windows.

Environment: Oracle 10g/11g, RMAN, OEM, ASM, Data Pump, Linux/Unix, Windows Server, Shell Scripting, JIRA, SQL*Plus, TOAD, Change Management, CAB

CERTIFICATIONS

• Oracle Certified Professional (OCP) — Oracle Database

• AWS Certified Security — Amazon Web Services

• OCI Architect Associate — Oracle Cloud Infrastructure

• Snowflake SnowPro Core — In Progress (2026)

EDUCATION

Bachelor of Technology in Computer Science — JNTU Hyderabad, 2015

Contact this candidate