Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Beulah Manohara Cheda

Beulah Manohara Cheda

Mechanicsburg,PA

Summary

Personable and detail-oriented Oracle Database Administrator with 16 years of experience installing, administrating, and troubleshooting Oracle 19c, 12c, 11g, 10g, and 9i across OLTP, OLAP, and Data Warehousing (DW) environments. Highly skilled in SQL, performance tuning, backup and recovery strategies, and disaster recovery solutions, with a solid understanding of data security protocols. Adept at managing clustered (RAC) and non-clustered databases, including ASM-based storage, across production, development, and testing servers. Committed to optimizing database systems to ensure data integrity, operational efficiency, and business continuity, while implementing scalable, high-performance solutions such as Oracle GoldenGate replication and Oracle Data Guard disaster recovery configurations tailored to organizational goals.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Database Administrator

Estee Lauder
05.2021 - Current
  • Delivered expert production DBA support for Oracle 19C/12CRAC Multi-Node configurations, ensuring high availability and performance in mission-critical environments.
  • Spearheaded database deployments across development, QA, test, and production environments, driving seamless integration and system stability.
  • Configured and installed Oracle database servers from scratch, managing complex configurations on security, scalability, and efficiency.
  • Engineered robust ASM-based database storage solutions, ensuring optimal performance, reliability, and rapid recovery.
  • Implemented Oracle GoldenGate Replication for real-time data synchronization across distributed systems.
  • Orchestrated major Oracle upgrades and patching, enabling seamless transitions to new releases while minimizing downtime.
  • Designed and maintained Oracle Data Guard environments, delivering robust disaster recovery solutions with periodic switchovers and failovers.
  • Defined and executed advanced backup and recovery strategies using RMAN and Data Pump, ensuring near-zero data loss in critical scenarios.
  • Optimized database storage structures with advanced security protocols, exceeding compliance requirements and enhancing data integrity.
  • Automated DBA tasks with Linux/Unix shell scripting, significantly improving operational efficiency.
  • Resolved database performance bottlenecks proactively, ensuring uninterrupted operations and optimized system performance.
  • Expert in advanced database concepts, including partitioning, Data Guard, and distributed queries (DBLinks), delivering scalable and robust solutions.
  • Designed and implemented scalable database architectures and data models, driving innovation and adaptability in data-driven initiatives.
  • Authored comprehensive DBA activity documentation, ensuring operational transparency and consistency.

Sr. Oracle/ SQL Server DBA

Concentrix
12.2014 - 12.2019
  • Production DBA Support for12c/11g/10g RAC Multi Node configuration
  • Perform database deployment in development, QA, Test, and Production environments
  • Maintain, monitor, and administer Oracle database servers, including daily monitoring, troubleshooting, and performance analysis of the system
  • Configured and installed Oracle database server from scratch in nominal to complex configurations
  • Managing databases storage including ASM, backups and recovery & general maintenance of Oracle databases etc
  • Implemented Golden Gate One Way Replication
  • Plan and implement Oracle upgrades and patching to include new major releases, patch set
  • Hands-on experience in Linux/Unix shell scripting
  • Strong understanding of partitioning, data guard, distributed query (dblinks)
  • Develop high level DB Performance Reports with Recommendations for future Capacity Planning works
  • Migration, Upgrade works of all critical Production Databases from9i to11g and10g RAC/Non-RAC/10g RAC and on different OS platforms (HP-UX, Linux4
  • X/3.x, Sun Solaris UNIX, Windows)
  • Setup and Maintain Oracle Data Guard for Disaster recovery as well as support periodic switchover
  • Manage and support various backup and recovery strategies for Oracle databases (RMAN, Data Pump, and Standby databases) Creating storage database structures with high-level security features
  • Altering storage structures to meet the evolving needs of the company
  • Setting up database user accounts
  • Training users on how to access the information in the database
  • Finding and debugging malfunctioning programs affecting the database integrity
  • Creating autonomous database backups
  • Regularly updating the database security protocols
  • Worked on all document process, related to all regular DBA activities
  • Exposed to Azure administration work
  • SQL Server Responsibilities:
  • MS SQL Server2000,2005,2008 and2012 installations, configuration, and administration Support more than150 SQL Servers and300+ databases
  • SQL Server upgrades from2000 to2005,2005 to2008
  • Installing service packs for SQL Server2000,2005 and2008
  • Upgraded SQL Server200532-bit to64-bit fail over cluster
  • Installed SQL Server2005 fail over cluster on Windows Server2008 R2
  • Having experience in Migrating on Premises SQL Databases to SQL Azure
  • Configured on-premises Sql database backups to Azure using Microsoft Azure Backup tool
  • Experience in working with databases ranging from1MB to1TB
  • Implementing and supporting high availability SQL Server solutions that include Log shipping, Mirroring and Clustering Creating and maintaining schedule jobs and Maintenance plans
  • Troubleshooting performance issues and fine-tuning queries and stored procedures
  • Developed scripts to monitor jobs from a centralized server
  • Developed scripts to monitor log files and data files from a centralized server
  • Developed capacity planning scripts to monitor drive free space along with the data file size from a centralized server
  • Exposed to Azure administration work
  • Providing24X7 on call support and problem resolution

Oracle DBA

Wipro Technologies
04.2008 - 12.2014
  • Installation, configuration, and maintenance of Oracle10g &11g RAC database on Linux
  • Administered and monitored100+ high availability Oracle databases in11g, and10g on prod/test/dev
  • Worked on10g/11g Real Application Cluster (RAC), Configured and Troubleshooting Real Application Clusters11g for single point of failure
  • Adding a new node to existing cluster for minimizing the downtime, maximizing availability, and achieved load balancing by minimizing the interconnect traffic
  • Administering Oracle Databases10g/11g of sizes ranging from100GB to5TB
  • Migrated databases from Filesystem to Automatic Storage Management (ASM)
  • Involved in migrating applications from Solaris10g/11g to Linux11.2.0.3
  • Up-gradation of single instance databases from10.2.0.x to11.2.0.3 on Linux
  • Responsible for using Flashback query mechanism along with automatic undo management
  • Experience in Creating Physical and logical database design Data Models using Erwin Tool
  • Installed12C grid control and Used Oracle Enterprise Manager (OEM) Grid control11g/12c for monitoring databases
  • Created Statistic jobs using DBA_SCHEDULER
  • Enabled/Disabled scheduler jobs using DBMS_SCHEDULER package
  • Involved in Mass Agent Deployment using Oracle Enterprise Manager12c
  • To ensure high availability, implemented Data Guard with maximum availability and performance configurations for16 production databases
  • Worked on11g new feature Active data guard with Data Guard Fail over and Switchover cases
  • Hands on Experience in SQL Tuning and SQL Optimization
  • Created Oracle Tables, Table Partitions, Views, and Materialized Views
  • Worked on database security Transparent Data Encryption & Created tables with Encrypted Columns and Managed Encryption Keys
  • Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation
  • Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database
  • Cloned schemas, objects and data on new server using Data pump
  • Created tables with11g new features Interval, Reference and System partitioning and used OLTP compression for tables to eliminate Overhead for write operations
  • Decreased Contention by reducing the Wait Events as a part of Performance Tuning
  • Implemented Backup and Recovery Strategies using RMAN and used11g new feature Recovery advisor to repair data block corruptions & data dictionary corruptions
  • Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports
  • Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers
  • Involved in Tuning Query's, Stored procedures by making use of PL/SQL collections and its BULK FETCH and BULK INSERT features
  • Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly
  • Exceptional communication and interpersonal skills and ability to work efficiently as a part of the team and individually Possessing excellent development and analytical skills
  • Involved in24x7 production database maintenance and on-call support
  • Environment: Oracle10g,11g,12c,19C, RHEL5/6, SOLARIS, AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL
  • LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps, Exports/Imports, SQL Server, Azure

Education

Bachelor of Engineering - Electronics And Communication Engineering

Jawaharlal Nehru Technological University
India
01-2007

Skills

  • Operating Systems: Red Hat Linux RHEL21,3x,4x ,5x,6x, HP-UX10x,11x, Sun Solaris90/100, AIX51,52
  • Database: Oracle19c/12c/11g/10g/9i, Oracle11g/10g Real Application Cluster (RAC), ASM, M, Multi-Tenancy Architecture, PostGres
  • Languages: SQL, PL/SQL, UNIX Shell Scripting, T SQL, Python
  • Tools/ Utilities: RAC, OEM Grid Control, SQL
  • Loader, ASM, SQL Server, Goldengate, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OEL, BMC remedy, Pac2000, VMware, Log-miner, Cron-Tab, Erwin, AUTOSYS, TDE
  • Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Profiler, Data Tuning Advisor, Execution Plans Performance monitor, Activity monitor
  • Terminal Emulation: Putty, Telnet, FTP, TOAD, Secure CRT
  • Cloud: Microsoft Azure

Certification

  • Oracle Database12c Administrator Certified Associate.
  • Oracle Database12c Administrator Certified Professional.

Timeline

Database Administrator

Estee Lauder
05.2021 - Current

Sr. Oracle/ SQL Server DBA

Concentrix
12.2014 - 12.2019

Oracle DBA

Wipro Technologies
04.2008 - 12.2014
  • Oracle Database12c Administrator Certified Associate.
  • Oracle Database12c Administrator Certified Professional.

Bachelor of Engineering - Electronics And Communication Engineering

Jawaharlal Nehru Technological University

Similar Profiles

  • Mona Abizeid

    Mona AbizeidMona Abizeid

    Scientist at Estee LauderScientist at Estee Lauder

    View Profile
  • Shelby Young

    Shelby YoungShelby Young

    Account Executive at Estee Lauder CompaniesAccount Executive at Estee Lauder Companies

    View Profile
  • Premetha Passu Davan

    Premetha Passu DavanPremetha Passu Davan

    Senior FP&A Analyst at The Estee Lauder CompaniesSenior FP&A Analyst at The Estee Lauder Companies

    View Profile
Beulah Manohara Cheda