Senior Engineer - Oracle Database Administration

Job Description

Database Administration and Operations

• Administer Oracle databases across production and non-production environments.
• Perform installation, configuration, upgrades, patching, cloning, and migration activities.
• Monitor availability, capacity, sessions, storage, jobs, and performance indicators.
• Perform SQL and database performance analysis using diagnostic reports and tuning techniques.

OCI Operations

• Use OCI Database Management, Monitoring, Logging, and Alarms.
• Manage OCI IAM, compartments, VCNs, private endpoints, NSGs, security lists, and cloud connectivity.
• Perform hands-on Oracle Cloud Infrastructure DBA operations.

Recovery, Security, and Support

• Plan, execute, and validate backup, restore, recovery, and disaster recovery procedures.
• Manage users, roles, privileges, auditing, and access controls according to approved security requirements.
• Investigate incidents, identify root causes, implement corrective actions, and contribute to problem management.
• Support releases, deployment validation, change implementation, and rollback planning.
• Maintain operational records, runbooks, SOPs, known-error records, and handover documents.
• Coordinate with technical and vendor teams while meeting SLAs and change controls.

Technical Skills

• Oracle Database 12c, 19c, or later administration, including installation, configuration, maintenance, patching, and upgrades.
• OCI database services, Autonomous Database, monitoring, performance management, backup and recovery, scaling, and troubleshooting.
• SQL tuning, indexing, execution plans, AWR, ASH, ADDM, storage, tablespace, and capacity management.
• RMAN backup and recovery, Oracle Data Guard, standby operations, switchover or failover support, and replication.
• Database security administration, monitoring, alert handling, incident resolution, RCA, and SLA-based support.
• SQL, PL/SQL, shell scripting, SOPs, configuration records, and technical handover documentation.

Education and Preferred Experience

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.
• Experience with Oracle RAC and clustered database environments is desirable.
• Exposure to Oracle Exadata or engineered systems is desirable.
• ITIL-aligned production support and change-management experience is desirable.

Soft Skills

• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and documentation abilities.
• Ability to work independently and collaborate across technical and service-management teams.
• Customer-focused ownership of incidents, requests, and operational commitments.

About Malomatia