Database Administrator - SME

Job description

·  Job Description:

·  In depth knowledge of the Oracle database architecture (Single Instance, RAC and ASM), related utilities and tools on Oracle 10g, 11gr1, 11gr2 and 12c.
·  Good hands-on experience in EXADATA DATABASE MACHINE Storage cell administration maintenance tasks by using utilities
·  Good Experience in Applying Latest Bundle Patches to EXADATA
·  Good Understanding of EXADATA smart storage capabilities, HCC, smart flash cache intelligent caching, EXADATA Storage indexes
·  A good understanding of the underlying operating system (linux/Solaris/HP Unix) and knowledge of network and storage.
·  A good knowledge of the physical database design.
·  Ability to perform both Oracle and operating system (Unix/Linux/Solaris) performance tuning and monitoring.
·  A good knowledge and hands on experience of Oracle Enterprise Manager 11g and 12c, Real Application Clusters, Partitioning, Diagnostics & Tuning, Audit Vault & Database Firewall, Database Vault, Advanced Security.
·  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, 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.
·  Experience in code migration, database change management and data management through the various stages of the development life cycle.
·  Create and manage multiple databases and assist in capacity planning.
·  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.
·  Knowledge of ALL Oracle backup and recovery scenarios.
·  Good knowledge and hands on experience of Oracle high availability solutions like RAC and Dataguard.
·  Knowledge of RTPA standard checks and criteria per global governing process

Incident Management: Resolve single- and cross technology

·  incidents independently. Work with team members to resolve unusually complex or cross technology incidents.
·  Problem Management: Proactively and reactively look for solutions to prevent problems from occurring in team/technology area.
·  Change Management/Implementation: Independently review, implement, and verify changes/solutions of high complexity and risk to meet customer and/or trade/company Information Technology infrastructure needs.
·  Patch and Security Management: Apply patch and security changes per policy. Proactively monitor the environment for patch compliance. Analyze patches for compatibility with each customer or internal infrastructure environment.
·  Configuration Management: Ensure Configuration Management Database (CMDB) entries are complete and accurate.
·  Solution Design: Apply company solutions to meet highly complex customer and/or trade/companyIT infrastructure needs.