Dhivya Kumaravadivel
Halifax,NS
Summary
Experienced Oracle Database Administrator seeking a challenging position where I can utilize my skills and expertise in managing, maintaining, and optimizing Oracle databases to contribute to the success of the organization. Experienced Oracle Database Administrator with strong background in managing, developing and optimizing database solutions. Skilled in performance tuning, backup/recovery procedures, and data migration strategies. Exceptional problem-solving abilities used to troubleshoot complex technical issues while improving system efficiency and reducing downtime. Successfully implemented thoughtful database design strategies resulting in improved operational performance in previous roles.
Overview
10
10
years of professional experience
Work History
I.T.Analyst - C2
Tata Consultancy Services
Bangalore, India
04.2021 - 01.2024
- Database Administration: Administered multiple Oracle databases, ensuring high availability, reliability, and security across various platforms.
- Installed, configured, and upgraded Oracle database software and implemented robust backup and recovery strategies using RMAN and Data Pump.
- Conduct regular patching and maintenance activities to keep databases up to date with the latest security patches and bug fixes.
- Performance Monitoring: Monitored and optimized database performance using Oracle Enterprise Manager (OEM), AWR reports, and other diagnostic tools such as Tkprof, ADDM, and ASH.
- Oracle RAC Administration: Administered and managed Oracle RAC environments, ensuring high availability and scalability.
- Disaster Recovery: Implemented and maintained Oracle Data Guard for disaster recovery and participated in regular maintenance activities, like switchover/failover.
- Capacity Planning: Participated in database capacity planning and forecasting to ensure optimal performance and scalability.
- 24/7 Support: Provided 24/7 support for critical database systems, including being part of an on-call rotation to address urgent issues promptly.
- Collaboration: Collaborated with development teams to design and implement database solutions for new applications, and managed the upgrade/migration of databases from Oracle 11g to 12c.
- E-Business Suite Management: Administered Oracle E-Business Suite applications, including Financials, HRMS, and Supply Chain modules, managing user access, applying patches, and performing application cloning and refreshes.
- Configured and maintained concurrent managers, workflow processes, and other system components to support business operations.
- Provided technical support and troubleshooting for Oracle EBS issues, working closely with functional users and developers to resolve issues in a timely manner.
- Developed and maintained documentation for database configurations, procedures, and troubleshooting guidelines.
- Migrated EBS workflow mailer from Cloud to On-Premise.
- Application and Middleware: Experience with Oracle Retail Stack, WebLogic, and IBM WebSphere Application Server.
- Applied quarterly WebLogic patches and managed database objects and forms deployment in production environments.
- Goldengate and Troubleshooting: Handled database troubleshooting and maintenance activities in Goldengate, including resolving thread abended and lag issues, and monitored Appworx batches.
Software Consultant
Caritor Solutions India Private Limited
Bangalore, India
06.2018 - 04.2021
- Installation and Configuration: Installed and configured Oracle Database and client machines, ensuring optimal setup and performance.
- Backup and Recovery: Implemented comprehensive backup strategies, including Data Pump utilities for logical backups and scheduled weekly physical backups. Managed backup and recovery operations using expdp/impdp, cold, and hot backups.
- Performance Monitoring: Evaluated database performance using STATSPACK and AWR reports to ensure efficiency.
- Standby Databases: Maintained physical standby databases to ensure high availability and disaster recovery readiness.
- Monitored and resolved archive log gaps between production and standby databases.
- Database Management: Oversaw tablespace and datafile sizing, user creation, and quota management. Maintained a physical standby database to ensure high availability.
- Client Support: Provided 24/7 support for 70 depots across the state and head office databases, demonstrating my commitment to reliable and responsive service.
- My ability to handle complex database environments and perform crucial tasks, such as performance tuning, backup management, and user administration, has consistently contributed to the stability and efficiency of the databases I manage.
Oracle Database Administrator
4SPL Technologies India Private Limited
Bangalore, India
07.2014 - 03.2018
- Monitoring and Alerts: Efficiently managed alerts related to database availability, tablespace usage, and backup processes, ensuring proactive issue resolution.
- Backup and Recovery: Implemented robust backup and recovery strategies for production databases using exp/imp utilities, as well as cold and hot backups. Ensured data integrity through precise backup and restoration procedures.
- Database Refreshes: Executed database refreshes for non-production environments from production databases using hot or cold backups, optimizing development and testing environments.
- Client Installation: Managed Oracle client installations and configurations, ensuring seamless connectivity and performance.
- Standby Databases: Maintained physical standby databases to ensure high availability and disaster recovery readiness.
- Performance Analysis: Analyzed AWR and STATSPACK reports to evaluate database performance and executed query tuning using explain plans for optimization.
- Database Management: Conducted schema and table-level refreshes and managed database structures, including tablespace and datafile sizing, to meet evolving business needs.
Education
Master of Computer Applications -
Skills
- Oracle 10g, 11g, 12c Database Administration
- Database Installation, Configuration, and Upgrades
- Backup and Recovery (RMAN, Data Pump)
- Performance Tuning and Optimization
- Oracle Enterprise Manager (OEM)
- SQL and PL/SQL
- Oracle Data Guard
- Oracle RAC (Real Application Cluster)
- Unix / Linux Shell Scripting
- Experience in Oracle E-Business Suite / Oracle Applications
- Oracle E-Business Suite Administration (R12)
- Oracle Applications DBA (AD Utilities, Patching, Cloning)
- Oracle Workflow and Concurrent Manager Administration
- Troubleshooting and Problem Resolution
- Strong Analytical and Communication skills
Accomplishments
- Special Achievement Award to successfully leading a EBS workflow mailer migration from Cloud to On-Premise
Timeline
I.T.Analyst - C2
Tata Consultancy Services
04.2021 - 01.2024
Software Consultant
Caritor Solutions India Private Limited
06.2018 - 04.2021
Oracle Database Administrator
4SPL Technologies India Private Limited
07.2014 - 03.2018
Master of Computer Applications -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Arian LoshiArian Loshi
Patron Safety Member at Legendary HospitalityPatron Safety Member at Legendary Hospitality