Job Description

Techwave is a leading global IT services and solutions company revolutionizing digital transformations. We enable clients to maximize their potential and achieve a greater market with a wide array of technology services, including, but not limited to Enterprise Resource Planning, Application Development, Analytics, Digital, and the Internet of things (IoT).

Organization : TECHWAVE (http://www.techwave.net/)
Requirement : Oracle Database Administrator
Experience : 4+ Years
Job type : Permanent
Location : Hyderabad

As? ??a? ?senior? ?Oracle? ?DBA? ?with? ?4+ ?years? ?of? ?experience,? ?candidate need to do the following:

Experience in DB management, prioritization, minor enhancements / fix activities, problem management, stability analysis, etc. L3 is supposed to be proactive in nature thus identifying problems in advance and looking for continuous service improvements
Design and Implementation

Monitor the event alerts like DB availability, Instance availability and the space availability of disk drives and file systems.
Monitor the Oracle Alert logs files, transaction logs and backup logs.
Monitor the database related activities, respond calls from the Application support and developments teams.
Monitor the backups, recovery errors, respond to the request regarding the restoration of the DB
Monitor the metric alerts, performance related issues like high CPU utilization, Application performance, high Memory utilization, Application tuning and Query tuning
Acknowledge the request for DB stop/start, user creation and grant specific data access to user

Advanced configuration and Troubleshooting
Analysis of technical issues and permanent fix/solution
Implementation of RAC & ASM , Data Guard for database failover between Data centre and DR site, perform switchover /failover activities.
Troubleshooting of cluster failures, ASM disk group's failures and DR related problem etc.
Adding and resizing of ASM disk groups.
Formulating Backup and Recovery strategies.
Database upgrades/migrations.
Install and configure Oracle enterprise manager Grid control.
Formulating Backup and Recovery strategies

• Strong experience on configure and troubleshoot physical standby database using dataguard broker
• Strong experience on configure and troubleshoot golden gate replication components
• Good Grip over Tables fine tuning and troubleshooting
• Implement backup and recovery of Oracle databases for various scenarios
• Administration over DB Objects including Tables , Clusters , Views , Procedures etc.
• Good in Impact Analysis of DB Change / DB Design Change etc.
• In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM)
• Good understanding of core support processes and change management, maintain documentation standards
• Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc
• Responsible for installation, upgrades (Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning
• Able to work in 24 by 7 Support

Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality.
SQL tuning and optimization
Transport data across platforms
DB-Related Software Evaluation, 3rd Party DBA Tools
Facilitate Training/Education

Requirements:

Having oracle RAC certification will be added advantage

Having experience on additional database technologies MSSQL or DB2 or Mysql will be added advantage