Job Description

for ORACLE DBA(Specialist) . Work with a team that supports large number of Oracle databases. . Participate in management, prioritization, minor enhancements / fix activities, problem management, stability analysis, etc. . To be proactive in nature thus identifying problems in advance and looking for continuous service improvements. . Min 10+ years of experience in Oracle database administration in production environments on Unix, Windows and Linux OS. . Capable of performing Database Administration tasks independently in Oracle 10g, 11g, 12c and 19c. . Analysis of technical issues and permanent fix/solution. . Implementation of RAC, ASM, Data Guard for database failover between Data center and DR site, perform switchover /failover activities. . Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality. . Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment. . All above applicable to infrastructure which has standalone and RAC databases using file-system based or ASM based storage. . Provide capacity planning and performance monitoring of our database environments. . Support, administer and maintain production and non-production database environments. . Implement and maintain proactive database monitoring. . Work with engineering and application support teams to identify, triage and resolve performance issues. This requires the ability to analyze, optimize and tune complex SQL queries. . Deploy and maintain high availability and failover technologies such as Active Data Guard, RAC. . Create, clone and upgrade database environments to support implementation activities. . Define, implement and support database backup and recovery policies using RMAN and/or storage replication technologies. . Working knowledge of ITIL processes. . Perform database restoration and recovery in the event of a failure. . Ensure sensitive data is appropriately protected via industry standard encryption solutions. . Contribute to, and update, systems documentation as required. . Participate in providing 24x7 support on rotational basis to ensure operations of these critical systems for different customers. Experience Required: . 10+ years in Database Management . Minimum 5 to 8 Implementation cycle (individual contributor) . Adoptive for 24x7 Shift Support . Excellent spoken and written English Communication. . Good attitude towards corporate environment. . Hands on experience in Operations and Support of Oracle RDBMS 11g,12c and 19C. . Team player & Mentor to the team. . Energetic, self-motivated and self-sufficient in accomplishing tasks. . Good analytical and problem solving skills. Must Have: . Must have implemented and supported mission critical systems providing 24X7 support. . Must have excellent shell scripting skills. . Must have proven experience in tuning databases and queries. . Can drive projects to get the projects accomplished with superior results. . Must deliver winning results and take accountability for your actions. . Must be an expert in diagnosing and solving complex problems. . Must have very good oral and written communication skills and have the ability to influence others. . Must have 10+ years of Oracle database related work experience. . Must have a BS or MS in Business, Computer Sciences, Engineering or related field (an equivalent combination of related education, training and experience may be considered). . Deep understanding of Oracle DBMS 11.2,12c and 19C. . Must have a deep understanding of Oracle Grid/RAC, Oracle Partitioning, Oracle CIS Security Standards, Oracle Enterprise Manager . Must understand Oracle performance tuning techniques. . Deep understanding of database replication using the following technologies: Oracle Active Data Guard, Oracle Golden Gate related data replication products. . Significant experience with . -UX, Linux (RHEL). Preferable: . Knowledge in MSSQL/MySQL/PostgreSQL RDMS . Solutioning towards Database requirement not limited to Oracle. . Should have Hands on Experience in monitoring and management tools. . Strong in preparing Knowledge Base Documents & SOP . Good in ITIL/ITSM Process - Incident, Service Requests, Change Management & Problem Management . Strong in adopting the SLA Governance. . OCA/OCP Certified. Technical Skills: . S/he will demonstrate an in depth understanding of several products in more than one functional area involving usage, configuration, and interaction with other products. . S/he must possess a balance of very well-developed troubleshooting, technical communication and written skills along with extensive product knowledge and skills. . Candidate should have excellent technical communication skills both verbal and written. Interpersonal Skills: . Be professional in all modes of interaction with our internal & external customers. . Be capable of making well founded decisions in high pressure situations & exercising diplomacy when operating in politically charged environments. . Actively listen and confirm problem details showing empathy for urgent situations . Utilize effective negotiation skills which will lead to satisfactory issue resolutions.

foundit