Oracle DBA L2

#FreePost#

LOCATION --Gurugram
DOMAIN –Oracle DBA L2
Level – L2
Required Relevant Domain Experience 4-5 Years
Job Type (Onsite/Remote) : Onsite
Shift details -- Onsite support 24 X 7
Mandatory Skills--
1) Oracle Server Installation and Upgrades 2) Storage Allocation and Planning 3) Oracle Enterprise Manager (OEM) and Grid Control

Roles & Responsibilities

• Installing and upgrading the Oracle server and application tools
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed
• an application
• Working knowledge of RMAN Data guard RAC Data pump ASM Networking Oracle 11G Performance Tuning
• SQL Database Grid CRS management Firewall.
• Change/Release Management and maintenance and management of databases using Oracle Enterprise
• Management 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 OS
• Services of the DB (Up/Down).
• Upgradation of Database version from existing to the latest recommended version in coordination with
• 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 database
• administration activities from a remotlocationson.
• Monitoring and management of table space usage, buffer cache hit ratio, no. of segments approaching
• max extent, chain counts index usability, invalid object counts, etc

Job Types: Full-time, Permanent

Pay: ₹800,000.00 - ₹1,000,000.00 per year

Benefits:

• Health insurance
• Provident Fund

Schedule:

• Morning shift

Supplemental Pay:

• Yearly bonus

Work Location: In person