Oracle Database Administration (Oracle DBA)

Position : Oracle Database Administration (Oracle DBA)

Experience: 3 to 6 Years

Notice period : Immediate to 15 Days

Location : Chennai.

Required Skills: Oracle DBA/Oracle APP DBA, Fusion Middleware administration and SQL Server DB administration.

To have some experience working with the below products.

• Oracle Databases (EBS & Non EBS Databases)
• Oracle Enterprise Manager
• Oracle Application Server

• Fusion Middleware administration

• Oracle e-Business Suite
• Oracle Golden Gate / Label Security / Data Masking / Oracle encryption
• Oracle SOA / Web logic
• Other Oracle related Product
• PL/SQL and shell scrip programming
• Microsoft SQL Server Databases

Job Roles & Responsibilities

• Administer the databases and Oracle Applications in Production, Test, and Development.
• Monitor, manage and maintain the database and ensure optimization of performance
• Responsible for the installation / migration or upgrade of databases based on Clients requirement.
• Responsible for the hardening of Database in accordance with Client company policies, processes, and guidelines.
• Coordinate with Clients data centre team and business application team to perform the monthly maintenance activity.
• Provide technical database administration support to the application developers and business super users.
• Monitor several database components through Oracle Enterprise Manager (OEM) and resolve issue identified.
• Clone Oracle Databases and Non-Oracle Databases
• Apply patches to Databases and applications based on Clients requirement.
• Troubleshoot problems related to applications and databases and provide support including tar logging.
• System health check and data management defragmentation, export/import, relocation of data files, and database refreshes.
• To support the Client in the backup and recovery of databases and applications.
• Participate in and support Client in scheduled DR exercises
• To change password periodically for default database users used by Oracle application as Clients security policies.
• Housekeeping of databases and applications in scope as per Clients policies.
• Configuring of OEM alerts for Databases.
• To support client on program deployments and code migrations.
• Provide necessary documentations as per Clients requirement
• Liaising and working with Oracle Customer Success Services team to support Client projects and initiatives.
• Prepare weekly and Monthly report.
• To participate in Oracle Cloud migration and Oracle upgrade projects, providing support in database administration activities according to project schedule.

"kalidasan.ramasamy@kiya.ai"

Regards,

Kalidasan Ramasamy

Human Resource
kalidasan.ramasamy@kiya.ai

www.kiya.ai