A dedicated professional, Oracle Database 11g certified Associate (OCA) & Oracle trained Professional with 4+ of experience in Oracle Database administration, Service Delivery and Application Support on Windows, Solaris and Linux Based Servers.
I am currently enrolled in Master's program in Information systems at Northeastern University. My coursework includes Swings (Java) Framework and Web design.
Engineer Oracle DBA @ Roles and Responsibilities :
Responsible for coding, analyzing and troubleshooting production database systems to achieve enhanced performance of CRMNext application.
- Performed database performance tuning and Proactively monitored the database's health.
- Created Oracle databases/Instances as per the requirement.
- Planned and Implemented scheduled backup and recovery strategies of the Oracle database.
- Implemented physical standby database from scratch within dataguard.
- Synchronized the standby database in case of network failure and Switchover activity for role
reversal between primary and standby.
- Managed the archives and flash recovery area.
- Configured RMAN parameters and retention policies.
- Handled the outages in close coordination with global teams.
- Performed database upgrades from 10g to 11g and lower version of 11g to higher version of 11g.
- Applied the latest CPU and PSU patches.
Accomplishments:
- Designed, tested and implemented Oracle high availability solution using Oracle Data guard, flashback technology and cloning and refreshing databases.
- Architected and implemented complete upgrade process for Oracle 10G to Oracle11G and accomplished efficient transaction management with improved PL/SQL performance.
- Tuned I/O, memory, CPU for Oracle 11G using Explain Plan, and TKPROF and achieved CRMNext application performance improvement by the factor of record 750 times.¬¬
- Redesigned a thorough backup and recovery strategy for all major production databases (Oracle 11G/SQL) using RMAN and rectified media failure, user failure and block corruption issues.
- Performed Oracle 11G and SQL server 2012 database testing for windows and web based applications in record 4 months’ time to rollout service for new clients. From August 2013 to September 2014 (1 year 2 months) Noida Area, IndiaEngineer Operations Ist Level Assurance @ Roles And Responsibilities:
Responsible for IPX (Internet payment exchange) messaging and application server monitoring and troubleshooting to achieve highest level of SLAs.
- Developed shell scripts and SQL scripts to automate database operation and database monitoring.
- Listener configuration and registering the required database.
- Performance Monitoring and fine-tuning the database and day-to-day database monitoring activities.
- Involved in Capacity Planning for changes in the size of databases due to business growth.
- Performed physical backups using RMAN and conventional backups..
- Data export and import using datapump.
- Root cause analysis of transaction logs to find the glitch in transactions, captured and analysed
TCP dump towards operator and service providers.
- Track record of Configuration, deployments and troubleshooting Activities of IPX Messaging & Application Servers.
Accomplishments:
- Configured dedicated and shared short-codes for cellular service providers to have auto reply SMS for MO SMS sent by subscribers.
- Developed shell scripts for automating daily database backups and generating monthly transaction reports to reduce man-hours by 4 hours per day.
- Deployed new IPX messaging servers to load balance application traffic for peak hours. From March 2010 to August 2013 (3 years 6 months) Noida Area, India
Master's degree, Information System @ Northeastern University From 2015 to 2017 Bachelor Of Information Technology, Information Technology, A @ Maharaja Agrasen Institute Of Technology From 2005 to 2009 Yamini Sehrawat is skilled in: Oracle, SQL, PL/SQL, Performance Tuning, Unix Shell Scripting, Solaris, Linux, Microsoft SQL Server, RMAN, Database Administration, Database Security, Oracle ASM, SQL*Plus, Databases, Troubleshooting