WS Foods Pvt. Ltd
مجموع سنوات الخبرة :21 years, 5 أشهر
Oracle Database 11gr2, Linux 5.4
Oracle RAC DBA Experience
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing and configuring Oracle clusterware and Database Software (Troubleshooting using cluvfy and handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation and cleanup of clusterware)
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for different RAC related issue: \[hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss and so on\]
• Troubleshoot performance issues for the RAC instances (GC events)
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC.
• Add or Remove Node from RAC.
Oracle DBA Experience
• Migrated Non-ASM Single Instance to ASM RAC Instance
• Manage RAC environment for Day to Day Database administrator, Performance Tuning
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Experience with databases running on UNIX (HP-US, Sun Solaris, AIX)/Linux (RedHat)
• In-depth knowledge of Oracle internals and architecture.
• Experience in installation, configuration and administration of Oracle Databases.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, AWR, Statspack and TKPROF.
Experience: Vinsys IT services
Project Name: Deployment of High Availability with RAC11gr2
Oracle Database 10g/11g, Sun OS, Linux 5.4
Responsibilities:
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Supporting more than 20 instances.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
• Managed disks and disk groups using ASM.
• SQL tuning using SQL Trace and TKPROF, Explain Plan and SQL Analyze.
• Install and configure necessary Oracle Software for the client in Linux, AIX and Solaris environment.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) and OS monitoring using SAR, VMSTAT, TOP, PRSTAT
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, AUTOTRACE, STATSPACK, AWR and ADDM reports for performance issues resolution.
• Partitioning Strategies for very large tables.
• Import and Export of database objects to copy from one database to another database.
•Contact to the development team to solve the issues with the new enhancement releases
Responsibilities:
• Supporting more than 10 instances.
• Maintenance of production database which includes tablespace space management, user creation, privileges, roles etc.
• Database installation and Instance creation, patching and upgrading.
• Tracing, troubleshooting with database performance and tuning issues.
• Monitored the database growth, forecasted the database growth and increased the tablespace size.
• Taking weekly cold backup.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Creating and dropping of users, granting and revoking rights as and when required
Oracle Database 10gR2, Linux 5.0
• Providing Technical Support for wired and wireless LAN equipment’s, such as Broadband Routers, Access Points, Range Expanders, Network Bridges, Network Adapters for the Desktop and Notebook PC and Hubs and Switches.
• Initial Configuration, troubleshooting and Up-gradation of the SOHO routers.
• Handling different wireless encryption methods such as WEP, WPA etc.
• Configuration of advanced wireless devices such as Wireless network Camera, Media adapter, Network Storage link.
• Configuration of VPN set-up, Installation of the Print Servers.
The Vision enterprises
courses: Oracle Certified Professional (OCP 11g) Sun Solaris System Administrator (Solaris 10) Cisco Certified Network Associate (CCNA)
courses: G Database Administration •Conducted training Oracle Linux Administration I and Oracle Linux Advanced Administration for Taqnia, Saudi Arabia •Trained more than 30+ corporate fresher’s on Redhat 124, Redhat 134, Redhat 254, Redhat Open Stack