Skip to content

Pradarshan Kumar Jupidi

Senior Database Administrator | Lead DBA • Detroit, MI • j*******@gmail.com • 312****524 • ai-dba-assistant.streamlit.app/•••••

Professional Summary

Senior Database Administrator with 15+ years of experience managing Oracle, MySQL, PostgreSQL and NoSQL platforms across on-prem and cloud. Expertise includes Oracle RAC, Data Guard, GoldenGate, RMAN, TTS migrations, performance tuning using AWR/ASH/ADDM, and large-scale upgrades (including a 15 TB 11g→19c migration). Built an AI-driven Oracle DBA assistant (Streamlit, Supabase, OpenAI) for query analysis and performance diagnostics. Seeking senior DBA/lead roles to drive reliability, performance and scalable database architecture.

Technical Skills

Programming Languages: Perl
Databases: Oracle 19c,Oracle 18c,Oracle 12c,Oracle 11g,Oracle 10g,9i,MySQL,PostgreSQL,MariaDB,MS SQL,SQL,MarkLogic,Cassandra,Oracle EBS,OBIEE,Business Intelligence
Cloud and DevOps: AWS EC2, RDS,Oracle Cloud,Microsoft Azure,Oracle VM,VMware vSphere
Tools and Methodologies: SQL*Plus,SQL*Loader,Toad,MySQL Workbench,MySQL Enterprise Monitor,GitHub,Streamlit
Skills: PL,Shell Bash,Korn
High Availability & Replication: Oracle RAC,Oracle Data Guard physical & logical,Oracle GoldenGate,Transportable Tablespaces TTS,Oracle Streams
Backup, Recovery & Cloning: RMAN,EMC Data Domain,EMC Snap,EXPDP,IMPDP Data Pump
Performance & Monitoring: AWR,ASH,ADDM,TKPROF,Explain Plan,OEM 10g,11g,12c,13c
Operating Systems: Red Hat Linux,Oracle Enterprise Linux,AIX,Solaris,Windows Server

Work Experience

BCBCM (Blue Cross Blue shield)
Detroit, MI
Sr. Database Administrator (DBA)
Sept 2023 – Till Date
Database migration and production support for a large health-insurance provider; focused on Oracle platform upgrades, Data Guard, backups and performance optimization.
Tech Stack: Oracle 19c, TTS, Data Pump, OEM 13c, Data Guard, RMAN, EMC Data Domain, AWR, TKPROF, Streamlit, OpenAI, Supabase
  • Led cross-platform migration from Oracle 12g to 19c on Red Hat Linux using Transportable Tablespaces (TTS) and Data Pump to minimize downtime and preserve schema integrity.
  • Installed and configured Oracle Enterprise Manager Cloud Control 13c to consolidate monitoring across mission-critical health insurance databases.
  • Performed SQL and instance-level tuning (SGA/shared pool/I/O) using AWR/ASH/ADDM, TKPROF and Explain Plan, reducing top SQL latency in production.
  • Designed and maintained Data Guard configurations (physical and logical standbys), executing controlled switchover/failover tests and monitoring with Data Guard Manager.
  • Implemented RMAN-based backup strategies with EMC Data Domain to ensure consistent large-scale backups and reliable restores for regulatory compliance.
  • Built and integrated an AI Oracle Performance Assistant (Streamlit + OpenAI + Supabase) to accelerate root-cause analysis for slow queries and configuration issues.
AbbVie | HCL
Chicago, IL
Sr. Oracle DBA / MarkLogic / MySQL (DBA)
April 2020 – Aug 2023
Pharmaceutical / life-sciences data platform support and cloud migrations including MySQL and Oracle RDS/EC2 instances.
Tech Stack: Oracle 19c, MySQL 8.0, AWS RDS, EC2, MySQL Enterprise Monitor, OEM, AWR, TKPROF, MarkLogic, Cassandra
  • Primary technical resource for migrations from Oracle 11g/12c to 19c, planning cutovers and executing schema/data moves with minimal service disruption.
  • Administered AWS RDS and EC2 database instances; implemented hardening, backup and monitoring procedures for cloud-hosted databases.
  • Upgraded MySQL from 5.7 to 8.0 on Linux; installed MySQL Enterprise Monitor and Workbench to improve observability and SQL troubleshooting.
  • Performed comprehensive performance tuning (I/O, memory, CPU, SQL) using Explain Plan, SQL*Trace, TKPROF and OEM, improving query throughput for ETL workloads.
  • Supported NoSQL platforms (MarkLogic, Cassandra) and MariaDB, ensuring integration with downstream data warehouse and analytics pipelines.
  • Collaborated with ETL teams to identify and remediate long-running queries in data warehouse environments, reducing batch windows.
DSW (Designer Brands)
Columbus, OH
Sr. Database Administrator (DBA)
August 2019 – March 2020
Retail ecommerce database modernization and migration to Oracle 19c multitenant on AIX, plus MySQL monitoring and performance support.
Tech Stack: Oracle 19c, TTS, AIX, MySQL Enterprise Monitor, OEM, Data Guard, RMAN, EMC Data Domain, TKPROF
  • Executed migration from Oracle 11gR2/12c to Oracle 19c multitenant on AIX using Transportable Tablespaces and validated tenant consolidation.
  • Introduced 19c features and hardened production environments to improve stability and manageability for high-traffic retail systems.
  • Installed and configured MySQL Enterprise Monitor and Workbench to centralize MySQL observability for analytics and storefront services.
  • Performed instance and SQL tuning using Explain Plan, TKPROF and OEM to reduce peak load response times during promotional events.
  • Configured Data Guard (physical and logical) and ran failover/switchover exercises to validate disaster recovery procedures.
  • Managed large backups and restores with RMAN and EMC Data Domain to support fast recovery and environment refreshes.
Conduent
Austin, TX
Sr. Database Administrator (DBA)
November 2018 – July 2019
Managed Oracle platforms on Exadata and virtual machines, led GoldenGate upgrades and cloud POCs for future migrations.
Tech Stack: Oracle 12c, Oracle 11g, Exadata, GoldenGate 12c, AWS EC2, OEM 12c, RMAN, EMC Data Domain, Data Guard
  • Contributed to migration POC efforts for 11g/12c→18c/19c on Exadata and virtualized environments, validating compatibility and performance.
  • Installed and tested Oracle 12c on AWS EC2 as a migration proof-of-concept to support cloud migration planning.
  • Led Oracle GoldenGate upgrade from 11g to 12c on Exadata; designed HA replication solutions leveraging clusterware functionality.
  • Developed custom GoldenGate lag-monitoring scripts and integrated GoldenGate monitoring into OEM 12c to improve replication observability.
  • Executed Data Guard configurations and managed controlled switchover/failover tests; documented DR runbooks for operations teams.
  • Performed large-scale RMAN backups to EMC Data Domain and validated restore scenarios for critical transaction systems.
BCBCM (Blue Cross Blue shield)
Detroit, MI
Sr. Database Administrator (DBA)
Sept 2015 – Oct 2018
Health insurance enterprise DBA role focused on cross-platform migrations, cloning, RMAN backups and PeopleSoft support.
Tech Stack: Oracle 11g, TTS, OEM 12c, RMAN, EMC Data Domain, EMC Snap, Data Guard, Perl, Korn Shell
  • Executed cross-platform migration from Oracle 10g on AIX to Oracle 11g on Linux using Transportable Tablespaces and Data Pump to modernize environment.
  • Installed Oracle Enterprise Manager 12c and standardized monitoring across a large estate to improve incident detection and resolution.
  • Implemented RMAN backups integrated with EMC Data Domain and supported Snap Clone (12 TB) refreshes for PeopleSoft environments.
  • Configured and managed Data Guard physical and logical standby databases; performed switchover/failover drills and monitored via Data Guard Manager.
  • Performed capacity planning for Oracle infrastructure to align storage/compute growth with anticipated business demand.
  • Developed batch reporting processes using Perl and Korn shell scripts; optimized partitioned table performance for reporting workloads.
GM (General Motors)
Detroit, MI
Sr. Database Administrator (DBA)
January 2014 – August 2015
Automotive enterprise data platform support covering RAC, Data Guard, GoldenGate and data modeling for centralized data resources.
Tech Stack: Oracle RAC, OEM 12c, AWR, ADDM, GoldenGate, Data Guard, V$ Views
  • Implemented and supported Oracle RAC, Data Guard and GoldenGate HA solutions to ensure high availability for vehicle and business systems.
  • Monitored and tuned RAC clusters with OEM 12c, AWR/ADDM and V$ views to maintain consistent SLAs for transactional systems.
  • Implemented Data Guard broker and log miner workflows; executed controlled failovers and validated recovery procedures.
  • Applied GoldenGate integrated capture and multi-threaded replicate features to improve replication performance and DDL capture.
  • Collaborated with development teams to design data models and schemas for BRM product and position components for a centralized data store.
  • Led POC, design and testing activities for new database features and validated changes against production-like workloads.
Foresee Result
MI
Sr. Oracle DBA
September 2013 – December 2014
Provided Oracle HA installations and Data Guard solutions for enterprise Linux clusters; supported GoldenGate and re-architecture efforts.
Tech Stack: Oracle 12c, Oracle 11gR2, RAC, Data Guard, GoldenGate, Oracle Enterprise Linux, Red Hat
  • Installed and maintained Oracle 11gR2/12c HA solutions including RAC and Data Guard on Oracle Enterprise Linux and Red Hat.
  • Configured multiple Data Guard standbys and implemented Data Guard Broker to streamline switchover/failover operations.
  • Served as primary resource for Oracle GoldenGate upgrades and configuration in an Exadata-capable environment.
  • Participated in a re-architecture to centralize data distribution; produced conceptual designs and roadmaps to align teams.
  • Designed and tested database architectures and validated failover procedures through scheduled DR exercises.
  • Collaborated on development and test activities to ensure new distribution architecture met performance and availability goals.
HCL / Crawford / Direct Brand (DBI) / Enabil Solutions
Sr. Oracle DBA / Apps DBA / Architect
November 2011 – Aug 2013
Application DBA and architecture work across enterprise EBS and data-warehouse platforms; migrations and OBIEE/BI implementations.
Tech Stack: Oracle EBS, Oracle 11g, RAC, OBIEE, RMAN, AWR, StatsPack, Red Hat, AIX, HP-UX
  • Installed and supported Oracle 9i/10g/11g databases and RAC on Red Hat, AIX and HP-UX; tuned clusters using StatsPack/AWR and V$ views.
  • Migrated Oracle E-Business Suite from 11i to 12.2.6 and upgraded databases from 11.2.0.4 to 12c to support application modernization.
  • Contributed to a re-architecture for a centralized data distribution system; created high-level conceptual frameworks and POCs.
  • Designed physical and logical schema layers for OBIEE and reporting stacks; worked with developers to implement Financial product schemas.
  • Executed capacity planning, I/O optimization and RMAN strategies to support growing transaction volumes and analytics workloads.
  • Gathered requirements, developed prototypes and tested application layers to ensure integration with enterprise BI and reporting tools.
Wells Fargo
West Des Moines, IA
Sr. Applications Performance Engineer/Developer
November 2010 – October 2011
Banking applications performance engineering with Oracle RAC, Data Guard and EBS installations on Unix/Linux platforms.
Tech Stack: Oracle 11g, RAC, OEM Grid Control, AWR, StatsPack, Data Guard, Oracle EBS
  • Installed and configured Oracle 9i/10g/11g and RAC across Red Hat Linux, AIX and HP-UX to support banking application SLAs.
  • Performed RAC cluster monitoring and load balancing using OEM Grid Control, StatsPack/AWR and V$ dynamic views to improve throughput.
  • Configured Data Guard and performed failover/switchover exercises; implemented log miner processes for replication and auditing.
  • Installed and configured Oracle EBS and supported database changes related to application deployments and performance tuning.
  • Collaborated with application teams to identify SQL hotspots and applied indexing and plan changes to reduce response times.
  • Documented performance baselines and tuning playbooks to accelerate incident response for production issues.
Well Care Inc.
Tampa, FL
DBA - Data Analysis
July 2010 – October 2010
Short-term DBA role supporting capacity planning, RMAN and OBIEE implementation for healthcare analytics.
Tech Stack: RMAN, OBIEE, Oracle 11g, Capacity Planning, Red Hat, Storage Configuration
  • Performed capacity planning and storage configuration to align database resources with projected application growth.
  • Designed hardware configurations and multi-tier physical architectures to support an Agile PLM Business Intelligence rollout.
  • Implemented RMAN backup and recovery procedures; executed restore tests to validate backup integrity for analytics datasets.
  • Developed OBIEE physical, business and presentation layers with BI teams and validated end-to-end reporting flows.
  • Wrote complex queries, procedures and functions to support data analysis and reporting requirements for business users.
  • Documented architecture and test results for handoff to operations and BI teams, enabling repeatable environment builds.
AC NIELSEN
Green Bay, WI
Sr. DBA Lead / Apps DBA / Architect
April 2007 – June 2010
Led DBA activities for consumer and ecommerce applications, EBS installs and HA database support across UNIX/Linux platforms.
Tech Stack: Oracle EBS, RAC, Data Guard, ASM, Red Hat, AIX, Performance Tuning
  • Architected and supported ecommerce J2EE database components and coordinated with development teams on data model design.
  • Installed and configured Oracle EBS and managed migrations from 11i to R12; supported schema and application compatibility work.
  • Implemented RAC, Data Guard and standby servers with ASM on Red Hat, AIX and HP-UX to ensure high availability.
  • Performed performance tuning, indexing and partitioning to optimize response for large-scale public-facing applications.
  • Worked with business stakeholders to gather requirements and translate into logical and physical data models for analytics.
  • Documented and standardized DBA processes, enabling consistent deployment and monitoring across multiple environments.
ORACLE CORP / KROGER
Cincinnati, OH
Sr. Oracle Database Administrator
January 2007 – March 2007
Short-term assignment focusing on replication, backup strategy and performance optimization for enterprise Oracle systems.
Tech Stack: Oracle Streams, RMAN, AWR, Statspack, TKPROF, Explain Plan
  • Planned and implemented Oracle Streams as a strategic replication solution to support integration and distribution requirements.
  • Designed and executed RMAN full, incremental and cumulative backup strategies and validated recovery procedures.
  • Restructured production schemas and storage to improve performance while meeting business and application requirements.
  • Optimized database performance with Statspack/AWR analysis, explain plans and TKPROF-based SQL tuning.
  • Implemented indexing, storage adjustments and spatial partitioning to improve query performance for large datasets.
  • Collaborated with application teams to align database optimizations with business use-cases and reporting needs.

Education

Osmania University
PGDM - Information Systems & Computer Applications • 1998 – 2000
Osmania University
Bachelor Degree in Civil Engineering • 1991 – 1995

Certifications

Oracle Certified Professional (OCP) – Admin I, Admin II, Oracle RAC — Oracle
Microsoft Certified Professional (MCP) Windows NT server & workstation — Microsoft
EXIN ITIL Foundation Certificate – IT Service Management — EXIN

Powered by Drivetube · Create your own profile at drivetube.ai