MOOKESH SUBRAMANIAN

Technical skillsets:

● Operating System Unix,Linux

● Database Oracle 19c,12C,11g, 10g, 9i

● Languages SQL

● Tool / Utility AWR Reports, OEM, RMAN, expdp, impdp, TKprof, Data Guard, ASM, RAC, Performance Tuning

● OS Utilities FTP, SCP, Win SCP, SSH, Putty, Telnet.

• Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
• Optimized database performance through regular maintenance, tuning, and optimization activities.
• Collaborate with business, developers and DBAs to design and validate architecture solutions
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Implementing DDL/DML in database through Servicenow ticket from SVN repository or GitHub repository.
• Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
• Worked with customers and other third parties to support DBA functions.
• Reviewed database design to recommend enhancements or improvements.
• Participated in situation management of incidents to support database operations.
• Engaged myself in improving performance of the query especially poor performance and reporting the same.
• Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
• Developed automated processes to manage database creation in virtualized or cloud environment.
• Doing data refresh between prod and development environments based on the business requirement using data pump.
• Managing and mentoring team to use proper SOP to work efficiently with near zero error.
• Documenting and implementing audits and standard operating procedure.

Technical skillsets:

● Operating System Unix, AIX, SunOS, Red Hat Linux RHEL 4.x, 5.x, 6.x, windows and Windows XP/2003/2008 Server

● Database Oracle 19c,12C,11g, 10g, 9i

● Languages SQL

● Tool / Utility AWR Reports, OEM, RMAN, expdp, impdp, TKprof, Data Guard, ASM, RAC, Performance Tuning

● OS Utilities FTP, SCP, Win SCP, SSH, Putty, Telnet.

• Provide 24/7 support for both Production and development database systems.
• Creation and Maintenance of Oracle Databases as per the requirement.
• Creating shell scripts for standby status check and monitoring space.
• Supporting implementation of ASM patching and upgrade.
• Trouble-shooting database impacting SQL queries using OEM, AWR and ADDM.
• Engaged and supporting in database migration activity from pureflex to exadata and exadata to exadata servers.
• Creation of Schema with Quota maintenance , roles and privileges.
• Creating and managing Profiles and Passwords.
• Monitoring database growth and backup logs.
• Refresh of Table, Schema and Database using RMAN and DATA PUMP.
• Taking performance report on daily and weekly basis.
• Performed logical backups using RMAN and DATA PUMP.
• Proposed database changes to ease monitoring and administrative
• Worked with customers and other third parties to support DBA functions.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Troubleshoot database issues to create and resolve trouble tickets.

• Company Overview: CLIENT: The Hartford – Insurance BU - USA 11/2017 – 10/2020 | Remotely from Coimbatore. India
• Comprehensive knowledge on Oracle Architecture.
• Worked on Performance tuning such as analysis of Long running & Database slowness and Capacity Monitoring, etc.
• Knowledge in RAC Architecture.
• Good experience in change management - patching activities.
• Experience in Datafix (Prod&Non-Prod) script execution activities.
• Knowledge in Automatic Storage Management.
• Handled Release in Production environment.
• Worked on Table Reorg and Stats Gather.
• Worked on Kill DB Session and Process ID.
• Knowledge in Object Logical Backup and Autosys Job monitoring.
• Worked on Oracle SR Creation and followup.
• Have experience in 1view and Contrat Pull.
• Worked in Shareplex Activity.

• Collaborated with cross-functional teams to develop innovative solutions for complex technical problems.
• Implemented proactive monitoring systems that minimized potential technical issues before escalating into critical incidents.
• Participated actively in continuous learning opportunities to maintain proficiency in relevant technologies and methodologies.
• My key role is about product design in modelling softwares and coding using arduino.
• Provided remote support for product functionality, maintenance and troubleshooting.
• Provided technical support throughout development phases of new products.
• Collaborated with team members in virtual environments to optimise field experience and development capabilities.
• Ensured data security by implementing stringent backup protocols, safeguarding vital company information from loss or corruption.
• Identified opportunities for process improvement by analyzing current workflows and suggesting strategic enhancements.