Quess IT Staffing (Formerly known as Magna Infotech)
Location
Gurgaon | India
Job description
Job Title : Oracle Database Administrator L1
Location : Gurgaon
Experience : 2 to 5 years
Skills : Oracle DBMS 11.2,12c and 19C
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.
Job tags
Salary
