The Job

Sr Administrator (Support & Operations)

Teknik, data och digitalt · IT-infrastruktur och säkerhet · Databasadministration

Gå med för uppdateringar

I korthet

This role involves advanced technical support, troubleshooting, and root cause analysis for Oracle databases (11g/12c/18c/19c) in a 24/7 support environment. The Sr Administrator will be responsible for database administration, installation, migration, backups, recovery, performance tuning, and managing team activities.

Ansvarsområden

  • Offer advanced technical support, troubleshooting, and root cause analysis.
  • Perform Oracle Database Administration (L2 Profile) for versions 11g/12c/18c/19c.
  • Monitor tickets and resolve them within SLA.
  • Manage Oracle database architecture, installation, design, migration, backups, recovery, user management, tablespace management, and security management.
  • Work with mission-critical systems of Oracle 11g, 12c, 18c, and 19c databases.
  • Manage database instances on Sun Solaris, Linux, HP/UX, IBM/AIX, and Windows platforms.
  • Create and maintain database instances.
  • Utilize replication tools like Oracle Dataguard and Dataguard broker.
  • Perform database cloning.
  • Apply quarterly PSU/CPU Patches in Non-Prod/Prod systems.
  • Design and implement backup policies.
  • Perform restore and recovery of Production databases within SLA time.
  • Apply rolling patches in RAC.
  • Upgrade databases (Single Instance and RAC) in a clustered environment.
  • Create RAC Databases as per requirement.
  • Configure RMAN for backup on DISK.
  • Implement OS level and database level security as per the Build.
  • Create and configure single instance and physical standby databases for RAC production databases.
  • Create and monitor Active Dataguard for real-time reporting.
  • Monitor database performance and tune accordingly.
  • Configure and solve Client connectivity issues.
  • Configure RMAN for database backup and clone database in other hosts.
  • Validate backups by restoring databases on test and development servers.
  • Configure and maintain ASM instances and DISK GROUPS.
  • Implement OEM12c/13c and configure agents for multiple databases.
  • Manage team, distribute activities, and resolve issues.
  • Provide inputs for new database configurations and implementation details to clients.
  • Schedule maintenance activities for databases (purging, shrinking, parameter changes, index rebuilding).
  • Perform database tuning using AWR, ADDM, ASM, Explain Plan, TKPROOF, and Enterprise Manager.

Krav

  • Oracle DBA L2 Profile
  • Readiness to work in 24*7 support.
  • Ability to monitor tickets and resolve them within SLA.
  • Good Technical, Analytical, Communication, and Interpersonal skills.
  • Extensive knowledge of Oracle database architecture (11g/12c/18c/19c).
  • Good knowledge of database Administration, Oracle Server Installation, Database design, database Migration, backups & recovery, User management, Table space management, Security management.
  • Experience working in mission critical systems of Oracle 11g and 12c, 18c, 19c databases.
  • Sound Knowledge on Sun Solaris, Linux, HP/UX, and IBM/AIX and windows platform.
  • Experience in creation and maintenance of database instances.
  • Good knowledge of replication tools like oracle Dataguard, Dataguard broker.
  • Experience in Cloning of Database.
  • Experience in quarterly PSU/CPU Patches in Non-Prod/Prod systems.
  • Experience in designing and implementing backup policies.
  • Experience in restore and recovery of Production database within SLA time.
  • Experience in applying rolling patch in RAC.
  • Experience in Upgradation of database (Single Instance and RAC) in clustered environment.
  • Experience in creating a RAC Database as per Requirement.
  • Experience in Configuring RMAN (Recovery Manager) for Backup on DISK.
  • Experience in Implementing the OS level and database level security as per the Build.
  • Experience in Creation and configuration of single instance, physical standby database at different location for the RAC production database.
  • Experience in Creation and monitoring of Active Dataguard for real time reporting.
  • Experience in Monitoring the database performance and tune the database accordingly.
  • Experience in Configuring and solving Client connectivity issue for test, development, and production system.
  • Experience in Configuring RMAN setup for taking backup of the database and creating clone database in other hosts.
  • Experience in Checking Backup validation by restoring database on test and development servers.
  • Experience in Configuring and maintaining ASM instance and DISK GROUPS.
  • Experience in Implementation of OEM12c/13c and configure the agent for multiple databases.
  • Experience in Managing team and handling and distributing activities within team and addressing the issue part and resolving it.
  • Experience in Providing inputs for new configurations for databases and implementation details to clients.
  • Experience in Scheduling maintenance activity for databases related to purging and shrinking, parameter change, index rebuilding.
  • Experience in Perform database tuning using AWR, ADDM, ASM, Explain Plan, TKPROOF and Enterprise Manager.
#Oracle DBA#Support#Operations#Database Administration#24/7 Support#SLA#Root Cause Analysis#Troubleshooting#Performance Tuning#Backup and Recovery#Cloning#Patching#Upgrades#RAC#DataGuard#ASM#OEM#Linux#Solaris#AIX#HP-UX#Windows
HCLTech Logo

Företag

HCLTech

Publicerade jobb

för 2 veckor sedan

Anställningstyp

Heltid

Arbetsform

På plats

Erfarenhetsnivå

Mellannivå

Platser

Noida, India

Sökande

Ansök tidigt