Summary
Overview
Work History
Education
Skills
Certification
Languages
Personal Information
Timeline
Avni Ajinkya Raut

Avni Ajinkya Raut

Irving

Summary

Accomplished Oracle Database Engineer with extensive experience at JCPenney, specializing in database upgrades and performance optimization. Demonstrated expertise in RMAN and Oracle RAC administration, complemented by exceptional communication skills. Spearheaded initiatives that improved operational efficiency and minimized downtime, ensuring seamless database management across diverse environments. A proven track record of working in a fast-paced environment. Resourceful professional in data architecture, known for high productivity and efficient task completion. Specialize in database design, data modeling, and information management systems. Excel in problem-solving, communication, and teamwork, ensuring successful project outcomes.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Oracle Database Engineer

JCPenney
Plano
03.2023 - 04.2025
  • Company Overview: JCPenney is one of the America's largest apparel and home furnishing retailers with more than 750 stores and jcp.com.
  • Responsible for performing Oracle database administration tasks such as, User Management, Export/Import task, DML and DDL script execution.
  • Responsible for performing Oracle EBS task such as, Database cloning, User management, Security management.
  • Responsible for performing task for Snowflake, User Management, Schema Refreshes.
  • Perform Oracle database upgrades and patches.
  • Perform Grid Infrastructure upgrades.
  • Perform Media Management Layer (ddboost) upgrades used for RMAN backup.
  • Identify performance issues, recommend/implement performance improvements.
  • Perform/schedule database maintenance, maintain/execute backup and recoveries.
  • Perform database on-call functions and participate in routine planned support and project activities.
  • Work closely with data modeler and cross-functional team to deliver solutions to business.
  • Analyze trends to proactively prevent problems.
  • Work with cross-functional teams across different geographies.
  • Managing Teradata RDBMS.
  • JCPenney is one of the America's largest apparel and home furnishing retailers with more than 750 stores and jcp.com.

Oracle EBS DBA Manager

Videojet Technologies
Mumbai
08.2021 - 12.2022
  • Company Overview: Videojet Technologies is a world-leading manufacturer of coding and marking solutions.
  • Define, prioritize, and lead projects to upgrade and modernize the technical architecture and infrastructure.
  • Identify and execute on opportunities for process improvement around operations, security, and disaster recovery.
  • Support mission critical production and non-production support in a 24X5 environment.
  • Support key business projects, including upgrades, new EBS modules, and acquisition/integrations.
  • Manage and mentor the DBAs to increase both team and individual capabilities.
  • Videojet Technologies is a world-leading manufacturer of coding and marking solutions.

DBA Lead

Capgemini
Mumbai
06.2015 - 08.2021
  • Company Overview: Support GE-Aviation database which has more than 500+ Distinct Business which is supported by database technologies like Oracle.
  • Define, prioritize, and lead projects to upgrade and modernize the technical architecture and infrastructure.
  • Creation of database structures such as instances, schemas, partitions, indexes, triggers, views and other objects including procedures and packages that are required by the application.
  • Initiate service calls with database providers when issues are related to database technology structure.
  • Initial creation of file systems, databases and schemas.
  • Proactive monitoring of space usage and proactive addition of space as required.
  • Recommendations where space can be reduced or eliminated.
  • Implement, perform, and enhance backup procedures according to database Service Provider and industry best practices.
  • Review of current backup strategy and schedules and propose improvements.
  • Fully document backup plan and maintain documentation updates/revisions.
  • Determine root cause of backup failures and take corrective actions.
  • Reschedule failed backups.
  • Analyze backup trends and make recommendations to improve.
  • Perform special requested backups (typically during upgrades or refreshes).
  • Proactively respond to backup alerts including permanent resolution across the environment for systemic issues.
  • Implement, perform, and enhance recovery procedures according to database Service Provider and industry best practices.
  • Perform database restoration as required per agreed-upon timeframe.
  • Perform schema level/table level refreshes with Datapump utility.
  • Perform ongoing tuning of database objects and structures to improve operational efficiency as measured by decreased processing time, space, or downtime.
  • Analyze databases that utilize inefficient SQL and coordinate with application teams to improve.
  • Check for and repair fragmentation.
  • Proactively look for significant tuning issues and resolution.
  • Respond to monitored events, problems, and alarms per SLA requirements.
  • Utilize GE Aviation monitoring tools such as Oracle Enterprise Manager (OEM) to monitor database components.
  • Add, modify, and delete accounts in compliance with GE Aviation standards.
  • Change and reset passwords in compliance with GE Aviation standards.
  • Complete requests from production to non-production environments including pre-clone, clone, and post-clone.
  • Complete all required activities to upgrade Oracle databases.
  • Migration of ON-PREM databases to Amazon (AWS) rds and EC2 instance using DATAPUMP utility.
  • Database Upgradations from older versions to 11g,12c,19c.
  • Support GE-Aviation database which has more than 500+ Distinct Business which is supported by database technologies like Oracle.

Senior DBA

Future Focus Infotech
Mumbai
03.2014 - 06.2015
  • Company Overview: Worked for client TCS on their project with Shipping Corporation of India.
  • Installation of Oracle 11g Express Edition (Database installation) with the help of batch script and vbscript.
  • Creation of Tablespace.
  • Creation of Schema.
  • Creation of database objects like tables, sequence, triggers.
  • Scheduling of RMAN backup job through DBMS scheduler.
  • Scheduling of EXPORT backup job through DBMS scheduler.
  • Code Migration.
  • Export/Import.
  • Restoration with RMAN backup.
  • Restoration with Export Backup.
  • Tablespace monitoring.
  • Troubleshooting user queries/issues and building a resolution plan accordingly.
  • Creation and maintaining documents.
  • Worked for client TCS on their project with Shipping Corporation of India.

Oracle Apps DBA

Sai Service Station Ltd.
Mumbai
04.2012 - 02.2014
  • Company Overview: The Sai Service Group is the largest selling Maruti Suzuki dealership authorize to sell Maruti Suzuki vehicles in India.
  • Support and manage Oracle EBS Application and Database including upgrades, cloning, monitoring and tuning the operating environment, co-ordinating/executing all code migrations.
  • Apply Patches and perform implementations, installations and upgrades as required, while working closely with Oracle Support to resolve any issues.
  • Opening, Managing, and Resolving Oracle SRs (Troubleshooting of issues raised by users and provide timely resolutions), via a thorough understanding of Oracle Apps technical environment.
  • Full Applications support, including Installation and Cloning of Applications, as well as System Administration and Troubleshooting, Backups, Refreshes and Non-Production Clones.
  • Troubleshooting issues related to Apache, Applications stack and DB.
  • Perform Apps / DB Bounces, Applying Data fixes, Setting up Debug logs, Gathering Schema Statistics, Running RDAs (Remote Diagnostic Agent), Opatch and AD Utilities, collecting logs and traces & other DB commands.
  • Work in flexible shifts from 8:00AM IST to 9:00PM IST and as when required and demanded by the project.
  • The Sai Service Group is the largest selling Maruti Suzuki dealership authorize to sell Maruti Suzuki vehicles in India.

DBA

KPIT-Cummins
Pune
10.2009 - 03.2012
  • Company Overview: Worked for client Cummins for the following Business Units: Cummins Parts and Service Business Unit, Cummins Engine Business Unit, Cummins Corporate IT.
  • Security Administration by creating Users with appropriate Roles and Privileges and generating Sarbanes-Oxley Act (SOX) report.
  • Creating Users, Granting Privileges to Users and allocating Space.
  • Managing Tablespaces.
  • Regularly watching System logs, Alert logs to know types of bottlenecks recorded if any and rising to encounter them.
  • Preparation of weekly and monthly maintenance schedules.
  • Providing support to end users and developers.
  • Audited different users for suspicious activities.
  • Monitoring database performance and manages statistics of database object for performance.
  • Responsible for creating new Schemas in the database.
  • Creating primary database objects (tables, views, indexes).
  • Worked as a part of a team and provide 24/7 production support.
  • Worked for client Cummins for the following Business Units: Cummins Parts and Service Business Unit, Cummins Engine Business Unit, Cummins Corporate IT.

Education

B.E. - COMPUTER

BHARATI VIDYAPEETH COLLEGE OF ENGINEERING, Navi Mumbai
06.2008
GPA: First Class

Skills

  • Database administration for Oracle 8i,9i,10g,11g,12c,19c
  • Installation and maintenance of Oracle Databases
  • Replication tools like ORACLE GOLDEN GATE
  • Oracle RAC database administration
  • Operating system expertise in MS-Windows, UNIX/Linux, Sun Solaris, RHEL
  • DATAGAURD configuration for Standby databases
  • Database backup and recovery with RMAN
  • Logical backups with DATAPUMP
  • Database patching
  • Database upgradation
  • Monitoring Oracle Databases with OEM
  • Oracle Database migration from On-Prem to AWS EC2 and RDS instances
  • Shell scripting
  • Windows batch scripting
  • Raising TAR with Oracle Support Metalink
  • Excellent Communication skills, Coordination

Certification

  • Oracle OCA 11g Certification Examination
  • ITIL foundation

Languages

  • English
  • Marathi
  • Hindi

Personal Information

  • Date of Birth: 08/28/86
  • Nationality: Indian
  • Marital Status: Married

Timeline

Oracle Database Engineer - JCPenney
03.2023 - 04.2025
Oracle EBS DBA Manager - Videojet Technologies
08.2021 - 12.2022
DBA Lead - Capgemini
06.2015 - 08.2021
Senior DBA - Future Focus Infotech
03.2014 - 06.2015
Oracle Apps DBA - Sai Service Station Ltd.
04.2012 - 02.2014
DBA - KPIT-Cummins
10.2009 - 03.2012
BHARATI VIDYAPEETH COLLEGE OF ENGINEERING - B.E., COMPUTER

Similar Profiles

CREATE PROFILE
Avni Ajinkya Raut