VIGNESH RAM S M
Chennai
Summary
A qualitative professional with overall 7.2+ year experienced , 4.76 years as an Oracle Database Administrator with expertise in oracle 11g, 12c ,database monitoring, trouble shooting, production support, installation, configuration, patches, upgrades, space management, backup and recovery, RMAN, database security. Experience on oracle database administrator in verity of environments like AIX, REDHAT LINUX & WINDOWS.
24/7 Support of production database services to ensure the highest standards. Hands on experience on user creation, user management, table-space creation, table-space management, data pump (expdp/impdp).
Have experience in working in a production support environment to be able to understand and appreciate the criticality of issues and trouble shoot quickly to meet SLAs to avoid service downtime. Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment. Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).Monitoring of database for growth and performance. Effective troubleshooting of database and Performance problems.
Certified GCP Associate cloud engineer and Oracle foundation associate
Overview
7
7
years of professional experience
Work History
IT Analyst
Tata Consultancy Services Private Ltd
04.2022 - Current
- Agile and waterfall project management.
- Scrum facilitator handling a team of 10 members.
- Developed and implemented IT solutions to streamline business processes.
- Provided support to RTL environments in troubleshooting application issues.
- Engaging the client and business team to improve the performance and efficiency of the application.
- Have implemented best practice approaches in JIRA
- Hands on experience in service now by raising the CR and engaging the third party host teams.
- Google cloud platform associate Engineer Certified.
- Smart Matter Expert within a cross-functional Scrum team to deliver innovative solutions.
- Provided technical guidance and insights on smart materials, enhancing project outcomes and team efficiency.
- Scrum ceremonies facilitator to ensure alignment and continuous improvement.
Oracle DBA
Apps Business IT Solutions Pvt Ltd.
01.2020 - 02.2022
- Ensured high availability and performance (24hr production support,Airport Authority of India,Chennai)
- Continuously monitoring of database performance on OEM 12c grid and alert log for database errors and ensure smooth everything is going smooth and steady
- Proactively monitoring database systems to ensure secure services with minimum downtime
- Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills, Good co-ordination and communication with system administrators, business data analysts and development teams
- Responsible for monitoring databases, diagnosing errors, database health, building, deploy, maintain and troubleshoot databases objects
- Checking daily backups (DB and archive log) and table space report via scheduled reports organized in OEM
- Checking users audit reports to get details about nominative, applicative and system users
- Performing day to day administrator tasks like table space usage, monitoring instances, memory structures, rollback segments, redo logs, checking alert logs, trace files, monitoring disk space usage, table/index analyze jobs
- Creating users and granting them required privileges and roles
- Involve in performance tuning by general health checks and maintenance of databases using AWR report
- Configuration of listeners, TNS names
- Self-starter capability, ability to acquire new skills autonomously
Oracle DBA
Apps Business IT Solutions Pvt Ltd.
04.2019 - 12.2019
- Regular DBA activities like backup, cloning, monitoring and check log & trace files
- Interacting with end-users for oracle application problems and trouble-shooting
- Monitored the growth of table spaces to see the fragmentation and available space for growth
- Monitoring DB alert log errors, Table space usage, Locks in a Database
- Lead small and mid-size DBA team to perform a variety of day-to-day DBA activities
- Periodic data refresh from production to test environments, reorganized database structures
- RMAN backups (Level 0, 1 & archive)
- Engaged in knowledge sharing sessions, mentoring junior DBAs and contributing to the development of a skilled team.
Junior Oracle DBA & Customer Support Executive
Ticketgoose.com
05.2017 - 04.2019
- Diagnosed and resolved critical database issues promptly, minimizing impact on business operations.
- Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
- Enhanced data security by implementing backup and recovery strategies, ensuring minimal data loss.
- Managing table spaces, data files, redo logs, tables and its segments
- DBA activities - backup, monitoring
- Backup and Recovery strategies for Oracle database using exp/imp, cold and Hot backups
- Monitoring DB alert log errors, Table space usage, Locks in Database
- Performed logical backups using Expdp/Impdp
- Configured RMAN backups (Level 0, 1 & archive)
- Experience in OEM (Oracle Enterprise Monitoring) & Database performance monitoring
- Applied patches and upgrades to Oracle database servers, keeping systems up-to-date and secure.
Education
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Chettinad College of Engineering And Technology
Karur, India04-2015
Skills
- Oracle 11g
- Oracle 12c
- Oracle enterprise manager
- RMAN
- Import & export (expdp/impdp)
- PUTTY
- JIRA
- SQL
- Database administrator
- Red hat Linux
- SQL
- PL/SQL
- UNIX
- Agile methodology practice
- Stakeholder engagement
Timeline
IT Analyst
Tata Consultancy Services Private Ltd
04.2022 - Current
Oracle DBA
Apps Business IT Solutions Pvt Ltd.
01.2020 - 02.2022
Oracle DBA
Apps Business IT Solutions Pvt Ltd.
04.2019 - 12.2019
Junior Oracle DBA & Customer Support Executive
Ticketgoose.com
05.2017 - 04.2019
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Chettinad College of Engineering And Technology
Similar Profiles
Paramita PaulParamita Paul
I.T Analyst at Tata Consultancy Services Private LtdI.T Analyst at Tata Consultancy Services Private Ltd
Bharani SairamBharani Sairam
Salesforce Administrator at tata consultancy Services Private LimitedSalesforce Administrator at tata consultancy Services Private Limited
Ravi Kumar VangariRavi Kumar Vangari
Assistant Consultant at TATA Consultancy Services Private LimitedAssistant Consultant at TATA Consultancy Services Private Limited