Application Support Engineer

Project Role : Application Support Engineer

Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.

Must have skills : Oracle Database Administration (DBA)

Good to have skills : NA
Minimum 5 year(s) of experience is required

Educational Qualification : 15 years full time education

Summary:
As an Application Support Engineer, a typical day involves acting as a software detective by investigating and resolving issues across various components of essential business systems. This role requires a proactive approach to identifying problems, analyzing system behavior, and ensuring smooth operation of critical applications. The position demands continuous monitoring, collaboration with different teams, and delivering timely solutions to maintain system reliability and performance in a dynamic environment.

Roles & Responsibilities:

Expected to be an SME, collaborate and manage the team to perform.

Responsible for team decisions.

Engage with multiple teams and contribute on key decisions.

Provide solutions to problems for their immediate team and across multiple teams.

Coordinate cross-functional efforts to streamline issue resolution and improve system stability.

Mentor junior team members to enhance their technical capabilities and problem-solving skills.

Facilitate communication between stakeholders to ensure alignment on system support priorities.

Install, configure, and upgrade Oracle databases (standalone and clustered) on Linux/Unix/Windows platforms.

Apply patches and perform database version upgrades and migrations.

Manage Oracle Grid Infrastructure, ASM, and listener configurations.

Monitor system performance using AWR, ASH, OEM, and SQL Trace.

Tune SQL queries, indexes, and PL/SQL procedures.

Proactively resolve bottlenecks and optimize resource utilization (CPU, memory, I/O).

Implement and manage RMAN-based backup and recovery strategies.

Configure and monitor Oracle Data Guard for high availability and disaster recovery.

Conduct database restores and participate in DR drills

Deploy and manage Oracle databases in cloud environments such as Oracle Cloud Infrastructure (OCI- DB Systems, Autonomous DB
& AWS RDS for Oracle, Azure Oracle DB Services

Support hybrid configurations and data replication between cloud and on-prem systems.

Configure data encryption (TDE), auditing, and fine-grained access control (FGAC).

Manage user access, privileges, roles, and authentication integration (LDAP, Kerberos).

Ensure compliance with internal policies and regulatory standards (e.g., GDPR, HIPAA).

Automate maintenance tasks using PL/SQL, Shell scripting, or Python.

Create monitoring and alerting scripts for early issue detection.

Use Oracle Enterprise Manager (OEM/Cloud Control) and third-party tools for monitoring.

Maintain documentation of architecture, processes, change logs, and disaster recovery plans.

Professional & Technical Skills:

Must To Have Skills:

Proficiency in Oracle Database Administration (DBA).

Good To Have Skills: Experience with AWS Administration, Microsoft Azure IaaS.

Need to have Oracle Versions skill in Oracle 11g, 12c, 18c, 19c, 21c

Need to have Cloud Platforms skill in OCI (Oracle Cloud Infrastructure), AWS RDS, Azure Oracle DB Services

Need to have Monitoring Tools skill in OEM (Enterprise Manager), Toad, SQL Developer, Nagios, SolarWinds

Need to have Backup Tools skill in RMAN, NetBackup, Commvault, Data Domain (integration)

Need to have Scripting & Automation skill in Bash, Shell, Python, PL/SQL

-Need to have certification in Oracle Certified Professional (OCP) - Oracle Database Administration
,Oracle Cloud Infrastructure (OCI) Architect / DBA Associate, AWS or Azure Database Certifications (for hybrid environments) & ITIL Foundation (for process-based environments).

The candidate should have minimum 5 years of experience in Oracle Database Administration (DBA).

This position is based at our Bengaluru office.

A 15 years full time education is required.

Qualification 15 years full time education