Oracle DBA - L2

MSIL LOCATIONGurgaon DOMAINOracle Level (L1/L2/L3)

L2 Required Relevant Domain Experience

4-5 Years Job Type (Onsite/Remote)Onsite Shift details (General/ 24X7)24X7 QualificationB.E/B.Tech/ BCA Certifications Required if ANYITIL Certified, OEM Certified Specific Remarks/Requirement by customerOracle Apps knowledge will add an advantage Budget12 LPA Certifications preferenceOEM Certification like OCP (Oracle Certified Professional)Role PurposeWe are looking for a passionate candidate who can perform Database Administration tasks in Oracle Database.Designs and builds simple to complex database structures from data models. Installs configure and patches in Oracle. Implements HA and DR systems using Data guard and RAC.

Job Responsibilities

Installing and upgrading the Oracle server and application toolsAllocating system storage and planning future storage requirements for the database systemCreating primary database storage structures (tablespaces) after application developers have designedan applicationWorking knowledge of RMAN Data guard RAC Data pump ASM Networking Oracle 11G Performance TuningSQL Database Grid CRS management Firewall.Change/Release Management and maintenance and management of databases using Oracle EnterpriseManagement Grid Control.Complex database migrations. Working knowledge with offshore partners and various cultures.Knowledge of the ITIL framework.Database: grant access rights, manage authorizations.OS Service Monitoring: Monitoring OS Services of the Applications (Up/Down).Database structure creation at the schema level and active reporting (data collection and report build).Install Database Server Security based upon Service Level.Respond to database security alerts.Applying simple/repeatable Security Patch. Regular Oracle DB admin password change.Process Monitoring: Monitoring OS processes of the DB (Up/Down). Service Monitoring: Monitoring OSServices of the DB (Up/Down).Upgradation of Database version from existing to the latest recommended version in coordination withMSIL domain owner.Database System Performance monitoring gathering d report build (buffer hit ratio, etc. for reporting).Work in close coordination with the application and other teams to resolve issues and optimize the database performance.Facilitate new database deployments, execute and manage cronjobs and perform another routine databaseadministration activities from a remotlocationson.Monitoring and management of table space usage, buffer cache hit ratio, no. of segments approachingmax extent, chain counts index usability, invalid object counts, etcTechnical Skills/Knowledge requirement

• Oracle Server Installation and Upgrades
• Storage Allocation and Planning
• Oracle Enterprise Manager (OEM) and Grid Control
  

FOR HPE
Project ManagerDateSignatureFOR CustomerProject ManagerDateSignature