Oracle DBA Full-Time

INFYJOB TECHNOLOGY SERVICES PRIVATE LIMITED

Posted By : INFYJOB TECHNOLOGY SERVICES PRIVATE LIMITED

Chennai, Tamil Nadu (2)

Experience:  hands-on professional experience as an Oracle Database Administrator. BS or MS degree or equivalent experience relevant to functional area.

 

Skillset / Prior Experience / Key Responsibilities::

  • Good understanding of the Oracle database architecture, License management of database, management packs and database options.
  • Defining database standards and procedures to cover the instance parameters, object sizing, storage, and naming. The procedures define the process for install/upgrade, corporate database requirements, security, and backup/recovery and automate the same.
  • Design, architect, and build databases based application systems from business requirements to planning and deploying test and production systems that are completely available and highly scalable.
  • A good understanding of the underlying operating system (Oracle Linux) and knowledge of network and storage.
  • A good knowledge of the physical database design and Partition Tables.
  • Ability to perform both Oracle and operating system (Oracle Linux) performance tuning and monitoring.
  • Knowledge of ALL Oracle backup and recovery scenarios.
  • Experience in code migration, database change management and data management through the various stages of the development life cycle.
  • Should have sound communication skills with management, development teams, vendors and systems administrators.
  • Should be able to work independently to troubleshoot issues, provide resolution and prepare RCA documents.
  • Good knowledge and hands on experience of Oracle high availability solutions like RAC and Dataguard.
  • Create and manage multiple databases and assist in capacity planning.
  • Knowledge or experience with Oracle Multitenant (CDB/PDB)
  • A good knowledge and hands on experience of Oracle Enterprise Manager 12c & 19c.
  • Use tools for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Developing database administration procedures and responsibilities for production systems.
  • Developing production database/storage (ASM) migration procedures.
  • Coordinating upgrades of system software products to resolve any Oracle/operating system issues/conflicts.
  • Coordinate & manage support activities and maintenance as required, part of the 24x7 operations support
  • Team management & grooming

 

Role Specific Skills
  • Active Listening
  • Category Flexibility
  • Complex Problem Solving
  • Computers and Electronics
  • Critical Thinking
  • Customer and Personal Service
  • Deductive Reasoning
  • Design
  • Engineering and Technology
  • English Language
  • Flexibility of Closure
  • Fluency of Ideas
  • Inductive Reasoning
  • Information Ordering
  • Judgment and Decision Making
  • Mathematical Reasoning
  • Mathematics
  • Near Vision
  • Operations Analysis
  • Oral Comprehension
  • Oral Expression
  • Originality
  • Problem Sensitivity
  • Programming
  • Reading Comprehension
  • Selective Attention
  • Speaking
  • Speech Clarity
  • Speech Recognition
  • Systems Analysis
  • Systems Evaluation
  • Written Comprehension
  • Written Expression

Bachelor of Engineering (B.E) - Others

Bachelor of Technology (B.Tech) - Others

Journey