Oracle Database Administrator

Location

Delhi | India

Job description

• This role plans, designs and implements maintenance programs to optimize the availability and productivity of production site facilities and equipment.
• Working knowledge of Middleware applications like JBOSS, Tomcat Apache, Jonas, WebLogic is also desirable.

Key Missions

• Handling Technical support tickets within SLAs

• Administer business application databases and associated program software in Database and Application Infrastructure.
• Undertake performance monitoring and tuning, problem resolution, availability management, capacity management, change management and security access management to ensure the continuous provision of service of the database and integrated platform environments.
• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary
• Monitor and maintain database storage resources,database maintenance plans for backups, index rebuild/defragment, and database statistics
• Provide advanced skills in the areas of fault diagnosis and failure and initiate remedial action as required in Database and Application Infrastructure environments.
• Perform complex backup and recovery tasks for database and applications infrastructure environments. Design the database recovery and backup policy and procedures in accordance with business requirements.

Skills Required

• Oracle Database Setup and administration.

• Implementation knowledge of RAC and its configuration from scratch.
• Expertise in one or more of Systems area including virtualization, network, storage
• Working knowledge of DBVisit, Oracle Backup Recovery and High availability technologies (via Dataguard)
• Knowledge in Oracle 12c and higher versions. Managing specialized workloads in cluster, volumes and configuring data, monitoring logging, maintenance and troubleshooting.
• Oracle Database upgrade, performance tuning, 24/7 production support.
• Planning out strategies for DB migration, DB consolidation and driving it end to end.
• Dig deep to discover the root causes of issues - exploring source code, databases, logs, and traces.
• Provide technical expertise, advice and guidance on technology aspects of database and application delivery services to management and other technical staff.
• Strong documentation skills in documenting processes, procedures and tools descriptions.
• Participate in and contribute to Release activities including Spec reviews.
• Understand and contribute to effective Monitoring of the critical components of the System.
• Ensure database security, integrity, and performance
• Recommend, implement, and maintain best practices and corporate standards

Candidate Profile (Required Qualifications)

• B.Tech/B.E/M.Tech/MCA or Equivalent degree from an accredited educational institution in Information Technology
• Overall 6+ years of technical experience in solution design maintenance support, with medium to large scale system integration projects in information systems
• Strong knowledge of standard hardware software configurations, Storage and Computing
• Maintain KEDB and can update technical documentation.
• Strong understanding of Customer Support and Helpdesk Best Practices (ITIL certification preferred)

Tools:

• Support ticket tracking tool dashboard: in progress tickets
• Atlassian tools (JIRA Confluence)

Job tags

Salary