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
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.