Prachi Sawant
Pune ,Maharashtra
Summary
Experienced Oracle DBA with a proven track record at Veritas Technologies LLC, adept in Oracle database administration, including upgrades and security enhancements. Excelled in automating DBA tasks and leading critical projects to success. Demonstrates strong problem-solving skills and a commitment to maintaining business continuity. Recognized for expertise in backup and recovery, alongside effective team collaboration.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Oracle DBA
Veritas Technologies LLC
Pune, Maharashtra
01.2023 - Current
- Built a complete new environment for Broadcom's Applications Manager scheduler (Appworx) from scratch, as part of the EBS upgrade project, ensuring seamless integration and functionality.
- Migrated databases from one platform to another using tools like export and import, datapump.
- Managed Oracle databases, including upgrading 12c databases to 19c.
- Leveraged tools including Dbcli, dbca, dbua, Goldengate, expdp, impdp, adpatch, and adop.
- Automated daily DBA tasks using shell scripting and cron jobs.
- Created Severity TARs/SR and conducted OWC sessions with Oracle support to resolve critical issues promptly.
- Implemented SSL/TLS in Oracle EBS Apps and managed security certificate imports.
- Performed Oracle Application Pre-patch analysis using Patch Wizard in Oracle Applications Manager and applied patches.
- Performed database refreshes.
- Provided 24x7 support during month-end, quarter-end, and year-end closures, maintaining business continuity.
Oracle DBA Intern
Veritas Technologies LLC
Pune, Maharashtra
01.2023 - 06.2023
- Developed an application that now serves as an inventory for the DBA team, storing various types of information such as database, server, or application details in one centralized location.
- Hands-on development using Oracle APEX.
- Performed installation and configuration of Oracle 19c database, Oracle APEX 22.2, ORDS 22.4, and WebLogic 14c.
- Created users, tablespaces, and databases in Oracle 19c.
- The project was selected as one of the top 10 projects from a total of 52 submissions.
- Assisted in the installation of Oracle Database 12c on multiple servers and configured parameters to meet customer requirements.
Associate Software Engineer
ATCS
Mumbai, Maharashtra
11.2019 - 08.2021
- Strong experience with Postgres functions, procedures, optimization, and performance tuning. Wrote scripts to execute SQL queries.
- Provided technical support for database systems, troubleshooting, and resolving system inefficiencies in a timely manner.
- I was the only responsible person for the database in my project.
Education
Master of Science - Data Science And Big Data Analytics
MIT-WPU
Pune06-2023
Bachelor of Science - Computer Science
Somaiya Vidyavihar
Mumbai06-2019
Skills
- Oracle Database administration
- Backup and recovery
- Oracle software installation
- RMAN
- Weblogic
- Clonning
Certification
- Oracle Cloud Infrastructure 2023 Foundations Associate. (Oracle - 2023)
- Programming for Everybody (Getting Started with Python). (Coursera - 2021)
Languages
English
Professional
Hindi
Professional
Marathi
Professional
Timeline
Oracle DBA
Veritas Technologies LLC
01.2023 - Current
Oracle DBA Intern
Veritas Technologies LLC
01.2023 - 06.2023
Associate Software Engineer
ATCS
11.2019 - 08.2021
Master of Science - Data Science And Big Data Analytics
MIT-WPU
Bachelor of Science - Computer Science
Somaiya Vidyavihar
Similar Profiles
Joann NeveJoann Neve
Sr. Program Manager / Leader Engineering Cloud and Engineering Operations at Veritas technologies, LLC/CohesitySr. Program Manager / Leader Engineering Cloud and Engineering Operations at Veritas technologies, LLC/Cohesity
Sidhesh GawasSidhesh Gawas
MTS-4 (Previously Principal Software Engineer) at Cohesity (Previously Veritas Technologies LLC)MTS-4 (Previously Principal Software Engineer) at Cohesity (Previously Veritas Technologies LLC)
Justin LewisJustin Lewis
Sr. Principal Information Security Analyst at Cohesity (acquired Veritas Technologies LLC.)Sr. Principal Information Security Analyst at Cohesity (acquired Veritas Technologies LLC.)
Pratik JunwarPratik Junwar
Senior Technical Support Engineer at Veritas Technologies LLCSenior Technical Support Engineer at Veritas Technologies LLC
Shyam KhamkarShyam Khamkar
Unit Manager - Data Science and Analytics at Bajaj FinservUnit Manager - Data Science and Analytics at Bajaj Finserv