Application and Database Admin Sr Associate

• Aug 2020 - Present

Sr Oracle DBA

• Feb 2020 - Aug 2020

Senior Consultant

• Jun 2016 - Feb 2020

Over 8 years of IT experience in Linux, Oracle, Sybase, Oracle DBA, Oracle Enterprise manager(OEM) ● ● Implemented backup and recovery procedures of databases in AIX and Red Hat Linux environment using Export/Import and RMAN. ● Monitoring database alerts from OEM and resolving database related issues. ● Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities. ● Handling the User management and managing table spaces, data files, redo logs, tables and its segments. ● Maintaining data integrity also managing profiles, resources and password security. ● Installation of Oracle software and patches. ● Upgrading the Database from lower version to higher version. ● Creating physical and logical standby database from OEM. ● Converting physical to logical and snapshot standby databases ● Configuring post installation tasks for the database like installing agents in OEM, configuring backups in cron jobs, discovering targets in the console. ● Working on service manager tickets and production changes ● Troubleshooting and managing database backups ● Refresh schema from production to cert/test environments. ● Performing export/import using expdp, impdp as per requirement. ● Incorporating user’s requests as per mails and giving optimum solution within SLA time. ● Created Technical Notes and Documentation. ● Monitoring and supporting day to day activities of the production and development databases and work on urgent issues. ● Monitoring and troubleshooting the golden gate manager/extract processes. ● Handling network issues based on db-links and listener. ● Creating and Modifying the crontabs for cleaning up data like error logs, trace file,older Archive logs, unnecessary files from the server. ● Planning and Execution of Database Purging/ Re-Org /Rebuild activities on the basis of Space availability and Secondary and DR Setup Replication of Purged Data. Show less

Software Engineer

• Feb 2014 - Jun 2016

• Installation and configuration: Installation and configuration of database and OEM 11g/12c on various Operating systems such as Linux and windows. • Administration: Administration of Database and OEM (Monitoring and managing targets from the OEM). • Skilled in managing and creating the new listeners/databases with the help of oracle 11g/12c. • Creating database report to analyze the database performance. • Analyzing AWR, ADDM and AHS reports and tune the database performance. • Familiar with unix cron jobs, unix administration, unix networking configurations like DNS, FTP, DHCP, NFS and etc. • Experience working on ITIL framework. Show less

Oracle database and Unix

• Feb 2011 - Feb 2014

Project 1 This project is an Application support project, where the person has to ensure the good health of all the applications being used by the business users to generate financial reports. At the same time, the support person also needs to deal with the technical deficiencies faced by the business users pertaining to the application, while they perform their regular tasks. ==================================================== Project 2 Project Description This project is an Application and database support project, where the person has to ensure the good health of the application and Database being used by the business users to generate financial reports. At the same time, the support person also needs to deal with the technical deficiencies faced by the business users pertaining to the application and database queries, while they perform their regular tasks. Show less